CData Software - Knowledge Base
Recent Articles
-
Build Splunk-Connected Apps in Choreo
Use CData Connect AI to connect to Splunk Data from Choreo and build custom apps using live Splunk data.
-
Connecting GenSpark with PolarTeamPro Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to PolarTeamPro data without any replication or custom integration required.
-
Query SAP Fieldglass Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP Fieldglass entities in PHP by modeling them as objects.
-
Access Asana Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Asana data from your Oracle system.
-
Visualize Live QuickBooks Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live QuickBooks data into custom reports in Power BI.
-
Connect to and Query Acumatica Data in QlikView over ODBC
Create data visualizations with Acumatica data in QlikView.
-
Build Procore-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Procore data.
-
Connect to GraphQL Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for GraphQL to connect to GraphQL data and execute queries in PowerBuilder.
-
How to connect to Freshservice Data from IntelliJ
Integrate connectivity to Freshservice data with wizards in IntelliJ.
-
Connect to Ontraport Data in DBeaver
Use the CData ODBC Driver to connect to Ontraport data in DBeaver.
-
Manage Klaviyo Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Klaviyo.
-
Create Data Visualizations Based On Cassandra Data in Mode
Use CData Connect AI to connect to Cassandra Data from Mode and build visualizations using live Cassandra data.
-
Load Scrapfly Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Scrapfly data to a database.
-
Access Google Analytics Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Google Analytics data.
-
Visualize Live GetResponse Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live GetResponse data.
-
How to create LinkedIn Ads federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for LinkedIn Ads data in MySQL .
-
Load Google Tasks Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Tasks data to a database.
-
Connect to ZohoExpense from Asprova with CData Software ODBC Driver for ZohoExpense
This article shows how to connect faster to ZohoExpense data from Asprova.
-
Automated Continuous Retently Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Retently data replication to OneLake in Microsoft Fabric.
-
Integrate Google's Antigravity Agent with Live Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Oracle Eloqua data using the Model Context Protocol.
-
How to create Odoo federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Odoo data in MySQL .
-
Connect to Missive Data in Jaspersoft Studio
Execute SQL to remote Missive data in Jaspersoft Studio.
-
Automated Continuous AlloyDB Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable AlloyDB replication to Apache Cassandra.
-
Use Dash to Build to Web Apps on Coinbase Data
Create Python applications that use pandas and Dash to build Coinbase-connected web apps.
-
Design BIRT Reports on Google Sheets Data
Provide current Google Sheets data to your embedded analytics.
-
Connect to OneNote Data in RazorSQL
Connect to OneNote from wizards and query OneNote data from the GUI in the RazorSQL database management tool.
-
Connect to Salesforce CRM Analytics Data in HULFT Integrate
Connect to Salesforce CRM Analytics as a JDBC data source in HULFT Integrate
-
Automated Continuous Google Ads Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Ads replication to IBM DB2.
-
Using the CData Software ODBC Driver for ZendeskSell in PyCharm
Connect to ZendeskSell as an ODBC data source in PyCharm using the CData Software ODBC Driver for ZendeskSell.
-
Getting Started with the CData JDBC Driver for Quaderno
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Quaderno.
-
Replicate Freshteam Data to Multiple Databases via the CData Sync CLI
Replicate Freshteam data to disparate databases with a single configuration.
-
Design BIRT Reports on LeadDesk Data
Provide current LeadDesk data to your embedded analytics.
-
Power BI Connector Getting Started Guide
A basic guide to connecting Power BI to data from anywhere using the CData Power BI Connector.
-
Create SSAS Tabular Models from Azure Data Catalog Data
How to build a SQL Server Analysis Service Tabular Model from Azure Data Catalog data using CData drivers.
-
Integrate Cline with Live Optimizely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Optimizely data from within your IDE.
-
How to update SQL Server from Excel
This article explains how to transfer data from Excel to SQL Server using the Excel Add-In for SQL Server.
-
Getting Started with the CData JDBC Driver for Freshsales
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Freshsales.
-
Replicate Amazon S3 Data in Heroku for Use in Salesforce Connect
Replicate Amazon S3 data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData ODBC Driver for Mailgun from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Mailgun to connect to Mailgun data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Mailgun data in Excel.
-
Back Up Microsoft Ads data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Microsoft Ads. In this article, we will employ an SSIS workflow to populate a database with Microsoft Ads data data.
-
Automated Raisers Edge NXT Data Replication to Teradata
Use CData Sync to Customize and automate Raisers Edge NXT data replication to Teradata.
-
Use the CData Software ODBC Driver for Outlook in MicroStrategy
Connect to Outlook data in MicroStrategy Developer using the CData Software ODBC Driver for Outlook.
-
Enable the Jodoo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Jodoo data.
-
Rapidly Develop AgileCRM-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 AgileCRM.
-
Getting Started with the CData JDBC Driver for Spotify
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Spotify.
-
EnterpriseDB Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to EnterpriseDB data through CData Connect AI using different applications and tools.
-
Automated Continuous Gong Replication to Vertica
Use CData Sync for automated, continuous, customizable Gong replication to Vertica.
-
Access Pipeliner CRM Data from MySQL in Amazon QuickSight
Connect to Pipeliner CRM and build visualizations of Pipeliner CRM data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Attio Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Attio replication to PostgreSQL.
-
How to Connect to Live Cvent Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Cvent data through natural language.
-
Create HubSpot-Connected Dashboards in Grafana
Connect to HubSpot Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to HubSpot data.
-
Access Zoho Inventory Data from MySQL in PHP
Connect to Zoho Inventory through the standard MySQL libraries in PHP.
-
Getting Started with the CData SSIS Components for Sentry
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Sentry.
-
SingleStore Reporting in OBIEE with the SingleStore JDBC Driver
Deploy the SingleStore JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to update Teradata from Excel
This article explains how to transfer data from Excel to Teradata using the Excel Add-In for Teradata.
-
Build Apps with Live Mode data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Mode data into the Adalo platform and build custom mobile and web applications with real-time Mode data.
-
How to Connect to Live Salesforce Marketing Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Salesforce Marketing data for you.
-
Connect to Paymo from Asprova with CData Software ODBC Driver for Paymo
This article shows how to connect faster to Paymo data from Asprova.
-
Use the CData ODBC Driver for CircleCI in Microsoft Power Query
You can use the CData CircleCI ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import CircleCI data into Microsoft Power Query.
-
Create Informatica Mappings From/To an ODBC Data Source for CampaignMonitor
Create an ODBC connection to CampaignMonitor in Informatica and browse and transfer CampaignMonitor data.
-
Excel Spreadsheet Automation on Google Tasks Data with the QUERY Formula
Pull data from Google Tasks, automate spreadsheets, and more with the QUERY formula.
-
Integrating Kiro with Stack Exchange 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.
-
Access Live ActiveCampaign Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live ActiveCampaign data through MCP integration.
-
Integrate Live Azure DevOps Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Azure DevOps data from within the IDE.
-
Build Avro Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Avro data and build visualizations in Tableau Cloud.
-
Connect to SAP SuccessFactors LMS Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP SuccessFactors LMS data from Crystal Reports.
-
Enable the Oracle Service Cloud JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Oracle Service Cloud data.
-
DataBind Charts to SAP HANA Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP HANA data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Analyze Dynamics NAV Data in Cognos Analytics
Use CData Connect AI to connect to Dynamics NAV Data from Cognos Analytics and analyze live Dynamics NAV data.
-
Integrating Dataiku with Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Cvent data.
-
Prepare, Blend, and Analyze MYOB AccountRight Data in Alteryx Designer (Connect AI)
Build workflows to access live MYOB AccountRight data for self-service data analytics.
-
Build NetSuite-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live NetSuite data.
-
Automate SAP Netweaver Gateway Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP Netweaver Gateway data replication to Azure Data Lake.
-
Analyze Zoho Inventory Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Zoho Inventory data with the CData JDBC Driver for Zoho Inventory.
-
Integrating LangGraph with Airtable Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Airtable data within automated workflows.
-
Automated Continuous SAP HANA Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP HANA replication to Snowflake.
-
Create Reports from Bannerbear Data in Looker Studio
Use CData Connect AI to gain access to live Bannerbear data and create custom reports in Looker Studio.
-
Automated Continuous Pushbullet Replication to Snowflake
Use CData Sync for automated, continuous, customizable Pushbullet replication to Snowflake.
-
Integrate Live Teamgate Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Teamgate data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Creating Greenplum-Connected Applications in Unqork
You can use CData Connect AI to feed Greenplum data to Unqork and build custom business apps.
-
Access Live Xero Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Xero data into the statistical analysis tools available in SAS JMP. This article shows how to use Xero data in the Graph Builder and Query Builder.
-
Establish a Live Connection with YouTube Analytics Data using Tableau Bridge
The CData ODBC Driver for YouTube Analytics enables you to integrate live YouTube Analytics data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Dashboards with Pushbullet Data in DBxtra
Create dynamic dashboards and perform analytics based on Pushbullet data in DBxtra.
-
Use the CData ODBC Driver for Spotify from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Spotify to connect to Spotify data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Spotify data in Excel.
-
Import and Visualize PolarTeamPro Data in Power View
Create data visualizations based on PolarTeamPro data in Excel.
-
Connect to Notion Data from Crystal Reports
Use CData Connect AI to connect to and report on live Notion data from Crystal Reports.
-
Build Voice Agents in ElevenLabs with access to Live TaxJar Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live TaxJar data.
-
Feed Unbounce Data into FineReport
How to set Unbounce data as a JDBC data source in FineReport.
-
Connect to GraphQL Data in ACL Analytics
Connect to GraphQL data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to GraphQL data.
-
Use the CData Software JDBC Driver for Twilio in MicroStrategy Desktop
Connect to Twilio data in MicroStrategy Desktop using the CData Software JDBC Driver for Twilio.
-
Use Biml to Build SSIS Tasks to Replicate ServiceNow Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ServiceNow data to SQL Server.
-
Query Parquet Data in ColdFusion
Write standard ColdFusion data access code to connect to Parquet data.
-
Access Microsoft Entra ID Data from MySQL in Amazon QuickSight
Connect to Microsoft Entra ID and build visualizations of Microsoft Entra ID data using a MySQL Connection in Amazon QuickSight.
-
Build Visualizations of Printful Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Printful data in Birst.
-
Use the CData Software ODBC Driver for ConvertAPI in MicroStrategy Web
Connect to ConvertAPI data in MicroStrategy Web using the CData Software ODBC Driver for ConvertAPI.
-
How to Connect to Live WooCommerce Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live WooCommerce data securely in real time.
-
Build Agents in Relevance AI with Access to Live Square Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Square data within intelligent agent workflows.
-
Connect to CloudConvert Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to CloudConvert.
-
Stream Sendwithus Data into Apache Kafka Topics
Access and stream Sendwithus data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to SAP SuccessFactors LMS Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP SuccessFactors LMS data.