CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Todoist Replication to MySQL
Use CData Sync for automated, continuous, customizable Todoist replication to MySQL.
-
Model, Search, and Visualize Live Azure DevOps Data in ThoughtSpot
Use CData Connect AI to connect to live Azure DevOps for modeling, searching, and visualizing.
-
Natively Connect to Ontraport Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Ontraport. Leverage the native support for ODBC in PHP.
-
Import Azure Analysis Services Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Azure Analysis Services Data and provide access to live Azure Analysis Services for custom reports in the Power BI Service.
-
Consume SuiteCRM OData Feeds in PowerBuilder
This article demonstrates how to consume SuiteCRM as OData feeds from PowerBuilder using the API Server.
-
Build a Simple VCL Application for Supabase Data
How to build a simple VCL Application to view Supabase in RAD Studio using the CData ODBC Driver for Supabase.
-
Replicate Multiple Insightly Accounts via the CData Sync CLI
Replicate multiple Insightly accounts to one or many databases.
-
How to Seamlessly Import Flowlu Data into IBM SPSS Modeler
Integrate Flowlu data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating GitHub Copilot CLI with LinkedIn 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.
-
Extract, Transform, and Load Redis Data in Informatica PowerCenter
Create a simple Workflow for Redis in Informatica PowerCenter.
-
Explore Geographical Relationships in Pipedrive Data with Power Map
Create data visualizations with Pipedrive in Power Map.
-
Enable the SAP SuccessFactors LMS JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP SuccessFactors LMS.
-
How to use SQLAlchemy ORM to access Twilio Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Twilio.
-
Use the CData ODBC Driver for Helpscout in Microsoft Power Query
You can use the CData Helpscout ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Helpscout into Microsoft Power Query.
-
Integrate with Sage 300 Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Sage 300 to a JSON file on disk.
-
Connect to Datadog Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Datadog to connect to Datadog and execute queries in PowerBuilder.
-
Access Live Workday Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Workday from your Excel spreadsheets.
-
Extend Google Sheets with DB2 Data
Make calls to DB2 from Google Apps Script via the API Server.
-
Analyze Google Spanner Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Spanner and visualize Google Spanner in SAP Analytics Cloud.
-
Write a Simple Go Application to work with Microsoft Dataverse Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Dataverse (CDS).
-
LINQ to Excel 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 Excel Data Provider.
-
Query Presto Data in DataGrip
Create a Data Source for Presto in DataGrip and use SQL to query live Presto.
-
Configure the CData JDBC Driver for OnePageCrm in a Connection Pool in Tomcat
Connect to OnePageCrm from a connection pool in Tomcat.
-
Connect to Google Translate from Asprova with CData Software ODBC Driver for Google Translate
This article shows how to connect faster to Google Translate data from Asprova.
-
Getting Started with the CData SSIS Components for Outlook
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Outlook.
-
How to Easily Query Shopify Data in OpenOffice Base
Connect to Shopify data in OpenOffice Base using the CData ODBC Driver for Shopify and generate reports with live data insights.
-
Build Vault CRM-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Vault CRM to explore live Vault CRM Data in Cursor to assist with building Vault CRM-powered applications.
-
Visualize Live Impala Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Apache Impala into custom reports in Power BI.
-
Build Semantic Layer Views for Email Data in APOS Live Data Gateway
Use the CData Connector for Email in APOS Live Data Gateway to build Semantic Layer Views for Email.
-
Automated Continuous Authorize.Net Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Amazon S3.
-
Bind Live TaxJar Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live TaxJar data
-
How to integrate Metabase with GraphQL Data
Use CData Connect AI to connect to live GraphQL and create an interactive dashboard in Metabase from GraphQL.
-
Connect to Cassandra Data in RapidMiner
Integrate Apache Cassandra with standard components and data source configuration wizards in RapidMiner Studio.
-
Replicate SFTP Data from PowerShell
Write a quick PowerShell script to query SFTP. Use connectivity to the live data to replicate SFTP to SQL Server.
-
Integrating Claude Code CLI with Klipfolio 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.
-
Connect to Snowflake Data from HeidiSQL
Use CData Connect AI to connect to and query live Snowflake from HeidiSQL.
-
How to Query Live Workday Data in Claude Desktop
Connect to and query live Workday Data in Claude Desktop using CData MCP Server.
-
Replicate Omnisend Data from PowerShell
Write a quick PowerShell script to query Omnisend. Use connectivity to the live data to replicate Omnisend to SQL Server.
-
How to connect to Landbot Data from IntelliJ
Integrate connectivity to Landbot with wizards in IntelliJ.
-
Getting Started with the CData SSIS Components for ActiveCampaign
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ActiveCampaign.
-
Query Nuclia Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Nuclia from Node.js.
-
How to Connect to Live Act-On Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Act-On for you.
-
Work with Dotmailer Data in FoxPro
Load Dotmailer into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Power BI XMLA from Asprova with CData Software ODBC Driver for Power BI XMLA
This article shows how to connect faster to Power BI XMLA data from Asprova.
-
How to connect SharePoint with Microsoft Exchange Data through external lists
Provide Microsoft Exchange to SharePoint users as an external list.
-
DataBind Controls to MySQL Data in C++Builder
DataBind to MySQL in C++Builder with standard components and controls.
-
How to connect and process Discourse from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Discourse.
-
Connect to and Visualize Live Shortcut Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Shortcut.
-
Choosing the Best Method to Connect Parquet to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Apache Parquet from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Splunk Data from PowerBuilder via ADO.NET
This article demonstrates how to access Splunk from Appeon PowerBuilder using the CData ADO.NET Provider for Splunk.
-
Build Printify-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Printify Data in Cursor to assist with building Printify-powered applications.
-
Use Microsoft Copilot Studio to talk to your Gong 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 Gong for you.
-
Use the CData Software JDBC Driver for Acumatica in MicroStrategy Web
Connect to Acumatica ERP in MicroStrategy Web using the CData Software JDBC Driver for Acumatica.
-
How to integrate ElevenLabs with Apache Airflow
Access and process ElevenLabs in Apache Airflow using the CData JDBC Driver.
-
Build Apps with Live Factorial Data Using the Low-Code Development Platform of Mendix
Connect Factorial with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate Demio with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Demio with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Demio.
-
Automated Continuous Supabase Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Supabase replication to PostgreSQL.
-
Build Semantic Layer Views for Zoho Recruit Data in APOS Live Data Gateway
Use the CData Connector for Zoho Recruit in APOS Live Data Gateway to build Semantic Layer Views for Zoho Recruit.
-
Create a Data Access Object for Apify Data using JDBI
A brief overview of creating a SQL Object API for Apify in JDBI.
-
Connect to Reply.io Data in DBeaver
Use the CData ODBC Driver to connect to Reply.io in DBeaver.
-
Easily Integrate Supabase Data in Lazarus Pascal IDE
Learn how to easily integrate live Supabase in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Live Zoho CRM Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Zoho CRM from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zoho CRM.
-
Connect Azure Synapse to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Azure Synapse with IBM WebSphere for seamless data integration and connectivity.
-
Building Dynamic Web Pages with Calendly Data Using AngularJS
Create single-page applications with live connectivity to Calendly using the CData API Server.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Twitter Ads within intelligent workflows.
-
Create a Data Access Object for Coinbase Data using JDBI
A brief overview of creating a SQL Object API for Coinbase in JDBI.
-
How to connect SharePoint with Reckon Data through external lists
Provide Reckon to SharePoint users as an external list.
-
Use JayDeBeApi to access SuiteCRM Data in Python
Use standard Python scripting and the development environment of your choice to access live SuiteCRM.
-
Use ChatGPT to Talk to Your Zuora 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 Zuora for you.
-
Automated Continuous Freshteam Replication to Databricks
Use CData Sync for automated, continuous, customizable Freshteam replication to Databricks.
-
Enable the NASA JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with NASA.
-
Write a Simple Go Application to work with Float Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Float.
-
Connect to Perigon Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Perigon to connect to Perigon and execute queries in PowerBuilder.
-
Natively Connect to Dynamics 365 Business Central Data in PHP
The CData ODBC driver for Dynamics 365 Business Central enables you to create PHP applications with connectivity to Dynamics 365 Business Central. Leverage the native support for ODBC in PHP.
-
Integrate Theia IDE with Live Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Access EnterpriseDB Data from MySQL in PHP
Connect to EnterpriseDB through the standard MySQL libraries in PHP.
-
Create Datasets from Box in Domo Workbench and Build Visualizations of Box Data in Domo
Use the CData Software ODBC Driver for Box to create datasets from Box in Domo Workbench and then build visualizations in the Domo service.
-
Build Semantic Layer Views for ClickUp Data in APOS Live Data Gateway
Use the CData Connector for ClickUp in APOS Live Data Gateway to build Semantic Layer Views for ClickUp.
-
Connect to Guru Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Guru and work with Guru in your FileMaker applications.
-
How to connect to Freshdesk Data from Spring Boot
Connect to Freshdesk in a Spring Boot Application using the CData JDBC Driver for Freshdesk
-
Using the CData Software ODBC Driver for Wave Financial in PyCharm
Connect to Wave Financial as an ODBC data source in PyCharm using the CData Software ODBC Driver for Wave Financial.
-
Connect to Twilio Data in RapidMiner
Integrate Twilio with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Apps with Live Monday.com Data Using the Low-Code Development Platform of Mendix
Connect Monday.com with Mendix to build apps using the CData JDBC Driver for Monday.com.
-
Access Live Azure Table 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 Azure Table Storage through MCP integration.
-
Build Semantic Layer Views for YouTube Analytics Data in APOS Live Data Gateway
Use the CData Connector for YouTube Analytics in APOS Live Data Gateway to build Semantic Layer Views for YouTube Analytics.
-
Integrate Live ScrapingBee Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ScrapingBee to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automate EnterpriseDB Data Replication to Azure Data Lake
Use CData Sync to customize and automate EnterpriseDB replication to Azure Data Lake.
-
Query Xero Data as a MySQL Database in Node.js
Execute MySQL queries against Xero Accounting from Node.js.
-
Automated Continuous Recurly Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Recurly replication to PostgreSQL.
-
Visualize MarkLogic Data in TIBCO Spotfire through OData
Integrate MarkLogic into dashboards in TIBCO Spotfire.
-
Seamlessly Bring Cloudant Data into Retool Using CData Connect AI
Integrate Cloudant data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Aircall Data Replication to Teradata
Use CData Sync to Customize and automate Aircall replication to Teradata.
-
Use the CData ODBC Driver for Presto from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Presto to connect to Presto from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Presto in Excel.
-
How to Connect DBeaver to SFTP via a JDBC Driver
Manage SFTP with visual tools in DBeaver like the query browser.
-
Migrating data from Helpscout to Snowflake using CData SSIS Components.
Easily push Helpscout to Snowflake using the CData SSIS Tasks for Helpscout and Snowflake.
-
Publish Crystal Reports on ShipStation Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ShipStation.
-
Analyze SharePoint Excel Services Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SharePoint Excel Services and visualize live SharePoint Excel Services in Infragistics Reveal.
-
Use the CData Software ODBC Driver for Perplexity in SAS for Real-Time Reporting and Analytics
Connect to real-time Perplexity in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Perplexity.
-
Integrating GitHub Data in Talend Cloud Data Management Platform
Connect GitHub Data with Talend Cloud Data Management Platform using the CData JDBC Driver for GitHub.
-
Query Moosend Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Moosend and perform CRUD operations on Moosend from Node.js.