CData Software - Knowledge Base
Recent Articles
-
Connect to Supabase Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Supabase as an External Source in Dremio.
-
Use Manus AI to Talk to Your SageHR 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 SageHR data.
-
Access CircleCI Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live CircleCI data from HeidiSQL.
-
Connect to Amazon Athena Data in RazorSQL
Connect to Amazon Athena from wizards and query Amazon Athena data from the GUI in the RazorSQL database management tool.
-
Use the CData Software ODBC Driver for Teradata in MicroStrategy
Connect to Teradata data in MicroStrategy Developer using the CData Software ODBC Driver for Teradata.
-
Integrate with Elasticsearch Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Elasticsearch data to a JSON file on disk.
-
Integrate PDFMonkey with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PDFMonkey with External Services.
-
Access Live SAP Hybris C4C Data in TIBCO Data Virtualization
Use the SAP Hybris C4C Tibco DV Adapter to create a SAP Hybris C4C data data source in TIBCO Data Virtualization Studio and gain access to live SAP Hybris C4C data from your TDV Server.
-
Create Apps from ADP Data in Qlik Sense Cloud
Use CData Connect AI to connect to ADP Data and build apps from live ADP data in Qlik Sense Cloud.
-
Connect to AfterShip Data in Jaspersoft Studio
Execute SQL to remote AfterShip data in Jaspersoft Studio.
-
Use the CData Software ODBC Driver for BenchmarkEmail in SAS for Real-Time Reporting and Analytics
Connect to real-time BenchmarkEmail data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for BenchmarkEmail.
-
Query NetSuite Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume NetSuite entities in PHP by modeling them as objects.
-
Back Up Sybase data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sybase. In this article, we will employ an SSIS workflow to populate a database with Sybase data data.
-
Integrate Live CSV Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to CSV from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live CSV data.
-
Configure the CData JDBC Driver for Apify in a Connection Pool in Tomcat
Connect to Apify data from a connection pool in Tomcat.
-
Access Live Superchat Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Superchat data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect Wistia 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 Wistia data in real time using natural language.
-
How to work with Front Data in Apache Spark using SQL
Access and process Front Data in Apache Spark using the CData Software JDBC Driver.
-
Build Semantic Layer Views for Reckon Data in APOS Live Data Gateway
Use the CData Connector for Reckon in APOS Live Data Gateway to build Semantic Layer Views for Reckon data.
-
Publish Active Directory-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Active Directory data.
-
Integrating Boomi Agentstudio with Google Campaign Manager 360 Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Campaign Manager 360 data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Process & Analyze iContact Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live iContact Data.
-
Configure the CData JDBC Driver for Smartsheet in a Connection Pool in Tomcat
Connect to Smartsheet data from a connection pool in Tomcat.
-
Integrate Live Snowflake Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Snowflake data and integrate live Snowflake data into apps built in Microsoft Power Apps.
-
Access Oracle Service Cloud Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Oracle Service Cloud data from your Oracle system.
-
Model eBay Analytics Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and eBay Analytics, enabling the direct import of real-time eBay Analytics data.
-
How to publish and share Basecamp Data dashboards with Tableau Server
The CData ODBC driver for Basecamp enables you integrate Basecamp data into Tableau dashboards.
-
Create Apps from Mailgun Data in Qlik Sense Cloud
Use CData Connect AI to connect to Mailgun Data and build apps from live Mailgun data in Qlik Sense Cloud.
-
Query Aweber Data as a SQL Server Database in Node.js
Execute SQL Server queries against Aweber data from Node.js.
-
Integrating GitHub Copilot with Mouseflow 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.
-
Google Sheets Reporting in OBIEE with the Google Sheets JDBC Driver
Deploy the Google Sheets JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build MVC Applications with Connectivity to CSV Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access CSV from an ASP.NET MVC application.
-
Build ShipEngine-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for ShipEngine Data and create custom apps in Mendix.
-
Use the CData Software ODBC Driver for Dynamics 365 Business Central in MicroStrategy Web
Connect to Dynamics 365 Business Central data in MicroStrategy Web using the CData Software ODBC Driver for Dynamics 365 Business Central.
-
Connect to Landbot Data in CloverDX (formerly CloverETL)
Transfer Landbot data using the visual workflow in the CloverDX data integration tool.
-
Connect to Notion Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Notion Data and connect to Notion data in Akorbi Digital RunMyProcess.
-
Migrating data from Parquet to Databricks using CData SSIS Components.
Easily push Parquet data to Databricks using the CData SSIS Tasks for Parquet and Databricks.
-
Replicate FreeAgent Data to Multiple Databases via the CData Sync CLI
Replicate FreeAgent data to disparate databases with a single configuration.
-
Automated Continuous SparkPost Replication to MongoDB
Use CData Sync for automated, continuous, customizable SparkPost replication to MongoDB.
-
Connect to RSS Feeds in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to RSS.
-
How to Access Pinterest Data Using Entity Framework
This article shows how to access Pinterest data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build a Singer.io Tap for REST With the CData Python Connector
Learn how to easily build a Singer.io Tap for live REST data using the CData Python Connector.
-
How to connect to Rebilly Data in DBVisualizer
Integrate Rebilly data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect the Power BI Service to Okta: Complete Guide
Connect to the CData Software Power BI Connector for Okta from PowerBI.com to provide real-time Okta data across the organization.
-
Create DocuSign-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to DocuSign Data from OutSystems and build custom enterprise apps using live DocuSign data.
-
Access Microsoft OneDrive 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 Microsoft OneDrive data.
-
Add Chargebee Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Chargebee with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Live Airtable Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Airtable data from within the IDE.
-
Build Automated Freshdesk-Connected Workflows in Zapier
Use CData Connect AI to connect to live Freshdesk data and build automated workflows in Zapier.
-
Use the CData Software JDBC Driver for Google Directory in MicroStrategy
Connect to Google Directory data in MicroStrategy Developer using the CData Software JDBC Driver for Google Directory.
-
How to Connect to Live Bitly Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Bitly data for you.
-
Use the CData Software ODBC Driver for Microsoft OneDrive in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft OneDrive data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Microsoft OneDrive.
-
Connect to BenchmarkEmail Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for BenchmarkEmail to connect to BenchmarkEmail data and execute queries in PowerBuilder.
-
Integrating Boomi Agentstudio with Reckon Accounts Hosted Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Reckon Accounts Hosted data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Create Reports with Twitter Ads Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Twitter Ads data.
-
Analyze Zoho Creator Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Zoho Creator data and visualize Zoho Creator data in SAP Analytics Cloud.
-
Manage ElevenLabs Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ElevenLabs.
-
Model, Search, and Visualize Live Azure Synapse Data in ThoughtSpot
Use CData Connect AI to connect to live Azure Synapse data for modeling, searching, and visualizing.
-
Access Shortcut Data from MySQL in PHP
Connect to Shortcut through the standard MySQL libraries in PHP.
-
How to Access Retently Data Using Entity Framework
This article shows how to access Retently data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automate HDFS Data Replication to Azure Synapse
Use CData Sync to customize and automate HDFS data replication to Azure Synapse.
-
Use Biml to Build SSIS Tasks to Replicate Invoiced Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Invoiced data to SQL Server.
-
How to Connect to & Open Samanage Data in Microsoft Excel
This article uses the CData ODBC driver for Samanage to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Live Adobe Target Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Adobe Target data from within the IDE.
-
DataBind Charts to Oracle Eloqua Reporting Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Eloqua Reporting data 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.
-
ETL Amazon S3 in Oracle Data Integrator
This article shows how to transfer Amazon S3 data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Teamgate Replication to Snowflake
Use CData Sync for automated, continuous, customizable Teamgate replication to Snowflake.
-
Create a Data Access Object for Bitly Data using JDBI
A brief overview of creating a SQL Object API for Bitly data in JDBI.
-
Connect to Microsoft Ads Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Ads data in DBeaver.
-
How to connect to Beeminder Data from IntelliJ
Integrate connectivity to Beeminder data with wizards in IntelliJ.
-
Connect to LinkedIn Ads Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for LinkedIn Ads data in Airbyte.
-
Connecting Mastra with Google Contacts Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Google Contacts data, no replication required.
-
Use Claude to Talk to Your MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your MySQL data for you.
-
Import and Visualize PhantomBuster Data in Power View
Create data visualizations based on PhantomBuster data in Excel.
-
How to connect and process Parallel data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Parallel data.
-
Connect to Freshteam Data from AWS Glue
Use CData Connect AI to gain access to live Freshteam data from your AWS Glue jobs.
-
Visualize Google Campaign Manager 360 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Campaign Manager 360 data.
-
How to publish and share Zendesk Data dashboards with Tableau Server
The CData ODBC driver for Zendesk enables you integrate Zendesk data into Tableau dashboards.
-
Automated Continuous Apollo Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Apollo replication to delimited files (CSV/TSV).
-
How to connect and process Teradata data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Teradata data.
-
Integrating Antigravity CLI with ElevenLabs data via CData CLI
Connect ElevenLabs data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous MariaDB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable MariaDB replication to Azure SQL Database.
-
How to Work with ActiveCampaign Data in ETL Validator JDBC
Connect to ActiveCampaign from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Pipeline CRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to IBM DB2.
-
Edit and Search External Google Sheets Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Sheets data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Sheets Data objects that you can access from apps and the dashboard.
-
Use the CData ODBC Driver for SAP Business One in Microsoft Power Query
You can use the CData SAP Business One ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP Business One data into Microsoft Power Query.
-
How to Connect to YouTube Analytics Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to YouTube Analytics data. Leverage the pyodbc module for ODBC in Python.
-
Build PDFMonkey-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to PDFMonkey data and build web apps with connectivity to live PDFMonkey data.
-
Getting Started with the CData SSIS Components for Quaderno
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Quaderno.
-
A PostgreSQL Interface for Dropbox Data using the CData ODBC Driver
Use the SQL Gateway and Dropbox ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Apps from Oracle Service Cloud Data in Qlik Sense Cloud
Use CData Connect AI to connect to Oracle Service Cloud Data and build apps from live Oracle Service Cloud data in Qlik Sense Cloud.
-
Replicate Confluence Data in Heroku for Use in Salesforce Connect
Replicate Confluence data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to TigerGraph Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for TigerGraph and the Script function in FileMaker Pro to connect to TigerGraph and work with TigerGraph data in your FileMaker application.
-
Consume Microsoft Entra ID OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Microsoft Entra ID feeds that reflect any changes in SAP Lumira.
-
Visualize Grafana Data in Sisense
Create an ElastiCube in Sisense app with access to Grafana data.
-
Replicate Multiple Avro Accounts
Replicate multiple Avro accounts to one or many databases.
-
Publish Oracle-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Oracle data.
-
Create SAS xpt-Connected Applications in Appsmith
Connect to SAS xpt Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAS xpt data.
-
Enable the Oracle Eloqua Reporting JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Oracle Eloqua Reporting data.
-
Visualize Couchbase Data in TIBCO Spotfire through OData
Integrate Couchbase data into dashboards in TIBCO Spotfire.