CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Acumatica Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Acumatica replication to Amazon S3.
-
Connect to Freshsales Data in Jaspersoft Studio
Execute SQL to remote Freshsales in Jaspersoft Studio.
-
Build Agents in Relevance AI with Access to Live Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Oracle Financials Cloud within intelligent agent workflows.
-
Integrating Claude Code CLI with xBase 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 eBay to Databricks using CData SSIS Components.
Easily push eBay to Databricks using the CData SSIS Tasks for eBay and Databricks.
-
Prepare, Blend, and Analyze CampaignMonitor Data in Alteryx Designer (ODBC)
Build workflows to access live CampaignMonitor for self-service data analytics.
-
Access Live Amazon S3 Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Amazon S3 from your Excel spreadsheets.
-
Replicate Sybase IQ Data to Multiple Databases
Replicate Sybase IQ to disparate databases with a point-and-click configuration.
-
Integrate Live Instagram Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Instagram and integrate live Instagram into apps built in Microsoft Power Apps.
-
Integrate HCL Domino Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live HCL Domino from Informatica Cloud.
-
Automated Continuous Rebilly Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Rebilly replication to Amazon Redshift.
-
Migrating data from PDFMonkey to Databricks using CData SSIS Components.
Easily push PDFMonkey to Databricks using the CData SSIS Tasks for PDFMonkey and Databricks.
-
Build Google Analytics-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Analytics.
-
How to Connect to Live Salesforce Pardot Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Salesforce Pardot securely in real time.
-
Integrate Live Paylocity Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Paylocity to Blue Prism using the CData ODBC Driver for Paylocity to create automated workflows for repetitive business tasks.
-
Visualize Onfleet Data in Sisense
Create an ElastiCube in Sisense app with access to Onfleet.
-
Use JayDeBeApi to access Landbot Data in Python
Use standard Python scripting and the development environment of your choice to access live Landbot.
-
How to Easily Query Avro Data in OpenOffice Base
Connect to Avro data in OpenOffice Base using the CData ODBC Driver for Avro and generate reports with live data insights.
-
Create Datasets from SAP Business One in Domo Workbench and Build Visualizations of SAP Business One Data in Domo
Use the CData Software ODBC Driver for SAP Business One to create datasets from SAP Business One in Domo Workbench and then build visualizations in the Domo service.
-
Connect to XML Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrating Claude Code with Twitter Ads Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Twitter Ads within assisted coding and automated development workflows.
-
Connect to Microsoft Dataverse Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft Dataverse and the Script function in FileMaker Pro to connect to Microsoft Dataverse and work with Microsoft Dataverse (CDS) in your FileMaker application.
-
Connect to Miro Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Miro.
-
Connect to Klaviyo from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Klaviyo, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Prepare, Blend, and Analyze Sage Intacct Data in Alteryx Designer (ODBC)
Build workflows to access live Sage Intacct for self-service data analytics.
-
Publish GitHub-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live GitHub.
-
Visualize Live Google Contacts Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Contacts using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Zoho CRM Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Zoho CRM entities in PHP by modeling them as objects.
-
Integrate Live Zoom Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Zoom from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zoom.
-
Connect to Real-Time Discord Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Discord in Power Apps.
-
Import Twitter Ads Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Twitter Ads Data and provide access to live Twitter Ads for custom reports in the Power BI Service.
-
Prepare, Blend, and Analyze Teamgate Data in Alteryx Designer (ODBC)
Build workflows to access live Teamgate for self-service data analytics.
-
Create Data Visualizations in Cognos BI with Samanage Data
Access Samanage as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Publish Crystal Reports on ClickUp Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ClickUp.
-
Work with Live SAP ByDesign Data in Power Query
Use CData Connect AI to connect to SAP Business ByDesign and work with live SAP Business ByDesign in Microsoft Power Query.
-
Use the CData Software JDBC Driver for Keap in MicroStrategy Web
Connect to Keap in MicroStrategy Web using the CData Software JDBC Driver for Keap.
-
Visualize Klaviyo Data in Sisense
Create an ElastiCube in Sisense app with access to Klaviyo.
-
Use the CData Software JDBC Driver for Browserless in MicroStrategy Web
Connect to Browserless in MicroStrategy Web using the CData Software JDBC Driver for Browserless.
-
Create Slack-Connected Applications in Appsmith
Connect to Slack Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Slack.
-
Connect to Cohere Data in CloverDX (formerly CloverETL)
Transfer Cohere using the visual workflow in the CloverDX data integration tool.
-
Create Float Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Float data access from reports, embedded analytics, and more.
-
Working with Kafka Data in LINQPad
Execute LINQ queries to Apache Kafka in LINQPad.
-
Migrating data from ZohoInvoice to Snowflake using CData SSIS Components.
Easily push ZohoInvoice to Snowflake using the CData SSIS Tasks for ZohoInvoice and Snowflake.
-
Access Live Oracle SCM Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Oracle SCM data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use the CData Software JDBC Driver for Sage Cloud Accounting in MicroStrategy
Connect to Sage Business Cloud Accounting in MicroStrategy Developer using the CData Software JDBC Driver for Sage Cloud Accounting.
-
Build Data Flows from OneNote to SQL Server using SSIS
Easily back up Microsoft OneNote to SQL Server using the SSIS components for OneNote.
-
Visualize Live Apollo Data in the Power BI Service
Use CData Connect AI to connect to live Apollo and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize DocuSign Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to DocuSign.
-
Import Real-Time Redis Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Redis in ColdFusion.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Delighted
Provide connectivity to Delighted through an SAP BusinessObjects universe.
-
Connect to and Query Guru Data in QlikView over ODBC
Create data visualizations with Guru in QlikView.
-
Integrating OpenCode Terminal with Twitter Ads 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 Informatica Mappings From/To a JDBC Data Source for LDAP
Create LDAP data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Apify Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Apify into the statistical analysis tools available in SAS JMP. This article shows how to use Apify in the Graph Builder and Query Builder.
-
Access Live Bullhorn CRM Data in Excel 365 Online (Excel for the web)
Connect to Bullhorn CRM from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Drift Data in DBArtisan
Use wizards in DBArtisan to configure Drift as a data source.
-
Connect to SAP Netweaver Gateway Data from a Connection Pool in Jetty
The SAP Netweaver Gateway JDBC Driver supports connection pooling: This article shows how to connect faster to SAP Netweaver Gateway from Web apps in Jetty.
-
Integrate QuickBooks Online with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate QuickBooks Online with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to QuickBooks Online.
-
Analyze Notion Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Notion from Power Pivot. You will use the Table Import Wizard to load Notion. You can visually build the import query or use any SQL supported by the driver.
-
Create Power BI Reports on Real-Time IBM Informix Data
Use the CData ODBC Driver for IBM Informix to visualize IBM Informix in Power BI Desktop.
-
Integrating LangGraph with Email Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Email within automated workflows.
-
Analyze JobNimbus Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze JobNimbus in Microsoft R Open.
-
Automated Continuous Notion Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Notion replication to Apache Kafka.
-
Connect to Real-Time Avro Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Avro and Dataflow to import and use Apache Avro in Power Apps.
-
How to integrate HubSpot with Apache Airflow
Access and process HubSpot in Apache Airflow using the CData JDBC Driver.
-
Query Bullhorn CRM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Bullhorn CRM from Node.js.
-
Back Up Gumroad to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Gumroad data.
-
Build MVC Applications with Connectivity to Codat Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Codat from an ASP.NET MVC application.
-
Analyze Azure Table Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Azure Table from Power Pivot. You will use the Table Import Wizard to load Azure Table Storage. You can visually build the import query or use any SQL supported by the driver.
-
Integrate with live CockroachDB Data in Jitterbit
Use CData Connect AI to connect to and integrate live CockroachDB in Jitterbit.
-
Publish Reports with ChargeOver Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ChargeOver.
-
Connect to Paylocity Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Paylocity Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build FTP-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for FTP Data and create custom apps in Mendix.
-
Connect to Planio Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Planio and the SQL Gateway to access Planio from Google Apps Script.
-
Extend Google Sheets with Dropbox Data
Make calls to Dropbox from Google Apps Script via the API Server.
-
Working with Grafana Data in LINQPad
Execute LINQ queries to Grafana in LINQPad.
-
Automated Continuous eBay Analytics Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Google Cloud SQL.
-
Access Square Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Square.
-
Use Dash to Build to Web Apps on PostgreSQL Data
Create Python applications that use pandas and Dash to build PostgreSQL-connected web apps.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Square using the Model Context Protocol.
-
How to Visualize Cosmos DB Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure Cosmos DB in Python.
-
How to Create Power BI Visual Reports with Real-Time Perigon Data
Use CData Power BI Connectors to visualize Perigon in Power BI.
-
How to connect SharePoint with Stripe Data through external lists
Provide Stripe to SharePoint users as an external list.
-
How to Query Productboard Data in MySQL Workbench
Execute MySQL queries against live Productboard from MySQL Workbench.
-
Integrate Beeminder with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Beeminder with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Beeminder.
-
Automated Continuous LinkedIn Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable LinkedIn replication to Apache Cassandra.
-
Connect to CloudConvert Data in Aqua Data Studio
Access CloudConvert from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Goose with Live Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Box from within the local AI agent.
-
Publish Splunk-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Splunk.
-
Back Up Mocean to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Mocean data.
-
Configure the CData JDBC Driver for Couchbase in a Connection Pool in Tomcat
Connect to Couchbase from a connection pool in Tomcat.
-
Building Dynamic Web Pages with SAP BusinessObjects BI Data Using AngularJS
Create single-page applications with live connectivity to SAP BusinessObjects BI using the CData API Server.
-
Add Oracle Sales Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Oracle Sales with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate with SQL Analysis Services Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SQL Analysis Services to a JSON file on disk.
-
Getting Started with the CData ODBC Driver for Timely
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Timely.
-
Automated Continuous Elasticsearch Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Elasticsearch replication to PostgreSQL.
-
How to Connect DBeaver to Basecamp via a JDBC Driver
Manage Basecamp with visual tools in DBeaver like the query browser.
-
Publish Sybase-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Sybase.
-
Access Live Databricks Data in Coginiti Pro
Connect to and query live Databricks from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Unbounce
Provide connectivity to Unbounce through an SAP BusinessObjects universe.