CData Software - Knowledge Base
Recent Articles
-
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.
-
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 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.
-
Automated Act-On Data Replication to Teradata
Use CData Sync to Customize and automate Act-On 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
-
Integrate Live SAP Business One Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP Business One and integrate live SAP Business One 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 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 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.
-
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 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 and create dashboards for real-time monitoring and visualization in Geckoboard.
-
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.
-
How to Query Live BigCommerce Data in Claude Desktop
Connect to and query live BigCommerce Data in Claude Desktop using CData MCP Server.
-
Integrate Confluence Data in Pentaho Data Integration
Build ETL pipelines based on Atlassian Confluence 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.
-
Import QuickBooks Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access QuickBooks Desktop. In this article, you will use the OData format to import QuickBooks Desktop into Microsoft Power Query.
-
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 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.
-
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 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.
-
Integrating Boomi Agentstudio with Stripe Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Stripe, 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 in Dundas BI.
-
How to connect to Google Ads Data with Squirrel SQL client
Connect to Google Ads and execute queries in the Squirrel SQL Client.
-
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.
-
Analyze Certinia Data in Looker
Use CData Connect AI to connect to Certinia Data from Looker and build custom apps using live Certinia.
-
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.
-
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.
-
Build Data Flows from Todoist to SQL Server using SSIS
Easily back up Todoist 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 with wizards in IntelliJ.
-
Connect to Google Campaign Manager 360 Data in CloverDX (formerly CloverETL)
Transfer Google Campaign Manager 360 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 for you.
-
Query SAP Concur Data in ColdFusion
Write standard ColdFusion data access code to connect to SAP Concur.
-
Edit and Search Dynamics 365 Business Central External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Dynamics 365 Business Central to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Dynamics 365 Business Central objects that you can access from apps and the dashboard.
-
Replicate Google Calendar Data from PowerShell
Write a quick PowerShell script to query Google Calendar. Use connectivity to the live data to replicate Google Calendar to SQL Server.
-
Query Snowflake Data as a MySQL Database in Node.js
Execute MySQL queries against Snowflake from Node.js.
-
Visualize Sendwithus Data in TIBCO Spotfire through ADO.NET
Integrate Sendwithus into dashboards in TIBCO Spotfire.
-
Integrating GitHub Copilot CLI with SageHR 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 IBM DB2.
-
How to Build an ETL App for JotForm Data in Python with CData
Create ETL applications and real-time data pipelines for JotForm in Python with petl.
-
Getting Started with the CData Python Connector for SageHR
Learn to install and license the CData Python Connector
-
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 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 CRM & ERP from PostgreSQL.
-
Automated Continuous Wave Financial Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Wave Financial replication to OneLake in Microsoft Fabric.
-
Build Dashboards with MailerSend Data in DBxtra
Create dynamic dashboards and perform analytics based on MailerSend 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.
-
Analyze Tally Data in Cognos Analytics
Use CData Connect AI to connect to Tally Data from Cognos Analytics and analyze live Tally ERP.
-
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 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
-
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.
-
Connect Delighted to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Delighted with IBM WebSphere for seamless data integration and connectivity.
-
Import Real-Time Monday.com Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Monday.com in ColdFusion.
-
Connect to Salesforce CRM Analytics Data from a Connection Pool in JBoss
Integrate Salesforce CRM Analytics into Java servlets: Use the Management Console in JBoss to install the Salesforce CRM Analytics JDBC Driver.
-
ETL Zuora in Oracle Data Integrator
This article shows how to transfer Zuora into a data warehouse using Oracle Data Integrator.
-
Use the CData ODBC Driver for PDFMonkey in Microsoft Power Query
You can use the CData PDFMonkey ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import PDFMonkey into Microsoft Power Query.
-
Connecting Pipedream with Neo4J 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 Neo4J data in real time.
-
Access Live GraphQL Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live GraphQL from your Excel spreadsheets.
-
Import and Visualize Browserless Data in Power View
Create data visualizations based on Browserless in Excel.
-
How to Connect to Live YouTube Analytics Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your YouTube Analytics for you.
-
Connect to GraphQL Data in DBeaver
Use the CData ODBC Driver to connect to GraphQL in DBeaver.
-
Build Azure Synapse-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Azure Synapse.
-
Replicate Odoo Data from PowerShell
Write a quick PowerShell script to query Odoo ERP. Use connectivity to the live data to replicate Odoo ERP to SQL Server.
-
Getting Started with the CData Tableau Connector for Yelp
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to Dropbox Data in NetBeans
Connect to Dropbox in NetBeans with the data source configuration wizard.
-
Automate Power BI XMLA Data Replication to Azure Synapse
Use CData Sync to customize and automate Power BI XMLA replication to Azure Synapse.
-
How to create an RPA flow for Pinterest Data in UiPath Studio
Use the Pinterest ODBC Driver to create workflows that access real-time Pinterest without any coding.
-
Access MongoDB Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live MongoDB from HeidiSQL.
-
Import Cvent Data Using Azure Data Factory
Use CData Connect AI to connect to Cvent Data from Azure Data Factory and import live Cvent.
-
Use the CData Software JDBC Driver for Bannerbear in MicroStrategy
Connect to Bannerbear in MicroStrategy Developer using the CData Software JDBC Driver for Bannerbear.
-
Automate SAP HANA Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP HANA and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build Charts with PivotalTracker Data in Clear Analytics
Create dynamic charts and perform analytics based on PivotalTracker in Clear Analytics.
-
How to connect and process MailerSend from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live MailerSend.
-
Integrating Dataiku with SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP Netweaver Gateway.
-
Query Cloudflare Data in DataGrip
Create a Data Source for Cloudflare in DataGrip and use SQL to query live Cloudflare.
-
Connecting GenSpark with Exact Online Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Exact Online without any replication or custom integration required.
-
Use Biml to Build SSIS Tasks to Replicate Tally Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Tally ERP to SQL Server.
-
Object-Relational Mapping (ORM) with QuickBooks Time 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 QuickBooks Time into a Java-based ORM framework, Hibernate.
-
Extend Google Sheets with SAP SuccessFactors Data
Make calls to SAP SuccessFactors from Google Apps Script via the API Server.
-
Create Data Visualizations in Cognos BI with OpenWeatherMap Data
Access OpenWeatherMap as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.