CData Software - Knowledge Base
Recent Articles
-
Automate Cassandra Data Replication to Azure Data Lake
Use CData Sync to customize and automate Cassandra data replication to Azure Data Lake.
-
DataBind Controls to QuickBooks Online Data in Delphi
DataBind to QuickBooks Online data in Delphi with standard data access components and controls.
-
Migrating data from ZohoPeople to Databricks using CData SSIS Components.
Easily push ZohoPeople data to Databricks using the CData SSIS Tasks for ZohoPeople and Databricks.
-
Access Live Microsoft Teams Data in AWS Lambda
Connect to live Microsoft Teams data in AWS Lambda using the CData JDBC Driver.
-
Migrating data from Azure DevOps to Databricks using CData SSIS Components.
Easily push Azure DevOps data to Databricks using the CData SSIS Tasks for Azure DevOps and Databricks.
-
Use Biml to Build SSIS Tasks to Replicate MySQL Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate MySQL data to SQL Server.
-
Create Reports from FTP Data in Looker Studio
Use CData Connect AI to gain access to live FTP data and create custom reports in Looker Studio.
-
Moving Data from ZohoExpense to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ZohoExpense data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Reports with ClickTime Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ClickTime data.
-
Use the CData ODBC Driver for Demio from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Demio to connect to Demio data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Demio data in Excel.
-
Getting Started with the CData SSIS Components for Stack Exchange
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Stack Exchange.
-
Automated Continuous Google Contacts Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Contacts replication to Databricks.
-
Integrate Salesforce CRM Analytics Data in Pentaho Data Integration
Build ETL pipelines based on Salesforce CRM Analytics data in the Pentaho Data Integration tool.
-
Integrate Open WebUI with Live SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP SuccessFactors LMS data from within the chat interface.
-
Connect to Microsoft Planner Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft Planner data in the Denodo Virtual DataPort Administrator.
-
Integrating Typeform Data in Talend Cloud Data Management Platform
Connect Typeform Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate Live Presto Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Presto from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Presto data.
-
How to Connect ZohoPeople 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 ZohoPeople data in real time using natural language.
-
Natively Connect to Short.io Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Short.io data. Leverage the native support for ODBC in PHP.
-
Connect to Adobe Analytics Data in HULFT Integrate
Connect to Adobe Analytics as a JDBC data source in HULFT Integrate
-
Automate SageHR Data Replication to Azure Synapse
Use CData Sync to customize and automate SageHR data replication to Azure Synapse.
-
Connect to JSON Services from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for JSON to connect to JSON services and execute queries in PowerBuilder.
-
Getting Started with the CData Excel Add-In for Acumatica
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Acumatica.
-
Connecting Agentforce with XML 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 XML data for you.
-
Connect to Oracle Service Cloud Data from a Connection Pool in JBoss
Integrate Oracle Service Cloud data into Java servlets: Use the Management Console in JBoss to install the Oracle Service Cloud JDBC Driver.
-
How to create an RPA flow for BenchmarkEmail Data in UiPath Studio
Use the BenchmarkEmail ODBC Driver to create workflows that access real-time BenchmarkEmail data without any coding.
-
Publish AfterShip-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live AfterShip data.
-
Bridge CampaignMonitor Connectivity with Apache NiFi
Access and process CampaignMonitor data in Apache NiFi using the CData JDBC Driver.
-
Connect to Billsby Data in CloverDX (formerly CloverETL)
Transfer Billsby data using the visual workflow in the CloverDX data integration tool.
-
How to Query Samanage Data in MySQL Workbench
Execute MySQL queries against live Samanage data from MySQL Workbench.
-
Automate FormSite Data Replication to Azure Data Lake
Use CData Sync to customize and automate FormSite data replication to Azure Data Lake.
-
Integrating Claude Code CLI with MariaDB 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.
-
Establish a Live Connection with VWO Data using Tableau Bridge
The CData ODBC Driver for VWO enables you to integrate live VWO data into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Dropbox Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Dropbox data.
-
Connect to Microsoft Planner Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Microsoft Planner data from Filemaker Pro on Mac.
-
Explore Geographical Relationships in Reply.io Data with Power Map
Create data visualizations with Reply.io data in Power Map.
-
DataBind Controls to AgileCRM Data in Delphi
DataBind to AgileCRM data in Delphi with standard data access components and controls.
-
DataBind Controls to Telegram Data in Delphi
DataBind to Telegram data in Delphi with standard data access components and controls.
-
Establish a Live Connection with Dotmailer Data using Tableau Bridge
The CData ODBC Driver for Dotmailer enables you to integrate live Dotmailer data into Tableau Cloud dashboards using the Tableau Bridge.
-
Create Omnisend-Connected Nintex Workflows
Use CData Connect AI to connect to Omnisend Data from Nintex Workflow Cloud and build custom workflows using live Omnisend data.
-
Connect DB2 to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live DB2 data using the CData Python MCP Server.
-
Build Semantic Layer Views for JSON Services in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for JSON services.
-
Use Biml to Build SSIS Tasks to Replicate Azure Table Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Azure Table data to SQL Server.
-
Connect to CockroachDB Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for CockroachDB to connect to CockroachDB data and execute queries in PowerBuilder.
-
Bright Data Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Bright Data data through CData Connect AI using different applications and tools.
-
Connect to Landbot Data from PowerBuilder via ADO.NET
This article demonstrates how to access Landbot data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build a Simple VCL Application for Coda Data
How to build a simple VCL Application to view Coda data in RAD Studio using the CData ODBC Driver for Coda.
-
Build Voice Agents in ElevenLabs with access to Live Zoho Projects Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Zoho Projects data.
-
Replicate Retently Data to Multiple Databases via the CData Sync CLI
Replicate Retently data to disparate databases with a single configuration.
-
Connect and Visualize Live Freshdesk Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Freshdesk data into the Databricks platform and create visualization dashboards with real-time Freshdesk data.
-
Search External iContact Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of iContact data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create iContact Data objects that you can access from apps and the dashboard.
-
Visualize Live GraphQL Data in the Power BI Service
Use CData Connect AI to connect to live GraphQL data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Helpscout Data in Tableau
The CData ODBC driver for Helpscout enables you integrate Helpscout data into Tableau dashboards.
-
Use the CData ODBC Driver for Recurly from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Recurly to connect to Recurly data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Recurly data in Excel.
-
How to use SQLAlchemy ORM to access Mailgun Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Mailgun data.
-
Import and Visualize Samanage Data in Power View
Create data visualizations based on Samanage data in Excel.
-
Use the CData ODBC Driver for Pingdom in Microsoft Power Query
You can use the CData Pingdom ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Pingdom data into Microsoft Power Query.
-
Build Oracle Sales Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Oracle Sales data and build visualizations in Tableau.
-
Access Live Oracle Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Oracle data into the statistical analysis tools available in SAS JMP. This article shows how to use Oracle data in the Graph Builder and Query Builder.
-
Create Dashboards and Visualize Live SingleStore Data in Geckoboard
Use CData Connect AI to connect to live SingleStore data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access Landbot Data from MySQL in Amazon QuickSight
Connect to Landbot and build visualizations of Landbot data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous GetResponse Replication to SQLite
Use CData Sync for automated, continuous, customizable GetResponse replication to SQLite.
-
Connect Telegram Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Telegram data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Google Analytics Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Analytics replication to SingleStore.
-
Automated Continuous REST Replication to SingleStore
Use CData Sync for automated, continuous, customizable REST replication to SingleStore.
-
Provide OData Services of Office 365 Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Office 365 data by developing a WCF Service Application.
-
Replicate ClickTime Data in Heroku for Use in Salesforce Connect
Replicate ClickTime data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Dynamics 365 Business Central Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Dynamics 365 Business Central data access from reports, embedded analytics, and more.
-
Automated Continuous EnterpriseDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to SingleStore.
-
Natively Connect to Slack Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Slack data. Leverage the native support for ODBC in PHP.
-
Connect to Asana Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Asana data using standard SQL.
-
Use Biml to Build SSIS Tasks to Replicate Amazon Marketplace Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Amazon Marketplace data to SQL Server.
-
Replicate Teradata Data to Multiple Databases
Replicate Teradata data to disparate databases with a point-and-click configuration.
-
Query Mistral AI Data in ColdFusion
Write standard ColdFusion data access code to connect to Mistral AI data.
-
Rapidly Develop SurveyMonkey-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 SurveyMonkey.
-
Prepare, Blend, and Analyze OData Services in Alteryx Designer (ODBC)
Build workflows to access live OData services for self-service data analytics.
-
Replicate Multiple Jumpseller Accounts via the CData Sync CLI
Replicate multiple Jumpseller accounts to one or many databases.
-
How to Connect to Clio Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Clio data. Leverage the pyodbc module for ODBC in Python.
-
How to import Sage Intacct Data into Apache Solr
Use the CData Software JDBC Driver for Sage Intacct in Data Import Handler and create an automated import of Sage Intacct data to Apache Solr Enterprise Search platform.
-
Process & Analyze NetSuite Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live NetSuite Data.
-
Work with Google Drive Data in FoxPro
Load Google Drive data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Close Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Close data in the Denodo Virtual DataPort Administrator.
-
Access Live Aweber Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Aweber data through MCP integration.
-
DataBind CircleCI Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide CircleCI data to a chart.
-
How to load Toggl data into Elasticsearch via Logstash
Introducing a simple method to load Toggl data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate with JSON Services in JReport Designer
Create charts and reports based on JSON services in JReport Designer.
-
Use Dash to Build to Web Apps on ClickTime Data
Create Python applications that use pandas and Dash to build ClickTime-connected web apps.
-
Access Perigon Data from MySQL in PHP
Connect to Perigon through the standard MySQL libraries in PHP.
-
Access Live Float Data in AWS Lambda
Connect to live Float data in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Paymo in MicroStrategy Desktop
Connect to Paymo data in MicroStrategy Desktop using the CData Software ODBC Driver for Paymo.
-
Operational Reporting on SAP Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP data.
-
Create JDBC-ODBC Bridge Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time JDBC-ODBC Bridge data access from reports, embedded analytics, and more.
-
Analyze FreeAgent Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze FreeAgent data with the CData JDBC Driver for FreeAgent.
-
Automated Continuous GraphQL Replication to SingleStore
Use CData Sync for automated, continuous, customizable GraphQL replication to SingleStore.
-
Automated Continuous ScrapingBee Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ScrapingBee replication to Apache Kafka.
-
Connect Auth0 to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Auth0 with IBM WebSphere for seamless data integration and connectivity.
-
Build Data Flows from Clio to SQL Server using SSIS
Easily back up Clio data to SQL Server using the SSIS components for Clio.
-
How to integrate Pipeliner CRM with Apache Airflow
Access and process Pipeliner CRM data in Apache Airflow using the CData JDBC Driver.
-
Build Pipelines with Live WordPress Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to WordPress from Google Cloud Data Fusion, enabling the integration of live WordPress data into the building and management of effective data pipelines.
-
Use the CData ODBC Driver for Everhour from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Everhour to connect to Everhour data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Everhour data in Excel.