CData Software - Knowledge Base
Recent Articles
-
Integrating Outreach.io Data in Talend Cloud Data Management Platform
Connect Outreach.io Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Outreach.io.
-
Create a Data Access Object for Amazon Marketplace Data using JDBI
A brief overview of creating a SQL Object API for Amazon Marketplace data in JDBI.
-
Access Live ShipEngine Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ShipEngine data into the statistical analysis tools available in SAS JMP. This article shows how to use ShipEngine data in the Graph Builder and Query Builder.
-
Import Real-Time Sage 200 Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Sage 200 data in ColdFusion.
-
Connect to and Visualize Live SageHR Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SageHR data.
-
Create Databricks-Connected Dashboards in Grafana
Connect to Databricks Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Databricks data.
-
Automated Continuous Greenhouse Replication to SingleStore
Use CData Sync for automated, continuous, customizable Greenhouse replication to SingleStore.
-
How to Work with MarkLogic Data in AWS Glue Jobs Using JDBC
Connect to MarkLogic from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData Software ODBC Driver for Rebilly in SAS for Real-Time Reporting and Analytics
Connect to real-time Rebilly data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Rebilly.
-
Bridge Timely Connectivity with Apache NiFi
Access and process Timely data in Apache NiFi using the CData JDBC Driver.
-
Getting Started with the CData Tableau Connector for Epicor Kinetic
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Epicor Kinetic.
-
Access Live Stripe Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Stripe data into the statistical analysis tools available in SAS JMP. This article shows how to use Stripe data in the Graph Builder and Query Builder.
-
Automate Greenhouse Data Replication to Couchbase
Use CData Sync to Customize and automate Greenhouse data replication to Couchbase.
-
Stream BambooHR Data into Apache Kafka Topics
Access and stream BambooHR data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Microsoft Exchange-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Microsoft Exchange data without replication.
-
Analyze Freshservice Data in Looker
Use CData Connect AI to connect to Freshservice Data from Looker and build custom apps using live Freshservice data.
-
Model Amazon Athena Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Amazon Athena, enabling the direct import of real-time Amazon Athena data.
-
Create Apps from Facebook Data in Qlik Sense Cloud
Use CData Connect AI to connect to Facebook Data and build apps from live Facebook data in Qlik Sense Cloud.
-
How to Connect to Live ClickUp 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 ClickUp data through natural language.
-
Connect to SuiteCRM Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SuiteCRM as an External Source in Dremio.
-
Connect to CockroachDB Data in JRuby
Create a simple JRuby app with access to live CockroachDB data.
-
Integrate Trae with Live iContact Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live iContact data from within the AI-powered IDE.
-
Publish Reports with Tanda Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Tanda data.
-
Build Dashboards with Google Analytics Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Analytics data in Dundas BI.
-
Build Coda-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Coda data without replication.
-
Build Pipelines with Live Workday Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Workday from Google Cloud Data Fusion, enabling the integration of live Workday data into the building and management of effective data pipelines.
-
Link SAP with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP data in Filemaker Pro for Mac or Windows.
-
Integrate with Impala Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Impala data to a JSON file on disk.
-
DataBind Charts to Mocean Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Mocean 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.
-
Use the CData Software JDBC Driver for ZeroBounce in MicroStrategy Desktop
Connect to ZeroBounce data in MicroStrategy Desktop using the CData Software JDBC Driver for ZeroBounce.
-
Moving Data from Omnisend to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Omnisend data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Load Dropbox Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Dropbox data to a database.
-
Creating Phoenix-Connected Applications in Unqork
You can use CData Connect AI to feed Phoenix data to Unqork and build custom business apps.
-
Connect to Live Power BI XMLA Data in MicroStrategy through CData Connect AI
Create a live connection to Power BI XMLA Data in CData Connect AI and connect to your Power BI XMLA data from MicroStrategy.
-
Publish Grafana-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Grafana data.
-
Analyze FTP Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of FTP data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
A PostgreSQL Interface for SurveyMonkey Data using the CData ODBC Driver
Use the SQL Gateway and SurveyMonkey ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create a Data Access Object for SAP Business One Data using JDBI
A brief overview of creating a SQL Object API for SAP Business One data in JDBI.
-
How to Connect to Live MySQL 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 MySQL data for you.
-
Build SAS Data Sets-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SAS Data Sets Data from Zoho Analytics and import live SAS Data Sets data.
-
Connect to Oracle Financials Cloud Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Oracle Financials Cloud data in Airbyte.
-
Publish Aweber-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Aweber data.
-
How to Build an ETL App for Aha! Data in Python with CData
Create ETL applications and real-time data pipelines for Aha! data in Python with petl.
-
Access Live Foursquare Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Foursquare data into the statistical analysis tools available in SAS JMP. This article shows how to use Foursquare data in the Graph Builder and Query Builder.
-
Access Live PolarTeamPro Data in AWS Lambda
Connect to live PolarTeamPro data in AWS Lambda using the CData JDBC Driver.
-
How to Access Live Couchbase Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Couchbase enables you to integrate Couchbase data into workflows built using Microsoft Power Automate Desktop.
-
How to Visualize Bugsnag Data in Python with pandas
Use pandas and other modules to analyze and visualize live Bugsnag data in Python.
-
Automated Continuous PayPal Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable PayPal replication to Azure SQL Database.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Campaign Manager 360
Create an ODBC connection to Google Campaign Manager 360 in Informatica and browse and transfer Google Campaign Manager 360 data.
-
Create Reports with SAP Business Warehouse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Business Warehouse data.
-
Visualize Live Kafka Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Kafka data into custom reports in Power BI.
-
Create Reports with Exact Online Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Exact Online data.
-
Visualize XML Data in Sisense
Create an ElastiCube in Sisense app with access to XML data.
-
Integrate Dify with Live Egnyte 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 Egnyte data.
-
Connect to Tavily Data in RazorSQL
Connect to Tavily from wizards and query Tavily data from the GUI in the RazorSQL database management tool.
-
Integrate Live Samanage Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Samanage data and integrate live Samanage data into apps built in Microsoft Power Apps.
-
Connect to Jira Data in JRuby
Create a simple JRuby app with access to live Jira data.
-
Create Okta-Connected Nintex Workflows
Use CData Connect AI to connect to Okta Data from Nintex Workflow Cloud and build custom workflows using live Okta data.
-
Connect to Shippo Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Shippo as an External Source in Dremio.
-
Automated Continuous Rebilly Replication to SingleStore
Use CData Sync for automated, continuous, customizable Rebilly replication to SingleStore.
-
Visualize Live Asana Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Asana data.
-
Use the CData SSIS Components to Insert New or Update Existing Cassandra Records from SQL Server
Easily push SQL Server data to Cassandra using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Cassandra or update existing records with data from a SQL Server database.
-
Integrating GitHub Copilot 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.
-
How to Build an ETL App for MYOB AccountRight Data in Python with CData Connect AI
Build ETL pipelines that read and write live MYOB AccountRight data in Python with petl and the CData Connect AI Python SDK.
-
Create Dropbox-Connected Dashboards in Grafana
Connect to Dropbox Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Dropbox data.
-
Replicate Multiple Strava Accounts
Replicate multiple Strava accounts to one or many databases.
-
Analyze Lakebase Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Lakebase from Power Pivot. You will use the Table Import Wizard to load Lakebase data. You can visually build the import query or use any SQL supported by the driver.
-
Working with Bullhorn CRM Data in LINQPad
Execute LINQ queries to Bullhorn CRM data in LINQPad.
-
Connect to HubSpot Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live HubSpot data.
-
Access ClickUp Data from MySQL in Amazon QuickSight
Connect to ClickUp and build visualizations of ClickUp data using a MySQL Connection in Amazon QuickSight.
-
Build Pipelines with Live CSV Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to CSV from Google Cloud Data Fusion, enabling the integration of live CSV data into the building and management of effective data pipelines.
-
How to Connect the Power BI Service to Zoho Inventory: Complete Guide
Connect to the CData Software Power BI Connector for Zoho Inventory from PowerBI.com to provide real-time Zoho Inventory data across the organization.
-
Integrating Codex with Sybase 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 EnterpriseDB Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate EnterpriseDB data into the statistical analysis tools available in SAS JMP. This article shows how to use EnterpriseDB data in the Graph Builder and Query Builder.
-
Replicate Reckon Data to Multiple Databases via the CData Sync CLI
Replicate Reckon data to disparate databases with a single configuration.
-
Getting Started with the CData ADO.NET Provider for Avalara AvaTax
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Avalara AvaTax.
-
How to Connect the Power BI Service to Yelp: Complete Guide
Connect to the CData Software Power BI Connector for Yelp from PowerBI.com to provide real-time Yelp data across the organization.
-
Query Brex Data as a MySQL Database in Node.js
Execute MySQL queries against Brex data from Node.js.
-
How to Access Live ZohoSubscriptions Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ZohoSubscriptions enables you to integrate ZohoSubscriptions data into workflows built using Microsoft Power Automate Desktop.
-
Connecting Mastra with DocuSign Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time DocuSign data, no replication required.
-
Moving Data from Bugsnag to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Bugsnag data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous RabbitMQ Replication to Amazon S3
Use CData Sync for automated, continuous, customizable RabbitMQ replication to Amazon S3.
-
Integrating Supabase Data in Talend Cloud Data Management Platform
Connect Supabase Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access Live Impala Data in Coginiti Pro
Connect to and query live Impala data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect DBeaver to ConstantContact via a JDBC Driver
Manage ConstantContact data with visual tools in DBeaver like the query browser.
-
How to Access Live xBase Data in Power Automate Desktop via ODBC
The CData ODBC Driver for xBase enables you to integrate xBase data into workflows built using Microsoft Power Automate Desktop.
-
Visualize Strava Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Strava data.
-
How to connect PolyBase to Phoenix
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Phoenix data.
-
Automated Continuous REST Replication to SQL Server
Use CData Sync for automated, continuous, customizable REST replication to SQL Server.
-
Build a Simple VCL Application for Typeform Data
How to build a simple VCL Application to view Typeform data in RAD Studio using the CData ODBC Driver for Typeform.
-
Query QuickBooks Time Data through ODBC in Node.js
Use node-odbc to execute SQL queries against QuickBooks Time data from Node.js.
-
Getting Started with the CData SSIS Components for MailerLite
Complete guide to installing, licensing, and connecting with the CData SSIS Components for MailerLite.
-
How to connect to Samanage Data with Squirrel SQL client
Connect to Samanage data and execute queries in the Squirrel SQL Client.
-
Publish Reports with JobNimbus Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date JobNimbus data.
-
Connect to Square Data in Aqua Data Studio
Access Square data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Query HBase Data as a SQL Server Database in Node.js
Execute SQL Server queries against HBase data from Node.js.
-
Access Live LinkedIn Ads Data in Coginiti Pro
Connect to and query live LinkedIn Ads data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Apps from Grafana Data in Qlik Sense Cloud
Use CData Connect AI to connect to Grafana Data and build apps from live Grafana data in Qlik Sense Cloud.
-
Integrate Adobe Experience Manager Data into Power Automate Desktop using CData Connect
CData Connect for Adobe Experience Manager Data enables you to integrate Adobe Experience Manager data into workflows built using Microsoft Power Automate Desktop.
-
How to connect Amazon QuickSight to Dynamics CRM Data
Create a connection to Dynamics CRM data in CData Connect AI and insert Dynamics CRM data into Amazon QuickSight SPICE to build interactive dashboards.