CData Software - Knowledge Base
Recent Articles
-
Natively Connect to Insightly Data in PHP
The CData ODBC driver for Insightly enables you to create PHP applications with connectivity to Insightly data. Leverage the native support for ODBC in PHP.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Anaplan
Provide connectivity to Anaplan data through an SAP BusinessObjects universe.
-
Work with Live VWO Data in Power Query
Use CData Connect AI to connect to VWO data and work with live VWO data in Microsoft Power Query.
-
Integrate Cursor with Live Mode Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Mode data from within the editor.
-
Access Redis Data from MySQL in PHP
Connect to Redis through the standard MySQL libraries in PHP.
-
DataBind FTP Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for FTP with the DevExpress Windows Forms and Web controls to provide FTP data to a chart.
-
Connect to Live Microsoft Planner Data in MicroStrategy through CData Connect AI
Create a live connection to Microsoft Planner Data in CData Connect AI and connect to your Microsoft Planner data from MicroStrategy.
-
Connect to Live Google Search Results in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Search in CData Connect AI and connect to your Google Search results from PostgreSQL.
-
Validate Facebook Ads Data with QuerySurge
Access and validate Facebook Ads data in QuerySurge using the CData JDBC Driver.
-
Connect to Dynamics 365 Data in NetBeans
Connect to Dynamics 365 data in NetBeans with the data source configuration wizard.
-
Create Google Forms Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Forms data access from reports, embedded analytics, and more.
-
Easily Integrate Microsoft Dataverse Data in Lazarus Pascal IDE
Learn how to easily integrate live Microsoft Dataverse data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connecting Agentforce with Salesforce CRM Analytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Salesforce CRM Analytics data for you.
-
Migrating data from Cloudflare to Databricks using CData SSIS Components.
Easily push Cloudflare data to Databricks using the CData SSIS Tasks for Cloudflare and Databricks.
-
How to Connect to Live SFTP Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your SFTP data for you.
-
Integrate Google's Antigravity Agent with Live Freshteam Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Freshteam data using the Model Context Protocol.
-
Build NetSuite Visualizations in Tableau Cloud
Use CData Connect AI to connect to live NetSuite data and build visualizations in Tableau Cloud.
-
Add Freshsales Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Freshsales with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Webex Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Webex.
-
Create a Data Access Object for Avro Data using JDBI
A brief overview of creating a SQL Object API for Avro data in JDBI.
-
Connect to ChargeOver from a Connection Pool in WebLogic
Use the CData JDBC Driver for ChargeOver to connect to ChargeOver data from Web applications running on WebLogic.
-
Integrate Deel Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Deel data from Informatica Cloud.
-
Automated Continuous Oracle Eloqua Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Azure SQL Database.
-
Build SQL Analysis Services-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SQL Analysis Services Data from Zoho Analytics and import live SQL Analysis Services data.
-
Use Microsoft Copilot Studio to talk to your Bullhorn CRM 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 Bullhorn CRM data for you.
-
Work with Slack Data in FoxPro
Load Slack data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect to Live ZohoInvoice Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your ZohoInvoice data for you.
-
Connect to Exact Online Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Exact Online Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Replicate SAS xpt Data to Multiple Databases
Replicate SAS xpt data to disparate databases with a point-and-click configuration.
-
Connect to AlloyDB Data in Google Apps Script via Connect AI
Use CData Connect AI to access AlloyDB data in Google Apps Script.
-
Connect to Redshift Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Redshift data.
-
Automated Continuous Pinterest Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Pinterest replication to Apache Cassandra.
-
Automated Continuous SingleStore Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SingleStore replication to Apache Cassandra.
-
Integrate Live Yelp Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Yelp data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build AI/ML Models with Live Neo4J Data using Dataiku
Connect Neo4J Data with Dataiku using the CData JDBC Driver for Neo4J.
-
Natively Connect to ShipEngine Data in PHP
The CData ODBC driver for ShipEngine enables you to create PHP applications with connectivity to ShipEngine data. Leverage the native support for ODBC in PHP.
-
How to Query Live Outreach.io Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Outreach.io data data in natural language using Python.
-
How to Access Live BigCommerce Data in Power Automate Desktop via ODBC
The CData ODBC Driver for BigCommerce enables you to integrate BigCommerce data into workflows built using Microsoft Power Automate Desktop.
-
Easily Integrate SAP Hybris C4C Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP Hybris C4C data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to and Visualize Live Tavily Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Tavily data.
-
Validate Parallel Data with QuerySurge
Access and validate Parallel data in QuerySurge using the CData JDBC Driver.
-
Connecting GenSpark with Authorize.Net Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Authorize.Net data without any replication or custom integration required.
-
Integrate Google's Vertex AI Agent with Live ServiceDesk Plus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live ServiceDesk Plus data within intelligent workflows.
-
Using the CData Software ODBC Driver for OnePageCrm in PyCharm
Connect to OnePageCrm as an ODBC data source in PyCharm using the CData Software ODBC Driver for OnePageCrm.
-
Replicate Multiple Epicor Kinetic Accounts
Replicate multiple Epicor Kinetic accounts to one or many databases.
-
Reply.io Reporting in OBIEE with the Reply.io JDBC Driver
Deploy the Reply.io JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate Live iContact Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to iContact from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live iContact data.
-
Building Dynamic Web Pages with Sybase Data Using AngularJS
Create single-page applications with live connectivity to Sybase using the CData API Server.
-
Create Power BI Reports on Real-Time Couchbase Data
Use the CData ODBC Driver for Couchbase to visualize Couchbase data in Power BI Desktop.
-
Import Real-Time GetResponse Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use GetResponse data in ColdFusion.
-
Automated Continuous Active Directory Replication to Snowflake
Use CData Sync for automated, continuous, customizable Active Directory replication to Snowflake.
-
Integrate Live Act CRM 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 Act CRM data from within the IDE.
-
Visualize HDFS Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to HDFS data.
-
Back Up Rebilly data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Rebilly data data.
-
Automated Continuous Oracle Eloqua Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Apache Cassandra.
-
Migrating data from Mailjet to Snowflake using CData SSIS Components.
Easily push Mailjet data to Snowflake using the CData SSIS Tasks for Mailjet and Snowflake.
-
Query Vimeo Data as a MySQL Database in Node.js
Execute MySQL queries against Vimeo data from Node.js.
-
Visualize Live Instagram Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Instagram data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Gumloop with ShipStation Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on ShipStation data within automated workflows.
-
How to Visualize ScrapingBee Data in Python with pandas
Use pandas and other modules to analyze and visualize live ScrapingBee data in Python.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Azure DevOps
Provide connectivity to Azure DevOps data through an SAP BusinessObjects universe.
-
Create Salesforce Data 360-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Salesforce Data 360 Data from OutSystems and build custom enterprise apps using live Salesforce Data 360 data.
-
Moving Data from Optimizely to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Optimizely data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate SFTP Data into Power Automate Desktop using CData Connect
CData Connect for SFTP Data enables you to integrate SFTP data into workflows built using Microsoft Power Automate Desktop.
-
Analyze Act-On Data in Cognos Analytics
Use CData Connect AI to connect to Act-On Data from Cognos Analytics and analyze live Act-On data.
-
Create Onfleet Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Onfleet data access from reports, embedded analytics, and more.
-
Automated ClickTime Data Replication to Teradata
Use CData Sync to Customize and automate ClickTime data replication to Teradata.
-
Use the CData SSIS Components to Insert New or Update Existing IBM Informix Records from SQL Server
Easily push SQL Server data to IBM Informix using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into IBM Informix or update existing records with data from a SQL Server database.
-
Use ChatGPT to Talk to Your Asana 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 Asana data for you.
-
Add SparkPost Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SparkPost with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build MVC Applications with Connectivity to Procore Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Procore from an ASP.NET MVC application.
-
Publish Jira-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Jira data.
-
Connect to Oracle Data in Ruby
Connect to Oracle data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Extract, Transform, and Load ChartMogul Data in Informatica PowerCenter
Create a simple Workflow for ChartMogul data in Informatica PowerCenter.
-
Automated Continuous ZohoMarketingHub Replication to Vertica
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to Vertica.
-
Integrating LangChain with OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on OData services within automated workflows.
-
View Reports on Real-Time Instagram Data in Power BI Report Server
Use the CData ODBC Driver for Instagram to visualize Instagram data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect DBeaver to Recurly via a JDBC Driver
Manage Recurly data with visual tools in DBeaver like the query browser.
-
How to Easily Query Coinbase Data in OpenOffice Base
Connect to Coinbase data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate Dify with Live Amazon S3 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 Amazon S3 data.
-
Automated Continuous Outlook Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Outlook replication to Amazon Redshift.
-
Integrate Live CSV Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to CSV data and integrate live CSV data into apps built in Microsoft Power Apps.
-
Perform Batch Operations with Azure Synapse Data in Apache NiFi
Connect to Azure Synapse data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automated Continuous Printful Replication to SQL Server
Use CData Sync for automated, continuous, customizable Printful replication to SQL Server.
-
Connect to Oracle Eloqua Data in NetBeans
Connect to Oracle Eloqua data in NetBeans with the data source configuration wizard.
-
How to create SAP HANA XS Advanced federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP HANA XS Advanced data in MySQL .
-
Access Live GraphQL Data in AWS Lambda (with IntelliJ IDEA)
Connect to live GraphQL data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Feed MarkLogic Data into FineReport
How to set MarkLogic data as a JDBC data source in FineReport.
-
Excel Spreadsheet Automation on YouTube Analytics Data with the QUERY Formula
Pull data from YouTube Analytics, automate spreadsheets, and more with the QUERY formula.
-
Replicate PhantomBuster Data to Multiple Databases
Replicate PhantomBuster data to disparate databases with a point-and-click configuration.
-
How to Visualize EnterpriseDB 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 EnterpriseDB data in Python.
-
Visualize Google Ad Manager Data in Sisense
Create an ElastiCube in Sisense app with access to Google Ad Manager data.
-
Connect to Omnisend Data from a Connection Pool in JBoss
Integrate Omnisend data into Java servlets: Use the Management Console in JBoss to install the Omnisend JDBC Driver.
-
Connect to Hive Data in Jaspersoft Studio
Execute SQL to remote Hive data in Jaspersoft Studio.
-
Replicate Omnisend Data to Multiple Databases via the CData Sync CLI
Replicate Omnisend data to disparate databases with a single configuration.
-
Visualize Exact Online Data in Sisense
Create an ElastiCube in Sisense app with access to Exact Online data.
-
Build Charts with Dropbox Data in Clear Analytics
Create dynamic charts and perform analytics based on Dropbox data in Clear Analytics.
-
Enable the EnterpriseDB JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with EnterpriseDB data.
-
Integrating Claude Code with ZohoDesk Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on ZohoDesk data within assisted coding and automated development workflows.
-
Replicate Multiple Act CRM Accounts
Replicate multiple Act CRM accounts to one or many databases.