CData Software - Knowledge Base
Recent Articles
-
Import Real-Time Mixpanel Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Mixpanel in ColdFusion.
-
How to connect to JotForm Data from IntelliJ
Integrate connectivity to JotForm with wizards in IntelliJ.
-
Publish Supabase-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Supabase.
-
Write a Simple Go Application to work with SpaceX Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SpaceX.
-
How to integrate ADP with Apache Airflow
Access and process ADP in Apache Airflow using the CData JDBC Driver.
-
DataBind Charts to SharePoint Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft SharePoint from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Build a PostgreSQL Interface for Dotmailer Data using the CData JDBC Driver
Use the Remoting features of the Dotmailer JDBC Driver to create a PostgreSQL entry-point for data access.
-
View Reports on Real-Time REST Data in Power BI Report Server
Use the CData ODBC Driver for REST to visualize REST in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Kiro CLI with Mailgun 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.
-
Automated Continuous Stripe Replication to SQLite
Use CData Sync for automated, continuous, customizable Stripe replication to SQLite.
-
Use the CData Software JDBC Driver for Wistia in MicroStrategy Web
Connect to Wistia in MicroStrategy Web using the CData Software JDBC Driver for Wistia.
-
Use the CData Software ODBC Driver for MySQL in SAS for Real-Time Reporting and Analytics
Connect to real-time MySQL in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MySQL.
-
Connect to Google Contacts Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Contacts from Appeon PowerBuilder using the CData ADO.NET Provider for Google Contacts.
-
Access Live Vertica Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Vertica from your Excel spreadsheets.
-
Automated Continuous HDFS Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable HDFS replication to Amazon Redshift.
-
Load Salesforce Pardot Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Salesforce Pardot to a database.
-
Extend Google Sheets with GitHub Data
Make calls to GitHub from Google Apps Script via the API Server.
-
Connect to Azure Synapse Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Azure Synapse Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
ETL Sage Intacct in Oracle Data Integrator
This article shows how to transfer Sage Intacct into a data warehouse using Oracle Data Integrator.
-
Natively Connect to SAS Data Sets Data in PHP
The CData ODBC driver for SAS Data Sets enables you to create PHP applications with connectivity to SAS Data Sets. Leverage the native support for ODBC in PHP.
-
Write a Simple Go Application to work with Zoho Creator Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zoho Creator.
-
Visualize Copper Data in Tableau
The CData ODBC driver for Copper enables you integrate Copper into Tableau dashboards.
-
Import and Visualize Wistia Data in Power View
Create data visualizations based on Wistia in Excel.
-
Connect to YouTube Analytics Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for YouTube Analytics.
-
How to Query Cohere Data in MySQL Workbench
Execute MySQL queries against live Cohere from MySQL Workbench.
-
Use Biml to Build SSIS Tasks to Replicate Recurly Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Recurly to SQL Server.
-
Connect to Vault CRM Data in Ruby
Connect to Veeva Vault & Vault CRM in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Edit and Search SAP External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SAP ERP/NetWeaver to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SAP objects that you can access from apps and the dashboard.
-
Process & Analyze Pinecone Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Pinecone Data.
-
How to Visualize Bullhorn CRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live Bullhorn CRM in Python.
-
Analyze SAP Fieldglass Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP Fieldglass and visualize live SAP Fieldglass in Infragistics Reveal.
-
How to connect SharePoint with Adobe Analytics Data through external lists
Provide Adobe Analytics to SharePoint users as an external list.
-
Connect ZendeskSell to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ZendeskSell with IBM WebSphere for seamless data integration and connectivity.
-
Back Up Highrise CRM to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Highrise. In this article, we will employ an SSIS workflow to populate a database with Highrise CRM data.
-
Automate SAP Concur Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP Concur and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Viewing Brex Data in RAD Studio Data Explorer
How to view Brex in RAD Studio Data Explorer using the CData ODBC Driver for Brex.
-
Analyze Simplesat Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Simplesat with the CData JDBC Driver for Simplesat.
-
Natively Connect to eBay Data in PHP
The CData ODBC driver for eBay enables you to create PHP applications with connectivity to eBay. Leverage the native support for ODBC in PHP.
-
Build Data Flows from Zoho Creator to SQL Server using SSIS
Easily back up Zoho Creator to SQL Server using the SSIS components for Zoho Creator.
-
Design BIRT Reports on CloudConvert Data
Provide current CloudConvert to your embedded analytics.
-
Connect to Google Calendar Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Google Calendar from Filemaker Pro on Mac.
-
Use Manus AI to Talk to Your Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Oracle Sales.
-
Publish Foursquare-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Foursquare.
-
Connect to LDAP from Asprova with CData Software ODBC Driver for LDAP
This article shows how to connect faster to LDAP data from Asprova.
-
Access Live PingOne Data in Coginiti Pro
Connect to and query live PingOne from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze PabblySubscriptions Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze PabblySubscriptions with the CData JDBC Driver for PabblySubscriptions.
-
Access Live Keap Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Keap in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Live Zendesk Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Zendesk in CData Connect AI and connect to your Zendesk from PostgreSQL.
-
Build Voice Agents in ElevenLabs with access to Live SAP Fieldglass Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAP Fieldglass.
-
How to Easily Query Asana Data in OpenOffice Base
Connect to Asana data in OpenOffice Base using the CData ODBC Driver for Asana and generate reports with live data insights.
-
Visualize Live MYOB AccountRight Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MYOB AccountRight using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect to Browserless Data with Squirrel SQL client
Connect to Browserless and execute queries in the Squirrel SQL Client.
-
Automated Continuous Cvent Replication to Databricks
Use CData Sync for automated, continuous, customizable Cvent replication to Databricks.
-
Connect to Recurly Data in Jaspersoft Studio
Execute SQL to remote Recurly in Jaspersoft Studio.
-
How to Work with ScrapingBee Data in ETL Validator JDBC
Connect to ScrapingBee from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Work with CapsuleCRM Data in ETL Validator JDBC
Connect to CapsuleCRM from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Keep Microsoft Access Working After an ERP Cloud Migration
A guide on using the CData ODBC Driver to restore Microsoft Access connectivity after a cloud ERP migration to NetSuite, Acumatica, or Business Central, enabling finance teams to run existing queries against live ERP data without rebuilding workflows.
-
Query Microsoft OneDrive Data as a SQL Server Database in Node.js
Execute SQL Server queries against Microsoft OneDrive from Node.js.
-
Migrating data from Everhour to Databricks using CData SSIS Components.
Easily push Everhour to Databricks using the CData SSIS Tasks for Everhour and Databricks.
-
Natively Connect to Cvent Data in PHP
The CData ODBC driver for Cvent enables you to create PHP applications with connectivity to Cvent. Leverage the native support for ODBC in PHP.
-
Replicate Mouseflow Data from PowerShell
Write a quick PowerShell script to query Mouseflow. Use connectivity to the live data to replicate Mouseflow to SQL Server.
-
Connect to Authorize.Net Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Authorize.Net.
-
Moving Data from SAP Fieldglass to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP Fieldglass data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Visualize Live DB2 Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live IBM DB2 using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Gmail Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Gmail.
-
Connect to Pipeliner CRM Data in NetBeans
Connect to Pipeliner CRM in NetBeans with the data source configuration wizard.
-
How to Visualize SAP SuccessFactors Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live SAP SuccessFactors in Python.
-
Connecting Pipedream with Azure Data Lake Storage 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 Azure Data Lake Storage data in real time.
-
Load Retently Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Retently to a database.
-
How to Access PolarTeamPro Data Using Entity Framework
This article shows how to access PolarTeamPro using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
View Reports on Real-Time Adobe Analytics Data in Power BI Report Server
Use the CData ODBC Driver for Adobe Analytics to visualize Adobe Analytics in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect to Live Active Directory 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 Active Directory for you.
-
Choosing the Best Method to Connect AdRoll to SQL Server: 5 Options Explained
Discover multiple ways to connect and use AdRoll from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Oracle SCM Data from HeidiSQL
Use CData Connect AI to connect to and query live Oracle SCM from HeidiSQL.
-
Connect to Live Epicor Kinetic Data in MicroStrategy through CData Connect AI
Create a live connection to Epicor Kinetic Data in CData Connect AI and connect to your Epicor Kinetic from MicroStrategy.
-
Analyze Google Cloud Storage Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google Cloud Storage and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Hubstaff Data from PowerBuilder via ADO.NET
This article demonstrates how to access Hubstaff from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Replicate Helpscout Data in Heroku for Use in Salesforce Connect
Replicate Helpscout to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrating Claude Code with Cassandra Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Apache Cassandra within assisted coding and automated development workflows.
-
Use Manus AI to Talk to Your MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on MailChimp.
-
Excel Spreadsheet Automation on Microsoft Entra ID Data with the QUERY Formula
Pull data from Microsoft Entra ID, automate spreadsheets, and more with the QUERY formula.
-
Bind Live WordPress Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live WordPress data
-
How to Visualize Airtable Data in Python with pandas
Use pandas and other modules to analyze and visualize live Airtable in Python.
-
Use the CData Software JDBC Driver for Aircall in MicroStrategy Web
Connect to Aircall in MicroStrategy Web using the CData Software JDBC Driver for Aircall.
-
How to Work with Elasticsearch Data in AWS Glue Jobs Using JDBC
Connect to Elasticsearch from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
LINQ to Redshift 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 Redshift Data Provider.
-
Import Real-Time HubSpot Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use HubSpot in ColdFusion.
-
Connect to ConvertKit Data from PowerBuilder via JDBC
This article demonstrates how to access ConvertKit from PowerBuilder using the ConvertKit JDBC Driver.
-
How to Connect to & Open Google Campaign Manager 360 Data in Microsoft Excel
This article uses the CData ODBC driver for Google Campaign Manager 360 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
ETL Raisers Edge NXT in Oracle Data Integrator
This article shows how to transfer Raisers Edge NXT into a data warehouse using Oracle Data Integrator.
-
Edit and Search Bitbucket External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Bitbucket to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Bitbucket objects that you can access from apps and the dashboard.
-
Build Apps with Live Contentful Data Using the Low-Code Development Platform of Mendix
Connect Contentful with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Jira Assets Replication to SingleStore
Use CData Sync for automated, continuous, customizable Jira Assets replication to SingleStore.
-
How to load Todoist data into Elasticsearch via Logstash
Introducing a simple method to load Todoist data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate GitHub with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate GitHub with External Services.
-
Migrating data from Sendwithus to Snowflake using CData SSIS Components.
Easily push Sendwithus to Snowflake using the CData SSIS Tasks for Sendwithus and Snowflake.
-
Build a Simple VCL Application for JobNimbus Data
How to build a simple VCL Application to view JobNimbus in RAD Studio using the CData ODBC Driver for JobNimbus.
-
Integrating Gumloop with Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Acumatica ERP within automated workflows.
-
Process & Analyze Google Cloud Storage Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Cloud Storage Data.
-
Access Redshift Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Amazon Redshift.