CData Software - Knowledge Base
Recent Articles
-
Integrate Cline with Live Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Adobe Analytics from within your IDE.
-
Moving Data from Microsoft Entra ID to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Microsoft Entra ID data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Twilio
Provide connectivity to Twilio through an SAP BusinessObjects universe.
-
Prepare, Blend, and Analyze Demio Data in Alteryx Designer (ODBC)
Build workflows to access live Demio for self-service data analytics.
-
Connect to BigCommerce Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for BigCommerce Data and connect to BigCommerce in Akorbi Digital RunMyProcess.
-
Integrating OpenCode Terminal with Azure DevOps 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.
-
Create Reports with Azure Table Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Azure Table Storage.
-
Getting Started with the CData Power BI Connector for Oracle Financials Cloud
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Oracle Financials Cloud.
-
How to integrate Adobe Experience Manager with Apache Airflow
Access and process Adobe Experience Manager in Apache Airflow using the CData JDBC Driver.
-
Connect and Query Live SharePoint Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Microsoft SharePoint into Databricks
-
Visualize Live Clockify Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Clockify using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Manage BigQuery Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for BigQuery.
-
Build Visualizations of iContact Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of iContact in Birst.
-
How to connect PolyBase to Azure Analysis Services
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Azure Analysis Services.
-
Build BigQuery-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to BigQuery Data from Zoho Analytics and import live Google BigQuery.
-
How to Build an ETL App for Act CRM Data in Python with CData
Create ETL applications and real-time data pipelines for Act CRM in Python with petl.
-
Replicate Google Cloud Storage Data to Multiple Databases
Replicate Google Cloud Storage to disparate databases with a point-and-click configuration.
-
Access Live Apollo Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Apollo in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Configure the CData JDBC Driver for Amazon S3 in a Connection Pool in Tomcat
Connect to Amazon S3 from a connection pool in Tomcat.
-
Create a Data Access Object for PolarTeamPro Data using JDBI
A brief overview of creating a SQL Object API for PolarTeamPro in JDBI.
-
Connect to Pipedrive Data in DBArtisan
Use wizards in DBArtisan to configure Pipedrive as a data source.
-
View Reports on Real-Time Bitly Data in Power BI Report Server
Use the CData ODBC Driver for Bitly to visualize Bitly in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData Software ODBC Driver for Excel Online in MicroStrategy Web
Connect to Microsoft Excel Online in MicroStrategy Web using the CData Software ODBC Driver for Excel Online.
-
Work with Live Act CRM Data in Power Query
Use CData Connect AI to connect to Act CRM and work with live Act CRM in Microsoft Power Query.
-
Query Zoho CRM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Zoho CRM from Node.js.
-
DataBind Charts to Sage Intacct Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Sage Intacct 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.
-
Validate Microsoft Teams Data with QuerySurge
Access and validate Microsoft Teams in QuerySurge using the CData JDBC Driver.
-
DataBind Controls to Apify Data in Delphi
DataBind to Apify in Delphi with standard data access components and controls.
-
Consume MYOB AccountRight OData Feeds in SAP Lumira
Use the API Server to create data visualizations on MYOB AccountRight feeds that reflect any changes in SAP Lumira.
-
Bidirectional Access to Missive Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Missive in Filemaker Pro for Mac or Windows.
-
Load Instagram Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Instagram to a database.
-
Create Power BI Reports on Real-Time GetResponse Data
Use the CData ODBC Driver for GetResponse to visualize GetResponse in Power BI Desktop.
-
Access Live Authorize.Net Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Authorize.Net from your Excel spreadsheets.
-
Connect to SAP HANA Data from a Connection Pool in JBoss
Integrate SAP HANA into Java servlets: Use the Management Console in JBoss to install the SAP HANA JDBC Driver.
-
Integrate Cline with Live SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft SQL Server from within your IDE.
-
Migrating data from Office 365 to Databricks using CData SSIS Components.
Easily push Microsoft Office 365 to Databricks using the CData SSIS Tasks for Office 365 and Databricks.
-
Create Data Visualizations Based On Microsoft Entra ID Data in Mode
Use CData Connect AI to connect to Microsoft Entra ID Data from Mode and build visualizations using live
-
Analyze RabbitMQ Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for RabbitMQ from Power Pivot. You will use the Table Import Wizard to load RabbitMQ. You can visually build the import query or use any SQL supported by the driver.
-
Replicate Multiple MailChimp Accounts via the CData Sync CLI
Replicate multiple MailChimp accounts to one or many databases.
-
Natively Connect to Microsoft Planner Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Planner. Leverage the native support for ODBC in PHP.
-
Extract, Transform, and Load ServiceNow Data in Informatica PowerCenter
Create a simple Workflow for ServiceNow in Informatica PowerCenter.
-
Build Dashboards with Zoho CRM Data in Dundas BI
Create dynamic dashboards and perform analytics based on Zoho CRM in Dundas BI.
-
Model, Search, and Visualize Live SAS xpt Data in ThoughtSpot
Use CData Connect AI to connect to live SAS XPORT for modeling, searching, and visualizing.
-
Integrate Live Google Sheets Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Sheets and integrate live Google Sheets into apps built in Microsoft Power Apps.
-
Build Azure Synapse-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Azure Synapse Data and create custom apps in Mendix.
-
Automate Oracle HCM Cloud Data Replication to SAP HANA
Use CData Sync to customize and automate Oracle HCM Cloud replication to SAP HANA.
-
Use the CData Software JDBC Driver for REST in MicroStrategy Web
Connect to REST in MicroStrategy Web using the CData Software JDBC Driver for REST.
-
Work with MarkLogic Data in FoxPro
Load MarkLogic into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect to Live QuickBooks Time Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live QuickBooks Time securely in real time.
-
Excel Spreadsheet Automation on Printful Data with the QUERY Formula
Pull data from Printful, automate spreadsheets, and more with the QUERY formula.
-
Integrating Kiro CLI with LeadDesk 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.
-
Migrating data from Apify to Google BigQuery using CData SSIS Components.
Easily push Apify to Google BigQuery using the CData SSIS Tasks for Apify and Google BigQuery.
-
Connect to ZeroBounce Data in JRuby
Create a simple JRuby app with access to live ZeroBounce.
-
Perform Batch Operations with JSON Services in Apache NiFi
Connect to JSON and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Quickbase using the Model Context Protocol.
-
Create Power BI Reports on Real-Time Brex Data
Use the CData ODBC Driver for Brex to visualize Brex in Power BI Desktop.
-
How to load Greenhouse data into Elasticsearch via Logstash
Introducing a simple method to load Greenhouse data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Replicate CSV Data to Multiple Databases via the CData Sync CLI
Replicate CSV/TSV Files to disparate databases with a single configuration.
-
Work with Salesforce Marketing Data in FoxPro
Load Salesforce Marketing Cloud into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to ConstantContact Data in Jaspersoft Studio
Execute SQL to remote ConstantContact in Jaspersoft Studio.
-
Connect to Spotify Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Spotify.
-
Integrate Live Airtable Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Airtable to Blue Prism using the CData ODBC Driver for Airtable to create automated workflows for repetitive business tasks.
-
Connecting Agentforce with Cloudant 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 IBM Cloudant for you.
-
Integrating Claude Code CLI with Codat 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.
-
How to Connect the Power BI Service to ZeroBounce: Complete Guide
Connect to the CData Software Power BI Connector for ZeroBounce from PowerBI.com to provide real-time ZeroBounce across the organization.
-
Integrating ShipStation Data in Talend Cloud Data Management Platform
Connect ShipStation Data with Talend Cloud Data Management Platform using the CData JDBC Driver for ShipStation.
-
How to Connect to Live Couchbase 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 Couchbase through natural language.
-
Load AlloyDB Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google AlloyDB to a database.
-
Build LinkedIn Ads Visualizations in Tableau Desktop
Use CData Connect AI to connect to live LinkedIn Ads and build visualizations in Tableau.
-
How to connect to SAS xpt Data with Squirrel SQL client
Connect to SAS XPORT and execute queries in the Squirrel SQL Client.
-
Create MailChimp Dataflows on PowerBI.com
Connect to the CData Power BI Connector for MailChimp from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating Kiro CLI with SAP HANA XS Advanced 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.
-
Import WooCommerce Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to WooCommerce Data and provide access to live WooCommerce for custom reports in the Power BI Service.
-
Integrate Live Gmail Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Gmail to Blue Prism using the CData ODBC Driver for Gmail to create automated workflows for repetitive business tasks.
-
Access Customer.io Data from MySQL in PHP
Connect to Customer.io through the standard MySQL libraries in PHP.
-
Publish Crystal Reports on Eventbrite Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Eventbrite.
-
Automated Continuous Smartsheet Replication to Snowflake
Use CData Sync for automated, continuous, customizable Smartsheet replication to Snowflake.
-
Use the CData ODBC Driver for SAP Ariba Source in Microsoft Power Query
You can use the CData SAP Ariba Source ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP Ariba Source into Microsoft Power Query.
-
Visualize HelloSign Data in Sisense
Create an ElastiCube in Sisense app with access to HelloSign.
-
Access Hubstaff Data from MySQL in PHP
Connect to Hubstaff through the standard MySQL libraries in PHP.
-
Integrating Claude Code CLI with Notion 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 SQL Server Data in Coginiti Pro
Connect to and query live Microsoft SQL Server from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Insightly Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Insightly replication to PostgreSQL.
-
Automated Continuous Act-On Replication to MongoDB
Use CData Sync for automated, continuous, customizable Act-On replication to MongoDB.
-
Natively Connect to Google Translate Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Translate. Leverage the native support for ODBC in PHP.
-
Automate Tasks in Power Automate Using the CData API Server
Automate TaxJar actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Automated Continuous Pipeline CRM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to Google BigQuery.
-
Automated Continuous Float Replication to MySQL
Use CData Sync for automated, continuous, customizable Float replication to MySQL.
-
Analyze EnterpriseDB Data in Cognos Analytics
Use CData Connect AI to connect to EnterpriseDB Data from Cognos Analytics and analyze live EnterpriseDB.
-
Connect to Wrike Data in Ruby
Connect to Wrike in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Rapidly Develop Presto-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 Presto.
-
Use Claude to Talk to Your Box 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 Box for you.
-
Integrate LibreChat with Live SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SAP BusinessObjects BI from within the chat interface.
-
Getting Started with the CData Tableau Connector for Instantly
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Publish Crystal Reports on ADP Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ADP.
-
Integrating OpenCode Terminal with Google Contacts 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.
-
How to Work with NASA Data in ETL Validator JDBC
Connect to NASA from ETL Validator jobs using the CData Software JDBC Driver.
-
Query Email Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Email from Node.js.
-
Build Adobe Target-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Adobe Target.
-
Integrating Antigravity CLI with Google BigQuery via CData CLI
Connect Google BigQuery to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.