CData Software - Knowledge Base
Recent Articles
-
How to Query Apollo Data in MySQL Workbench
Execute MySQL queries against live Apollo from MySQL Workbench.
-
Automate Twitter Ads Data Replication to Couchbase
Use CData Sync to Customize and automate Twitter Ads replication to Couchbase.
-
Analyze Active Directory Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Active Directory from Power Pivot. You will use the Table Import Wizard to load Active Directory. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Cline with Live SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAS XPORT from within your IDE.
-
Query AdRoll Data in ColdFusion
Write standard ColdFusion data access code to connect to AdRoll.
-
Getting Started with the CData Power BI Connector for Blackbaud FE NXT
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Blackbaud FE NXT.
-
Integrating Claude Code CLI with Pipeliner CRM 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 Zoho Inventory Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Zoho Inventory data access from reports, embedded analytics, and more.
-
Natively Connect to Splunk Data in PHP
The CData ODBC driver for Splunk enables you to create PHP applications with connectivity to Splunk. Leverage the native support for ODBC in PHP.
-
How to Create Power BI Visual Reports with Real-Time Exa Data
Use CData Power BI Connectors to visualize Exa in Power BI.
-
Process & Analyze RabbitMQ Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live RabbitMQ Data.
-
Build Automated OData-Connected Workflows in Zapier
Use CData Connect AI to connect to live OData and build automated workflows in Zapier.
-
Connect to MailChimp Data in CloverDX (formerly CloverETL)
Transfer MailChimp using the visual workflow in the CloverDX data integration tool.
-
Migrating data from ShipEngine to Google BigQuery using CData SSIS Components.
Easily push ShipEngine to Google BigQuery using the CData SSIS Tasks for ShipEngine and Google BigQuery.
-
Use Microsoft Copilot Studio to talk to your Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Xero Accounting for you.
-
Object-Relational Mapping (ORM) with Pinecone Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Pinecone into a Java-based ORM framework, Hibernate.
-
How to Work with Jira Data in AWS Glue Jobs Using JDBC
Connect to Jira from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Perigon Data in NetBeans
Connect to Perigon in NetBeans with the data source configuration wizard.
-
Build Dashboards with Sage Cloud Accounting Data in DBxtra
Create dynamic dashboards and perform analytics based on Sage Business Cloud Accounting in DBxtra.
-
Connect to Everhour from Asprova with CData Software ODBC Driver for Everhour
This article shows how to connect faster to Everhour data from Asprova.
-
Connect to Splunk Data in Claris FileMaker Pro
Use the CData ODBC Driver for Splunk in FileMaker Pro to connect to Splunk and work with Splunk in your FileMaker applications.
-
Connect to Epicor Kinetic Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Epicor Kinetic in the Denodo Virtual DataPort Administrator.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Testmonitor
Provide connectivity to Testmonitor through an SAP BusinessObjects universe.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Oracle Eloqua Reporting to Power BI dashboards. Simply drag and drop Oracle Eloqua Reporting into data visuals on the Power BI canvas.
-
Connect to Instagram Data from HeidiSQL
Use CData Connect AI to connect to and query live Instagram from HeidiSQL.
-
Connect to Parquet Data in Claris FileMaker Pro
Use the CData ODBC Driver for Parquet in FileMaker Pro to connect to Parquet and work with Apache Parquet in your FileMaker applications.
-
Migrating data from Cloudant to Google BigQuery using CData SSIS Components.
Easily push IBM Cloudant to Google BigQuery using the CData SSIS Tasks for Cloudant and Google BigQuery.
-
Bind Live HubDB Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live HubDB data
-
How to create an RPA flow for Factorial Data in UiPath Studio
Use the Factorial ODBC Driver to create workflows that access real-time Factorial without any coding.
-
Integrate with YouTube Analytics Data in JReport Designer
Create charts and reports based on YouTube Analytics in JReport Designer.
-
Connect to Mailgun Data in Ruby
Connect to Mailgun in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Apps with Live IBM Cloud Object Storage in Adalo using CData Connect AI
Use CData Connect AI to integrate live IBM Cloud Object Storage into the Adalo platform and build custom mobile and web applications with real-time IBM Cloud Object Storage.
-
Connect to SurveyMonkey Data from PowerBuilder via JDBC
This article demonstrates how to access SurveyMonkey from PowerBuilder using the SurveyMonkey JDBC Driver.
-
How to create an RPA flow for Bitbucket Data in UiPath Studio
Use the Bitbucket ODBC Driver to create workflows that access real-time Bitbucket without any coding.
-
How to publish and share Simplesat Data dashboards with Tableau Server
The CData ODBC driver for Simplesat enables you integrate Simplesat into Tableau dashboards.
-
Getting Started with the CData Power BI Connector for FTP
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for FTP.
-
How to Create Power BI Visual Reports with Real-Time xBase Data
Use CData Power BI Connectors to visualize xBase in Power BI.
-
How to Connect to Live Microsoft Planner 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 Microsoft Planner for you.
-
Deploy the ADO.NET Provider for Sage Cloud Accounting on an SSRS Report Server
Connect to Sage Business Cloud Accounting 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.
-
Create Informatica Mappings From/To a JDBC Data Source for Factorial
Create Factorial data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Teamgate Reporting in OBIEE with the Teamgate JDBC Driver
Deploy the Teamgate JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Microsoft Exchange Data in ACL Analytics
Connect to Microsoft Exchange via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft Exchange.
-
Create Hubstaff Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Hubstaff data access from reports, embedded analytics, and more.
-
Build Charts with Dynamics CRM Data in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft Dynamics CRM in Clear Analytics.
-
Query Smartsheet Data as a SQL Server Database in Node.js
Execute SQL Server queries against Smartsheet from Node.js.
-
How to Query Live MailChimp Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live MailChimp data in natural language using Python.
-
Connect to Google Cloud Storage from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Cloud Storage to connect to Google Cloud Storage from Web applications running on WebLogic.
-
Getting Started with the CData JDBC Driver for Azure Analysis Services
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Azure Analysis Services.
-
How to Query Mode Data in MySQL Workbench
Execute MySQL queries against live Mode from MySQL Workbench.
-
Connect to Facebook Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Facebook from Filemaker Pro on Mac.
-
Analyze Salesforce Pardot Data in Looker
Use CData Connect AI to connect to Salesforce Pardot Data from Looker and build custom apps using live Salesforce Pardot.
-
Connect to Coinbase from a Connection Pool in WebLogic
Use the CData JDBC Driver for Coinbase to connect to Coinbase from Web applications running on WebLogic.
-
Extend Google Sheets with Cloudant Data
Make calls to Cloudant from Google Apps Script via the API Server.
-
How to Connect to Salesforce Marketing Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Salesforce Marketing Cloud. Leverage the pyodbc module for ODBC in Python.
-
Add LaunchDarkly Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for LaunchDarkly with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData Tableau Connector for Okta
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Okta.
-
Choosing the Best Method to Connect PostgreSQL to SQL Server: 5 Options Explained
Discover multiple ways to connect and use PostgreSQL from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Validate TigerGraph Data with QuerySurge
Access and validate TigerGraph in QuerySurge using the CData JDBC Driver.
-
Connect to Excel Online Data in Aqua Data Studio
Access Microsoft Excel Online from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Access Live ShipStation Data in Visual Studio Code via Cline
Run CData MCP Server for ShipStation on Windows Subsytem for Linux (WSL) and connect to live ShipStation from the Cline extension in Visual Studio Code.
-
Access Live Couchbase Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Couchbase into the statistical analysis tools available in SAS JMP. This article shows how to use Couchbase in the Graph Builder and Query Builder.
-
Automated Continuous Google Tasks Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Tasks replication to Azure SQL Database.
-
DataBind Charts to Amazon Athena Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Amazon Athena 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.
-
Integrating Claude Code CLI with ClickUp 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.
-
Viewing EnterpriseDB Data in RAD Studio Data Explorer
How to view EnterpriseDB in RAD Studio Data Explorer using the CData ODBC Driver for EnterpriseDB.
-
Easily Integrate Spotify Data in Lazarus Pascal IDE
Learn how to easily integrate live Spotify in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize SAP Ariba Source Data in Tableau
The CData ODBC driver for SAP Ariba Source enables you integrate SAP Ariba Source into Tableau dashboards.
-
Migrating data from Calendly to Snowflake using CData SSIS Components.
Easily push Calendly to Snowflake using the CData SSIS Tasks for Calendly and Snowflake.
-
How to Work with Jira Assets Data in ETL Validator JDBC
Connect to Jira Assets from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for SharePoint Excel Services in MicroStrategy Desktop
Connect to SharePoint Excel Services in MicroStrategy Desktop using the CData Software ODBC Driver for SharePoint Excel Services.
-
Automate LinkedIn Data Replication to SAP HANA
Use CData Sync to customize and automate LinkedIn replication to SAP HANA.
-
Build Automated Oracle Sales-Connected Workflows in Zapier
Use CData Connect AI to connect to live Oracle Sales and build automated workflows in Zapier.
-
Analyze Bitbucket Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Bitbucket in Microsoft R Open.
-
Create Data Visualizations Based On Sage Intacct Data in Mode
Use CData Connect AI to connect to Sage Intacct Data from Mode and build visualizations using live
-
Connect to Mixpanel in SpagoBI
Create reports featuring live Mixpanel in SpagoBI Studio. Host Mixpanel reports on SpagoBI Server.
-
How to Query Redshift Data in MySQL Workbench
Execute MySQL queries against live Amazon Redshift from MySQL Workbench.
-
Use CData Connect AI to Access Sage Cloud Accounting Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Sage Business Cloud Accounting in the Power Pivot business intelligence tool.
-
Use the CData Software JDBC Driver for Asana in MicroStrategy
Connect to Asana in MicroStrategy Developer using the CData Software JDBC Driver for Asana.
-
Use Biml to Build SSIS Tasks to Replicate PolarTeamPro Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate PolarTeamPro to SQL Server.
-
Connect to Snapchat Ads Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Query Sage Cloud Accounting Data in ColdFusion
Write standard ColdFusion data access code to connect to Sage Business Cloud Accounting.
-
Automated Continuous Zoho CRM Replication to Oracle
Use CData Sync for automated, continuous, customizable Zoho CRM replication to Oracle.
-
Create Datasets from Redshift in Domo Workbench and Build Visualizations of Redshift Data in Domo
Use the CData Software ODBC Driver for Redshift to create datasets from Amazon Redshift in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Cline with Live OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft OneNote from within your IDE.
-
Integrate with SAP Business Warehouse Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP Business Warehouse to a JSON file on disk.
-
Extend Google Sheets with HubDB Data
Make calls to HubDB from Google Apps Script via the API Server.
-
Build Visualizations of Elasticsearch Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Elasticsearch in Birst.
-
Connect to Google Analytics Data in JRuby
Create a simple JRuby app with access to live Google Analytics.
-
Connect to ZarMoney Data in RapidMiner
Integrate ZarMoney with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData Tableau Connector for Deel
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Feed Greenplum Data into FineReport
How to set Pivotal GreenPlum as a JDBC data source in FineReport.
-
Integrating Claude Code CLI with Salesforce Pardot 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.
-
Replicate Multiple Azure Blob Storage Accounts via the CData Sync CLI
Replicate multiple Azure Blob Storage accounts to one or many databases.
-
Integrate with Elasticsearch Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Elasticsearch in SnapLogic.
-
How to Connect DBeaver to Sage 200 via a JDBC Driver
Manage Sage 200 with visual tools in DBeaver like the query browser.
-
Automate Adobe Target Data Replication to Azure Data Lake
Use CData Sync to customize and automate Adobe Target replication to Azure Data Lake.
-
DataBind Controls to ConvertKit Data in C++Builder
DataBind to ConvertKit in C++Builder with standard components and controls.
-
Integrate Mailgun with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Mailgun with External Services.
-
Access ShipStation Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ShipStation from HeidiSQL.
-
Integrating Claude Code CLI with CloudConvert 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.