CData Software - Knowledge Base
Recent Articles
-
Connect to SingleStore Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SingleStore in the Denodo Virtual DataPort Administrator.
-
Integrate HubSpot Data in the Pentaho Report Designer
Publish reports based on HubSpot in the Pentaho BI tool.
-
Query, Visualize, and Share live Dynamics CRM Data in Redash
Use CData Connect AI to connect to live Microsoft Dynamics CRM in Redash for querying, visualizing, and sharing.
-
Access Live Smartsheet Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Smartsheet in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access SAP Ariba Source Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP Ariba Source from your Oracle system.
-
Connect to Oracle Service Cloud Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle Service Cloud and the Script function in FileMaker Pro to connect to Oracle Service Cloud and work with Oracle Service Cloud in your FileMaker application.
-
Getting Started with the CData JDBC Driver for Timely
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Timely.
-
Excel Spreadsheet Automation on Google Cloud Storage Data with the QUERY Formula
Pull data from Google Cloud Storage, automate spreadsheets, and more with the QUERY formula.
-
Access Short.io Data from MySQL in Amazon QuickSight
Connect to Short.io and build visualizations of Short.io using a MySQL Connection in Amazon QuickSight.
-
Integrate Live Microsoft OneDrive Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft OneDrive to Blue Prism using the CData ODBC Driver for Microsoft OneDrive to create automated workflows for repetitive business tasks.
-
Connect to Stack Exchange Data in NetBeans
Connect to Stack Exchange in NetBeans with the data source configuration wizard.
-
Build Visualizations of OnePageCrm Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of OnePageCrm in Birst.
-
Use the CData API Server to Access SAP Fieldglass Data in Microsoft PowerPivot
Use the CData API Server to connect to live SAP Fieldglass in the Power Pivot business intelligence tool.
-
Query, Visualize, and Share live Microsoft Teams Data in Redash
Use CData Connect AI to connect to live Microsoft Teams in Redash for querying, visualizing, and sharing.
-
Build Dashboards with Google Cloud Storage Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Cloud Storage in Dundas BI.
-
Create SSAS Tabular Models from Marketo Data
How to build a SQL Server Analysis Service Tabular Model from Marketo using CData drivers.
-
How to Connect to Live ShipStation Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your ShipStation for you.
-
Build Oracle-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Oracle Database.
-
Integrating LangChain with Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Workday within automated workflows.
-
Connect to Vimeo Data in CloverDX (formerly CloverETL)
Transfer Vimeo using the visual workflow in the CloverDX data integration tool.
-
Analyze Microsoft Teams Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft Teams and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Paylocity Data in the Pentaho Report Designer
Publish reports based on Paylocity in the Pentaho BI tool.
-
Build a Singer.io Tap for SuiteCRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SuiteCRM data using
-
Use Biml to Build SSIS Tasks to Replicate Salesforce Pardot Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Salesforce Pardot to SQL Server.
-
Integrate Real-Time Access to Azure Table in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Azure Table Storage in real time.
-
View Reports on Real-Time SAP HANA XS Advanced Data in Power BI Report Server
Use the CData ODBC Driver for SAP HANA XS Advanced to visualize SAP HANA XS Advanced in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect and process QuickBooks Time from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live QuickBooks Time.
-
Integrate Redshift Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Amazon Redshift from Informatica Cloud.
-
Working with Typeform Data in LINQPad
Execute LINQ queries to Typeform in LINQPad.
-
Extract, Transform, and Load Anaplan Data in Informatica PowerCenter
Create a simple Workflow for Anaplan in Informatica PowerCenter.
-
Integrating Claude Code CLI with CouchDB 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.
-
Migrating data from Access to Snowflake using CData SSIS Components.
Easily push Microsoft Access to Snowflake using the CData SSIS Tasks for Access and Snowflake.
-
Integrate Quickbase with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Quickbase with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Quickbase.
-
Query SparkPost Data as a MySQL Database in Node.js
Execute MySQL queries against SparkPost from Node.js.
-
Build a PostgreSQL Interface for Slack Data using the CData JDBC Driver
Use the Remoting features of the Slack JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Scrapfly Data as a MySQL Database in Node.js
Execute MySQL queries against Scrapfly from Node.js.
-
Build MVC Applications with Connectivity to Clio Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Clio from an ASP.NET MVC application.
-
Enable the SparkPost JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SparkPost.
-
Work with Chargebee Data in FoxPro
Load Chargebee into a FoxPro database. This article includes full code and a walk-through of the process.
-
Write a Simple Go Application to work with Procore Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Procore.
-
Automated Continuous DB2 Replication to Snowflake
Use CData Sync for automated, continuous, customizable DB2 replication to Snowflake.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live WordPress using the Model Context Protocol.
-
How to connect and process Basecamp from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Basecamp.
-
Build Pipelines with Live SAP Hybris C4C Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP Hybris C4C from Google Cloud Data Fusion, enabling the integration of live SAP Hybris C4C into the building and management of effective data pipelines.
-
Visualize Live IBM Cloud Object Storage Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live IBM Cloud Object Storage into custom reports in Power BI.
-
Configure the CData JDBC Driver for ZohoExpense in a Connection Pool in Tomcat
Connect to ZohoExpense from a connection pool in Tomcat.
-
Migrating data from Vault CRM to Snowflake using CData SSIS Components.
Easily push Veeva Vault & Vault CRM to Snowflake using the CData SSIS Tasks for Vault CRM and Snowflake.
-
Connect to Suadeo Data in DBArtisan
Use wizards in DBArtisan to configure Suadeo as a data source.
-
Prepare, Blend, and Analyze Omnisend Data in Alteryx Designer (ODBC)
Build workflows to access live Omnisend for self-service data analytics.
-
Enable the PhantomBuster JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with PhantomBuster.
-
Integrate with Jira Assets Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Jira Assets in SnapLogic.
-
Integrate Microsoft Teams Data into Power Automate Desktop using CData Connect
CData Connect for Microsoft Teams Data enables you to integrate Microsoft Teams into workflows built using Microsoft Power Automate Desktop.
-
Connect to Mixpanel Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Mixpanel and the SQL Gateway to access Mixpanel from Google Apps Script.
-
Build Dashboards with Google Spanner Data in DBxtra
Create dynamic dashboards and perform analytics based on Google Spanner in DBxtra.
-
How to Work with Everhour Data in ETL Validator JDBC
Connect to Everhour from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Connect AI Python SDK for AlloyDB
Install the CData Connect AI Python SDK to read and write live Google AlloyDB with standard DB-API 2.0 Python code.
-
Natively Connect to SendPulse Data in PHP
The CData ODBC driver for SendPulse enables you to create PHP applications with connectivity to SendPulse. Leverage the native support for ODBC in PHP.
-
Automated Continuous LinkedIn Ads Replication to MySQL
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to MySQL.
-
Migrating data from Email to Snowflake using CData SSIS Components.
Easily push Email to Snowflake using the CData SSIS Tasks for Email and Snowflake.
-
Replicate FreshBooks Data in Heroku for Use in Salesforce Connect
Replicate FreshBooks to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Stream SendPulse Data into Apache Kafka Topics
Access and stream SendPulse in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Drip Data in Tableau
The CData ODBC driver for Drip enables you integrate Drip into Tableau dashboards.
-
DataBind Controls to Jira Assets Data in Delphi
DataBind to Jira Assets in Delphi with standard data access components and controls.
-
Connect to Mode Data in Jaspersoft Studio
Execute SQL to remote Mode in Jaspersoft Studio.
-
Create Datasets from Flowlu in Domo Workbench and Build Visualizations of Flowlu Data in Domo
Use the CData Software ODBC Driver for Flowlu to create datasets from Flowlu in Domo Workbench and then build visualizations in the Domo service.
-
Query SAP Fieldglass Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP Fieldglass entities in PHP by modeling them as objects.
-
Getting Started with the CData SSIS Components for SAP BusinessObjects BI
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP BusinessObjects BI.
-
Integrate Azure Table Data into Power Automate Desktop using CData Connect
CData Connect for Azure Table Data enables you to integrate Azure Table Storage into workflows built using Microsoft Power Automate Desktop.
-
Analyze Adobe Experience Manager Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Adobe Experience Manager in Microsoft R Open.
-
Automated Continuous Greenhouse Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Greenhouse replication to Amazon S3.
-
How to create an RPA flow for GetResponse Data in UiPath Studio
Use the GetResponse ODBC Driver to create workflows that access real-time GetResponse without any coding.
-
How to Access Gmail Data Using Entity Framework
This article shows how to access Gmail using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Procore Replication to Snowflake
Use CData Sync for automated, continuous, customizable Procore replication to Snowflake.
-
Import and Visualize Aha! Data in Power View
Create data visualizations based on Aha! in Excel.
-
Use Dash to Build to Web Apps on Vimeo Data
Create Python applications that use pandas and Dash to build Vimeo-connected web apps.
-
Create ChartMogul Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ChartMogul from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build a PostgreSQL Interface for Contentful Data using the CData JDBC Driver
Use the Remoting features of the Contentful JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Exa Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Exa.
-
Connect to Sage Cloud Accounting Data in JRuby
Create a simple JRuby app with access to live Sage Business Cloud Accounting.
-
Build a Singer.io Tap for Pinterest With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Pinterest data using
-
How to Seamlessly Import Odoo Data into IBM SPSS Modeler
Integrate Odoo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Voice Agents in ElevenLabs with access to Live Google Drive Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Drive.
-
Use the CData Software JDBC Driver for DocuSign in MicroStrategy Desktop
Connect to DocuSign in MicroStrategy Desktop using the CData Software JDBC Driver for DocuSign.
-
Access Email Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Email from HeidiSQL.
-
Getting Started with the CData SSIS Components for Impala
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Impala.
-
Create Apps from SAP SuccessFactors LMS Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP SuccessFactors LMS Data and build apps from live SAP SuccessFactors LMS in Qlik Sense Cloud.
-
A PostgreSQL Interface for Webex Data (MySQL Remoting via JDBC)
Use the Remoting features of the Webex JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Oracle Eloqua using the Model Context Protocol.
-
A PostgreSQL Interface for Shortcut Data using the CData ODBC Driver
Use the SQL Gateway and Shortcut ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect Sage 300 to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sage 300 using the CData Python MCP Server.
-
Build a Singer.io Tap for NetSuite With the CData Python Connector
Learn how to easily build a Singer.io Tap for live NetSuite data using
-
Query Sage Cloud Accounting Data in DataGrip
Create a Data Source for Sage Cloud Accounting in DataGrip and use SQL to query live Sage Business Cloud Accounting.
-
Integrate Real-Time Access to IBM Cloud Object Storage in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to IBM Cloud Object Storage in real time.
-
How to create an RPA flow for Grafana Data in UiPath Studio
Use the Grafana ODBC Driver to create workflows that access real-time Grafana without any coding.
-
Connect EnterpriseDB Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your EnterpriseDB using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData Python Connector for Sentry
Learn to install and license the CData Python Connector
-
Getting Started with the CData Excel Add-In for Oracle Eloqua Reporting
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Oracle Eloqua Reporting.
-
Getting Started with the CData ODBC Driver for Google Ad Manager
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Ad Manager.
-
Create Google Drive-Connected Dashboards in Grafana
Connect to Google Drive Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Drive.
-
Migrating data from Demio to Databricks using CData SSIS Components.
Easily push Demio to Databricks using the CData SSIS Tasks for Demio and Databricks.