CData Software - Knowledge Base
Recent Articles
-
How to connect PolyBase to Dynamics 365 Business Central
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Dynamics 365 Business Central data.
-
Automated Continuous Google Forms Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Google Forms replication to AlloyDB.
-
Create Data Visualizations Based On SAP HANA XS Advanced Data in Mode
Use CData Connect AI to connect to SAP HANA XS Advanced Data from Mode and build visualizations using live SAP HANA XS Advanced data.
-
How to connect to Omnisend Data from Spring Boot
Connect to Omnisend in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous Adobe Target Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Adobe Target replication to Google BigQuery.
-
Working with Opsgenie Data in LINQPad
Execute LINQ queries to Opsgenie data in LINQPad.
-
Use CData Connect AI to Access SendPulse Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SendPulse data in the Power Pivot business intelligence tool.
-
Analyze iContact Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of iContact data and visualize live iContact data in Infragistics Reveal.
-
Integrate Cursor with Live Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Act CRM data from within the editor.
-
Access Live SAP Concur Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP Concur data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Query Teamwork Data in DataGrip
Create a Data Source for Teamwork in DataGrip and use SQL to query live Teamwork data.
-
Build Google Campaign Manager 360-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Campaign Manager 360 data.
-
Connect to IBM Cloud Object Storage Data in ACL Analytics
Connect to IBM Cloud Object Storage data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to IBM Cloud Object Storage data.
-
Integrate Live Gong Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Gong from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Gong data.
-
Integrate Adobe Target Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Adobe Target data from Informatica Cloud.
-
How to Create Power BI Visual Reports with Real-Time OneNote Data
Use CData Power BI Connectors to visualize OneNote data in Power BI.
-
Connect to Live ServiceNow Data in MicroStrategy through CData Connect AI
Create a live connection to ServiceNow Data in CData Connect AI and connect to your ServiceNow data from MicroStrategy.
-
Use the CData ODBC Driver for Bannerbear in Microsoft Power Query
You can use the CData Bannerbear ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Bannerbear data into Microsoft Power Query.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Parallel
Provide connectivity to Parallel data through an SAP BusinessObjects universe.
-
Deploy the ADO.NET Provider for Square on an SSRS Report Server
Connect to Square data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect to LightSpeedRetail Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to LightSpeedRetail.
-
How to import Email Data into Apache Solr
Use the CData Software JDBC Driver for Email in Data Import Handler and create an automated import of Email data to Apache Solr Enterprise Search platform.
-
A PostgreSQL Interface for MailChimp Data (MySQL Remoting via JDBC)
Use the Remoting features of the MailChimp JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Excel Add-In for Azure Synapse
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Azure Synapse.
-
How to connect Amazon QuickSight to Kafka Data
Create a connection to Kafka data in CData Connect AI and insert Kafka data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Connect to Live Quickbase 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 Quickbase data for you.
-
Natively Connect to Coda Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Coda data. Leverage the native support for ODBC in PHP.
-
Automated Continuous ADP Replication to Vertica
Use CData Sync for automated, continuous, customizable ADP replication to Vertica.
-
Access Recurly Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Recurly data from HeidiSQL.
-
Feed Tanda Data into FineReport
How to set Tanda data as a JDBC data source in FineReport.
-
Working with Guru Data in LINQPad
Execute LINQ queries to Guru data in LINQPad.
-
Integrate with live Impala Data in Jitterbit
Use CData Connect AI to connect to and integrate live Impala data in Jitterbit.
-
Connect Ontraport to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Ontraport with IBM WebSphere for seamless data integration and connectivity.
-
Migrating data from Qualaroo to Snowflake using CData SSIS Components.
Easily push Qualaroo data to Snowflake using the CData SSIS Tasks for Qualaroo and Snowflake.
-
Use Agno to Talk to Your Perplexity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Perplexity data for you.
-
How to work with Google Contacts Data in Apache Spark using SQL
Access and process Google Contacts Data in Apache Spark using the CData Software JDBC Driver.
-
Visualize Live Amazon Athena Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Amazon Athena data into custom reports in Power BI.
-
Use the CData Software ODBC Driver for Pipedrive in MicroStrategy Web
Connect to Pipedrive data in MicroStrategy Web using the CData Software ODBC Driver for Pipedrive.
-
Design a Custom SAP Function Module to Circumvent RFC_READ_TABLE Limitations
The RFC_READ_TABLE function enables you to get data from SAP tables, but limits retrieving transaction records to 512 bytes. You can use the CData ADO.NET Provider for SAP to circumvent this by defining a custom SAP function module that will allow to retrieve data as you would with any ADO.NET data source.
-
Connect to NetSuite Data in CloverDX (formerly CloverETL)
Transfer NetSuite data using the visual workflow in the CloverDX data integration tool.
-
Create Datasets from AfterShip in Domo Workbench and Build Visualizations of AfterShip Data in Domo
Use the CData Software ODBC Driver for AfterShip to create datasets from AfterShip data in Domo Workbench and then build visualizations in the Domo service.
-
Query FTP Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume FTP entities in PHP by modeling them as objects.
-
Seamlessly Bring Vertica Data into Retool Using CData Connect AI
Integrate Vertica data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Getting Started with the CData Tableau Connector for Active Directory
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Active Directory.
-
Analyze Box Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Box data and visualize Box data in SAP Analytics Cloud.
-
Integrate Mocean Data in Pentaho Data Integration
Build ETL pipelines based on Mocean data in the Pentaho Data Integration tool.
-
Automated Continuous MariaDB Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable MariaDB replication to Apache Cassandra.
-
Prepare, Blend, and Analyze Placid Data in Alteryx Designer (ODBC)
Build workflows to access live Placid data for self-service data analytics.
-
Analyze Microsoft OneDrive Data in Looker
Use CData Connect AI to connect to Microsoft OneDrive Data from Looker and build custom apps using live Microsoft OneDrive data.
-
Access Live GetResponse Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to GetResponse data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate with BigCommerce Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy BigCommerce data to a JSON file on disk.
-
Connect to SparkPost Data in Aqua Data Studio
Access SparkPost data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build a PostgreSQL Interface for Excel Data using the CData JDBC Driver
Use the Remoting features of the Excel JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect Flowise AI Agents to Live Google Ad Manager Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Google Ad Manager data without replication.
-
Connect to Avalara AvaTax Data in RapidMiner
Integrate Avalara AvaTax data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData ODBC Driver for Oracle in Microsoft Power Query
You can use the CData Oracle ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Oracle data into Microsoft Power Query.
-
How to Access Live XML Data in Power Automate Desktop via ODBC
The CData ODBC Driver for XML enables you to integrate XML data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Open WebUI with Live SAP HANA XS Advanced Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP HANA XS Advanced data from within the chat interface.
-
Access BenchmarkEmail Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access BenchmarkEmail data from your Oracle system.
-
Create Neo4J-Connected Dashboards in Grafana
Connect to Neo4J Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Neo4J data.
-
Connect Perplexity to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Perplexity data using the CData Python MCP Server.
-
Build Sage 300-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Sage 300 Data from Zoho Analytics and import live Sage 300 data.
-
Connect to Live Zoho Inventory Data in MicroStrategy through CData Connect AI
Create a live connection to Zoho Inventory Data in CData Connect AI and connect to your Zoho Inventory data from MicroStrategy.
-
Connect to Beeminder Data in HULFT Integrate
Connect to Beeminder as a JDBC data source in HULFT Integrate
-
How to Visualize BambooHR 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 BambooHR data in Python.
-
Build Data Flows from Google Ads to SQL Server using SSIS
Easily back up Google Ads data to SQL Server using the SSIS components for Google Ads.
-
How to Connect DBeaver to Dynamics CRM via a JDBC Driver
Manage Dynamics CRM data with visual tools in DBeaver like the query browser.
-
Creating Quickbase-Connected Applications in Unqork
You can use CData Connect AI to feed Quickbase data to Unqork and build custom business apps.
-
Connect to GitLab Data in Google Apps Script via Connect AI
Use CData Connect AI to access GitLab data in Google Apps Script.
-
Build Dashboards with GitHub Data in DBxtra
Create dynamic dashboards and perform analytics based on GitHub data in DBxtra.
-
Deploy the ADO.NET Provider for SQL Analysis Services on an SSRS Report Server
Connect to SQL Analysis Services data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Work with Live Optimizely Data in Power Query
Use CData Connect AI to connect to Optimizely data and work with live Optimizely data in Microsoft Power Query.
-
Integrate Trae with Live HBase Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live HBase data from within the AI-powered IDE.
-
Create LinkedIn-Connected Nintex Workflows
Use CData Connect AI to connect to LinkedIn Data from Nintex Workflow Cloud and build custom workflows using live LinkedIn data.
-
Access Live Adobe Analytics Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Adobe Analytics data into the statistical analysis tools available in SAS JMP. This article shows how to use Adobe Analytics data in the Graph Builder and Query Builder.
-
Access SharePoint Data from MySQL in PHP
Connect to SharePoint through the standard MySQL libraries in PHP.
-
Getting Started with the CData Python Connector for CloudConvert
Learn to install and license the CData Python Connector and configure a connection to live CloudConvert data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Elasticsearch
Provide connectivity to Elasticsearch data through an SAP BusinessObjects universe.
-
Use JayDeBeApi to access Office 365 Data in Python
Use standard Python scripting and the development environment of your choice to access live Office 365 data.
-
How to Connect to Intercom Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Intercom data. Leverage the pyodbc module for ODBC in Python.
-
Basecamp Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Basecamp data through CData Connect AI using different applications and tools.
-
Visualize SparkPost 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 SparkPost data into TIBCO Spotfire.
-
Connect to Timely Data in Ruby
Connect to Timely data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect and Visualize Live Klaviyo Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Klaviyo data into the Databricks platform and create visualization dashboards with real-time Klaviyo data.
-
Integrating Claude Code CLI with Oracle HCM Cloud 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 Outlook Data in HULFT Integrate
Connect to Outlook as a JDBC data source in HULFT Integrate
-
How to integrate Trello with Apache Airflow
Access and process Trello data in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Auth0 Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Auth0 replication to Amazon Redshift.
-
Import Real-Time DocuSign Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use DocuSign data in ColdFusion.
-
Build Automated Amazon S3-Connected Workflows in Zapier
Use CData Connect AI to connect to live Amazon S3 data and build automated workflows in Zapier.
-
Create Informatica Mappings From/To an ODBC Data Source for SendPulse
Create an ODBC connection to SendPulse in Informatica and browse and transfer SendPulse data.
-
Automated Continuous ClickTime Replication to Vertica
Use CData Sync for automated, continuous, customizable ClickTime replication to Vertica.
-
Import and Visualize FormSite Data in Power View
Create data visualizations based on FormSite data in Excel.
-
Integrate Live Vertica Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Vertica data and integrate live Vertica data into apps built in Microsoft Power Apps.
-
Build AI/ML Models with Live Snapchat Ads Data using Dataiku
Connect Snapchat Ads Data with Dataiku using the CData JDBC Driver for Snapchat Ads.
-
Bridge Email Connectivity with Apache NiFi
Access and process Email data in Apache NiFi using the CData JDBC Driver.
-
How to Visualize Xero Data in Python with pandas
Use pandas and other modules to analyze and visualize live Xero data in Python.
-
Migrating data from HubSpot to Snowflake using CData SSIS Components.
Easily push HubSpot data to Snowflake using the CData SSIS Tasks for HubSpot and Snowflake.
-
How to work with Microsoft OneDrive Data in Apache Spark using SQL
Access and process Microsoft OneDrive Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Bannerbear Data Replication to Teradata
Use CData Sync to Customize and automate Bannerbear data replication to Teradata.