CData Software - Knowledge Base
Recent Articles
-
Connect to Intercom Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Intercom data in the Denodo Virtual DataPort Administrator.
-
How to connect to Perigon Data with Squirrel SQL client
Connect to Perigon data and execute queries in the Squirrel SQL Client.
-
Natively Connect to Azure Data Catalog Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Azure Data Catalog data. Leverage the native support for ODBC in PHP.
-
Connecting Mastra with SharePoint 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 SharePoint data, no replication required.
-
Connect to Highrise Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Highrise as an External Source in Dremio.
-
Build Data Flows from Amazon S3 to SQL Server using SSIS
Easily back up Amazon S3 data to SQL Server using the SSIS components for Amazon S3.
-
Build Semantic Layer Views for Trello Data in APOS Live Data Gateway
Use the CData Connector for Trello in APOS Live Data Gateway to build Semantic Layer Views for Trello data.
-
DataBind Controls to eBay Analytics Data in C++Builder
DataBind to eBay Analytics data in C++Builder with standard components and controls.
-
Automated Continuous XML Replication to SingleStore
Use CData Sync for automated, continuous, customizable XML replication to SingleStore.
-
Connect to Odoo Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Odoo and the Script function in FileMaker Pro to connect to Odoo and work with Odoo data in your FileMaker application.
-
Connect to Greenhouse Data in HULFT Integrate
Connect to Greenhouse as a JDBC data source in HULFT Integrate
-
Migrating data from Front to Google BigQuery using CData SSIS Components.
Easily push Front data to Google BigQuery using the CData SSIS Tasks for Front and Google BigQuery.
-
Visualize Paylocity Data in TIBCO Spotfire through ADO.NET
Integrate Paylocity data into dashboards in TIBCO Spotfire.
-
How to connect PolyBase to SurveyMonkey
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SurveyMonkey data.
-
Integrate WordPress Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live WordPress data from Informatica Cloud.
-
Use ChatGPT to Talk to Your SAP Fieldglass 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 SAP Fieldglass data for you.
-
Integrate Bright Data with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Bright Data with External Services.
-
How to use SQLAlchemy ORM to access Teradata Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Teradata data.
-
Integrating Kiro with Azure DevOps 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.
-
Configure the CData JDBC Driver for Typeform in a Connection Pool in Tomcat
Connect to Typeform data from a connection pool in Tomcat.
-
Connect to LinkedIn Ads Data from a Connection Pool in JBoss
Integrate LinkedIn Ads data into Java servlets: Use the Management Console in JBoss to install the LinkedIn Ads JDBC Driver.
-
Use Dash to Build to Web Apps on Printify Data
Create Python applications that use pandas and Dash to build Printify-connected web apps.
-
Visualize Live TaxJar Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live TaxJar data into custom reports in Power BI.
-
Connect to ServiceNow Data in RapidMiner
Integrate ServiceNow data with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Datasets from DocuSign in Domo Workbench and Build Visualizations of DocuSign Data in Domo
Use the CData Software ODBC Driver for DocuSign to create datasets from DocuSign data in Domo Workbench and then build visualizations in the Domo service.
-
Build MVC Applications with Connectivity to Quickbase Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Quickbase from an ASP.NET MVC application.
-
How to integrate ConvertAPI with Apache Airflow
Access and process ConvertAPI data in Apache Airflow using the CData JDBC Driver.
-
Build Visualizations of Dynamics NAV Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Dynamics NAV data in Birst.
-
Getting Started with the CData JDBC Driver for Adobe Target
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Adobe Target.
-
Build Visualizations of ZohoDesk Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ZohoDesk data in Birst.
-
How to Query Live SAP Ariba Source Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP Ariba Source data data in natural language using Python.
-
Create MySQL-Connected Dashboards in Grafana
Connect to MySQL Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to MySQL data.
-
Query Adobe Target Data in DataGrip
Create a Data Source for Adobe Target in DataGrip and use SQL to query live Adobe Target data.
-
Natively Connect to Telegram Data in PHP
The CData ODBC driver for Telegram enables you to create PHP applications with connectivity to Telegram data. Leverage the native support for ODBC in PHP.
-
Connecting Pipedream with Instagram 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 Instagram data in real time.
-
Build Apps with Live Reply.io Data Using the Low-Code Development Platform of Mendix
Connect Reply.io data with Mendix to build apps using the CData API Driver for JDBC.
-
Automated PhantomBuster Data Replication to Teradata
Use CData Sync to Customize and automate PhantomBuster data replication to Teradata.
-
Connect to Adobe Analytics Data from a Connection Pool in Jetty
The Adobe Analytics JDBC Driver supports connection pooling: This article shows how to connect faster to Adobe Analytics data from Web apps in Jetty.
-
Replicate Float Data to Multiple Databases
Replicate Float data to disparate databases with a point-and-click configuration.
-
Automated Continuous Salesforce Marketing Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Google BigQuery.
-
Access Live Power BI XMLA Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Power BI XMLA data through MCP integration.
-
How to Connect to ActiveCampaign Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ActiveCampaign data. Leverage the pyodbc module for ODBC in Python.
-
Use JayDeBeApi to access DocuSign Data in Python
Use standard Python scripting and the development environment of your choice to access live DocuSign data.
-
Extract, Transform, and Load CouchDB Data in Informatica PowerCenter
Create a simple Workflow for CouchDB data in Informatica PowerCenter.
-
How to connect Amazon QuickSight to SAP SuccessFactors Data
Create a connection to SAP SuccessFactors data in CData Connect AI and insert SAP SuccessFactors data into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate Live Azure Analysis Services Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Azure Analysis Services data and integrate live Azure Analysis Services data into apps built in Microsoft Power Apps.
-
Visualize ZeroBounce 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 ZeroBounce data into TIBCO Spotfire.
-
Connect to Wave Financial in SpagoBI
Create reports featuring live Wave Financial data in SpagoBI Studio. Host Wave Financial reports on SpagoBI Server.
-
Connect to Unbounce from a Connection Pool in WebLogic
Use the CData JDBC Driver for Unbounce to connect to Unbounce data from Web applications running on WebLogic.
-
Connect to AdRoll Data in RapidMiner
Integrate AdRoll data with standard components and data source configuration wizards in RapidMiner Studio.
-
Replicate Multiple Bullhorn CRM Accounts via the CData Sync CLI
Replicate multiple Bullhorn CRM accounts to one or many databases.
-
Automate Dynamics 365 Data Replication to Azure Data Lake
Use CData Sync to customize and automate Dynamics 365 data replication to Azure Data Lake.
-
Connect to ShipStation Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for ShipStation Data and connect to ShipStation data in Akorbi Digital RunMyProcess.
-
Integrating LangChain with Timely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Timely data within automated workflows.
-
Integrating LangGraph with Azure Analysis Services Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Azure Analysis Services data within automated workflows.
-
Create Informatica Mappings From/To a JDBC Data Source for SuiteCRM
Create SuiteCRM data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate OnePageCrm with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate OnePageCrm with External Services.
-
Integrating LangGraph with Testmonitor Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Testmonitor data within automated workflows.
-
How to create Twilio federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Twilio data in MySQL .
-
Create Informatica Mappings From/To an ODBC Data Source for Printful
Create an ODBC connection to Printful in Informatica and browse and transfer Printful data.
-
Automated Continuous Elasticsearch Replication to MySQL
Use CData Sync for automated, continuous, customizable Elasticsearch replication to MySQL.
-
Integrate Snowflake Data in Pentaho Data Integration
Build ETL pipelines based on Snowflake data in the Pentaho Data Integration tool.
-
Build an OLAP Cube in SSAS from Egnyte Data
Establish a connection to Egnyte data data from SQL Server Analysis Services, and use the Egnyte Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automate Browserless Data Replication to Couchbase
Use CData Sync to Customize and automate Browserless data replication to Couchbase.
-
Create Apps from Sybase IQ Data in Qlik Sense Cloud
Use CData Connect AI to connect to Sybase IQ Data and build apps from live Sybase IQ data in Qlik Sense Cloud.
-
DataBind Controls to Oracle SCM Data in C++Builder
DataBind to Oracle SCM data in C++Builder with standard components and controls.
-
How to Connect to & Open FormSite Data in Microsoft Excel
This article uses the CData ODBC driver for FormSite to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Datasets from CapsuleCRM in Domo Workbench and Build Visualizations of CapsuleCRM Data in Domo
Use the CData Software ODBC Driver for CapsuleCRM to create datasets from CapsuleCRM data in Domo Workbench and then build visualizations in the Domo service.
-
Create SAS Data Sets-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAS Data Sets Data from OutSystems and build custom enterprise apps using live SAS Data Sets data.
-
Create Datasets from Factorial in Domo Workbench and Build Visualizations of Factorial Data in Domo
Use the CData Software ODBC Driver for Factorial to create datasets from Factorial data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to PolarTeamPro Data in RapidMiner
Integrate PolarTeamPro data with standard components and data source configuration wizards in RapidMiner Studio.
-
Provide OData Services of Attio Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Attio data by developing a WCF Service Application.
-
Bind Live Paylocity Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Paylocity data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Access Live Cvent Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Cvent data from your Excel spreadsheets.
-
Integrate Live Okta Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Okta data and integrate live Okta data into apps built in Microsoft Power Apps.
-
Connect PabblySubscriptions to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect PabblySubscriptions with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Google Cloud Storage Data into Power Automate Desktop using CData Connect
CData Connect for Google Cloud Storage Data enables you to integrate Google Cloud Storage data into workflows built using Microsoft Power Automate Desktop.
-
Replicate ScrapingBee Data from PowerShell
Write a quick PowerShell script to query ScrapingBee data. Use connectivity to the live data to replicate ScrapingBee data to SQL Server.
-
Viewing Authorize.Net Data in RAD Studio Data Explorer
How to view Authorize.Net data in RAD Studio Data Explorer using the CData ODBC Driver for Authorize.Net.
-
Automated Continuous SAP BusinessObjects BI Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to IBM DB2.
-
Create Power BI Reports on Real-Time Twilio Data
Use the CData ODBC Driver for Twilio to visualize Twilio data in Power BI Desktop.
-
Access Live Elasticsearch Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Elasticsearch data through MCP integration.
-
Build Dashboards with Epicor Kinetic Data in DBxtra
Create dynamic dashboards and perform analytics based on Epicor Kinetic data in DBxtra.
-
Analyze Azure DevOps Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Azure DevOps data and visualize Azure DevOps data in SAP Analytics Cloud.
-
Connect to Marketo Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Marketo data using standard SQL.
-
Build HubDB-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 HubDB data without replication.
-
Automated Outreach.io Data Replication to Teradata
Use CData Sync to Customize and automate Outreach.io data replication to Teradata.
-
Access Live Excel Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Excel data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Analyze Live AgileCRM Data in SAS Viya
Use CData Connect AI to connect to AgileCRM data from SAS Viya and deploy self-service analytics using live AgileCRM data.
-
How to use SQLAlchemy ORM to access Exact Online Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Exact Online data.
-
Explore Geographical Relationships in AgileCRM Data with Power Map
Create data visualizations with AgileCRM data in Power Map.
-
Load ZohoDesk Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ZohoDesk data to a database.
-
Automated Continuous Calendly Replication to Databricks
Use CData Sync for automated, continuous, customizable Calendly replication to Databricks.
-
Create a Data Access Object for Insightly Data using JDBI
A brief overview of creating a SQL Object API for Insightly data in JDBI.
-
Automate Pipeliner CRM Data Replication to SAP HANA
Use CData Sync to customize and automate Pipeliner CRM data replication to SAP HANA.
-
Create Avalara AvaTax-Connected Nintex Workflows
Use CData Connect AI to connect to Avalara AvaTax Data from Nintex Workflow Cloud and build custom workflows using live Avalara AvaTax data.
-
Back Up Testmonitor 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 Testmonitor data data.
-
Access Live Odoo Data in AWS Lambda
Connect to live Odoo data in AWS Lambda using the CData JDBC Driver.
-
Integrate LibreChat with Live Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Monday.com data from within the chat interface.
-
DataBind Controls to ChargeOver Data in Delphi
DataBind to ChargeOver data in Delphi with standard data access components and controls.