CData Software - Knowledge Base
Recent Articles
-
Work with Live Zoho Inventory Data in Power Query
Use CData Connect AI to connect to Zoho Inventory data and work with live Zoho Inventory data in Microsoft Power Query.
-
Connecting Mastra with Perplexity 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 Perplexity data, no replication required.
-
Connect to Sugar CRM Data from a Connection Pool in Jetty
The Sugar CRM JDBC Driver supports connection pooling: This article shows how to connect faster to Sugar CRM data from Web apps in Jetty.
-
Publish LinkedIn-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live LinkedIn data.
-
Connect to Real-Time iContact Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use iContact data in Power Apps.
-
Connect to SingleStore Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SingleStore data in Airbyte.
-
Build Semantic Layer Views for Google Analytics Data in APOS Live Data Gateway
Use the CData Connector for Google Analytics in APOS Live Data Gateway to build Semantic Layer Views for Google Analytics data.
-
Integrating Chargebee Data in Talend Cloud Data Management Platform
Connect Chargebee Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate Elasticsearch Data in Pentaho Data Integration
Build ETL pipelines based on Elasticsearch data in the Pentaho Data Integration tool.
-
Write a Simple Go Application to work with Accelo Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Accelo data.
-
Connect to Sybase IQ Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Sybase IQ Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Visualize IBM Informix Data in TIBCO Spotfire through ADO.NET
Integrate IBM Informix data into dashboards in TIBCO Spotfire.
-
Process & Analyze MailerSend Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live MailerSend Data.
-
Use Dash to Build Web Apps on Shippo Data via CData Connect AI
Build interactive Dash web apps on live Shippo data using pandas and the CData Connect AI Python SDK.
-
Automated Continuous MYOB AccountRight Replication to SQLite
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to SQLite.
-
How to Connect to & Open Airtable Data in Microsoft Excel
This article uses the CData ODBC driver for Airtable to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Establish a Live Connection with Clockify Data using Tableau Bridge
The CData ODBC Driver for Clockify enables you to integrate live Clockify data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Microsoft Entra ID Data in Jaspersoft Studio
Execute SQL to remote Microsoft Entra ID data in Jaspersoft Studio.
-
Integrating LlamaIndex with Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Reckon Accounts Hosted data in real time.
-
Back Up Azure Data Catalog data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Azure Data Catalog. In this article, we will employ an SSIS workflow to populate a database with Azure Data Catalog data data.
-
Build Automated Azure Data Lake Storage-Connected Workflows in Zapier
Use CData Connect AI to connect to live Azure Data Lake Storage data and build automated workflows in Zapier.
-
Automated Continuous Workday Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Workday replication to Google BigQuery.
-
Publish Datadog-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Datadog data.
-
Connect Active Directory to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Active Directory with IBM WebSphere for seamless data integration and connectivity.
-
Connecting GenSpark with Amazon Marketplace Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Amazon Marketplace data without any replication or custom integration required.
-
How to Query Live Guru Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Guru data data in natural language using Python.
-
Use Agno to Talk to Your Adobe Commerce 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 Adobe Commerce data for you.
-
Analyze Eventbrite Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Eventbrite from Power Pivot. You will use the Table Import Wizard to load Eventbrite data. You can visually build the import query or use any SQL supported by the driver.
-
Use Dash to Build to Web Apps on Cloudflare Data
Create Python applications that use pandas and Dash to build Cloudflare-connected web apps.
-
How to connect to Avro Data in DBVisualizer
Integrate Avro data with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze Live Facebook Ads Data in SAS Viya
Use CData Connect AI to connect to Facebook Ads data from SAS Viya and deploy self-service analytics using live Facebook Ads data.
-
Automated Continuous Tickspot Replication to MongoDB
Use CData Sync for automated, continuous, customizable Tickspot replication to MongoDB.
-
Use Dash to Build Web Apps on Act CRM Data via CData Connect AI
Build interactive Dash web apps on live Act CRM data using pandas and the CData Connect AI Python SDK.
-
Access Live SAP SuccessFactors Data in TIBCO Data Virtualization
Use the SAP SuccessFactors Tibco DV Adapter to create a SAP SuccessFactors data data source in TIBCO Data Virtualization Studio and gain access to live SAP SuccessFactors data from your TDV Server.
-
Deploy the ADO.NET Provider for Pipeline CRM on an SSRS Report Server
Connect to Pipeline CRM 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.
-
Replicate Multiple NASA Accounts via the CData Sync CLI
Replicate multiple NASA accounts to one or many databases.
-
Integrate Dify with Live eBay Analytics 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 eBay Analytics data.
-
Connect to Airtable Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Airtable data from Filemaker Pro on Mac.
-
Establish a Live Connection with Sage 200 Data using Tableau Bridge
The CData ODBC Driver for Sage 200 enables you to integrate live Sage 200 data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate OpenCode with Live Splunk Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Splunk data from within your AI coding agent.
-
Use the CData Software ODBC Driver for Unbounce in MicroStrategy
Connect to Unbounce data in MicroStrategy Developer using the CData Software ODBC Driver for Unbounce.
-
Use Grok to Talk to Your Freshdesk 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 Freshdesk data for you.
-
Migrating data from Zoho Books to Databricks using CData SSIS Components.
Easily push Zoho Books data to Databricks using the CData SSIS Tasks for Zoho Books and Databricks.
-
Use the CData Software ODBC Driver for Snowflake in SAS for Real-Time Reporting and Analytics
Connect to real-time Snowflake data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Snowflake.
-
Stream Beeminder Data into Apache Kafka Topics
Access and stream Beeminder data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automate Epicor Kinetic Data Replication to Azure Data Lake
Use CData Sync to customize and automate Epicor Kinetic data replication to Azure Data Lake.
-
Connect to Bannerbear Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Bannerbear data.
-
Integrate Google Ad Manager Data in Pentaho Data Integration
Build ETL pipelines based on Google Ad Manager data in the Pentaho Data Integration tool.
-
Natively Connect to Adobe Analytics Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Adobe Analytics data. Leverage the native support for ODBC in PHP.
-
Use ChatGPT to Talk to Your Square 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 Square data for you.
-
How to use SQLAlchemy ORM to access Oracle SCM Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle SCM data.
-
Create Mailgun-Connected Dashboards in Grafana
Connect to Mailgun Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Mailgun data.
-
Connect to Gong Data from Crystal Reports
Use CData Connect AI to connect to and report on live Gong data from Crystal Reports.
-
Integrate Dynamics NAV Data into Power Automate Desktop using CData Connect
CData Connect for Dynamics NAV Data enables you to integrate Dynamics NAV data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Cloudant Data from a Connection Pool in Jetty
The Cloudant JDBC Driver supports connection pooling: This article shows how to connect faster to Cloudant data from Web apps in Jetty.
-
Integrating Kiro 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.
-
Connect to Sage 200 Data from AWS Glue
Use CData Connect AI to gain access to live Sage 200 data from your AWS Glue jobs.
-
Automated Continuous IBM Informix Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable IBM Informix data replication to OneLake in Microsoft Fabric.
-
DataBind HBase Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for HBase with the DevExpress Windows Forms and Web controls to provide HBase data to a chart.
-
Connect to Real-Time AfterShip Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use AfterShip data in Power Apps.
-
Analyze TigerGraph Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for TigerGraph from Power Pivot. You will use the Table Import Wizard to load TigerGraph data. You can visually build the import query or use any SQL supported by the driver.
-
How to connect to Outreach.io Data in DBVisualizer
Integrate Outreach.io data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to import Klaviyo Data into Apache Solr
Use the CData Software JDBC Driver for Klaviyo in Data Import Handler and create an automated import of Klaviyo data to Apache Solr Enterprise Search platform.
-
How to publish and share Adobe Analytics Data dashboards with Tableau Server
The CData ODBC driver for Adobe Analytics enables you integrate Adobe Analytics data into Tableau dashboards.
-
Automated Continuous Close Replication to SingleStore
Use CData Sync for automated, continuous, customizable Close replication to SingleStore.
-
Connecting Pipedream with Shortcut Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Shortcut data in real time.
-
Automated Continuous Intercom Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Intercom replication to Azure SQL Database.
-
Use the CData ODBC Driver for SQL Analysis Services from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SQL Analysis Services to connect to SQL Analysis Services data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SQL Analysis Services data in Excel.
-
Integrating Dataiku with Azure Data Catalog Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Azure Data Catalog data.
-
A PostgreSQL Interface for Excel Data (MySQL Remoting via JDBC)
Use the Remoting features of the Excel JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Attio Replication to Databricks
Use CData Sync for automated, continuous, customizable Attio replication to Databricks.
-
Automated Continuous AfterShip Replication to Databricks
Use CData Sync for automated, continuous, customizable AfterShip replication to Databricks.
-
How to Visualize FTP Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live FTP data in Python.
-
Access eBay Analytics Data from MySQL in PHP
Connect to eBay Analytics through the standard MySQL libraries in PHP.
-
Query Coda Data in DataGrip
Create a Data Source for Coda in DataGrip and use SQL to query live Coda data.
-
Connect to Greenplum Data in DBeaver
Use the CData ODBC Driver to connect to Greenplum data in DBeaver.
-
Replicate Multiple Amazon Marketplace Accounts
Replicate multiple Amazon Marketplace accounts to one or many databases.
-
Automated Continuous Eventbrite Replication to SQLite
Use CData Sync for automated, continuous, customizable Eventbrite replication to SQLite.
-
Feed Highrise Data into FineReport
How to set Highrise data as a JDBC data source in FineReport.
-
Connect to Procore Data in DBArtisan
Use wizards in DBArtisan to configure Procore data as a data source.
-
Analyze Live Pipedrive Data in SAS Viya
Use CData Connect AI to connect to Pipedrive data from SAS Viya and deploy self-service analytics using live Pipedrive data.
-
Provide OData Services of Onfleet Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Onfleet data by developing a WCF Service Application.
-
Build Automated Workflows with Live ConstantContact Data in Workato
Use CData Connect AI to connect to live ConstantContact data and build automated workflows in Workato.
-
Build a Singer.io Tap for Elorus With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Elorus data using the CData Python Connector.
-
Create Data Visualizations in Cognos BI with Testmonitor Data
Access Testmonitor data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Informatica Mappings From/To a JDBC Data Source for Twilio
Create Twilio data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live ShipEngine Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ShipEngine data from your Google Sheets.
-
Automated Continuous Greenplum Replication to SingleStore
Use CData Sync for automated, continuous, customizable Greenplum replication to SingleStore.
-
Replicate CircleCI Data in Heroku for Use in Salesforce Connect
Replicate CircleCI data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Live Active Directory Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Active Directory data from your Google Sheets.
-
Automated Continuous PagerDuty Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable PagerDuty replication to delimited files (CSV/TSV).
-
Connect to ZohoPeople Data in DBArtisan
Use wizards in DBArtisan to configure ZohoPeople data as a data source.
-
Migrating data from SAP Concur to Google BigQuery using CData SSIS Components.
Easily push SAP Concur data to Google BigQuery using the CData SSIS Tasks for SAP Concur and Google BigQuery.
-
Query Stack Exchange Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Stack Exchange data from Node.js.
-
Automate Datadog Data Replication to Azure Synapse
Use CData Sync to customize and automate Datadog data replication to Azure Synapse.
-
Integrating Antigravity CLI with Hive data via CData CLI
Connect Hive data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connecting Moonlit Workflow with SuiteCRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SuiteCRM data in real time.
-
Visualize Live Adobe Target Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Adobe Target data into custom reports in Power BI.
-
Create Informatica Mappings From/To a JDBC Data Source for ZohoDesk
Create ZohoDesk data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Connect to Live Google Spanner 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 Google Spanner data for you.