CData Software - Knowledge Base
Recent Articles
-
Automated Continuous SQL Server Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SQL Server replication to IBM DB2.
-
Use the CData ODBC Driver for Google Analytics from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Analytics to connect to Google Analytics data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Analytics data in Excel.
-
DataBind Controls to Tally Data in Delphi
DataBind to Tally data in Delphi with standard data access components and controls.
-
Connect to and Visualize Live Google Cloud Storage Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Cloud Storage data.
-
Automated Continuous Amazon Athena Replication to SQLite
Use CData Sync for automated, continuous, customizable Amazon Athena replication to SQLite.
-
Connecting Agentforce with Act-On Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Act-On data for you.
-
Use the CData ODBC Driver for Zoom from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Zoom to connect to Zoom data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zoom data in Excel.
-
Automated Continuous AgileCRM Replication to Vertica
Use CData Sync for automated, continuous, customizable AgileCRM replication to Vertica.
-
How to Connect Flowise AI Agents to Live Kintone Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Kintone data without replication.
-
Use Dash to Build Web Apps on SAS xpt Data via CData Connect AI
Build interactive Dash web apps on live SAS xpt data using pandas and the CData Connect AI Python SDK.
-
Replicate Amazon Athena Data in Heroku for Use in Salesforce Connect
Replicate Amazon Athena data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create iContact-Connected Applications in Appsmith
Connect to iContact Data via CData Connect AI in Appsmith and create custom business applications with real-time access to iContact data.
-
Automated Continuous Neo4J Replication to SQLite
Use CData Sync for automated, continuous, customizable Neo4J replication to SQLite.
-
Automated Continuous Adobe Commerce Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to IBM DB2.
-
Excel Spreadsheet Automation on SAP SuccessFactors Data with the QUERY Formula
Pull data from SAP SuccessFactors, automate spreadsheets, and more with the QUERY formula.
-
Extract, Transform, and Load Act-On Data in Informatica PowerCenter
Create a simple Workflow for Act-On data in Informatica PowerCenter.
-
Connect to SAP ByDesign Data in CloverDX (formerly CloverETL)
Transfer SAP ByDesign data using the visual workflow in the CloverDX data integration tool.
-
Connect to Live Zoho Projects Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Zoho Projects in CData Connect AI and connect to your Zoho Projects data from PostgreSQL.
-
Design BIRT Reports on Microsoft OneDrive Data
Provide current Microsoft OneDrive data to your embedded analytics.
-
How to Connect DBeaver to Simplesat via a JDBC Driver
Manage Simplesat data with visual tools in DBeaver like the query browser.
-
Create Adobe Experience Manager-Connected Dashboards in Grafana
Connect to Adobe Experience Manager Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Adobe Experience Manager data.
-
Visualize Live Opsgenie Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Opsgenie data.
-
Migrating data from Pinterest to Databricks using CData SSIS Components.
Easily push Pinterest data to Databricks using the CData SSIS Tasks for Pinterest and Databricks.
-
How to create RabbitMQ federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for RabbitMQ data in MySQL .
-
Build Automated Workflows with Live Reckon Data in Workato
Use CData Connect AI to connect to live Reckon data and build automated workflows in Workato.
-
Integrate with CSV Data in JReport Designer
Create charts and reports based on CSV data in JReport Designer.
-
Use Agno to Talk to Your Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Microsoft Entra ID data for you.
-
How to Access Zoho Recruit Data Using Entity Framework
This article shows how to access Zoho Recruit data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect to & Open Cloudant Data in Microsoft Excel
This article uses the CData ODBC driver for Cloudant to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Charts with Telegram Data in Clear Analytics
Create dynamic charts and perform analytics based on Telegram data in Clear Analytics.
-
Create Reports from Supabase Data in Looker Studio
Use CData Connect AI to gain access to live Supabase data and create custom reports in Looker Studio.
-
Visualize Cohere Data in Sisense
Create an ElastiCube in Sisense app with access to Cohere data.
-
Configure the CData JDBC Driver for WordPress in a Connection Pool in Tomcat
Connect to WordPress data from a connection pool in Tomcat.
-
Integrate Dify with Live Blackbaud FE NXT Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Blackbaud FE NXT data.
-
Automated Continuous CSV Replication to Databricks
Use CData Sync for automated, continuous, customizable CSV replication to Databricks.
-
Integrating Smartsheet Data in Talend Cloud Data Management Platform
Connect Smartsheet Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Smartsheet.
-
Act CRM Reporting in OBIEE with the Act CRM JDBC Driver
Deploy the Act CRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Seamlessly Import Dynamics 365 Data into IBM SPSS Modeler
Integrate Dynamics 365 data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Prepare, Blend, and Analyze Microsoft Planner Data in Alteryx Designer (Connect AI)
Build workflows to access live Microsoft Planner data for self-service data analytics.
-
Getting Started with the CData Python Connector for Google Calendar
Learn to install and license the CData Python Connector and configure a connection to live Google Calendar data.
-
ETL Xero in Oracle Data Integrator
This article shows how to transfer Xero data into a data warehouse using Oracle Data Integrator.
-
Create Data Visualizations in Cognos BI with Float Data
Access Float data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Chargebee Data from PowerBuilder via ADO.NET
This article demonstrates how to access Chargebee data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Semantic Layer Views for BigCommerce Data in APOS Live Data Gateway
Use the CData Connector for BigCommerce in APOS Live Data Gateway to build Semantic Layer Views for BigCommerce data.
-
Use the CData Software ODBC Driver for ChargeOver in MicroStrategy Web
Connect to ChargeOver data in MicroStrategy Web using the CData Software ODBC Driver for ChargeOver.
-
Analyze MySQL Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of MySQL data and visualize live MySQL data in Infragistics Reveal.
-
Build Dynamics 365 Business Central-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Dynamics 365 Business Central data.
-
Automated Continuous Sentry Replication to Vertica
Use CData Sync for automated, continuous, customizable Sentry replication to Vertica.
-
Create Moosend Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Moosend data access from reports, embedded analytics, and more.
-
Create Amazon S3-Connected Business Apps in AppSheet
Connect to Amazon S3 Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Amazon S3 data.
-
Manage Slack Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Slack.
-
Use the CData Software ODBC Driver for Teamgate in MicroStrategy
Connect to Teamgate data in MicroStrategy Developer using the CData Software ODBC Driver for Teamgate.
-
Access Clari Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Clari data from HeidiSQL.
-
Build JotForm-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live JotForm data.
-
Access Live Splunk Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Splunk data into the statistical analysis tools available in SAS JMP. This article shows how to use Splunk data in the Graph Builder and Query Builder.
-
Getting Started with the CData ADO.NET Provider for MailerSend
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to connect to OneNote Data in DBVisualizer
Integrate OneNote data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect to Live Cloudflare Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Cloudflare data for you.
-
Migrating data from LDAP to Snowflake using CData SSIS Components.
Easily push LDAP objects to Snowflake using the CData SSIS Tasks for LDAP and Snowflake.
-
Connect to Oracle Financials Cloud Data in JRuby
Create a simple JRuby app with access to live Oracle Financials Cloud data.
-
Integrate Google's Antigravity Agent with Live Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Paylocity data using the Model Context Protocol.
-
Integrate with Quickbase Data in JReport Designer
Create charts and reports based on Quickbase data in JReport Designer.
-
Connect to Wave Financial from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Wave Financial data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Easily Query SurveyMonkey Data in OpenOffice Base
Connect to SurveyMonkey data in OpenOffice Base using the CData ODBC Driver for SurveyMonkey and generate reports with live data insights.
-
Replicate IBM Informix Data to Multiple Databases
Replicate IBM Informix data to disparate databases with a point-and-click configuration.
-
Connect to Sugar CRM Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Sugar CRM.
-
Integrate Cline with Live Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Exact Online data from within your IDE.
-
Connect to Real-Time CircleCI Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use CircleCI data in Power Apps.
-
Connect to Gong Data in Aqua Data Studio
Access Gong data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to import Paymo Data into Apache Solr
Use the CData Software JDBC Driver for Paymo in Data Import Handler and create an automated import of Paymo data to Apache Solr Enterprise Search platform.
-
Seamlessly Bring Reckon Data into Retool Using CData Connect AI
Integrate Reckon data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Using the CData Software ODBC Driver for SAP Fieldglass in PyCharm
Connect to SAP Fieldglass as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP Fieldglass.
-
How to Connect to Live Microsoft Ads Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Microsoft Ads data for you.
-
How to Connect to Live SAP Concur Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your SAP Concur data for you.
-
Use the CData SSIS Components to Insert New or Update Existing Dynamics 365 Business Central Records from SQL Server
Easily push SQL Server data to Dynamics 365 Business Central using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Dynamics 365 Business Central or update existing records with data from a SQL Server database.
-
Moving Data from Webflow to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Webflow data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Query ZohoInvoice Data in MySQL Workbench
Execute MySQL queries against live ZohoInvoice data from MySQL Workbench.
-
How to import Omnisend Data into Apache Solr
Use the CData Software JDBC Driver for Omnisend in Data Import Handler and create an automated import of Omnisend data to Apache Solr Enterprise Search platform.
-
Work with Harvest Data in FoxPro
Load Harvest data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to JotForm Data in JRuby
Create a simple JRuby app with access to live JotForm data.
-
Replicate Customer.io Data in Heroku for Use in Salesforce Connect
Replicate Customer.io data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect Codat to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Codat data using the CData Python MCP Server.
-
Use Dash to Build to Web Apps on Cohere Data
Create Python applications that use pandas and Dash to build Cohere-connected web apps.
-
How to Query Live Google Drive Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Drive data data in natural language using Python.
-
Import Avro Data Using Azure Data Factory
Use CData Connect AI to connect to Avro Data from Azure Data Factory and import live Avro data.
-
Publish SAP SuccessFactors LMS-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP SuccessFactors LMS data.
-
Query Quickbase Data in DataGrip
Create a Data Source for Quickbase in DataGrip and use SQL to query live Quickbase data.
-
Build Apps with Live Instagram Data Using the Low-Code Development Platform of Mendix
Connect Instagram data with Mendix to build apps using the CData JDBC Driver for Instagram.
-
Automated Continuous TaxJar Replication to Databricks
Use CData Sync for automated, continuous, customizable TaxJar replication to Databricks.
-
Create Data Visualizations Based On Perplexity Data in Mode
Use CData Connect AI to connect to Perplexity Data from Mode and build visualizations using live Perplexity data.
-
Connect to ZendeskSell Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ZendeskSell to connect to ZendeskSell data and execute queries in PowerBuilder.
-
Visualize NASA Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to NASA data.
-
How to work with Todoist Data in Apache Spark using SQL
Access and process Todoist Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to ConstantContact Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live ConstantContact data from Filemaker Pro on Mac.
-
Query SendPulse Data in ColdFusion
Write standard ColdFusion data access code to connect to SendPulse data.
-
How to connect and process Scrapfly data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Scrapfly data.
-
Visualize ShipStation Data in Tableau
The CData ODBC driver for ShipStation enables you integrate ShipStation data into Tableau dashboards.
-
Publish Reports with Sage Cloud Accounting Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sage Cloud Accounting data.
-
Visualize Datadog Data in Tableau
The CData ODBC driver for Datadog enables you integrate Datadog data into Tableau dashboards.
-
Integrate EnterpriseDB Data in the Pentaho Report Designer
Publish reports based on EnterpriseDB data in the Pentaho BI tool.