CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Harvest Replication to Vertica
Use CData Sync for automated, continuous, customizable Harvest replication to Vertica.
-
Automated Continuous PolarTeamPro Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to Amazon Redshift.
-
Integrating LangGraph with Salesforce Marketing Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Salesforce Marketing data within automated workflows.
-
Connect to HDFS Data in Google Apps Script via Connect AI
Use CData Connect AI to access HDFS data in Google Apps Script.
-
Connect to Exact Online Data from Crystal Reports
Use CData Connect AI to connect to and report on live Exact Online data from Crystal Reports.
-
Access Live Workday Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Workday data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating Missive Data in Talend Cloud Data Management Platform
Connect Missive Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate ZohoSubscriptions with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ZohoSubscriptions with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ZohoSubscriptions data.
-
Integrating Codex with SAP SuccessFactors 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 JayDeBeApi to access PagerDuty Data in Python
Use standard Python scripting and the development environment of your choice to access live PagerDuty data.
-
How to integrate Teamwork with Apache Airflow
Access and process Teamwork data in Apache Airflow using the CData JDBC Driver.
-
How to Query Live Apollo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Apollo data data in natural language using Python.
-
Working with Discourse Data in LINQPad
Execute LINQ queries to Discourse data in LINQPad.
-
Use Dash to Build to Web Apps on Clio Data
Create Python applications that use pandas and Dash to build Clio-connected web apps.
-
How to Access Exact Online Data Using Entity Framework
This article shows how to access Exact Online data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connecting Agentforce with SAP Business Warehouse 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 SAP Business Warehouse data for you.
-
Choosing the Best Method to Connect Oracle HCM Cloud to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Oracle HCM Cloud data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Live Sage Cloud Accounting Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Sage Cloud Accounting data to Blue Prism using the CData ODBC Driver for Sage Cloud Accounting to create automated workflows for repetitive business tasks.
-
Automated Continuous Pinecone Replication to SingleStore
Use CData Sync for automated, continuous, customizable Pinecone replication to SingleStore.
-
Connect to Avro Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Avro and the SQL Gateway to access Avro data from Google Apps Script.
-
A PostgreSQL Interface for Optimizely Data (MySQL Remoting via JDBC)
Use the Remoting features of the Optimizely JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect Flowise AI Agents to Live Oracle SCM 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 Oracle SCM data without replication.
-
Create Reports with ZeroBounce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZeroBounce data.
-
Build Retently-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Retently data and build web apps with connectivity to live Retently data.
-
Automated Zoho Projects Data Replication to Teradata
Use CData Sync to Customize and automate Zoho Projects data replication to Teradata.
-
Build Data Flows from ChartMogul to SQL Server using SSIS
Easily back up ChartMogul data to SQL Server using the SSIS components for ChartMogul.
-
Migrating data from Clockify to Snowflake using CData SSIS Components.
Easily push Clockify data to Snowflake using the CData SSIS Tasks for Clockify and Snowflake.
-
Connect to CockroachDB Data in Ruby
Connect to CockroachDB data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Bidirectional Access to Twilio Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Twilio data in Filemaker Pro for Mac or Windows.
-
Build Trello-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 Trello data without replication.
-
Use Dash to Build Web Apps on Zoom Data via CData Connect AI
Build interactive Dash web apps on live Zoom data using pandas and the CData Connect AI Python SDK.
-
How to Access Live Zoho Recruit Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Zoho Recruit enables you to integrate Zoho Recruit data into workflows built using Microsoft Power Automate Desktop.
-
Use Dash to Build Web Apps on SAP SuccessFactors LMS Data via CData Connect AI
Build interactive Dash web apps on live SAP SuccessFactors LMS data using pandas and the CData Connect AI Python SDK.
-
Automated Continuous ChargeOver Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ChargeOver replication to Apache Cassandra.
-
Connect and Visualize Live GitHub Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live GitHub data into the Databricks platform and create visualization dashboards with real-time GitHub data.
-
Build GetResponse-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live GetResponse data.
-
Connect to Wave Financial from Asprova with CData Software ODBC Driver for Wave Financial
This article shows how to connect faster to Wave Financial data from Asprova.
-
Build MVC Applications with Connectivity to Google Calendar Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Calendar from an ASP.NET MVC application.
-
Validate Freshsales Data with QuerySurge
Access and validate Freshsales data in QuerySurge using the CData JDBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate Google Search Results to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Search results to SQL Server.
-
Automated Continuous EmailOctopus Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable EmailOctopus replication to delimited files (CSV/TSV).
-
Connect to GitLab Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to GitLab and work with GitLab data in your FileMaker applications.
-
Getting Started with the CData ODBC Driver for Jira
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Jira.
-
How to connect Amazon QuickSight to Wistia Data
Create a connection to Wistia data in CData Connect AI and insert Wistia data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Connect to Live Epicor Kinetic Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Epicor Kinetic data without replication.
-
Automated Continuous Insightly Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Insightly replication to Azure SQL Database.
-
Access Live Hacker News Data in AWS Lambda
Connect to live Hacker News data in AWS Lambda using the CData JDBC Driver.
-
Interact with Live SparkPost Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SparkPost data.
-
Build Data Flows from Exa to SQL Server using SSIS
Easily back up Exa data to SQL Server using the SSIS components for Exa.
-
Getting Started with the CData Tableau Connector for Gong
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Feed SAP Data into FineReport
How to set SAP data as a JDBC data source in FineReport.
-
Connect to Xero Data from Crystal Reports
Use CData Connect AI to connect to and report on live Xero data from Crystal Reports.
-
Integrating Kiro with Quickbase 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.
-
How to Connect to & Open Raisers Edge NXT Data in Microsoft Excel
This article uses the CData ODBC driver for Raisers Edge NXT to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Printful Data in RapidMiner
Integrate Printful data with standard components and data source configuration wizards in RapidMiner Studio.
-
Azure DevOps Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Azure DevOps data through CData Connect AI using different applications and tools.
-
Create Reports with Epicor Kinetic Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Epicor Kinetic data.
-
How to connect to Dynamics 365 Data from IntelliJ
Integrate connectivity to Dynamics 365 data with wizards in IntelliJ.
-
Automated Continuous Teradata Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Teradata replication to PostgreSQL.
-
Build Automated Workflows with Live Google Analytics Data in Workato
Use CData Connect AI to connect to live Google Analytics data and build automated workflows in Workato.
-
Create Salesforce-Connected Applications in Appsmith
Connect to Salesforce Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Salesforce data.
-
Connect and Visualize Live Salesforce CRM Analytics Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Salesforce CRM Analytics data into the Databricks platform and create visualization dashboards with real-time Salesforce CRM Analytics data.
-
How to use SQLAlchemy ORM to access Clari Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Clari data.
-
How to Query Google Campaign Manager 360 Data in MySQL Workbench
Execute MySQL queries against live Google Campaign Manager 360 data from MySQL Workbench.
-
Excel Spreadsheet Automation on Freshsales Data with the QUERY Formula
Pull data from Freshsales, automate spreadsheets, and more with the QUERY formula.
-
Work with Google Spanner Data in FoxPro
Load Google Spanner data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Close Data in JRuby
Create a simple JRuby app with access to live Close data.
-
Query Klaviyo Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Klaviyo entities in PHP by modeling them as objects.
-
Replicate Multiple iContact Accounts via the CData Sync CLI
Replicate multiple iContact accounts to one or many databases.
-
Import Real-Time SAP Fieldglass Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP Fieldglass data in ColdFusion.
-
Use the CData Software JDBC Driver for Azure Data Lake Storage in MicroStrategy Desktop
Connect to Azure Data Lake Storage data in MicroStrategy Desktop using the CData Software JDBC Driver for Azure Data Lake Storage.
-
Build a Singer.io Tap for Oracle SCM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Oracle SCM data using the CData Python Connector.
-
Use Azure AI Foundry to Talk to Your SQL Server 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 SQL Server data for you.
-
Access Live EmailOctopus Data in AWS Lambda (with IntelliJ IDEA)
Connect to live EmailOctopus data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Cloudant Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Cloudant facts in real time.
-
Integrating Antigravity CLI with Azure DevOps data via CData CLI
Connect Azure DevOps data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Back Up OData services to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for OData. In this article, we will employ an SSIS workflow to populate a database with OData services data.
-
Connecting Agentforce with Spark 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 Spark data for you.
-
DataBind Sage 200 Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Sage 200 with the DevExpress Windows Forms and Web controls to provide Sage 200 data to a chart.
-
Integrate Gumroad Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Gumroad data from Informatica Cloud.
-
Use Azure AI Foundry to Talk to Your MailerLite 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 MailerLite data for you.
-
Connect to Databricks Data in Claris FileMaker Pro
Use the CData ODBC Driver for Databricks in FileMaker Pro to connect to Databricks and work with Databricks data in your FileMaker applications.
-
Integrating MessageBird Data in Talend Cloud Data Management Platform
Connect MessageBird Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to Figshare Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Figshare data.
-
Create MailChimp-Connected Dashboards in Grafana
Connect to MailChimp Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to MailChimp data.
-
Query BigCommerce Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume BigCommerce entities in PHP by modeling them as objects.
-
Visualize Live SharePoint Excel Services Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SharePoint Excel Services data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live Twilio Data in TIBCO Data Virtualization
Use the Twilio Tibco DV Adapter to create a Twilio data data source in TIBCO Data Virtualization Studio and gain access to live Twilio data from your TDV Server.
-
Bidirectional Access to Adobe Commerce Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Adobe Commerce data in Filemaker Pro for Mac or Windows.
-
Analyze NASA Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze NASA data with the CData JDBC Driver for NASA.
-
Connect to Square Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Square data from Filemaker Pro on Mac.
-
Build Semantic Layer Views for SurveyMonkey Data in APOS Live Data Gateway
Use the CData Connector for SurveyMonkey in APOS Live Data Gateway to build Semantic Layer Views for SurveyMonkey data.
-
Connect to FTP Data from PowerBuilder via ADO.NET
This article demonstrates how to access FTP data from Appeon PowerBuilder using the CData ADO.NET Provider for FTP.
-
Integrate Live PingOne Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live PingOne data to Blue Prism using the CData ODBC Driver for PingOne to create automated workflows for repetitive business tasks.
-
Automated Continuous RabbitMQ Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable RabbitMQ data replication to OneLake in Microsoft Fabric.
-
How to Connect DBeaver to Shopify via a JDBC Driver
Manage Shopify data with visual tools in DBeaver like the query browser.
-
Build Clari-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Clari data and build web apps with connectivity to live Clari data.
-
How to connect Amazon QuickSight to Perplexity Data
Create a connection to Perplexity data in CData Connect AI and insert Perplexity data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connecting Mastra with LinkedIn Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time LinkedIn Ads data, no replication required.
-
Bridge Asana Connectivity with Apache NiFi
Access and process Asana data in Apache NiFi using the CData JDBC Driver.