CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Zoho Inventory Replication to Snowflake
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to Snowflake.
-
Integrate Live ActiveCampaign Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ActiveCampaign data to Blue Prism using the CData ODBC Driver for ActiveCampaign to create automated workflows for repetitive business tasks.
-
Create NetSuite-Connected Nintex Workflows
Use CData Connect AI to connect to NetSuite Data from Nintex Workflow Cloud and build custom workflows using live NetSuite data.
-
Integrate Live Azure Data Lake Storage Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Azure Data Lake Storage data from within the IDE.
-
How to Access Live Invoiced Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Invoiced enables you to integrate Invoiced data into workflows built using Microsoft Power Automate Desktop.
-
How to Visualize Azure Data Lake Storage 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 Azure Data Lake Storage data in Python.
-
Automated Continuous Google Ad Manager Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to MySQL.
-
Query Neo4J Data as a MySQL Database in Node.js
Execute MySQL queries against Neo4J data from Node.js.
-
Analyze Box Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Box data in Microsoft R Open.
-
Analyze CSV Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze CSV data with the CData JDBC Driver for CSV.
-
Connect to Zoom Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Zoom Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connecting GenSpark with Apify Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Apify data without any replication or custom integration required.
-
Connect to SuiteCRM Data in DBArtisan
Use wizards in DBArtisan to configure SuiteCRM data as a data source.
-
Visualize Live SendPulse Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SendPulse data into custom reports in Power BI.
-
Viewing Dynamics 365 Data in RAD Studio Data Explorer
How to view Dynamics 365 data in RAD Studio Data Explorer using the CData ODBC Driver for Dynamics 365.
-
Use the CData ODBC Driver for Office 365 from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Office 365 to connect to Office 365 data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Office 365 data in Excel.
-
Integrating LangGraph with HubSpot Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on HubSpot data within automated workflows.
-
Connect Jumpseller to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Jumpseller with IBM WebSphere for seamless data integration and connectivity.
-
How to Create Power BI Visual Reports with Real-Time Oracle SCM Data
Use CData Power BI Connectors to visualize Oracle SCM data in Power BI.
-
Getting Started with the CData SSIS Components for Mode
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Mode.
-
Connect to SFTP Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SFTP and the SQL Gateway to access SFTP data from Google Apps Script.
-
Use the CData ODBC Driver for Teamwork in Microsoft Power Query
You can use the CData Teamwork ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Teamwork data into Microsoft Power Query.
-
Object-Relational Mapping (ORM) with Qualaroo 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 Qualaroo data into a Java-based ORM framework, Hibernate.
-
How to publish and share Dotmailer Data dashboards with Tableau Server
The CData ODBC driver for Dotmailer enables you integrate Dotmailer data into Tableau dashboards.
-
How to Connect Flowise AI Agents to Live Presto Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Presto data without replication.
-
Prepare, Blend, and Analyze Instagram Data in Alteryx Designer (ODBC)
Build workflows to access live Instagram data for self-service data analytics.
-
Integrate SAP HANA XS Advanced with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP HANA XS Advanced with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP HANA XS Advanced data.
-
Process & Analyze Hive Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Hive Data.
-
Interact with Live Gong Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Gong data.
-
Visualize eBay Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to eBay data.
-
Visualize Salesforce CRM Analytics Data in Tableau
The CData ODBC driver for Salesforce CRM Analytics enables you integrate Salesforce CRM Analytics data into Tableau dashboards.
-
Create Mailgun-Connected Business Apps in AppSheet
Connect to Mailgun Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Mailgun data.
-
Automated Continuous SurveyMonkey Replication to Snowflake
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Snowflake.
-
Connect to Avro Data from Crystal Reports
Use CData Connect AI to connect to and report on live Avro data from Crystal Reports.
-
Model, Search, and Visualize Live SAS Data Sets Data in ThoughtSpot
Use CData Connect AI to connect to live SAS Data Sets data for modeling, searching, and visualizing.
-
Process & Analyze Webflow Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Webflow Data.
-
Automated Continuous IBM Informix Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable IBM Informix replication to Amazon Redshift.
-
Automated Continuous Jodoo Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Jodoo replication to delimited files (CSV/TSV).
-
How to Connect Spark 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 Spark data in real time using natural language.
-
Use JayDeBeApi to access Scrapfly Data in Python
Use standard Python scripting and the development environment of your choice to access live Scrapfly data.
-
Create Informatica Mappings From/To an ODBC Data Source for ShipEngine
Create an ODBC connection to ShipEngine in Informatica and browse and transfer ShipEngine data.
-
Integrating Boomi Agentstudio with Salesforce CRM Analytics Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Salesforce CRM Analytics data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use the CData Software JDBC Driver for SuiteCRM in MicroStrategy Web
Connect to SuiteCRM data in MicroStrategy Web using the CData Software JDBC Driver for SuiteCRM.
-
Create a Data Access Object for MessageBird Data using JDBI
A brief overview of creating a SQL Object API for MessageBird data in JDBI.
-
Process & Analyze Stack Exchange Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Stack Exchange Data.
-
Build Notion-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Notion data and build web apps with connectivity to live Notion data.
-
Integrating Cursor with Greenplum 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 Boomi Agentstudio with Mode Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Mode data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
DataBind Charts to FTP Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to FTP 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.
-
Integrate with Sybase Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Sybase data to a JSON file on disk.
-
Use the CData ODBC Driver for ScrapingBee in Microsoft Power Query
You can use the CData ScrapingBee ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ScrapingBee data into Microsoft Power Query.
-
Analyze Invoiced Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Invoiced from Power Pivot. You will use the Table Import Wizard to load Invoiced data. You can visually build the import query or use any SQL supported by the driver.
-
Access Live Pinecone Data in AWS Lambda
Connect to live Pinecone data in AWS Lambda using the CData JDBC Driver.
-
How to integrate Metabase with Freshteam Data
Use CData Connect AI to connect to live Freshteam data and create an interactive dashboard in Metabase from Freshteam data.
-
Automated Continuous ZohoSubscriptions Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Amazon Redshift.
-
Natively Connect to Basecamp Data in PHP
The CData ODBC driver for Basecamp enables you to create PHP applications with connectivity to Basecamp data. Leverage the native support for ODBC in PHP.
-
Connect to Google Directory Data in DBeaver
Use the CData ODBC Driver to connect to Google Directory data in DBeaver.
-
Bridge DB2 Connectivity with Apache NiFi
Access and process DB2 data in Apache NiFi using the CData JDBC Driver.
-
How to Access Smartsheet Data Using Entity Framework
This article shows how to access Smartsheet data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build AI/ML Models with Live eBay Data using Dataiku
Connect eBay Data with Dataiku using the CData JDBC Driver for eBay.
-
Publish Unbounce-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Unbounce data.
-
Integrating Kiro with Testmonitor 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 Azure AI Foundry to Talk to Your SharePoint 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 SharePoint data for you.
-
Connect to LDAP Objects from HeidiSQL
Use CData Connect AI to connect to and query live LDAP objects from HeidiSQL.
-
Build Google Cloud Storage-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Cloud Storage Data from Zoho Analytics and import live Google Cloud Storage data.
-
Visualize Neo4J Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Neo4J data into TIBCO Spotfire.
-
How to Query Live Cassandra Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Cassandra data data in natural language using Python.
-
Visualize Live SAP Ariba Source Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP Ariba Source data.
-
SAP: How to Install a Custom Read Table RFC Function Module
In this entry, you will find the steps how to install the Z_CUSTOM_READ_TABLE function module
-
A PostgreSQL Interface for eBay Data using the CData ODBC Driver
Use the SQL Gateway and eBay ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use Agno to Talk to Your QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your QuickBooks Time data for you.
-
Create a Data Access Object for Sybase IQ Data using JDBI
A brief overview of creating a SQL Object API for Sybase IQ data in JDBI.
-
Use ChatGPT to Talk to Your Sendwithus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Sendwithus data for you.
-
Getting Started with the CData ODBC Driver for Certinia
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Certinia.
-
Integrate with OnePageCrm Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy OnePageCrm data to a JSON file on disk.
-
Automated Continuous Typeform Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Typeform replication to AlloyDB.
-
Connect to Live PayPal Data in PostGresSQL Interface through CData Connect AI
Create a live connection to PayPal in CData Connect AI and connect to your PayPal data from PostgreSQL.
-
Connect to Clockify Data in HULFT Integrate
Connect to Clockify as a JDBC data source in HULFT Integrate
-
Getting Started with the CData JDBC Driver for SAP HANA XS Advanced
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP HANA XS Advanced.
-
Visualize Live SendInBlue Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SendInBlue data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Link ClickUp with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ClickUp data in Filemaker Pro for Mac or Windows.
-
Automated Continuous ZendeskSell Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ZendeskSell replication to Google Cloud SQL.
-
How to Connect the Power BI Service to Freshsales: Complete Guide
Connect to the CData Software Power BI Connector for Freshsales from PowerBI.com to provide real-time Freshsales data across the organization.
-
Object-Relational Mapping (ORM) with GetResponse 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 GetResponse data into a Java-based ORM framework, Hibernate.
-
Creating Oracle Service Cloud-Connected Applications in Unqork
You can use CData Connect AI to feed Oracle Service Cloud data to Unqork and build custom business apps.
-
Integrate Cursor with Live Odoo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Odoo data from within the editor.
-
Getting Started with the CData Power BI Connector for LDAP
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for LDAP.
-
Work with SparkPost Data in FoxPro
Load SparkPost data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Dashboards with Epicor Kinetic Data in Dundas BI
Create dynamic dashboards and perform analytics based on Epicor Kinetic data in Dundas BI.
-
Integrating GitHub Copilot with SAP BusinessObjects BI 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 Access Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Access data.
-
Work with MongoDB Data in FoxPro
Load MongoDB data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Dashboards with Coinbase Data in DBxtra
Create dynamic dashboards and perform analytics based on Coinbase data in DBxtra.
-
Connect to SAP Hybris C4C Data in Ruby
Connect to SAP Hybris C4C data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Billsby Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Billsby data in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Google Campaign Manager 360 Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to AlloyDB.
-
Connect to FormSite Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to FormSite and work with FormSite data in your FileMaker applications.
-
Manage Vercel Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Vercel.
-
Migrating data from Clari to Google BigQuery using CData SSIS Components.
Easily push Clari data to Google BigQuery using the CData SSIS Tasks for Clari and Google BigQuery.
-
Use Biml to Build SSIS Tasks to Replicate SAP BusinessObjects BI Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP BusinessObjects BI data to SQL Server.