CData Software - Knowledge Base
Recent Articles
-
Integrating LangGraph with YouTube Analytics Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on YouTube Analytics within automated workflows.
-
Integrate Slack Data in Pentaho Data Integration
Build ETL pipelines based on Slack in the Pentaho Data Integration tool.
-
Integrating LangGraph with ADP Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on ADP within automated workflows.
-
Automate Jodoo Data Replication to Azure Synapse
Use CData Sync to customize and automate Jodoo replication to Azure Synapse.
-
OneNote Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft OneNote through CData Connect AI using different applications and tools.
-
Work with Flowlu Data in FoxPro
Load Flowlu into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Goose with Live Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Elasticsearch from within the local AI agent.
-
Replicate Google Directory Data in Heroku for Use in Salesforce Connect
Replicate Google Directory to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
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.
-
Build Dashboards with Hubstaff Data in DBxtra
Create dynamic dashboards and perform analytics based on Hubstaff 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 to Apache Solr Enterprise Search platform.
-
Integrating GitHub Copilot CLI with RabbitMQ 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 into the statistical analysis tools available in SAS JMP. This article shows how to use Placid in the Graph Builder and Query Builder.
-
Build Excel-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Excel to explore live Excel Data in Gemini Code Assist to assist with building Excel-powered applications.
-
Delighted Reporting in OBIEE with the Delighted JDBC Driver
Deploy the Delighted JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
ETL Workable in Oracle Data Integrator
This article shows how to transfer Workable into a data warehouse using Oracle Data Integrator.
-
Connect to Teradata Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Load FreeAgent Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load FreeAgent to a database.
-
Use the CData Software ODBC Driver for Suadeo in MicroStrategy
Connect to Suadeo 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 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 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 Apache Impala.
-
Extract, Transform, and Load Retently Data in Informatica PowerCenter
Create a simple Workflow for Retently 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.
-
Automated Continuous Microsoft Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to Amazon S3.
-
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 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 Apache HBase 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 Microsoft Office 365 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 from Node.js.
-
Automated Continuous DB2 Replication to MongoDB
Use CData Sync for automated, continuous, customizable DB2 replication to MongoDB.
-
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.
-
Connect to and Query CapsuleCRM Data in QlikView over ODBC
Create data visualizations with CapsuleCRM in QlikView.
-
Replicate TaxJar Data in Heroku for Use in Salesforce Connect
Replicate TaxJar 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 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 in real time.
-
Connect Deel Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Deel 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 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 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 in ColdFusion.
-
Build Visualizations of ZohoPeople Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ZohoPeople 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 replication to Azure Synapse.
-
DataBind Charts to MailChimp Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to MailChimp 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 from your Excel spreadsheets.
-
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 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
-
Integrate with Smartsheet Data in JReport Designer
Create charts and reports based on Smartsheet 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 Google BigQuery.
-
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.
-
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 ERP/NetWeaver.
-
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 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 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 Apache Impala.
-
Publish Postmark-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Postmark.
-
Replicate MarkLogic Data from PowerShell
Write a quick PowerShell script to query MarkLogic. Use connectivity to the live data to replicate MarkLogic 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 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 to SQL Server.
-
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 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.
-
Automate Couchbase Data Replication to Azure Synapse
Use CData Sync to customize and automate Couchbase replication to Azure Synapse.
-
Visualize Qualaroo Data in Sisense
Create an ElastiCube in Sisense app with access to Qualaroo.
-
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
-
Use the CData Software JDBC Driver for SAS Data Sets in MicroStrategy Desktop
Connect to SAS Data Sets 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 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
-
Use the CData API Server to Access Greenplum Data in Microsoft PowerPivot
Use the CData API Server to connect to live Pivotal GreenPlum in the Power Pivot business intelligence tool.
-
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 in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Authorize.Net-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Authorize.Net to explore live Authorize.Net Data in Cursor to assist with building Authorize.Net-powered applications.
-
Build Dashboards with Mistral AI Data in Dundas BI
Create dynamic dashboards and perform analytics based on Mistral AI 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.
-
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 Microsoft SQL Server 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.
-
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 for you.
-
How to Query Live Greenplum Data in Claude Desktop
Connect to and query live Greenplum Data in Claude Desktop using CData MCP Server.
-
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.
-
Validate ServiceDesk Plus Data with QuerySurge
Access and validate ServiceDesk Plus 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 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.