CData Software - Knowledge Base
Recent Articles
-
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 data.
-
How to connect to Outlook Data with Squirrel SQL client
Connect to Outlook data and execute queries in the Squirrel SQL Client.
-
DataBind Charts to Office 365 Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Office 365 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.
-
Use Microsoft Copilot Studio to talk to your GitHub 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 GitHub data for you.
-
Integrate Goose with Live Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Asana data from within the local AI agent.
-
Use CData Connect AI to Access Pinterest Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Pinterest data in the Power Pivot business intelligence tool.
-
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 data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query Spotify Data in ColdFusion
Write standard ColdFusion data access code to connect to Spotify data.
-
Create a Data Access Object for YouTube Analytics Data using JDBI
A brief overview of creating a SQL Object API for YouTube Analytics data in JDBI.
-
Automate ChartMogul Data Replication to SAP HANA
Use CData Sync to customize and automate ChartMogul data replication to SAP HANA.
-
Automate Insightly Data Replication to Couchbase
Use CData Sync to Customize and automate Insightly data replication to Couchbase.
-
Connect to MailerLite Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for MailerLite to connect to MailerLite data and execute queries in PowerBuilder.
-
Creating CouchDB-Connected Applications in Unqork
You can use CData Connect AI to feed CouchDB data 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.
-
Integrate Dify with Live Tally Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Tally data.
-
Analyze Oracle Sales Data in Looker
Use CData Connect AI to connect to Oracle Sales Data from Looker and build custom apps using live Oracle Sales data.
-
Connect to Pushbullet Data in Aqua Data Studio
Access Pushbullet data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Load Drip Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Drip data to a database.
-
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 data in real time.
-
Query Zoho CRM Data in ColdFusion
Write standard ColdFusion data access code to connect to Zoho CRM data.
-
Integrating GitHub Copilot with Paymo 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.
-
Connect to OneNote Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for OneNote data in Airbyte.
-
Replicate SAP HANA Data from PowerShell
Write a quick PowerShell script to query SAP HANA data. Use connectivity to the live data to replicate SAP HANA data 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 data from Filemaker Pro on Mac.
-
Working with Parquet Data in LINQPad
Execute LINQ queries to Parquet data in LINQPad.
-
Operational Reporting on MailerSend Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote MailerSend data.
-
Use Dash to Build to Web Apps on ClickUp Data
Create Python applications that use pandas and Dash to build ClickUp-connected web apps.
-
How to Visualize Twilio 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 Twilio data in Python.
-
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.
-
How to Visualize Discord 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 Discord data in Python.
-
Automated Act-On Data Replication to Teradata
Use CData Sync to Customize and automate Act-On data replication to Teradata.
-
Build a Singer.io Tap for HCL Domino With the CData Python Connector
Learn how to easily build a Singer.io Tap for live HCL Domino data using the CData Python Connector.
-
Integrate Live SAP Business One Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP Business One data and integrate live SAP Business One data into apps built in Microsoft Power Apps.
-
Use the CData ODBC Driver for Google Spanner in Microsoft Power Query
You can use the CData Google Spanner ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Spanner data into Microsoft Power Query.
-
Automated Continuous BambooHR Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable BambooHR replication to Amazon Redshift.
-
Connect to ZohoMarketingHub Data in DBArtisan
Use wizards in DBArtisan to configure ZohoMarketingHub data as a data source.
-
How to Visualize Auth0 Data in Python with pandas
Use pandas and other modules to analyze and visualize live Auth0 data in Python.
-
Query Workable Data in ColdFusion
Write standard ColdFusion data access code to connect to Workable data.
-
Access Elasticsearch Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Elasticsearch data 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 data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Google Calendar Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Calendar and the SQL Gateway to access Google Calendar data from Google Apps Script.
-
Create Dashboards and Visualize Live SAP Netweaver Gateway Data in Geckoboard
Use CData Connect AI to connect to live SAP Netweaver Gateway data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to TaxJar Data from AWS Glue
Use CData Connect AI to gain access to live TaxJar data from your AWS Glue jobs.
-
Replicate Greenplum Data in Heroku for Use in Salesforce Connect
Replicate Greenplum data 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.
-
Integrate Confluence Data in Pentaho Data Integration
Build ETL pipelines based on Confluence data in the Pentaho Data Integration tool.
-
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.
-
Getting Started with the CData ODBC Driver for Cohere
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Cohere.
-
Automated Continuous Tally Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Tally replication to Amazon Redshift.
-
Build a Simple VCL Application for Reckon Data
How to build a simple VCL Application to view Reckon data in RAD Studio using the CData ODBC Driver for Reckon.
-
Import ShipEngine Data Using Azure Data Factory
Use CData Connect AI to connect to ShipEngine Data from Azure Data Factory and import live ShipEngine data.
-
Create SSAS Tabular Models from HubDB Data
How to build a SQL Server Analysis Service Tabular Model from HubDB data using CData drivers.
-
Connect to Sentry 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 Sentry and work with Sentry data in your FileMaker application.
-
Build FreshBooks-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live FreshBooks data.
-
Integrating Boomi Agentstudio with Stripe Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Stripe data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Create Dynamic Hugging Face Grids Using the Infragistics XamDataGrid
Learn how you can connect Hugging Face to Infragistics XamDataGrid to build dynamic grids.
-
Create FreeAgent Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time FreeAgent data access from reports, embedded analytics, and more.
-
Build Dashboards with GetResponse Data in Dundas BI
Create dynamic dashboards and perform analytics based on GetResponse data in Dundas BI.
-
How to connect to Google Ads Data with Squirrel SQL client
Connect to Google Ads data and execute queries in the Squirrel SQL Client.
-
Automated Continuous Pushbullet Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Pushbullet replication to delimited files (CSV/TSV).
-
Automated Continuous Amazon Athena Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Google Cloud SQL.
-
How to update LDAP from Excel
This article explains how to transfer data from Excel to LDAP using the Excel Add-In for LDAP.
-
Connect to Pinterest from Asprova with CData Software ODBC Driver for Pinterest
This article shows how to connect faster to Pinterest data from Asprova.
-
Connecting Pipedream with Optimizely Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Optimizely data in real time.
-
Analyze Certinia Data in Looker
Use CData Connect AI to connect to Certinia Data from Looker and build custom apps using live Certinia data.
-
Import and Visualize Azure Data Lake Storage Data in Power View
Create data visualizations based on Azure Data Lake Storage data 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 data for you.
-
Write a Simple Go Application to work with Notion Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Notion data.
-
Build Data Flows from Todoist to SQL Server using SSIS
Easily back up Todoist data to SQL Server using the SSIS components for Todoist.
-
Automated Continuous Adobe Target Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Adobe Target replication to Amazon Redshift.
-
How to connect to Epicor Kinetic Data from IntelliJ
Integrate connectivity to Epicor Kinetic data with wizards in IntelliJ.
-
How to Connect PingOne 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 PingOne data in real time using natural language.
-
Connect to Google Campaign Manager 360 Data in CloverDX (formerly CloverETL)
Transfer Google Campaign Manager 360 data using the visual workflow in the CloverDX data integration tool.
-
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 data for you.
-
Query SAP Concur Data in ColdFusion
Write standard ColdFusion data access code to connect to SAP Concur data.
-
Replicate Google Calendar Data from PowerShell
Write a quick PowerShell script to query Google Calendar data. Use connectivity to the live data to replicate Google Calendar data to SQL Server.
-
Query Snowflake Data as a MySQL Database in Node.js
Execute MySQL queries against Snowflake data from Node.js.
-
Visualize Sendwithus Data in TIBCO Spotfire through ADO.NET
Integrate Sendwithus data into dashboards in TIBCO Spotfire.
-
Integrating GitHub Copilot with SageHR 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 Dataiku with DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live DB2 data.
-
How to Build an ETL App for JotForm Data in Python with CData
Create ETL applications and real-time data pipelines for JotForm data in Python with petl.
-
Getting Started with the CData Python Connector for SageHR
Learn to install and license the CData Python Connector and configure a connection to live SageHR data.
-
Connect and Visualize Live AfterShip Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live AfterShip data into the Databricks platform and create visualization dashboards with real-time AfterShip data.
-
How to Connect to Live MailChimp 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 MailChimp data for you.
-
AgileCRM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on AgileCRM facts in real time.
-
Connect to Live NetSuite Data in PostGresSQL Interface through CData Connect AI
Create a live connection to NetSuite in CData Connect AI and connect to your NetSuite data from PostgreSQL.
-
Automated Continuous Wave Financial Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Wave Financial data replication to OneLake in Microsoft Fabric.
-
Build Dashboards with MailerSend Data in DBxtra
Create dynamic dashboards and perform analytics based on MailerSend data in DBxtra.
-
Automated Continuous HDFS Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable HDFS replication to delimited files (CSV/TSV).
-
Automated Continuous Raisers Edge NXT Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Google Cloud SQL.
-
Build ZohoInvoice-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live ZohoInvoice data without replication.
-
Analyze Tally Data in Cognos Analytics
Use CData Connect AI to connect to Tally Data from Cognos Analytics and analyze live Tally data.
-
Object-Relational Mapping (ORM) with HCL Domino Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to HCL Domino data into a Java-based ORM framework, Hibernate.
-
Integrate Theia IDE with Live Oracle Sales 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 Oracle Sales data from within the development environment.
-
Use Manus AI to Talk to Your SAP Ariba Procurement 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 SAP Ariba Procurement data.
-
Import Real-Time Monday.com Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Monday.com data in ColdFusion.