CData Software - Knowledge Base
Recent Articles
-
Visualize Live Campaigner Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Campaigner.
-
Create Reports from IBM Informix Data in Looker Studio
Use CData Connect AI to gain access to live IBM Informix and create custom reports in Looker Studio.
-
Stream ClickTime Data into Apache Kafka Topics
Access and stream ClickTime in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Getting Started with the CData JDBC Driver for SingleStore
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SingleStore.
-
Create a Data Access Object for SAP Business Warehouse Data using JDBI
A brief overview of creating a SQL Object API for SAP Business Warehouse in JDBI.
-
Automated Continuous Teamgate Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Teamgate replication to Amazon S3.
-
Creating Twitter Ads-Connected Applications in Unqork
You can use CData Connect AI to feed Twitter Ads to Unqork and build custom business apps.
-
Build Egnyte-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Egnyte and build web apps with connectivity to live Egnyte.
-
Import and Visualize Cvent Data in Power View
Create data visualizations based on Cvent in Excel.
-
How to connect to GitHub Data with Squirrel SQL client
Connect to GitHub and execute queries in the Squirrel SQL Client.
-
Integrate Live SAS Data Sets Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAS Data Sets and integrate live SAS Data Sets into apps built in Microsoft Power Apps.
-
Use CData Connect AI to Access Azure Table Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Azure Table Storage in the Power Pivot business intelligence tool.
-
Using the CData Software ODBC Driver for Miro in PyCharm
Connect to Miro as an ODBC data source in PyCharm using the CData Software ODBC Driver for Miro.
-
Getting Started with the CData Excel Add-In for SAP ByDesign
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP ByDesign.
-
Automate Oracle Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Oracle Database from PowerShell? This article demonstrates how to utilize the Oracle Cmdlets for tasks like connecting to Oracle Database, automating operations, downloading data, and more.
-
Connecting GenSpark with Highrise Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Highrise CRM without any replication or custom integration required.
-
Visualize Zoho Creator Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Zoho Creator.
-
Build MYOB AccountRight-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for MYOB AccountRight to explore live MYOB AccountRight Data in Claude Code to assist with building MYOB AccountRight-powered applications.
-
Visualize PostgreSQL Data in TIBCO Spotfire through OData
Integrate PostgreSQL into dashboards in TIBCO Spotfire.
-
Rapidly Develop AfterShip-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by AfterShip.
-
Build Google Contacts-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Contacts.
-
How to Connect Procore Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Procore data in real time using natural language.
-
Access Live VWO Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate VWO into the statistical analysis tools available in SAS JMP. This article shows how to use VWO in the Graph Builder and Query Builder.
-
Build ADP-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live ADP and build ADP-connected web apps with Axios.
-
Getting Started with the CData SSIS Components for Teamgate
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Teamgate.
-
Getting Started with the CData Tableau Connector for Paylocity
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Paylocity.
-
Choosing the Best Method to Connect Browserless to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Browserless from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating LangChain with HBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Apache HBase within automated workflows.
-
Build Snapchat Ads-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Snapchat Ads.
-
Access Live Bannerbear Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Bannerbear into the statistical analysis tools available in SAS JMP. This article shows how to use Bannerbear in the Graph Builder and Query Builder.
-
Automate SAP Ariba Procurement Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP Ariba Procurement from PowerShell? This article demonstrates how to utilize the SAP Ariba Procurement Cmdlets for tasks like connecting to SAP Ariba Procurement, automating operations, downloading data, and more.
-
Connect to QuickBooks Time Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for QuickBooks Time and the Script function in FileMaker Pro to connect to QuickBooks Time and work with QuickBooks Time in your FileMaker application.
-
Access Bugsnag Data from MySQL in Amazon QuickSight
Connect to Bugsnag and build visualizations of Bugsnag using a MySQL Connection in Amazon QuickSight.
-
Automate Basecamp Data Replication to Azure Data Lake
Use CData Sync to customize and automate Basecamp replication to Azure Data Lake.
-
Build AI/ML Models with Live HubSpot Data using Dataiku
Connect HubSpot Data with Dataiku using the CData JDBC Driver for HubSpot.
-
Automated Continuous eBay Analytics Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Amazon Redshift.
-
Build a Singer.io Tap for Pinecone With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Pinecone data using
-
Use the CData Software ODBC Driver for Raisers Edge NXT in MicroStrategy Web
Connect to Raisers Edge NXT in MicroStrategy Web using the CData Software ODBC Driver for Raisers Edge NXT.
-
Integrating Claude Code CLI with Microsoft Teams Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata - all without leaving the terminal.
-
Use CData Connect AI to Access ADP Data in Microsoft Power Pivot
Use CData Connect AI to connect to live ADP in the Power Pivot business intelligence tool.
-
Integrate Open WebUI with Live Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Twitter Ads from within the chat interface.
-
Natively Connect to Hive Data in PHP
The CData ODBC driver for Hive enables you to create PHP applications with connectivity to Apache Hive. Leverage the native support for ODBC in PHP.
-
Create Dynamic Sybase IQ Grids Using the Infragistics XamDataGrid
Learn how you can connect Sybase IQ to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Goose with Live Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Google Drive from within the local AI agent.
-
How to Easily Query SharePoint Excel Services Data in OpenOffice Base
Connect to SharePoint Excel Services data in OpenOffice Base using the CData ODBC Driver for SharePoint Excel Services and generate reports with live data insights.
-
Integrating OpenCode Terminal with Klipfolio Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Connect to MongoDB Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for MongoDB in the Denodo Virtual DataPort Administrator.
-
Connect to Google Search Results Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Google Search and the Script function in FileMaker Pro to connect to Google Search and work with Google Search in your FileMaker application.
-
Connect to Snowflake Data in JRuby
Create a simple JRuby app with access to live Snowflake.
-
Provide OData Services of CapsuleCRM Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for CapsuleCRM by developing a WCF Service Application.
-
Using the CData Software ODBC Driver for Freshteam in PyCharm
Connect to Freshteam as an ODBC data source in PyCharm using the CData Software ODBC Driver for Freshteam.
-
Integrate LionDesk Data in the Pentaho Report Designer
Publish reports based on LionDesk in the Pentaho BI tool.
-
Integrate with live Google Sheets Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google Sheets in Jitterbit.
-
Access Nuclia Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Nuclia from HeidiSQL.
-
Build Salesforce-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Salesforce Data from Zoho Analytics and import live Salesforce & Force.com.
-
Automate Tasks in Power Automate Using the CData API Server
Automate SAP SuccessFactors actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connect to Presto Data in HULFT Integrate
Connect to Presto as a JDBC data source in HULFT Integrate
-
Build Semantic Layer Views for Zendesk Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Zendesk.
-
Getting Started with the CData Tableau Connector for PostgreSQL
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for PostgreSQL.
-
How to import Redis Data into Apache Solr
Use the CData Software JDBC Driver for Redis in Data Import Handler and create an automated import of Redis to Apache Solr Enterprise Search platform.
-
Build a Simple VCL Application for Office 365 Data
How to build a simple VCL Application to view Microsoft Office 365 in RAD Studio using the CData ODBC Driver for Office 365.
-
Use the CData Software ODBC Driver for ZohoDesk in MicroStrategy Desktop
Connect to ZohoDesk in MicroStrategy Desktop using the CData Software ODBC Driver for ZohoDesk.
-
Integrate with TigerGraph Data in JReport Designer
Create charts and reports based on TigerGraph in JReport Designer.
-
Perform Batch Operations with CockroachDB Data in Apache NiFi
Connect to CockroachDB and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Create Oracle HCM Cloud-Connected Dashboards in Grafana
Connect to Oracle HCM Cloud Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Oracle HCM Cloud.
-
Manage OneNote Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for OneNote.
-
Use the CData Software JDBC Driver for ScrapingBee in MicroStrategy Desktop
Connect to ScrapingBee in MicroStrategy Desktop using the CData Software JDBC Driver for ScrapingBee.
-
Visualize IBM Cloud Object Storage Data in Tableau
The CData ODBC driver for IBM Cloud Object Storage enables you integrate IBM Cloud Object Storage into Tableau dashboards.
-
Build Charts with Zoho CRM Data in Clear Analytics
Create dynamic charts and perform analytics based on Zoho CRM in Clear Analytics.
-
SQL Analysis Services Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SQL Analysis Services through CData Connect AI using different applications and tools.
-
Publish Sage 300-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Sage 300.
-
Build Dynamics CRM-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Dynamics CRM Data from Zoho Analytics and import live Microsoft Dynamics CRM.
-
Create TigerGraph Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time TigerGraph data access from reports, embedded analytics, and more.
-
How to connect to Freshservice Data in DBVisualizer
Integrate Freshservice with visual data analysis tools and data connection wizards in DBVisualizer
-
Publish Wave Financial-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Wave Financial.
-
How to Connect to Mocean Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Mocean. Leverage the pyodbc module for ODBC in Python.
-
Prepare, Blend, and Analyze QuickBooks Time Data in Alteryx Designer (ODBC)
Build workflows to access live QuickBooks Time for self-service data analytics.
-
Operational Reporting on Google Ads Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Ads.
-
Easily Integrate Authorize.Net Data in Lazarus Pascal IDE
Learn how to easily integrate live Authorize.Net in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Explore Geographical Relationships in ZohoInvoice Data with Power Map
Create data visualizations with ZohoInvoice in Power Map.
-
Automate Wrike Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Wrike from PowerShell? This article demonstrates how to utilize the Wrike Cmdlets for tasks like connecting to Wrike, automating operations, downloading data, and more.
-
Integrate LibreChat with Live Sage Intacct Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Sage Intacct from within the chat interface.
-
How to Query SAP Ariba Procurement Data in MySQL Workbench
Execute MySQL queries against live SAP Ariba Procurement from MySQL Workbench.
-
Edit and Search External Oracle HCM Cloud Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Oracle HCM Cloud to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Oracle HCM Cloud Data objects that you can access from apps and the dashboard.
-
How to Visualize SAS xpt Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live SAS XPORT in Python.
-
Query Authorize.Net Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Authorize.Net entities in PHP by modeling them as objects.
-
Integrating Kiro CLI with OnePageCrm Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Use Claude to Talk to Your Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Microsoft Entra ID for you.
-
Automated Continuous Azure Synapse Replication to Vertica
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Vertica.
-
Edit and Search Snapchat Ads External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Snapchat Ads to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Snapchat Ads objects that you can access from apps and the dashboard.
-
Analyze Microsoft Entra ID Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft Entra ID and visualize Microsoft Entra ID in SAP Analytics Cloud.
-
DataBind Productboard Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Productboard to a chart.
-
Connect Coda Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Coda using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Spark Data in ACL Analytics
Connect to Apache Spark SQL via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Apache Spark SQL.
-
Build Apps with Live IBM Cloud Object Storage Data Using the Low-Code Development Platform of Mendix
Connect IBM Cloud Object Storage with Mendix to build apps using the CData JDBC Driver for IBM Cloud Object Storage.
-
Analyze SAP HANA Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP HANA from Power Pivot. You will use the Table Import Wizard to load SAP HANA. You can visually build the import query or use any SQL supported by the driver.
-
Create Postmark Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Postmark from PowerBI.com to create Power BI Dataflows with real-time data.
-
Explore Geographical Relationships in Elorus Data with Power Map
Create data visualizations with Elorus in Power Map.
-
Work with Sugar CRM Data in FoxPro
Load Sugar CRM into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build a Simple VCL Application for Perigon Data
How to build a simple VCL Application to view Perigon in RAD Studio using the CData ODBC Driver for Perigon.