CData Software - Knowledge Base
Recent Articles
-
Integrate Odoo Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Odoo data and integrate live Odoo data into your Power Automate tasks.
-
How to Connect to & Open SharePoint Data in Microsoft Excel
This article uses the CData ODBC driver for SharePoint to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Work with Zoho Inventory Data in FoxPro
Load Zoho Inventory data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Pushbullet with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Pushbullet with External Services.
-
Migrating data from Ontraport to Snowflake using CData SSIS Components.
Easily push Ontraport data to Snowflake using the CData SSIS Tasks for Ontraport and Snowflake.
-
Explore Geographical Relationships in Toggl Data with Power Map
Create data visualizations with Toggl data in Power Map.
-
Access Live Tickspot Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Tickspot data into the statistical analysis tools available in SAS JMP. This article shows how to use Tickspot data in the Graph Builder and Query Builder.
-
Integrating Claude Code CLI with Productboard 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.
-
Build Voice Agents in ElevenLabs with access to Live Amazon Athena Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Amazon Athena data.
-
Building Dynamic Web Pages with Amazon Marketplace Data Using AngularJS
Create single-page applications with live connectivity to Amazon Marketplace using the CData API Server.
-
Create Apps from AlloyDB Data in Qlik Sense Cloud
Use CData Connect AI to connect to AlloyDB Data and build apps from live AlloyDB data in Qlik Sense Cloud.
-
Build Semantic Layer Views for Google Search Results in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Search results.
-
Integrate Dify with Live Freshservice 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 Freshservice data.
-
Connect to Real-Time Acumatica Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Acumatica and Dataflow to import and use Acumatica data in Power Apps.
-
Automated Continuous Pipedrive Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Pipedrive replication to delimited files (CSV/TSV).
-
Create Informatica Mappings From/To a JDBC Data Source for QuickBooks
Create QuickBooks data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous CapsuleCRM Replication to Vertica
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Vertica.
-
How to Seamlessly Import ZohoExpense Data into IBM SPSS Modeler
Integrate ZohoExpense data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Amazon DynamoDB Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Amazon DynamoDB Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Attio Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Attio data in Airbyte.
-
Extract, Transform, and Load Microsoft Planner Data in Informatica PowerCenter
Create a simple Workflow for Microsoft Planner data in Informatica PowerCenter.
-
Create Dynamics 365-Connected Business Apps in AppSheet
Connect to Dynamics 365 Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Dynamics 365 data.
-
Query Zendesk Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Zendesk entities in PHP by modeling them as objects.
-
Integrate with Couchbase Data in JReport Designer
Create charts and reports based on Couchbase data in JReport Designer.
-
Connect Azure Data Catalog Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Azure Data Catalog data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
ETL Coinbase in Oracle Data Integrator
This article shows how to transfer Coinbase data into a data warehouse using Oracle Data Integrator.
-
Connecting GenSpark with MariaDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to MariaDB data without any replication or custom integration required.
-
Getting Started with the CData ADO.NET Provider for Zoho Recruit
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect Facebook Ads Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Facebook Ads data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create MailerLite-Connected Nintex Workflows
Use CData Connect AI to connect to MailerLite Data from Nintex Workflow Cloud and build custom workflows using live MailerLite data.
-
Access Live SendPulse Data in Excel 365 Online (Excel for the web)
Connect to SendPulse data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to work with Bright Data Data in Apache Spark using SQL
Access and process Bright Data Data in Apache Spark using the CData Software JDBC Driver.
-
Use Agno to Talk to Your TaxJar 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 TaxJar data for you.
-
Automate AdRoll Data Replication to SAP HANA
Use CData Sync to customize and automate AdRoll data replication to SAP HANA.
-
How to Visualize Rebilly Data in Python with pandas
Use pandas and other modules to analyze and visualize live Rebilly data in Python.
-
Validate Kintone Data with QuerySurge
Access and validate Kintone data in QuerySurge using the CData JDBC Driver.
-
How to Access Rootly Data Using Entity Framework
This article shows how to access Rootly data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Cassandra-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Cassandra data.
-
Use the CData Software ODBC Driver for ActiveCampaign in MicroStrategy Desktop
Connect to ActiveCampaign data in MicroStrategy Desktop using the CData Software ODBC Driver for ActiveCampaign.
-
Getting Started with the CData ODBC Driver for Gorgias
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Gorgias.
-
Write a Simple Go Application to work with Sentry Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sentry data.
-
Manage ServiceDesk Plus Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ServiceDesk Plus.
-
Automate MailChimp Data Replication to Azure Synapse
Use CData Sync to customize and automate MailChimp data replication to Azure Synapse.
-
Automated Continuous SpaceX Replication to SingleStore
Use CData Sync for automated, continuous, customizable SpaceX replication to SingleStore.
-
Bridge Printful Connectivity with Apache NiFi
Access and process Printful data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous SAP BusinessObjects BI Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to AlloyDB.
-
Connect and Query Live Freshteam Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Freshteam data into Databricks and enable direct, live querying and analysis without replication.
-
Automated Continuous Mode Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Mode replication to Apache Cassandra.
-
Integrate with Salesforce Marketing Data in JReport Designer
Create charts and reports based on Salesforce Marketing data in JReport Designer.
-
Connect to Greenhouse Data in RazorSQL
Connect to Greenhouse from wizards and query Greenhouse data from the GUI in the RazorSQL database management tool.
-
Create Reports with Google Calendar Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Calendar data.
-
Integrate SuiteCRM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SuiteCRM with External Services.
-
Use Azure AI Foundry to Talk to Your YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your YouTube Analytics data for you.
-
Integrate Sybase IQ Data in the Pentaho Report Designer
Publish reports based on Sybase IQ data in the Pentaho BI tool.
-
Webex Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Webex facts in real time.
-
Manage SAP Concur Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP Concur.
-
Automated Continuous Campaigner Replication to MySQL
Use CData Sync for automated, continuous, customizable Campaigner replication to MySQL.
-
Build Apps with Live MYOB AccountRight data in Adalo using CData Connect AI
Use CData Connect AI to integrate live MYOB AccountRight data into the Adalo platform and build custom mobile and web applications with real-time MYOB AccountRight data.
-
Prepare, Blend, and Analyze Wistia Data in Alteryx Designer (ODBC)
Build workflows to access live Wistia data for self-service data analytics.
-
Use the CData Software JDBC Driver for ShipEngine in MicroStrategy Web
Connect to ShipEngine data in MicroStrategy Web using the CData Software JDBC Driver for ShipEngine.
-
Operational Reporting on DocuSign Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote DocuSign data.
-
How to Seamlessly Import Outlook Data into IBM SPSS Modeler
Integrate Outlook data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use ChatGPT to Talk to Your ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your ServiceNow data for you.
-
Enable the Airtable JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Airtable data.
-
Integrate Shippo Data in the Pentaho Report Designer
Publish reports based on Shippo data in the Pentaho BI tool.
-
Visualize Live Vimeo Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Vimeo data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Grok to Talk to Your Aweber Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Aweber data for you.
-
Replicate LaunchDarkly Data in Heroku for Use in Salesforce Connect
Replicate LaunchDarkly data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData ODBC Driver for Suadeo from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Suadeo to connect to Suadeo data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Suadeo data in Excel.
-
Build Oracle Financials Cloud-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Oracle Financials Cloud Data from Zoho Analytics and import live Oracle Financials Cloud data.
-
Query Live SparkPost Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live SparkPost data directly from the development environment.
-
Automated Continuous Cloudant Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Cloudant replication to Amazon Redshift.
-
Automated Continuous Splunk Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Splunk replication to Apache Kafka.
-
How to work with Excel Data in Apache Spark using SQL
Access and process Excel Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to SAP SuccessFactors Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP SuccessFactors data.
-
Connect to Live Bannerbear Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Bannerbear in CData Connect AI and connect to your Bannerbear data from PostgreSQL.
-
Access Live Freshteam Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Freshteam data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build LinkedIn Ads-Connected Apps in Choreo
Use CData Connect AI to connect to LinkedIn Ads Data from Choreo and build custom apps using live LinkedIn Ads data.
-
Integrating GitHub Copilot with Sage Intacct 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.
-
Visualize OnePageCrm Data in Tableau
The CData ODBC driver for OnePageCrm enables you integrate OnePageCrm data into Tableau dashboards.
-
Integrating Claude Code with Wave Financial Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Wave Financial data within assisted coding and automated development workflows.
-
Connecting GenSpark with CSV Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to CSV data without any replication or custom integration required.
-
ETL Suadeo in Oracle Data Integrator
This article shows how to transfer Suadeo data into a data warehouse using Oracle Data Integrator.
-
DataBind Controls to Oracle HCM Cloud Data in C++Builder
DataBind to Oracle HCM Cloud data in C++Builder with standard components and controls.
-
Use Biml to Build SSIS Tasks to Replicate Google Cloud Storage Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Cloud Storage data to SQL Server.
-
Connect to Salesforce Pardot Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Salesforce Pardot and the Script function in FileMaker Pro to connect to Salesforce Pardot and work with Salesforce Pardot data in your FileMaker application.
-
Query Azure Data Lake Storage Data as a SQL Server Database in Node.js
Execute SQL Server queries against Azure Data Lake Storage data from Node.js.
-
How to use SQLAlchemy ORM to access Elasticsearch Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Elasticsearch data.
-
Integrate Dify with Live JSON 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 JSON services.
-
Create SSAS Tabular Models from Airtable Data
How to build a SQL Server Analysis Service Tabular Model from Airtable data using CData drivers.
-
Query CouchDB Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume CouchDB entities in PHP by modeling them as objects.
-
Analyze LeadDesk Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for LeadDesk from Power Pivot. You will use the Table Import Wizard to load LeadDesk data. You can visually build the import query or use any SQL supported by the driver.
-
Deploy the ADO.NET Provider for Miro on an SSRS Report Server
Connect to Miro data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Access Live SQL Server 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 SQL Server data through MCP integration.
-
Automate SAP HANA XS Advanced Data Replication to SAP HANA
Use CData Sync to customize and automate SAP HANA XS Advanced data replication to SAP HANA.
-
Build Automated Workflows with Live MarkLogic Data in Workato
Use CData Connect AI to connect to live MarkLogic data and build automated workflows in Workato.
-
Work with Sage Cloud Accounting Data in FoxPro
Load Sage Cloud Accounting data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Configure the CData JDBC Driver for SAP Netweaver Gateway in a Connection Pool in Tomcat
Connect to SAP Netweaver Gateway data from a connection pool in Tomcat.
-
Query HCL Domino Data in ColdFusion
Write standard ColdFusion data access code to connect to HCL Domino data.
-
Access Live AfterShip Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live AfterShip data from your Excel spreadsheets.