CData Software - Knowledge Base
Recent Articles
-
Integrate Live Factorial Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Factorial data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Use CData Connect AI to Access HCL Domino Data in Microsoft Power Pivot
Use CData Connect AI to connect to live HCL Domino data in the Power Pivot business intelligence tool.
-
How to Work with ZohoDesk Data in ETL Validator JDBC
Connect to ZohoDesk from ETL Validator jobs using the CData Software JDBC Driver.
-
Search External Zuora Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Zuora data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Zuora Data objects that you can access from apps and the dashboard.
-
Integrate BigQuery Data into Power Automate Desktop using CData Connect
CData Connect for BigQuery Data enables you to integrate BigQuery data into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software ODBC Driver for Codat in MicroStrategy
Connect to Codat data in MicroStrategy Developer using the CData Software ODBC Driver for Codat.
-
Use Claude to Talk to Your Monday.com 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 Monday.com data for you.
-
Create Informatica Mappings From/To an ODBC Data Source for Anaplan
Create an ODBC connection to Anaplan in Informatica and browse and transfer Anaplan data.
-
Getting Started with the CData Power BI Connector for Amazon Athena
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Amazon Athena.
-
Back Up BenchmarkEmail data 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 BenchmarkEmail data data.
-
Build Omnisend-Connected Apps in Choreo
Use CData Connect AI to connect to Omnisend Data from Choreo and build custom apps using live Omnisend data.
-
Use Databricks Agent Bricks to Talk to Your Bullhorn CRM Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Bullhorn CRM data for you.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Perigon
Provide connectivity to Perigon data through an SAP BusinessObjects universe.
-
Create Informatica Mappings From/To a JDBC Data Source for Apify
Create Apify data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automate Printify Data Replication to Azure Data Lake
Use CData Sync to customize and automate Printify data replication to Azure Data Lake.
-
Use JayDeBeApi to access PDFMonkey Data in Python
Use standard Python scripting and the development environment of your choice to access live PDFMonkey data.
-
Build Automated Workflows with Live Zuora Data in Workato
Use CData Connect AI to connect to live Zuora data and build automated workflows in Workato.
-
Getting Started with the CData Python Connector for Reckon Accounts Hosted
Learn to install and license the CData Python Connector and configure a connection to live Reckon Accounts Hosted data.
-
DataBind Google Analytics Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Google Analytics with the DevExpress Windows Forms and Web controls to provide Google Analytics data to a chart.
-
Build Automated Workflows with Live NetSuite SuiteAnalytics Data in Workato
Use CData Connect AI to connect to live NetSuite SuiteAnalytics data and build automated workflows in Workato.
-
Automated Continuous Printful Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Printful replication to Azure SQL Database.
-
Create Reports with Facebook Ads Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Facebook Ads data.
-
Connect to Power BI XMLA Data in Aqua Data Studio
Access Power BI XMLA data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous VWO Replication to Vertica
Use CData Sync for automated, continuous, customizable VWO replication to Vertica.
-
Connect to Contentful Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Contentful and the SQL Gateway to access Contentful data from Google Apps Script.
-
Import Real-Time HubSpot Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use HubSpot data in ColdFusion.
-
Connect to ConvertKit Data from PowerBuilder via JDBC
This article demonstrates how to access ConvertKit data from PowerBuilder using the ConvertKit JDBC Driver.
-
Use the CData Software JDBC Driver for Oracle in MicroStrategy
Connect to Oracle data in MicroStrategy Developer using the CData Software JDBC Driver for Oracle.
-
Visualize Zoho Projects Data in TIBCO Spotfire through ADO.NET
Integrate Zoho Projects data into dashboards in TIBCO Spotfire.
-
Connect to Aircall Data in NetBeans
Connect to Aircall data in NetBeans with the data source configuration wizard.
-
Create Informatica Mappings From/To a JDBC Data Source for Egnyte
Create Egnyte data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Access Live CapsuleCRM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for CapsuleCRM enables you to integrate CapsuleCRM data into workflows built using Microsoft Power Automate Desktop.
-
Replicate Simplesat Data in Heroku for Use in Salesforce Connect
Replicate Simplesat data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Import Real-Time Coda Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Coda data in ColdFusion.
-
Connecting Mastra with MarkLogic 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 MarkLogic data, no replication required.
-
Import Facebook Ads Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Facebook Ads Data and provide access to live Facebook Ads data for custom reports in the Power BI Service.
-
Access Live Rebilly Data in AWS Lambda
Connect to live Rebilly data in AWS Lambda using the CData JDBC Driver.
-
Connect to Live Timely Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Timely in CData Connect AI and connect to your Timely data from PostgreSQL.
-
How to publish and share Factorial Data dashboards with Tableau Server
The CData ODBC driver for Factorial enables you integrate Factorial data into Tableau dashboards.
-
Integrate Cursor with Live Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Twitter Ads data from within the editor.
-
Connect Google Ad Manager to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Ad Manager with IBM WebSphere for seamless data integration and connectivity.
-
Getting Started with the CData Power BI Connector for Google Analytics
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Analytics.
-
Publish Crystal Reports on Helpscout Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Helpscout data.
-
Automated Continuous Guru Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Guru replication to Google Cloud SQL.
-
View Reports on Real-Time Clari Data in Power BI Report Server
Use the CData ODBC Driver for Clari to visualize Clari data in Power BI Desktop and then publish them to Power BI Report Server.
-
A PostgreSQL Interface for Azure Analysis Services Data (MySQL Remoting via JDBC)
Use the Remoting features of the Azure Analysis Services JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live QuickBooks Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live QuickBooks data from your Excel spreadsheets.
-
Query Webex Data in DataGrip
Create a Data Source for Webex in DataGrip and use SQL to query live Webex data.
-
Create Reports with Reckon Accounts Hosted Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Reckon Accounts Hosted data.
-
Integrating LangChain with PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on PostgreSQL data within automated workflows.
-
Use the CData ODBC Driver for LinkedIn from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for LinkedIn to connect to LinkedIn data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring LinkedIn data in Excel.
-
Access Live Sage Cloud Accounting Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Sage Cloud Accounting data from your Excel spreadsheets.
-
How to work with Quaderno Data in Apache Spark using SQL
Access and process Quaderno Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Autopilot Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Autopilot replication to Amazon S3.
-
Analyze Lakebase Data in Cognos Analytics
Use CData Connect AI to connect to Lakebase Data from Cognos Analytics and analyze live Lakebase data.
-
Access Shopify Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Shopify data from your Oracle system.
-
Build Agents in Relevance AI with Access to Live WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on WordPress data within intelligent agent workflows.
-
DocuSign Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to DocuSign data through CData Connect AI using different applications and tools.
-
Build Semantic Layer Views for NetSuite SuiteAnalytics Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for NetSuite SuiteAnalytics data.
-
Load SFTP Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SFTP data to a database.
-
Automated Continuous ZarMoney Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ZarMoney replication to Google Cloud SQL.
-
Query, Visualize, and Share live Excel Online Data in Redash
Use CData Connect AI to connect to live Excel Online data in Redash for querying, visualizing, and sharing.
-
Build Oracle SCM-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Oracle SCM Data from Zoho Analytics and import live Oracle SCM data.
-
Connect to Close from a Connection Pool in WebLogic
Use the CData JDBC Driver for Close to connect to Close data from Web applications running on WebLogic.
-
Connect to Adobe Commerce Data from AWS Glue
Use CData Connect AI to gain access to live Adobe Commerce data from your AWS Glue jobs.
-
Getting Started with the CData Connect AI Python SDK for LinkedIn
Install the CData Connect AI Python SDK to read and write live LinkedIn data with standard DB-API 2.0 Python code.
-
Model MYOB AccountRight Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and MYOB AccountRight, enabling the direct import of real-time MYOB AccountRight data.
-
Integrating Boomi Agentstudio with HDFS Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to HDFS data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Oracle Data in Jaspersoft Studio
Execute SQL to remote Oracle data in Jaspersoft Studio.
-
How to Create Power BI Visual Reports with Real-Time Jira Data
Use CData Power BI Connectors to visualize Jira data in Power BI.
-
Validate Factorial Data with QuerySurge
Access and validate Factorial data in QuerySurge using the CData JDBC Driver.
-
Integrating Cursor with Databricks 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.
-
Integrate Outreach.io Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Outreach.io data and integrate live Outreach.io data into your Power Automate tasks.
-
Automated Continuous SendGrid Replication to Oracle
Use CData Sync for automated, continuous, customizable SendGrid replication to Oracle.
-
Create Data Visualizations in Cognos BI with Microsoft Entra ID Data
Access Microsoft Entra ID data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create a Data Access Object for Highrise Data using JDBI
A brief overview of creating a SQL Object API for Highrise data in JDBI.
-
Replicate Microsoft Dataverse Data in Heroku for Use in Salesforce Connect
Replicate Microsoft Dataverse data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Quaderno Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Quaderno data from HeidiSQL.
-
DataBind Charts to IBM Cloud Object Storage Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to IBM Cloud Object Storage 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.
-
Build Google Contacts-Connected Apps in Choreo
Use CData Connect AI to connect to Google Contacts Data from Choreo and build custom apps using live Google Contacts data.
-
Analyze MessageBird Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze MessageBird data in Microsoft R Open.
-
Viewing Salesforce Data 360 Data in RAD Studio Data Explorer
How to view Salesforce Data 360 data in RAD Studio Data Explorer using the CData ODBC Driver for Salesforce Data 360.
-
Build Data Flows from SQL Server to Zoho Inventory through SSIS
Easily push SQL Server data to Zoho Inventory using the CData SSIS Tasks for Zoho Inventory.
-
Integrating Claude Code CLI with SAP Concur 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 connect PolyBase to Brex
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Brex data.
-
Create Data Visualizations in Cognos BI with Jira Assets Data
Access Jira Assets data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use Manus AI to Talk to Your Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Freshdesk data.
-
How to Connect to Live Avro 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 Avro data for you.
-
Access Pinterest Data from MySQL in PHP
Connect to Pinterest through the standard MySQL libraries in PHP.
-
Jira Assets Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Jira Assets facts in real time.
-
Link AfterShip with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate AfterShip data in Filemaker Pro for Mac or Windows.
-
Connect to Pipedrive Data in HULFT Integrate
Connect to Pipedrive as a JDBC data source in HULFT Integrate
-
Build Blackbaud FE NXT Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Blackbaud FE NXT data and build visualizations in Tableau.
-
Integrating OpenCode with SAP Fieldglass 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 Dynamic Aha! Grids Using the Infragistics XamDataGrid
Learn how you can connect Aha! to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Printify Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Printify Data and connect to Printify data in Akorbi Digital RunMyProcess.
-
Replicate Parallel Data to Multiple Databases via the CData Sync CLI
Replicate Parallel data to disparate databases with a single configuration.
-
Create Data Visualizations Based On Twitter Ads Data in Mode
Use CData Connect AI to connect to Twitter Ads Data from Mode and build visualizations using live Twitter Ads data.
-
Query Cloudant Data in ColdFusion
Write standard ColdFusion data access code to connect to Cloudant data.
-
Use JayDeBeApi to access CloudConvert Data in Python
Use standard Python scripting and the development environment of your choice to access live CloudConvert data.