CData Software - Knowledge Base
Recent Articles
-
Create Dynamic Google Forms Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Forms to Infragistics XamDataGrid to build dynamic grids.
-
Query Nethunt Data as a MySQL Database in Node.js
Execute MySQL queries against Nethunt data from Node.js.
-
Integrating LlamaIndex with Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Vault CRM data in real time.
-
Paylocity Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Paylocity data through CData Connect AI using different applications and tools.
-
Import Real-Time Samanage Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Samanage data in ColdFusion.
-
Build Dashboards with Copper Data in DBxtra
Create dynamic dashboards and perform analytics based on Copper data in DBxtra.
-
How to Connect Trello 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 Trello data in real time using natural language.
-
Integrate SAP with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP data.
-
Automated Continuous LDAP Replication to MongoDB
Use CData Sync for automated, continuous, customizable LDAP replication to MongoDB.
-
How to Access Highrise Data Using Entity Framework
This article shows how to access Highrise data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Reports with SAP SuccessFactors LMS Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP SuccessFactors LMS data.
-
Use the CData Software ODBC Driver for Zuora in MicroStrategy
Connect to Zuora data in MicroStrategy Developer using the CData Software ODBC Driver for Zuora.
-
Access QuickBooks Online Data from MySQL in Amazon QuickSight
Connect to QuickBooks Online and build visualizations of QuickBooks Online data using a MySQL Connection in Amazon QuickSight.
-
How to load SAP Ariba Source data into Elasticsearch via Logstash
Introducing a simple method to load SAP Ariba Source data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
DataBind Drip Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Drip data to a chart.
-
Use Databricks Agent Bricks to Talk to Your JSON Services via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your JSON services for you.
-
How to create Gumroad federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Gumroad data in MySQL .
-
Connect to Act-On Data in ACL Analytics
Connect to Act-On data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Act-On data.
-
Integrate Real-Time Access to ActiveCampaign in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to ActiveCampaign data in real time.
-
Use the CData ODBC Driver for Salesforce Pardot from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Salesforce Pardot to connect to Salesforce Pardot data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Salesforce Pardot data in Excel.
-
Automated Continuous Vimeo Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Vimeo replication to Amazon Redshift.
-
Access ZarMoney Data from MySQL in PHP
Connect to ZarMoney through the standard MySQL libraries in PHP.
-
Integrate Goose with Live Square Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Square data from within the local AI agent.
-
Access Live Asana Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Asana data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Intercom from a Connection Pool in WebLogic
Use the CData JDBC Driver for Intercom to connect to Intercom data from Web applications running on WebLogic.
-
Write a Simple Go Application to work with EnterpriseDB Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to EnterpriseDB data.
-
MYOB AccountRight Reporting in OBIEE with the MYOB AccountRight JDBC Driver
Deploy the MYOB AccountRight JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
ETL Front in Oracle Data Integrator
This article shows how to transfer Front data into a data warehouse using Oracle Data Integrator.
-
Connect to FTP Data in HULFT Integrate
Connect to FTP as a JDBC data source in HULFT Integrate
-
Create Informatica Mappings From/To a JDBC Data Source for Samanage
Create Samanage data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Analyze Zoho Inventory Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Zoho Inventory data and visualize live Zoho Inventory data in Infragistics Reveal.
-
Integrate with Oracle Financials Cloud Data in JReport Designer
Create charts and reports based on Oracle Financials Cloud data in JReport Designer.
-
Integrate Twitter Ads Data into Power Automate Desktop using CData Connect
CData Connect for Twitter Ads Data enables you to integrate Twitter Ads data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Act-On Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Act-On to connect to Act-On data and execute queries in PowerBuilder.
-
Replicate Active Directory Data to Multiple Databases via the CData Sync CLI
Replicate Active Directory data to disparate databases with a single configuration.
-
Automated Continuous Cloudant Replication to Vertica
Use CData Sync for automated, continuous, customizable Cloudant replication to Vertica.
-
Automated Continuous GetResponse Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable GetResponse replication to Apache Kafka.
-
Use Claude to Talk to Your LinkedIn Ads 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 LinkedIn Ads data for you.
-
Write a Simple Go Application to work with SAP Business Warehouse Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Business Warehouse data.
-
Configure the CData JDBC Driver for SendPulse in a Connection Pool in Tomcat
Connect to SendPulse data from a connection pool in Tomcat.
-
DataBind Salesforce CRM Analytics Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Salesforce CRM Analytics with the DevExpress Windows Forms and Web controls to provide Salesforce CRM Analytics data to a chart.
-
Connect FormSite to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live FormSite data using the CData Python MCP Server.
-
Create Zoho Books-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Zoho Books Data from OutSystems and build custom enterprise apps using live Zoho Books data.
-
Build Charts with JSON Services in Clear Analytics
Create dynamic charts and perform analytics based on JSON services in Clear Analytics.
-
Connecting Pipedream with Freshdesk 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 Freshdesk data in real time.
-
Build ActiveCampaign-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live ActiveCampaign data and build ActiveCampaign-connected web apps with Axios.
-
Use Databricks Agent Bricks to Talk to Your EnterpriseDB Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your EnterpriseDB data for you.
-
Automated Continuous Wrike Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Wrike replication to IBM DB2.
-
Visualize Datadog Data in TIBCO Spotfire through ADO.NET
Integrate Datadog data into dashboards in TIBCO Spotfire.
-
Use the CData ODBC Driver for Coda from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Coda to connect to Coda data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Coda data in Excel.
-
Integrate Live Salesforce Marketing Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Salesforce Marketing data and integrate live Salesforce Marketing data into apps built in Microsoft Power Apps.
-
Build Semantic Layer Views for Harvest Data in APOS Live Data Gateway
Use the CData Connector for Harvest in APOS Live Data Gateway to build Semantic Layer Views for Harvest data.
-
Use the CData Software ODBC Driver for Salesforce in MicroStrategy Web
Connect to Salesforce data in MicroStrategy Web using the CData Software ODBC Driver for Salesforce.
-
How to create an RPA flow for Presto Data in UiPath Studio
Use the Presto ODBC Driver to create workflows that access real-time Presto data without any coding.
-
Replicate Multiple ZeroBounce Accounts via the CData Sync CLI
Replicate multiple ZeroBounce accounts to one or many databases.
-
How to connect SharePoint with Trello Data through external lists
Provide Trello data to SharePoint users as an external list.
-
Import Amazon Marketplace Data Using Azure Data Factory
Use CData Connect AI to connect to Amazon Marketplace Data from Azure Data Factory and import live Amazon Marketplace data.
-
Connect to Xero from Asprova with CData Software ODBC Driver for Xero
This article shows how to connect faster to Xero data from Asprova.
-
LINQ to Workable Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Workable Data Provider.
-
Connect to Tanda Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Tanda and work with Tanda data in your FileMaker applications.
-
Replicate Multiple Basecamp Accounts
Replicate multiple Basecamp accounts to one or many databases.
-
How to Build an ETL App for Email Data in Python with CData Connect AI
Build ETL pipelines that read and write live Email data in Python with petl and the CData Connect AI Python SDK.
-
Connect to SAP SuccessFactors Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP SuccessFactors data from HeidiSQL.
-
Integrating Claude Code CLI with Todoist 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.
-
Build Apps with Live MessageBird Data Using the Low-Code Development Platform of Mendix
Connect MessageBird data with Mendix to build apps using the CData API Driver for JDBC.
-
Object-Relational Mapping (ORM) with Azure Data Lake Storage 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 Azure Data Lake Storage data into a Java-based ORM framework, Hibernate.
-
Access Google Calendar Data from MySQL in PHP
Connect to Google Calendar through the standard MySQL libraries in PHP.
-
How to Connect to Live Office 365 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 Office 365 data for you.
-
DataBind Controls to Exact Online Data in C++Builder
DataBind to Exact Online data in C++Builder with standard components and controls.
-
Access Zoho Creator Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zoho Creator data from your Oracle system.
-
Use Biml to Build SSIS Tasks to Replicate PhantomBuster Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate PhantomBuster data to SQL Server.
-
How to Build an ETL App for Cassandra Data in Python with CData Connect AI
Build ETL pipelines that read and write live Cassandra data in Python with petl and the CData Connect AI Python SDK.
-
How to Work with SharePoint Excel Services Data in ETL Validator JDBC
Connect to SharePoint Excel Services from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to ScrapingBee Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ScrapingBee data using standard SQL.
-
Automated Continuous Microsoft Entra ID Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to Apache Cassandra.
-
Build IBM Cloud Object Storage-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 IBM Cloud Object Storage data without replication.
-
Query, Visualize, and Share live TaxJar Data in Redash
Use CData Connect AI to connect to live TaxJar data in Redash for querying, visualizing, and sharing.
-
Oracle Reporting in OBIEE with the Oracle JDBC Driver
Deploy the Oracle JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Creating Kafka-Connected Applications in Unqork
You can use CData Connect AI to feed Kafka data to Unqork and build custom business apps.
-
Integrating Claude Code with Pipedrive Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Pipedrive data within assisted coding and automated development workflows.
-
Use the CData Software ODBC Driver for Qualaroo in SAS for Real-Time Reporting and Analytics
Connect to real-time Qualaroo data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Qualaroo.
-
Automated Continuous Samanage Replication to SQL Server
Use CData Sync for automated, continuous, customizable Samanage replication to SQL Server.
-
Build Charts with BenchmarkEmail Data in Clear Analytics
Create dynamic charts and perform analytics based on BenchmarkEmail data in Clear Analytics.
-
Build a Singer.io Tap for Excel With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Excel data using the CData Python Connector.
-
How to Work with SAP Ariba Source Data in AWS Glue Jobs Using JDBC
Connect to SAP Ariba Source from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Access Live ClickTime Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ClickTime enables you to integrate ClickTime data into workflows built using Microsoft Power Automate Desktop.
-
Connecting GenSpark with Microsoft Dataverse Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Microsoft Dataverse data without any replication or custom integration required.
-
Prepare, Blend, and Analyze Pinecone Data in Alteryx Designer (ODBC)
Build workflows to access live Pinecone data for self-service data analytics.
-
Write a Simple Go Application to work with Amazon S3 Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Amazon S3 data.
-
Connect to and Query AdRoll Data in QlikView over ODBC
Create data visualizations with AdRoll data in QlikView.
-
Connect to LeadDesk Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to LeadDesk.
-
How to create Pinecone federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Pinecone data in MySQL .
-
How to connect and process TigerGraph data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live TigerGraph data.
-
Import Typeform Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Typeform Data and provide access to live Typeform data for custom reports in the Power BI Service.
-
Create SSAS Tabular Models from Acumatica Data
How to build a SQL Server Analysis Service Tabular Model from Acumatica data using CData drivers.
-
Build MVC Applications with Connectivity to AdRoll Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access AdRoll from an ASP.NET MVC application.
-
Integrate Dify with Live Sybase IQ 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 Sybase IQ data.
-
Connect to Toggl Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Toggl as an External Source in Dremio.
-
Automated Continuous Monday.com Replication to Databricks
Use CData Sync for automated, continuous, customizable Monday.com replication to Databricks.
-
Use the CData Software ODBC Driver for Wistia in SAS for Real-Time Reporting and Analytics
Connect to real-time Wistia data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Wistia.