CData Software - Knowledge Base
Recent Articles
-
Integrating Kiro with Dynamics 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 Informatica Mappings From/To a JDBC Data Source for Rootly
Create Rootly data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating Kiro with Aweber 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 publish and share eBay Analytics Data dashboards with Tableau Server
The CData ODBC driver for eBay Analytics enables you integrate eBay Analytics data into Tableau dashboards.
-
Build Apps with Live SAP SuccessFactors LMS data in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP SuccessFactors LMS data into the Adalo platform and build custom mobile and web applications with real-time SAP SuccessFactors LMS data.
-
How to Connect DBeaver to EmailOctopus via a JDBC Driver
Manage EmailOctopus data with visual tools in DBeaver like the query browser.
-
Create Samanage Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Samanage from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData ADO.NET Provider for BenchmarkEmail
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Migrating data from Perigon to Databricks using CData SSIS Components.
Easily push Perigon data to Databricks using the CData SSIS Tasks for Perigon and Databricks.
-
Connect to Sybase IQ from a Connection Pool in WebLogic
Use the CData JDBC Driver for Sybase IQ to connect to Sybase IQ data from Web applications running on WebLogic.
-
Use Biml to Build SSIS Tasks to Replicate SAS Data Sets Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAS Data Sets data to SQL Server.
-
Use Agno to Talk to Your FTP 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 FTP data for you.
-
Query Salesloft Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Salesloft data from Node.js.
-
Automated Continuous Kintone Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Kintone replication to Google BigQuery.
-
Automate SendInBlue Data Replication to Azure Synapse
Use CData Sync to customize and automate SendInBlue data replication to Azure Synapse.
-
Integrate Goose with Live Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Oracle Eloqua data from within the local AI agent.
-
How to Easily Query Oracle Sales Data in OpenOffice Base
Connect to Oracle Sales data in OpenOffice Base using the CData ODBC Driver for Oracle Sales and generate reports with live data insights.
-
Connect to BigCommerce Data in Aqua Data Studio
Access BigCommerce data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Visualize ConvertKit Data in TIBCO Spotfire through ADO.NET
Integrate ConvertKit data into dashboards in TIBCO Spotfire.
-
How to Connect to Live Sybase IQ Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Sybase IQ data securely in real time.
-
Design BIRT Reports on ServiceDesk Plus Data
Provide current ServiceDesk Plus data to your embedded analytics.
-
Access Live Oracle Financials Cloud Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Oracle Financials Cloud data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Prepare, Blend, and Analyze ZohoSubscriptions Data in Alteryx Designer (Connect AI)
Build workflows to access live ZohoSubscriptions data for self-service data analytics.
-
Connect to SingleStore Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SingleStore data.
-
Rapidly Develop JobNimbus-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by JobNimbus.
-
Integrate Theia IDE with Live SuiteCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live SuiteCRM data from within the development environment.
-
Perform Batch Operations with Reckon Accounts Hosted Data in Apache NiFi
Connect to Reckon Accounts Hosted data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automated Continuous Short.io Replication to SingleStore
Use CData Sync for automated, continuous, customizable Short.io replication to SingleStore.
-
Visualize SAP Ariba Source Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP Ariba Source data.
-
Query Redshift Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Redshift entities in PHP by modeling them as objects.
-
Create Dynamics 365 Business Central-Connected Applications in Appsmith
Connect to Dynamics 365 Business Central Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Dynamics 365 Business Central data.
-
Use Claude to Talk to Your Certinia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Certinia data for you.
-
Connect to Simplesat Data in JRuby
Create a simple JRuby app with access to live Simplesat data.
-
Connect to Oracle Financials Cloud Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Oracle Financials Cloud as an External Source in Dremio.
-
Validate IBM Cloud Object Storage Data with QuerySurge
Access and validate IBM Cloud Object Storage data in QuerySurge using the CData JDBC Driver.
-
Build Data Flows from SQL Server to Google Campaign Manager 360 through SSIS
Easily push SQL Server data to Google Campaign Manager 360 using the CData SSIS Tasks for Google Campaign Manager 360.
-
How to connect to Greenhouse Data from Spring Boot
Connect to Greenhouse in a Spring Boot Application using the CData JDBC Driver for Greenhouse
-
DataBind Controls to HubSpot Data in Delphi
DataBind to HubSpot data in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for Paylocity in MicroStrategy
Connect to Paylocity data in MicroStrategy Developer using the CData Software ODBC Driver for Paylocity.
-
Connect to SAS xpt Data from HeidiSQL
Use CData Connect AI to connect to and query live SAS xpt data from HeidiSQL.
-
Natively Connect to Greenhouse Data in PHP
The CData ODBC driver for Greenhouse enables you to create PHP applications with connectivity to Greenhouse data. Leverage the native support for ODBC in PHP.
-
Integrate Devin with Live SparkPost Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live SparkPost data.
-
How to Visualize Customer.io Data in Python with pandas
Use pandas and other modules to analyze and visualize live Customer.io data in Python.
-
Replicate Teradata Data from PowerShell
Write a quick PowerShell script to query Teradata data. Use connectivity to the live data to replicate Teradata data to SQL Server.
-
Manage Humanity Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Humanity.
-
How to Connect to & Open Facebook Data in Microsoft Excel
This article uses the CData ODBC driver for Facebook to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Data Visualizations in Cognos BI with Templated Data
Access Templated data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software JDBC Driver for Scrapfly in MicroStrategy Desktop
Connect to Scrapfly data in MicroStrategy Desktop using the CData Software JDBC Driver for Scrapfly.
-
Model SendPulse Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SendPulse, enabling the direct import of real-time SendPulse data.
-
Use the CData ODBC Driver for HelloSign from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for HelloSign to connect to HelloSign data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring HelloSign data in Excel.
-
Access Live Optimizely Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Optimizely data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query Google Contacts Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Contacts data from Node.js.
-
Integrate Dify with Live SAP Business One 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 SAP Business One data.
-
Import Sybase IQ Data Using Azure Data Factory
Use CData Connect AI to connect to Sybase IQ Data from Azure Data Factory and import live Sybase IQ data.
-
Connecting Agentforce with BigQuery Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your BigQuery data for you.
-
Build Dashboards with NASA Data in Dundas BI
Create dynamic dashboards and perform analytics based on NASA data in Dundas BI.
-
Connect to Microsoft Exchange Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Exchange data.
-
Connecting Pipedream with SAP Business Warehouse 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 SAP Business Warehouse data in real time.
-
Getting Started with the CData ODBC Driver for SharePoint Excel Services
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SharePoint Excel Services.
-
DataBind AdRoll Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide AdRoll data to a chart.
-
Build Apps with Live Azure Table data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Azure Table data into the Adalo platform and build custom mobile and web applications with real-time Azure Table data.
-
DataBind Controls to Office 365 Data in C++Builder
DataBind to Office 365 data in C++Builder with standard components and controls.
-
Connect to ElevenLabs Data in DBArtisan
Use wizards in DBArtisan to configure ElevenLabs data as a data source.
-
Model Smartsheet Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Smartsheet, enabling the direct import of real-time Smartsheet data.
-
Automated Continuous MariaDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable MariaDB replication to SingleStore.
-
Access Paylocity Data from MySQL in PHP
Connect to Paylocity through the standard MySQL libraries in PHP.
-
Automated Continuous Clio Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Clio replication to Azure SQL Database.
-
Access Planio Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Planio data from HeidiSQL.
-
Visualize Live TigerGraph Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live TigerGraph data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Using the CData Software ODBC Driver for Zoho Books in PyCharm
Connect to Zoho Books as an ODBC data source in PyCharm using the CData Software ODBC Driver for Zoho Books.
-
Create Datasets from Clockify in Domo Workbench and Build Visualizations of Clockify Data in Domo
Use the CData Software ODBC Driver for Clockify to create datasets from Clockify data in Domo Workbench and then build visualizations in the Domo service.
-
Process & Analyze Placid Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Placid Data.
-
Connect to Google Ads Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Ads data.
-
How to Create Power BI Visual Reports with Real-Time SparkPost Data
Use CData Power BI Connectors to visualize SparkPost data in Power BI.
-
Automated Continuous GitHub Replication to MySQL
Use CData Sync for automated, continuous, customizable GitHub replication to MySQL.
-
How to Connect Microsoft Exchange Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Microsoft Exchange data in real time using natural language.
-
Connect to SAP Hybris C4C from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP Hybris C4C to connect to SAP Hybris C4C data from Web applications running on WebLogic.
-
Seamlessly Bring ServiceDesk Plus Data into Retool Using CData Connect AI
Integrate ServiceDesk Plus data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connecting GenSpark with Campaigner Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Campaigner data without any replication or custom integration required.
-
Feed Dynamics CRM Data into FineReport
How to set Dynamics CRM data as a JDBC data source in FineReport.
-
Publish Deel-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Deel data.
-
Create Apps from Redshift Data in Qlik Sense Cloud
Use CData Connect AI to connect to Redshift Data and build apps from live Redshift data in Qlik Sense Cloud.
-
Integrate Elorus Data in the Pentaho Report Designer
Publish reports based on Elorus data in the Pentaho BI tool.
-
How to load Office 365 data into Elasticsearch via Logstash
Introducing a simple method to load Office 365 data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect ZohoPeople to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ZohoPeople with IBM WebSphere for seamless data integration and connectivity.
-
Process & Analyze SAP BusinessObjects BI Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP BusinessObjects BI Data.
-
Moving Data from Moosend to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Moosend data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Replicate Access Data to Multiple Databases
Replicate Access data to disparate databases with a point-and-click configuration.
-
Import Lakebase Data Using Azure Data Factory
Use CData Connect AI to connect to Lakebase Data from Azure Data Factory and import live Lakebase data.
-
How to create an RPA flow for Workable Data in UiPath Studio
Use the Workable ODBC Driver to create workflows that access real-time Workable data without any coding.
-
Create Apps from Cloudant Data in Qlik Sense Cloud
Use CData Connect AI to connect to Cloudant Data and build apps from live Cloudant data in Qlik Sense Cloud.
-
Connect to Mailgun Data from HeidiSQL
Use CData Connect AI to connect to and query live Mailgun data from HeidiSQL.
-
Automate Hacker News Data Replication to SAP HANA
Use CData Sync to customize and automate Hacker News data replication to SAP HANA.
-
Import Real-Time Instantly Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Instantly data in ColdFusion.
-
Edit and Search External QuickBooks Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of QuickBooks data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create QuickBooks Data objects that you can access from apps and the dashboard.
-
Provide OData Services of Sybase Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sybase data by developing a WCF Service Application.
-
Configure the CData JDBC Driver for Codat in a Connection Pool in Tomcat
Connect to Codat data from a connection pool in Tomcat.
-
Access Teamwork Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Teamwork data from your Oracle system.
-
Moving Data from Cosmos DB to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Cosmos DB data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating Dataiku with Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Amazon S3 data.