CData Software - Knowledge Base
Recent Articles
-
DataBind Controls to Humanity Data in C++Builder
DataBind to Humanity data in C++Builder with standard components and controls.
-
Seamlessly Bring Amazon Athena Data into Retool Using CData Connect AI
Integrate Amazon Athena data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Use the CData Software JDBC Driver for Google Sheets in MicroStrategy Desktop
Connect to Google Sheets data in MicroStrategy Desktop using the CData Software JDBC Driver for Google Sheets.
-
Connect to MYOB AccountRight Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with MYOB AccountRight Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Analyze Live Instagram Data in SAS Viya
Use CData Connect AI to connect to Instagram data from SAS Viya and deploy self-service analytics using live Instagram data.
-
Use the CData Software JDBC Driver for Bright Data in MicroStrategy
Connect to Bright Data data in MicroStrategy Developer using the CData Software JDBC Driver for Bright Data.
-
Automated Continuous Microsoft Dataverse Replication to SingleStore
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to SingleStore.
-
Use Claude to Talk to Your eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your eBay data for you.
-
Import Real-Time Amazon S3 Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Amazon S3 data in ColdFusion.
-
ETL BenchmarkEmail in Oracle Data Integrator
This article shows how to transfer BenchmarkEmail data into a data warehouse using Oracle Data Integrator.
-
Analyze Live Sybase IQ Data in SAS Viya
Use CData Connect AI to connect to Sybase IQ data from SAS Viya and deploy self-service analytics using live Sybase IQ data.
-
Access Live FreshBooks Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate FreshBooks data into the statistical analysis tools available in SAS JMP. This article shows how to use FreshBooks data in the Graph Builder and Query Builder.
-
Build VWO-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live VWO data.
-
Integrate with Live Airtable Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Airtable from the MuleSoft Anypoint Platform to integrate live Airtable data into custom reports and dashboards.
-
Automated Continuous SAP Ariba Source Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Azure SQL Database.
-
Build AI/ML Models with Live ZohoExpense Data using Dataiku
Connect ZohoExpense Data with Dataiku using the CData API Driver for JDBC.
-
Query HelloSign Data as a MySQL Database in Node.js
Execute MySQL queries against HelloSign data from Node.js.
-
Connect to Cvent from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Cvent data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to work with Procore Data in Apache Spark using SQL
Access and process Procore Data in Apache Spark using the CData Software JDBC Driver.
-
Connect Instagram to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Instagram with IBM WebSphere for seamless data integration and connectivity.
-
How to use SQLAlchemy ORM to access Stripe Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Stripe data.
-
Automated Continuous ZeroBounce Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ZeroBounce replication to AlloyDB.
-
Automated Continuous Instantly Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Instantly replication to Google Cloud SQL.
-
Integrate Live Dynamics CRM Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Dynamics CRM data to Blue Prism using the CData ODBC Driver for Dynamics CRM to create automated workflows for repetitive business tasks.
-
Integrating Kiro with Azure Analysis Services 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 Dynamics NAV Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Dynamics NAV data.
-
Build Oracle Eloqua Reporting-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Oracle Eloqua Reporting data and build web apps with connectivity to live Oracle Eloqua Reporting data.
-
Rapidly Develop Landbot-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Landbot.
-
Connect LightSpeedRetail to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live LightSpeedRetail data using the CData Python MCP Server.
-
Working with RabbitMQ Data in LINQPad
Execute LINQ queries to RabbitMQ data in LINQPad.
-
Automated Continuous Stack Exchange Replication to Databricks
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Databricks.
-
Integrating Kiro with Nethunt 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.
-
Create Informatica Mappings From/To a JDBC Data Source for Confluence
Create Confluence data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Xero Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Xero data.
-
Automated Zoho CRM Data Replication to Teradata
Use CData Sync to Customize and automate Zoho CRM data replication to Teradata.
-
Integrate REST with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate REST with External Services.
-
Automated Continuous ZohoPeople Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ZohoPeople replication to IBM DB2.
-
DataBind Charts to MailerSend Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to MailerSend 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.
-
Design BIRT Reports on Invoiced Data
Provide current Invoiced data to your embedded analytics.
-
Integrate Shopify Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Shopify data from Informatica Cloud.
-
Integrating MongoDB Data in Talend Cloud Data Management Platform
Connect MongoDB Data with Talend Cloud Data Management Platform using the CData JDBC Driver for MongoDB.
-
Automated Continuous Onfleet Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Onfleet replication to Amazon S3.
-
Connect to and Visualize Live Zoho Recruit Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Zoho Recruit data.
-
Connect to ScrapingBee Data in CloverDX (formerly CloverETL)
Transfer ScrapingBee data using the visual workflow in the CloverDX data integration tool.
-
Connect to GetResponse Data in JRuby
Create a simple JRuby app with access to live GetResponse data.
-
Integrating Kiro 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 Codex with Humanity 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.
-
Reckon Accounts Hosted Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Reckon Accounts Hosted facts in real time.
-
Create Power BI Reports on Real-Time ADP Data
Use the CData ODBC Driver for ADP to visualize ADP data in Power BI Desktop.
-
Automate Salesforce Pardot Data Replication to Couchbase
Use CData Sync to Customize and automate Salesforce Pardot data replication to Couchbase.
-
Natively Connect to Retently Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Retently data. Leverage the native support for ODBC in PHP.
-
A PostgreSQL Interface for iContact Data using the CData ODBC Driver
Use the SQL Gateway and iContact ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Dashboards with CockroachDB Data in DBxtra
Create dynamic dashboards and perform analytics based on CockroachDB data in DBxtra.
-
Query SurveyMonkey Data in ColdFusion
Write standard ColdFusion data access code to connect to SurveyMonkey data.
-
Connect to Amazon DynamoDB Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Amazon DynamoDB data in Airbyte.
-
Build a Simple VCL Application for Sugar CRM Data
How to build a simple VCL Application to view Sugar CRM data in RAD Studio using the CData ODBC Driver for Sugar CRM.
-
Connect to Aha! Data in RapidMiner
Integrate Aha! data with standard components and data source configuration wizards in RapidMiner Studio.
-
Build an OLAP Cube in SSAS from ZendeskSell Data
Establish a connection to ZendeskSell data data from SQL Server Analysis Services, and use the ZendeskSell Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create PDFMonkey Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time PDFMonkey data access from reports, embedded analytics, and more.
-
Connect to ScrapingBee Data in NetBeans
Connect to ScrapingBee data in NetBeans with the data source configuration wizard.
-
Automated Continuous Coinbase Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Coinbase replication to IBM DB2.
-
Connect to SQL Server Data in DBeaver
Use the CData ODBC Driver to connect to SQL Server data in DBeaver.
-
Access Microsoft Teams Data from MySQL in Amazon QuickSight
Connect to Microsoft Teams and build visualizations of Microsoft Teams data using a MySQL Connection in Amazon QuickSight.
-
Access Live Redshift Data in TIBCO Data Virtualization
Use the Redshift Tibco DV Adapter to create a Redshift data data source in TIBCO Data Virtualization Studio and gain access to live Redshift data from your TDV Server.
-
Import SharePoint Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SharePoint Data and provide access to live SharePoint data for custom reports in the Power BI Service.
-
Automated Continuous Front Replication to Snowflake
Use CData Sync for automated, continuous, customizable Front replication to Snowflake.
-
Build Dashboards with JSON Services in DBxtra
Create dynamic dashboards and perform analytics based on JSON services in DBxtra.
-
Trigger NetSuite IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for NetSuite with standard wizards in Logic Apps.
-
Integrating Dataiku with Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Bullhorn CRM data.
-
Consume Adobe Target OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Adobe Target feeds that reflect any changes in SAP Lumira.
-
Integrating LangGraph with Attio Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Attio data within automated workflows.
-
Use the CData Software JDBC Driver for Bugsnag in MicroStrategy Desktop
Connect to Bugsnag data in MicroStrategy Desktop using the CData Software JDBC Driver for Bugsnag.
-
Connect and Visualize Live Azure Data Lake Storage Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Azure Data Lake Storage data into the Databricks platform and create visualization dashboards with real-time Azure Data Lake Storage data.
-
Object-Relational Mapping (ORM) with Insightly 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 Insightly data into a Java-based ORM framework, Hibernate.
-
Connect to Google Directory Data from AWS Glue
Use CData Connect AI to gain access to live Google Directory data from your AWS Glue jobs.
-
Connect to ZohoExpense Data in CloverDX (formerly CloverETL)
Transfer ZohoExpense data using the visual workflow in the CloverDX data integration tool.
-
Connect to Yelp 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 Yelp and work with Yelp data in your FileMaker application.
-
Connect to ConstantContact Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to ConstantContact.
-
Replicate Webflow Data to Multiple Databases
Replicate Webflow data to disparate databases with a point-and-click configuration.
-
How to Access Live Mailgun Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Mailgun enables you to integrate Mailgun data into workflows built using Microsoft Power Automate Desktop.
-
Connect to SAS xpt Data in DBeaver
Use the CData ODBC Driver to connect to SAS xpt data in DBeaver.
-
Create Reports from Toggl Data in Looker Studio
Use CData Connect AI to gain access to live Toggl data and create custom reports in Looker Studio.
-
Integrate Open WebUI with Live BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live BigCommerce data from within the chat interface.
-
Process & Analyze Mistral AI Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Mistral AI Data.
-
Getting Started with the CData Connect AI Python SDK for Redis
Install the CData Connect AI Python SDK to read and write live Redis data with standard DB-API 2.0 Python code.
-
How to Connect Sage Cloud Accounting 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 Sage Cloud Accounting data in real time using natural language.
-
Automated Continuous Zoom Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Zoom data replication to OneLake in Microsoft Fabric.
-
Access Presto Data from MySQL in PHP
Connect to Presto through the standard MySQL libraries in PHP.
-
Automate eBay Data Replication to SAP HANA
Use CData Sync to customize and automate eBay data replication to SAP HANA.
-
Connect to Airtable from Asprova with CData Software ODBC Driver for Airtable
This article shows how to connect faster to Airtable data from Asprova.
-
Integrate LibreChat with Live Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Epicor Kinetic data from within the chat interface.
-
How to load Oracle Eloqua data into Elasticsearch via Logstash
Introducing a simple method to load Oracle Eloqua data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Work with Lakebase Data in ETL Validator JDBC
Connect to Lakebase from ETL Validator jobs using the CData Software JDBC Driver.
-
Query Live RSS Feeds 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 RSS feeds directly from the development environment.
-
Create Apps from ZohoSubscriptions Data in Qlik Sense Cloud
Use CData Connect AI to connect to ZohoSubscriptions Data and build apps from live ZohoSubscriptions data in Qlik Sense Cloud.
-
Create SSAS Tabular Models from Helpscout Data
How to build a SQL Server Analysis Service Tabular Model from Helpscout data using CData drivers.
-
Connect Jumpseller to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Jumpseller data using the CData Python MCP Server.
-
How to create an RPA flow for Harvest Data in UiPath Studio
Use the Harvest ODBC Driver to create workflows that access real-time Harvest data without any coding.
-
How to Visualize Perplexity 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 Perplexity data in Python.
-
Automated Continuous Harvest Replication to SQLite
Use CData Sync for automated, continuous, customizable Harvest replication to SQLite.