CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Salesloft Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Salesloft replication to Apache Cassandra.
-
Using the CData Software ODBC Driver for QuickBooks in PyCharm
Connect to QuickBooks as an ODBC data source in PyCharm using the CData Software ODBC Driver for QuickBooks.
-
Build SAP Ariba Procurement-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP Ariba Procurement Data and create custom apps in Bubble.
-
Integrating GitHub Copilot CLI with iContact 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.
-
Getting Started with the CData Excel Add-In for HelloSign
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for HelloSign.
-
Replicate OData Services from PowerShell
Write a quick PowerShell script to query OData. Use connectivity to the live data to replicate OData to SQL Server.
-
How to Access Live SAP Ariba Procurement Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP Ariba Procurement enables you to integrate SAP Ariba Procurement into workflows built using Microsoft Power Automate Desktop.
-
Replicate IBM Cloud Object Storage Data in Heroku for Use in Salesforce Connect
Replicate IBM Cloud Object Storage to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Miro with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Miro with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Miro.
-
Creating MariaDB-Connected Applications in Unqork
You can use CData Connect AI to feed MariaDB to Unqork and build custom business apps.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAS XPORT within intelligent workflows.
-
Connect to Short.io Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Short.io in the Denodo Virtual DataPort Administrator.
-
Create SAP Concur-Connected Applications in Appsmith
Connect to SAP Concur Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Concur.
-
Bidirectional Access to Rootly Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Rootly in Filemaker Pro for Mac or Windows.
-
Access Live Gmail Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Gmail in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData ODBC Driver for ShipEngine in Microsoft Power Query
You can use the CData ShipEngine ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ShipEngine into Microsoft Power Query.
-
Use Databricks Agent Bricks to Talk to Your Acumatica Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Acumatica ERP for you.
-
Visualize SAP Business Warehouse Data in Tableau
The CData ODBC driver for SAP Business Warehouse enables you integrate SAP Business Warehouse into Tableau dashboards.
-
Automated Continuous Google Tasks Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Tasks replication to IBM DB2.
-
Use the CData Software ODBC Driver for PivotalTracker in MicroStrategy Desktop
Connect to PivotalTracker in MicroStrategy Desktop using the CData Software ODBC Driver for PivotalTracker.
-
Automated Continuous Access Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Access replication to Apache Cassandra.
-
Access Live Amazon DynamoDB Data in TIBCO Data Virtualization
Use the Amazon DynamoDB Tibco DV Adapter to create a Amazon DynamoDB data source in TIBCO Data Virtualization Studio and gain access to live Amazon DynamoDB from your TDV Server.
-
Integrating LlamaIndex with Certinia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Certinia in real time.
-
Use the CData Software ODBC Driver for SAP Ariba Source in MicroStrategy Web
Connect to SAP Ariba Source in MicroStrategy Web using the CData Software ODBC Driver for SAP Ariba Source.
-
Use the CData API Server to Access Stack Exchange Data in Microsoft PowerPivot
Use the CData API Server to connect to live Stack Exchange in the Power Pivot business intelligence tool.
-
How to Easily Query Oracle SCM Data in OpenOffice Base
Connect to Oracle SCM data in OpenOffice Base using the CData ODBC Driver for Oracle SCM and generate reports with live data insights.
-
Automated Continuous Pipedrive Replication to SingleStore
Use CData Sync for automated, continuous, customizable Pipedrive replication to SingleStore.
-
Integrate Scrapfly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Scrapfly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Scrapfly.
-
Query Live Pipedrive Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Pipedrive directly from the development environment.
-
Viewing Delighted Data in RAD Studio Data Explorer
How to view Delighted in RAD Studio Data Explorer using the CData ODBC Driver for Delighted.
-
Visualize Live Microsoft Entra ID Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft Entra ID into custom reports in Power BI.
-
Create Kintone-Connected Applications in Appsmith
Connect to Kintone Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Kintone.
-
Use the CData ODBC Driver for Oracle Sales from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Oracle Sales to connect to Oracle Sales from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Oracle Sales in Excel.
-
How to integrate WooCommerce with Apache Airflow
Access and process WooCommerce in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Clio Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Clio replication to Amazon Redshift.
-
Work with Oracle Sales Data in FoxPro
Load Oracle Sales into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate with live Excel Online Data in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft Excel Online in Jitterbit.
-
Access Oracle Eloqua Reporting Data from MySQL in Amazon QuickSight
Connect to Oracle Eloqua Reporting and build visualizations of Oracle Eloqua Reporting using a MySQL Connection in Amazon QuickSight.
-
Create a Data Access Object for YouTube Analytics Data using JDBI
A brief overview of creating a SQL Object API for YouTube Analytics in JDBI.
-
Enable the Moosend JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Moosend.
-
Automate Insightly Data Replication to Couchbase
Use CData Sync to Customize and automate Insightly replication to Couchbase.
-
Creating CouchDB-Connected Applications in Unqork
You can use CData Connect AI to feed Apache CouchDB to Unqork and build custom business apps.
-
Getting Started with the CData SSIS Components for Float
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Float.
-
Automate SAP SuccessFactors Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP SuccessFactors and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to Pushbullet Data in Aqua Data Studio
Access Pushbullet from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connecting Moonlit Workflow with MongoDB 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 MongoDB in real time.
-
Access Live SAS xpt Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAS XPORT from your Google Sheets.
-
Accessing Website Data Using ADO.NET
An article from iProgrammer explores accessing Web data through the CData Data Providers: Interacting with websites via the wide range of APIs that are on offer is attractive because it provides new possibilities but is slightly depressing because you have to find out how to do the job all over again for each API. Now there is a better way...
-
Connect to JSON in SpagoBI
Create reports featuring live JSON in SpagoBI Studio. Host JSON reports on SpagoBI Server.
-
Getting Started with the CData Tableau Connector for Box
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Box.
-
Connect to OneNote Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft OneNote in Airbyte.
-
Automated Continuous GetResponse Replication to MongoDB
Use CData Sync for automated, continuous, customizable GetResponse replication to MongoDB.
-
Replicate SAP HANA Data from PowerShell
Write a quick PowerShell script to query SAP HANA. Use connectivity to the live data to replicate SAP HANA to SQL Server.
-
How to Work with Epicor Kinetic Data in AWS Glue Jobs Using JDBC
Connect to Epicor Kinetic from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Databricks Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Databricks from Filemaker Pro on Mac.
-
Working with Parquet Data in LINQPad
Execute LINQ queries to Apache Parquet in LINQPad.
-
Operational Reporting on MailerSend Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote MailerSend.
-
Access Microsoft Exchange Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Microsoft Exchange.
-
Access Live Oracle Sales Data in TIBCO Data Virtualization
Use the Oracle Sales Tibco DV Adapter to create a Oracle Sales data source in TIBCO Data Virtualization Studio and gain access to live Oracle Sales from your TDV Server.
-
Use Dash to Build to Web Apps on ClickUp Data
Create Python applications that use pandas and Dash to build ClickUp-connected web apps.
-
Getting Started with the CData ADO.NET Provider for Azure Synapse
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Azure Synapse.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Stripe using the Model Context Protocol.
-
Query, Visualize, and Share live Zendesk Data in Redash
Use CData Connect AI to connect to live Zendesk in Redash for querying, visualizing, and sharing.
-
Integrate Theia IDE with Live NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Automate Omnisend Data Replication to SAP HANA
Use CData Sync to customize and automate Omnisend replication to SAP HANA.
-
Connect to ZohoMarketingHub Data in DBArtisan
Use wizards in DBArtisan to configure ZohoMarketingHub as a data source.
-
How to Visualize Auth0 Data in Python with pandas
Use pandas and other modules to analyze and visualize live Auth0 in Python.
-
Query Workable Data in ColdFusion
Write standard ColdFusion data access code to connect to Workable.
-
Access Elasticsearch Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Elasticsearch from your Oracle system.
-
Automated Continuous ZohoSubscriptions Replication to Snowflake
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Snowflake.
-
Connect to Microsoft Entra ID Data in Aqua Data Studio
Access Microsoft Entra ID from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Work with SAP Fieldglass Data in AWS Glue Jobs Using JDBC
Connect to SAP Fieldglass from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build a Singer.io Tap for Nuclia With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Nuclia data using
-
Getting Started with the CData JDBC Driver for ZohoSubscriptions
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ZohoSubscriptions.
-
Import Real-Time Scrapfly Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Scrapfly in ColdFusion.
-
Replicate Greenplum Data in Heroku for Use in Salesforce Connect
Replicate Pivotal GreenPlum to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Getting Started with the CData ADO.NET Provider for Discord
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to SurveyMonkey Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SurveyMonkey from Filemaker Pro on Mac.
-
Build LinkedIn-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for LinkedIn to explore live LinkedIn Data in Cursor to assist with building LinkedIn-powered applications.
-
Connect to Redshift from a Connection Pool in WebLogic
Use the CData JDBC Driver for Redshift to connect to Amazon Redshift from Web applications running on WebLogic.
-
Connect to Azure Data Lake Storage Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Azure Data Lake Storage as an External Source in Dremio.
-
Visualize LinkedIn Data in TIBCO Spotfire through ADO.NET
Integrate LinkedIn into dashboards in TIBCO Spotfire.
-
How to Easily Query Dynamics 365 Data in OpenOffice Base
Connect to Dynamics 365 data in OpenOffice Base using the CData ODBC Driver for Dynamics 365 and generate reports with live data insights.
-
Create Data Visualizations in Cognos BI with Dotmailer Data
Access Dotmailer as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Getting Started with the CData ODBC Driver for Cohere
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Cohere.
-
Build a Simple VCL Application for Reckon Data
How to build a simple VCL Application to view Reckon in RAD Studio using the CData ODBC Driver for Reckon.
-
Create SSAS Tabular Models from HubDB Data
How to build a SQL Server Analysis Service Tabular Model from HubDB using CData drivers.
-
Create Dynamic Hugging Face Grids Using the Infragistics XamDataGrid
Learn how you can connect Hugging Face to Infragistics XamDataGrid to build dynamic grids.
-
Publish Rootly-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Rootly.
-
How to connect to Google Ads Data with Squirrel SQL client
Connect to Google Ads and execute queries in the Squirrel SQL Client.
-
How to connect SharePoint with Spark Data through external lists
Provide Apache Spark SQL to SharePoint users as an external list.
-
Build ActiveCampaign-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for ActiveCampaign to explore live ActiveCampaign Data in Claude Code to assist with building ActiveCampaign-powered applications.
-
Prepare, Blend, and Analyze Salesforce Pardot Data in Alteryx Designer (Connect AI)
Build workflows to access live Salesforce Pardot for self-service data analytics.
-
Natively Connect to Greenhouse Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Greenhouse. Leverage the native support for ODBC in PHP.
-
Import and Visualize Azure Data Lake Storage Data in Power View
Create data visualizations based on Azure Data Lake Storage in Excel.
-
Getting Started with the CData ADO.NET Provider for ConstantContact
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Connect to Live Box Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Box for you.
-
How to Query Live Greenplum Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Pivotal GreenPlum data in natural language using Python.
-
How to connect to Epicor Kinetic Data from IntelliJ
Integrate connectivity to Epicor Kinetic with wizards in IntelliJ.
-
Use Azure AI Foundry to Talk to Your GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your GitHub for you.