CData Software - Knowledge Base
Recent Articles
-
How to update Jira Assets from Excel
This article explains how to transfer data from Excel to Jira Assets using the Excel Add-In for Jira Assets.
-
Build Charts with Bannerbear Data in Clear Analytics
Create dynamic charts and perform analytics based on Bannerbear data in Clear Analytics.
-
Add Sage Intacct Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Sage Intacct with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use CData Connect AI to Access Gong Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Gong data in the Power Pivot business intelligence tool.
-
How to connect PolyBase to Google Analytics
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Analytics data.
-
Migrating data from Brex to Snowflake using CData SSIS Components.
Easily push Brex data to Snowflake using the CData SSIS Tasks for Brex and Snowflake.
-
How to Work with Cohere Data in ETL Validator JDBC
Connect to Cohere from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Landbot Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Landbot replication to Amazon S3.
-
How to Connect to & Open Qualaroo Data in Microsoft Excel
This article uses the CData ODBC driver for Qualaroo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Work with Live HCL Domino Data in Power Query
Use CData Connect AI to connect to HCL Domino data and work with live HCL Domino data in Microsoft Power Query.
-
Automated Continuous Insightly Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Insightly replication to Apache Cassandra.
-
Automate Dotmailer Data Replication to SAP HANA
Use CData Sync to customize and automate Dotmailer data replication to SAP HANA.
-
Create Dynamic Act CRM Grids Using the Infragistics XamDataGrid
Learn how you can connect Act CRM to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Parallel Replication to MongoDB
Use CData Sync for automated, continuous, customizable Parallel replication to MongoDB.
-
Create a Data Access Object for Telegram Data using JDBI
A brief overview of creating a SQL Object API for Telegram data in JDBI.
-
Use the CData Software ODBC Driver for SAP BusinessObjects BI in MicroStrategy
Connect to SAP BusinessObjects BI data in MicroStrategy Developer using the CData Software ODBC Driver for SAP BusinessObjects BI.
-
Visualize Bullhorn CRM Data in TIBCO Spotfire through ADO.NET
Integrate Bullhorn CRM data into dashboards in TIBCO Spotfire.
-
Easily Integrate Drip Data in Lazarus Pascal IDE
Learn how to easily integrate live Drip data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Visualize Gmail 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 Gmail data in Python.
-
Connect to SingleStore Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live SingleStore data.
-
Design BIRT Reports on Airtable Data
Provide current Airtable data to your embedded analytics.
-
How to Connect Flowise AI Agents to Live DocuSign Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live DocuSign data without replication.
-
Automated Continuous Tally Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Tally replication to delimited files (CSV/TSV).
-
Connect to Google Ad Manager Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Ad Manager and the SQL Gateway to access Google Ad Manager data from Google Apps Script.
-
Easily Integrate ElevenLabs Data in Lazarus Pascal IDE
Learn how to easily integrate live ElevenLabs data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect to Live Cloudant Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Cloudant data through natural language.
-
Connect to FHIR Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for FHIR data.
-
Automated Continuous Copper Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Copper replication to Google Cloud SQL.
-
Automated Continuous Airtable Replication to MySQL
Use CData Sync for automated, continuous, customizable Airtable replication to MySQL.
-
Seamlessly Bring Sage 300 Data into Retool Using CData Connect AI
Integrate Sage 300 data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Amplitude Reporting in OBIEE with the Amplitude JDBC Driver
Deploy the Amplitude JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Zoho Recruit Replication to SingleStore
Use CData Sync for automated, continuous, customizable Zoho Recruit replication to SingleStore.
-
Create Data Visualizations in Cognos BI with Shortcut Data
Access Shortcut data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Getting Started with the CData Tableau Connector for ZohoSubscriptions
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to connect to Apify Data from Spring Boot
Connect to Apify in a Spring Boot Application using the CData API Driver for JDBC
-
Create Informatica Mappings From/To an ODBC Data Source for Office 365
Create an ODBC connection to Office 365 in Informatica and browse and transfer Office 365 data.
-
Use the CData ODBC Driver for ConvertKit in Microsoft Power Query
You can use the CData ConvertKit ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ConvertKit data into Microsoft Power Query.
-
Connect to Strava Data in RapidMiner
Integrate Strava data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Google Drive Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Drive data from Appeon PowerBuilder using the CData ADO.NET Provider for Google Drive.
-
Query JSON Services in ColdFusion
Write standard ColdFusion data access code to connect to JSON services.
-
Build a Singer.io Tap for Oracle With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Oracle data using the CData Python Connector.
-
Integrate Wistia Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Wistia data and integrate live Wistia data into your Power Automate tasks.
-
Analyze Sentry Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Sentry data with the CData JDBC Driver for Sentry.
-
Build an OLAP Cube in SSAS from Zoho Recruit Data
Establish a connection to Zoho Recruit data data from SQL Server Analysis Services, and use the Zoho Recruit Data Provider to build OLAP cubes for use in analytics and reporting.
-
Analyze Active Directory Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Active Directory data in Microsoft R Open.
-
Extract, Transform, and Load Couchbase Data in Informatica PowerCenter
Create a simple Workflow for Couchbase data in Informatica PowerCenter.
-
Publish Zoho Recruit-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Zoho Recruit data.
-
Integrate Theia IDE with Live BigQuery 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 BigQuery data from within the development environment.
-
Validate EnterpriseDB Data with QuerySurge
Access and validate EnterpriseDB data in QuerySurge using the CData JDBC Driver.
-
How to Build an ETL App for Authorize.Net Data in Python with CData
Create ETL applications and real-time data pipelines for Authorize.Net data in Python with petl.
-
Replicate PolarTeamPro Data to Multiple Databases via the CData Sync CLI
Replicate PolarTeamPro data to disparate databases with a single configuration.
-
Automated Continuous Guru Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Guru replication to Amazon S3.
-
Create SAP HANA-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP HANA Data from OutSystems and build custom enterprise apps using live SAP HANA data.
-
Integrate LibreChat with Live GetResponse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live GetResponse data from within the chat interface.
-
Connect to ZarMoney Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ZarMoney to connect to ZarMoney data and execute queries in PowerBuilder.
-
Create Dynamic Ontraport Grids Using the Infragistics XamDataGrid
Learn how you can connect Ontraport to Infragistics XamDataGrid to build dynamic grids.
-
Using the CData Software ODBC Driver for SQL Server in PyCharm
Connect to SQL Server as an ODBC data source in PyCharm using the CData Software ODBC Driver for SQL Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zoho Projects
Provide connectivity to Zoho Projects data through an SAP BusinessObjects universe.
-
Connect to Hubstaff Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Hubstaff and work with Hubstaff data in your FileMaker application.
-
Connecting GenSpark with Shortcut Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Shortcut data without any replication or custom integration required.
-
How to connect to Sage Intacct Data from Spring Boot
Connect to Sage Intacct in a Spring Boot Application using the CData JDBC Driver for Sage Intacct
-
Link Postmark with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Postmark data in Filemaker Pro for Mac or Windows.
-
Access Rebilly Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Rebilly data from your Oracle system.
-
Back Up Mailjet 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 Mailjet data data.
-
Create Datasets from SAP SuccessFactors in Domo Workbench and Build Visualizations of SAP SuccessFactors Data in Domo
Use the CData Software ODBC Driver for SAP SuccessFactors to create datasets from SAP SuccessFactors data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to GetResponse Data as an External Source in Dremio
Use the CData JDBC Driver to connect to GetResponse as an External Source in Dremio.
-
Build AI/ML Models with Live Sage 300 Data using Dataiku
Connect Sage 300 Data with Dataiku using the CData JDBC Driver for Sage 300.
-
Integrating Claude Code CLI with Perigon 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.
-
Integrating LlamaIndex with JSON Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on JSON services in real time.
-
Visualize Live Smartsheet Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Smartsheet data.
-
Moving Data from Missive to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Missive data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to NetSuite Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for NetSuite Data and connect to NetSuite data in Akorbi Digital RunMyProcess.
-
DataBind Controls to SAP Data in C++Builder
DataBind to SAP data in C++Builder with standard components and controls.
-
Integrate FTP Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live FTP data from Informatica Cloud.
-
Connect to Adobe Commerce from a Connection Pool in WebLogic
Use the CData JDBC Driver for Adobe Commerce to connect to Adobe Commerce data from Web applications running on WebLogic.
-
Connect to JSON from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from JSON services, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build DocuSign-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for DocuSign Data and create custom apps in Mendix.
-
Dynamics 365 Business Central Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Dynamics 365 Business Central facts in real time.
-
Connect to Adobe Experience Manager from a Connection Pool in WebLogic
Use the CData JDBC Driver for Adobe Experience Manager to connect to Adobe Experience Manager data from Web applications running on WebLogic.
-
Connect to Oracle Eloqua Reporting Data in Jaspersoft Studio
Execute SQL to remote Oracle Eloqua Reporting data in Jaspersoft Studio.
-
Use Microsoft Copilot Studio to talk to your Sage 300 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Sage 300 data for you.
-
Create Datasets from Square in Domo Workbench and Build Visualizations of Square Data in Domo
Use the CData Software ODBC Driver for Square to create datasets from Square data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Oracle Financials Cloud Data from a Connection Pool in JBoss
Integrate Oracle Financials Cloud data into Java servlets: Use the Management Console in JBoss to install the Oracle Financials Cloud JDBC Driver.
-
Analyze GraphQL Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze GraphQL data in Microsoft R Open.
-
Integrate OpenCode with Live CockroachDB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live CockroachDB data from within your AI coding agent.
-
Create Informatica Mappings From/To a JDBC Data Source for Recurly
Create Recurly data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Apps with Live ZohoInvoice Data Using the Low-Code Development Platform of Mendix
Connect ZohoInvoice data with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Moosend Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Moosend replication to AlloyDB.
-
Connect to Microsoft Ads Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Microsoft Ads.
-
Connect to Google Forms Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Google Forms and work with Google Forms data in your FileMaker application.
-
Connect to Smartsheet Data in JRuby
Create a simple JRuby app with access to live Smartsheet data.
-
Integrate Perigon with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Perigon with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Perigon data.
-
Use the CData Software ODBC Driver for Adobe Commerce in SAS for Real-Time Reporting and Analytics
Connect to real-time Adobe Commerce data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Adobe Commerce.
-
Connect to Google Spanner Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google Spanner data from Crystal Reports.
-
How to Query Google Contacts Data in MySQL Workbench
Execute MySQL queries against live Google Contacts data from MySQL Workbench.
-
Build a Singer.io Tap for Salesforce With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Salesforce data using the CData Python Connector.
-
Work with Live Kintone Data in Power Query
Use CData Connect AI to connect to Kintone data and work with live Kintone data in Microsoft Power Query.
-
Create SSAS Tabular Models from Cvent Data
How to build a SQL Server Analysis Service Tabular Model from Cvent data using CData drivers.
-
Design BIRT Reports on SparkPost Data
Provide current SparkPost data to your embedded analytics.
-
Connect to Live NetSuite SuiteAnalytics Data in MicroStrategy through CData Connect AI
Create a live connection to NetSuite SuiteAnalytics Data in CData Connect AI and connect to your NetSuite SuiteAnalytics data from MicroStrategy.