CData Software - Knowledge Base
Recent Articles
-
Use Dash to Build to Web Apps on Email Data
Create Python applications that use pandas and Dash to build Email-connected web apps.
-
Connect to Act-On Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Act-On as an External Source in Dremio.
-
Use the CData Software JDBC Driver for SAP HANA in MicroStrategy Web
Connect to SAP HANA data in MicroStrategy Web using the CData Software JDBC Driver for SAP HANA.
-
Access NetSuite Saved Searches as Views
You can use CData NetSuite Data Providers to access saved searches from third-party tools.
-
Getting Started with the CData Tableau Connector for Azure Synapse
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Azure Synapse.
-
Automated Continuous PDFMonkey Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable PDFMonkey replication to Azure SQL Database.
-
Access Live Freshteam Data in Coginiti Pro
Connect to and query live Freshteam data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to connect to Google Search Results with Squirrel SQL client
Connect to Google Search results and execute queries in the Squirrel SQL Client.
-
Build SAP HANA-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP HANA Data and create custom apps in Bubble.
-
Access Live IBM Cloud Object Storage Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live IBM Cloud Object Storage data through MCP integration.
-
MYOB AccountRight Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to MYOB AccountRight data through CData Connect AI using different applications and tools.
-
Connect to Redis Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Redis data.
-
Getting Started with the CData ADO.NET Provider for Oracle HCM Cloud
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Oracle HCM Cloud.
-
Integrating OpenCode with HubDB 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.
-
A PostgreSQL Interface for WordPress Data using the CData ODBC Driver
Use the SQL Gateway and WordPress ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Bannerbear in MicroStrategy
Connect to Bannerbear data in MicroStrategy Developer using the CData Software ODBC Driver for Bannerbear.
-
Build Dashboards with Guru Data in DBxtra
Create dynamic dashboards and perform analytics based on Guru data in DBxtra.
-
Integrating Claude Code CLI with Scrapfly 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.
-
Use Dash to Build Web Apps on GitLab Data via CData Connect AI
Build interactive Dash web apps on live GitLab data using pandas and the CData Connect AI Python SDK.
-
Visualize Live FHIR Data in the Power BI Service
Use CData Connect AI to connect to live FHIR data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Live PostgreSQL Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to PostgreSQL from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live PostgreSQL data.
-
Automated Continuous Paylocity Replication to Oracle
Use CData Sync for automated, continuous, customizable Paylocity replication to Oracle.
-
Create Dotmailer Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Dotmailer from PowerBI.com to create Power BI Dataflows with real-time data.
-
Amplitude Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Amplitude facts in real time.
-
Connect to SAP Ariba Source Data in Aqua Data Studio
Access SAP Ariba Source data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Customer.io Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Customer.io replication to Amazon Redshift.
-
How to connect to Billsby Data from IntelliJ
Integrate connectivity to Billsby data with wizards in IntelliJ.
-
Use Grok to Talk to Your Grafana 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 Grafana data for you.
-
Use the CData Software JDBC Driver for Instantly in MicroStrategy
Connect to Instantly data in MicroStrategy Developer using the CData Software JDBC Driver for Instantly.
-
Integrate SharePoint Excel Services Data in Pentaho Data Integration
Build ETL pipelines based on SharePoint Excel Services data in the Pentaho Data Integration tool.
-
DataBind Cvent Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Cvent with the DevExpress Windows Forms and Web controls to provide Cvent data to a chart.
-
Automated Continuous SingleStore Replication to SQLite
Use CData Sync for automated, continuous, customizable SingleStore replication to SQLite.
-
How to integrate Metabase with Redshift Data
Use CData Connect AI to connect to live Redshift data and create an interactive dashboard in Metabase from Redshift data.
-
Connect and Query Live Basecamp Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Basecamp data into Databricks and enable direct, live querying and analysis without replication.
-
Automated Continuous Demio Replication to MySQL
Use CData Sync for automated, continuous, customizable Demio replication to MySQL.
-
Working with Microsoft Dataverse Data in LINQPad
Execute LINQ queries to Microsoft Dataverse data in LINQPad.
-
Connect to Zoho Books Data from Crystal Reports
Use CData Connect AI to connect to and report on live Zoho Books data from Crystal Reports.
-
Use Biml to Build SSIS Tasks to Replicate Teamwork Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Teamwork data to SQL Server.
-
Replicate Multiple BambooHR Accounts
Replicate multiple BambooHR accounts to one or many databases.
-
Integrate Instagram Data in Pentaho Data Integration
Build ETL pipelines based on Instagram data in the Pentaho Data Integration tool.
-
Create Spark-Connected Dashboards in Grafana
Connect to Spark Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Spark data.
-
Connect to Workday in SpagoBI
Create reports featuring live Workday data in SpagoBI Studio. Host Workday reports on SpagoBI Server.
-
Use the CData Software JDBC Driver for Mailjet in MicroStrategy
Connect to Mailjet data in MicroStrategy Developer using the CData Software JDBC Driver for Mailjet.
-
Connect to Webex Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Webex and work with Webex data in your FileMaker applications.
-
Manage PingOne Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for PingOne.
-
Create Reports with Rebilly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Rebilly data.
-
Build Voice Agents in ElevenLabs with access to Live MailerLite Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live MailerLite data.
-
Access Live SAP BusinessObjects BI Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP BusinessObjects BI data into the statistical analysis tools available in SAS JMP. This article shows how to use SAP BusinessObjects BI data in the Graph Builder and Query Builder.
-
ETL Google Spanner in Oracle Data Integrator
This article shows how to transfer Google Spanner data into a data warehouse using Oracle Data Integrator.
-
Automate Teamwork Data Replication to Azure Data Lake
Use CData Sync to customize and automate Teamwork data replication to Azure Data Lake.
-
Query Templated Data as a MySQL Database in Node.js
Execute MySQL queries against Templated data from Node.js.
-
Query Zoho Projects Data in ColdFusion
Write standard ColdFusion data access code to connect to Zoho Projects data.
-
Visualize SAP Ariba Source Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load SAP Ariba Source data into TIBCO Spotfire.
-
DataBind Controls to Zoho Books Data in Delphi
DataBind to Zoho Books data in Delphi with standard data access components and controls.
-
Access Live Omnisend Data in Excel 365 Online (Excel for the web)
Connect to Omnisend data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous MailerSend Replication to MongoDB
Use CData Sync for automated, continuous, customizable MailerSend replication to MongoDB.
-
Visualize Live Lakebase Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Lakebase data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Avro-Connected Business Apps in AppSheet
Connect to Avro Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Avro data.
-
Create Avro Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Avro from PowerBI.com to create Power BI Dataflows with real-time data.
-
Import Real-Time GraphQL Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use GraphQL data in ColdFusion.
-
Integrate with Parallel Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Parallel data to a JSON file on disk.
-
Connect to Exa Data in RapidMiner
Integrate Exa data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to SageHR in SpagoBI
Create reports featuring live SageHR data in SpagoBI Studio. Host SageHR reports on SpagoBI Server.
-
Visualize Live Act-On Data in the Power BI Service
Use CData Connect AI to connect to live Act-On data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to Live Salesloft 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 Salesloft data for you.
-
Build Agents in Relevance AI with Access to Live Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft Exchange data within intelligent agent workflows.
-
Build SQL Analysis Services-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SQL Analysis Services data.
-
Integrate Superchat Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Superchat data from Informatica Cloud.
-
How to create Visio diagrams from MarkLogic Data
Automatically update MarkLogic data with the changes you make to Visio master shapes.
-
Build Automated Sugar CRM-Connected Workflows in Zapier
Use CData Connect AI to connect to live Sugar CRM data and build automated workflows in Zapier.
-
How to Seamlessly Import Adobe Commerce Data into IBM SPSS Modeler
Integrate Adobe Commerce data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Design BIRT Reports on Avalara AvaTax Data
Provide current Avalara AvaTax data to your embedded analytics.
-
Connect to Accelo Data in Aqua Data Studio
Access Accelo data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Design BIRT Reports on Google Contacts Data
Provide current Google Contacts data to your embedded analytics.
-
Connect to JSON Services as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live JSON services.
-
Query Clio Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Clio data from Node.js.
-
DataBind Controls to SAP Business One Data in Delphi
DataBind to SAP Business One data in Delphi with standard data access components and controls.
-
ETL Missive in Oracle Data Integrator
This article shows how to transfer Missive data into a data warehouse using Oracle Data Integrator.
-
Create OneNote-Connected Dashboards in Grafana
Connect to OneNote Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to OneNote data.
-
Use Dash to Build to Web Apps on Aweber Data
Create Python applications that use pandas and Dash to build Aweber-connected web apps.
-
Create Pinterest-Connected Dashboards in Grafana
Connect to Pinterest Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Pinterest data.
-
How to Connect the Power BI Service to Quaderno: Complete Guide
Connect to the CData Software Power BI Connector for Quaderno from PowerBI.com to provide real-time Quaderno data across the organization.
-
Integrate OpenCode with Live Amazon S3 Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Amazon S3 data from within your AI coding agent.
-
Getting Started with the CData Python Connector for Salesforce Data 360
Learn to install and license the CData Python Connector and configure a connection to live Salesforce Data 360 data.
-
Use the CData SSIS Components to Insert New or Update Existing Paylocity Records from SQL Server
Easily push SQL Server data to Paylocity using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Paylocity or update existing records with data from a SQL Server database.
-
ETL Wave Financial in Oracle Data Integrator
This article shows how to transfer Wave Financial data into a data warehouse using Oracle Data Integrator.
-
Getting Started with the CData JDBC Driver for Templated
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Templated.
-
Visualize Live Yelp Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Yelp data.
-
Natively Connect to Epicor Kinetic Data in PHP
The CData ODBC driver for Epicor Kinetic enables you to create PHP applications with connectivity to Epicor Kinetic data. Leverage the native support for ODBC in PHP.
-
Connect to Sendwithus Data in Jaspersoft Studio
Execute SQL to remote Sendwithus data in Jaspersoft Studio.
-
Build Anaplan-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Anaplan Data from Zoho Analytics and import live Anaplan data.
-
Visualize Live ServiceNow Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live ServiceNow data into custom reports in Power BI.
-
Automate Databricks Data Replication to Azure Synapse
Use CData Sync to customize and automate Databricks data replication to Azure Synapse.
-
Establish a Live Connection with QuickBooks Time Data using Tableau Bridge
The CData ODBC Driver for QuickBooks Time enables you to integrate live QuickBooks Time data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect to Acumatica Data from Spring Boot
Connect to Acumatica in a Spring Boot Application using the CData JDBC Driver for Acumatica
-
Feed Airtable Data into FineReport
How to set Airtable data as a JDBC data source in FineReport.
-
Visualize Live AfterShip Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live AfterShip data.
-
Integrating Boomi Agentstudio with Workday Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Workday data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Analyze Outreach.io Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Outreach.io from Power Pivot. You will use the Table Import Wizard to load Outreach.io data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Adobe Experience Manager Data in JRuby
Create a simple JRuby app with access to live Adobe Experience Manager data.