CData Software - Knowledge Base
Recent Articles
-
Build Opsgenie-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Opsgenie data.
-
Build Dashboards with Hubstaff Data in DBxtra
Create dynamic dashboards and perform analytics based on Hubstaff data in DBxtra.
-
How to Use a Microsoft Access Database to Update Gmail Data in Real Time
Update Gmail data by creating a linked table in Microsoft Access with the CData Gmail ODBC Driver.
-
How to import MailerLite Data into Apache Solr
Use the CData Software JDBC Driver for MailerLite in Data Import Handler and create an automated import of MailerLite data to Apache Solr Enterprise Search platform.
-
Integrating GitHub Copilot with RabbitMQ 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.
-
Access Live Placid Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Placid data into the statistical analysis tools available in SAS JMP. This article shows how to use Placid data in the Graph Builder and Query Builder.
-
ETL Workable in Oracle Data Integrator
This article shows how to transfer Workable data into a data warehouse using Oracle Data Integrator.
-
Connect to Teradata Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Teradata.
-
Load FreeAgent Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load FreeAgent data to a database.
-
Use the CData Software ODBC Driver for Suadeo in MicroStrategy
Connect to Suadeo data in MicroStrategy Developer using the CData Software ODBC Driver for Suadeo.
-
Build Pipelines with Live PostgreSQL Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to PostgreSQL from Google Cloud Data Fusion, enabling the integration of live PostgreSQL data into the building and management of effective data pipelines.
-
Use the CData ODBC Driver for Landbot in Microsoft Power Query
You can use the CData Landbot ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Landbot data into Microsoft Power Query.
-
How to connect PolyBase to Impala
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Impala data.
-
Extract, Transform, and Load Retently Data in Informatica PowerCenter
Create a simple Workflow for Retently data in Informatica PowerCenter.
-
Integrate Paddle with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Paddle with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Paddle data.
-
Create Apps from PolarTeamPro Data in Qlik Sense Cloud
Use CData Connect AI to connect to PolarTeamPro Data and build apps from live PolarTeamPro data in Qlik Sense Cloud.
-
Automated Continuous Microsoft Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to Amazon S3.
-
Integrate with Moosend Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Moosend data in SnapLogic.
-
Cassandra Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Cassandra facts in real time.
-
Build MVC Applications with Connectivity to Zoom Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zoom from an ASP.NET MVC application.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Perplexity
Provide connectivity to Perplexity data through an SAP BusinessObjects universe.
-
Connect to Jira Assets Data in HULFT Integrate
Connect to Jira Assets as a JDBC data source in HULFT Integrate
-
Automated Continuous Zoho Creator Replication to Snowflake
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Snowflake.
-
How to Connect to Live HBase Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your HBase data for you.
-
Using the CData Software ODBC Driver for CapsuleCRM in PyCharm
Connect to CapsuleCRM as an ODBC data source in PyCharm using the CData Software ODBC Driver for CapsuleCRM.
-
Integrate Office 365 Data into Power Automate Desktop using CData Connect
CData Connect for Office 365 Data enables you to integrate Office 365 data into workflows built using Microsoft Power Automate Desktop.
-
Query HubSpot Data through ODBC in Node.js
Use node-odbc to execute SQL queries against HubSpot data from Node.js.
-
Automated Continuous DB2 Replication to MongoDB
Use CData Sync for automated, continuous, customizable DB2 replication to MongoDB.
-
Create Moosend-Connected Nintex Workflows
Use CData Connect AI to connect to Moosend Data from Nintex Workflow Cloud and build custom workflows using live Moosend data.
-
How to connect PolyBase to Zendesk
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zendesk data.
-
Connect to and Query CapsuleCRM Data in QlikView over ODBC
Create data visualizations with CapsuleCRM data in QlikView.
-
Replicate TaxJar Data in Heroku for Use in Salesforce Connect
Replicate TaxJar data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData Software JDBC Driver for ZeroBounce in MicroStrategy Web
Connect to ZeroBounce data in MicroStrategy Web using the CData Software JDBC Driver for ZeroBounce.
-
Connecting Moonlit Workflow with Zuora Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Zuora data in real time.
-
Connect Deel Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Deel data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Provide OData Services of SAP Fieldglass Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Fieldglass data by developing a WCF Service Application.
-
Connect to Planio Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Planio to connect to Planio data and execute queries in PowerBuilder.
-
Import Real-Time Oracle Eloqua Reporting Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Oracle Eloqua Reporting data in ColdFusion.
-
Build Visualizations of ZohoPeople Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ZohoPeople data in Birst.
-
Process & Analyze SAS xpt Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAS xpt Data.
-
Automate Oracle Eloqua Reporting Data Replication to Azure Synapse
Use CData Sync to customize and automate Oracle Eloqua Reporting data replication to Azure Synapse.
-
DataBind Charts to MailChimp Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to MailChimp 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.
-
Access Live Google Calendar Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google Calendar data from your Excel spreadsheets.
-
Integrating Boomi Agentstudio with eBay Analytics Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to eBay Analytics data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Provide OData Services of Flowlu Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Flowlu data by developing a WCF Service Application.
-
Integrate Theia IDE with Live Zoho Books 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 Zoho Books data from within the development environment.
-
Integrate with Smartsheet Data in JReport Designer
Create charts and reports based on Smartsheet data in JReport Designer.
-
Create BigQuery-Connected Business Apps in AppSheet
Connect to BigQuery Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to BigQuery data.
-
Create Reports with Sybase IQ Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sybase IQ data.
-
How to Connect Exa 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 Exa data in real time using natural language.
-
Getting Started with the CData Power BI Connector for HubDB
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for HubDB.
-
Using the CData Software ODBC Driver for Azure Data Lake Storage in PyCharm
Connect to Azure Data Lake Storage as an ODBC data source in PyCharm using the CData Software ODBC Driver for Azure Data Lake Storage.
-
Connect to SAP Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP data.
-
A PostgreSQL Interface for Exa Data using the CData ODBC Driver
Use the SQL Gateway and Exa ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Epicor Kinetic Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to PostgreSQL.
-
Getting Started with the CData ADO.NET Provider for Marketo
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Marketo.
-
Access Live PayPal Data in AWS Lambda (with IntelliJ IDEA)
Connect to live PayPal data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Prepare, Blend, and Analyze SAP Netweaver Gateway Data in Alteryx Designer (ODBC)
Build workflows to access live SAP Netweaver Gateway data for self-service data analytics.
-
How to Easily Query Rebilly Data in OpenOffice Base
Connect to Rebilly data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create Impala-Connected Applications in Appsmith
Connect to Impala Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Impala data.
-
Publish Postmark-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Postmark data.
-
Replicate MarkLogic Data from PowerShell
Write a quick PowerShell script to query MarkLogic data. Use connectivity to the live data to replicate MarkLogic data to SQL Server.
-
Build Amazon Athena-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Amazon Athena data and build Amazon Athena-connected web apps with Axios.
-
A PostgreSQL Interface for OpenWeatherMap Data using the CData ODBC Driver
Use the SQL Gateway and OpenWeatherMap ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Claude Code CLI with Trello 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 Biml to Build SSIS Tasks to Replicate Microsoft Teams Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Teams data to SQL Server.
-
ServiceDesk Plus Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to ServiceDesk Plus data through CData Connect AI using different applications and tools.
-
Create a Data Access Object for Salesforce Data 360 Data using JDBI
A brief overview of creating a SQL Object API for Salesforce Data 360 data in JDBI.
-
Getting Started with the CData Excel Add-In for Google Campaign Manager 360
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Campaign Manager 360.
-
Write a Simple Go Application to work with Pipeline CRM Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Pipeline CRM data.
-
Automate Couchbase Data Replication to Azure Synapse
Use CData Sync to customize and automate Couchbase data replication to Azure Synapse.
-
Visualize Qualaroo Data in Sisense
Create an ElastiCube in Sisense app with access to Qualaroo data.
-
HCL Domino REST API Part 2: Schema and Scope Setting
A detailed guide on configuring schema and scope settings in the HCL Domino REST API to optimize data access and integration.
-
Add Discourse Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Discourse with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Anaplan Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Anaplan.
-
Use the CData Software JDBC Driver for SAS Data Sets in MicroStrategy Desktop
Connect to SAS Data Sets data in MicroStrategy Desktop using the CData Software JDBC Driver for SAS Data Sets.
-
ETL SurveyMonkey in Oracle Data Integrator
This article shows how to transfer SurveyMonkey data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Egnyte Replication to SQL Server
Use CData Sync for automated, continuous, customizable Egnyte replication to SQL Server.
-
Connect to Asana Data in HULFT Integrate
Connect to Asana as a JDBC data source in HULFT Integrate
-
Automate ZeroBounce Data Replication to SAP HANA
Use CData Sync to customize and automate ZeroBounce data replication to SAP HANA.
-
How to Connect to Live HubDB 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 HubDB data for you.
-
Replicate Multiple Avaza Accounts via the CData Sync CLI
Replicate multiple Avaza accounts to one or many databases.
-
View Reports on Real-Time ActiveCampaign Data in Power BI Report Server
Use the CData ODBC Driver for ActiveCampaign to visualize ActiveCampaign data in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Dashboards with Mistral AI Data in Dundas BI
Create dynamic dashboards and perform analytics based on Mistral AI data in Dundas BI.
-
Create Dynamic Clockify Grids Using the Infragistics XamDataGrid
Learn how you can connect Clockify to Infragistics XamDataGrid to build dynamic grids.
-
Publish Exact Online-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Exact Online data.
-
Connect to DB2 from Asprova with CData Software ODBC Driver for DB2
This article shows how to connect faster to DB2 data from Asprova.
-
Use Grok to Talk to Your SQL Server 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 SQL Server data for you.
-
Build Semantic Layer Views for SAP HANA XS Advanced Data in APOS Live Data Gateway
Use the CData Connector for SAP HANA XS Advanced in APOS Live Data Gateway to build Semantic Layer Views for SAP HANA XS Advanced data.
-
How to Connect to Live ZohoExpense 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 ZohoExpense data for you.
-
Use Grok to Talk to Your Power BI XMLA 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 Power BI XMLA data for you.
-
Connect to Presto from Asprova with CData Software ODBC Driver for Presto
This article shows how to connect faster to Presto data from Asprova.
-
Query Zoho Recruit Data in DataGrip
Create a Data Source for Zoho Recruit in DataGrip and use SQL to query live Zoho Recruit data.
-
Validate ServiceDesk Plus Data with QuerySurge
Access and validate ServiceDesk Plus data in QuerySurge using the CData JDBC Driver.
-
Connect to ZendeskSell Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ZendeskSell data in the Denodo Virtual DataPort Administrator.
-
Query Airtable Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Airtable entities in PHP by modeling them as objects.
-
Connect to BambooHR 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 BambooHR data.
-
Create Pingdom Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Pingdom from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Power BI Reports on Real-Time Workable Data
Use the CData ODBC Driver for Workable to visualize Workable data in Power BI Desktop.
-
A PostgreSQL Interface for xBase Data using the CData ODBC Driver
Use the SQL Gateway and xBase ODBC Driver to create a PostgreSQL entry-point for data access.