CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for Azure Data Catalog in MicroStrategy
Connect to Azure Data Catalog data in MicroStrategy Developer using the CData Software ODBC Driver for Azure Data Catalog.
-
Migrating data from BenchmarkEmail to Snowflake using CData SSIS Components.
Easily push BenchmarkEmail data to Snowflake using the CData SSIS Tasks for BenchmarkEmail and Snowflake.
-
Integrate Goose with Live Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Smartsheet data from within the local AI agent.
-
Visualize Live Amazon Athena Data in the Power BI Service
Use CData Connect AI to connect to live Amazon Athena data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Power BI Reports on Real-Time Billsby Data
Use the CData ODBC Driver for Billsby to visualize Billsby data in Power BI Desktop.
-
How to Query Procore Data in MySQL Workbench
Execute MySQL queries against live Procore data from MySQL Workbench.
-
Connect to Bullhorn CRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Bullhorn CRM to connect to Bullhorn CRM data from Web applications running on WebLogic.
-
Build Automated Workflows with Live IBM Cloud Object Storage Data in Workato
Use CData Connect AI to connect to live IBM Cloud Object Storage data and build automated workflows in Workato.
-
Integrate with Demio Data in JReport Designer
Create charts and reports based on Demio data in JReport Designer.
-
Visualize JotForm Data in Sisense
Create an ElastiCube in Sisense app with access to JotForm data.
-
How to connect to Figshare Data from Spring Boot
Connect to Figshare in a Spring Boot Application using the CData API Driver for JDBC
-
Automate Deel Data Replication to SAP HANA
Use CData Sync to customize and automate Deel data replication to SAP HANA.
-
Visualize Presto Data in Sisense
Create an ElastiCube in Sisense app with access to Presto data.
-
Connect to Basecamp Data in Jaspersoft Studio
Execute SQL to remote Basecamp data in Jaspersoft Studio.
-
DataBind PagerDuty Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide PagerDuty data to a chart.
-
Create Informatica Mappings From/To an ODBC Data Source for Blackbaud FE NXT
Create an ODBC connection to Blackbaud FE NXT in Informatica and browse and transfer Blackbaud FE NXT data.
-
Moving Data from Clari to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Clari data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
ETL Attio in Oracle Data Integrator
This article shows how to transfer Attio data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous SendInBlue Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SendInBlue replication to Amazon S3.
-
Connect to Snapchat Ads from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Snapchat Ads data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Analyze Oracle Service Cloud Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Oracle Service Cloud data and visualize live Oracle Service Cloud data in Infragistics Reveal.
-
How to integrate Databricks with Apache Airflow
Access and process Databricks data in Apache Airflow using the CData JDBC Driver.
-
DataBind Oracle Eloqua Reporting Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Oracle Eloqua Reporting with the DevExpress Windows Forms and Web controls to provide Oracle Eloqua Reporting data to a chart.
-
Create LightSpeedRetail Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time LightSpeedRetail data access from reports, embedded analytics, and more.
-
Automated Continuous Notion Replication to SQLite
Use CData Sync for automated, continuous, customizable Notion replication to SQLite.
-
Natively Connect to Azure Analysis Services Data in PHP
The CData ODBC driver for Azure Analysis Services enables you to create PHP applications with connectivity to Azure Analysis Services data. Leverage the native support for ODBC in PHP.
-
Moving Data from SAP Business Warehouse to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP Business Warehouse data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Biml to Build SSIS Tasks to Replicate Testmonitor Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Testmonitor data to SQL Server.
-
How to Connect Flowise AI Agents to Live Amazon Marketplace 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 Amazon Marketplace data without replication.
-
Azure Synapse Reporting in OBIEE with the Azure Synapse JDBC Driver
Deploy the Azure Synapse JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Work with SQL Server Data in ETL Validator JDBC
Connect to SQL Server from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect to Microsoft Exchange Data from IntelliJ
Integrate connectivity to Microsoft Exchange data with wizards in IntelliJ.
-
Automated Continuous Close Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Close replication to Google BigQuery.
-
Connect to Sugar CRM Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Sugar CRM Data and connect to Sugar CRM data in Akorbi Digital RunMyProcess.
-
Access BenchmarkEmail Data from MySQL in Amazon QuickSight
Connect to BenchmarkEmail and build visualizations of BenchmarkEmail data using a MySQL Connection in Amazon QuickSight.
-
Visualize Live MailerLite Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live MailerLite data.
-
Replicate CampaignMonitor Data to Multiple Databases via the CData Sync CLI
Replicate CampaignMonitor data to disparate databases with a single configuration.
-
Getting Started with the CData ADO.NET Provider for PabblySubscriptions
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Validate Pingdom Data with QuerySurge
Access and validate Pingdom data in QuerySurge using the CData JDBC Driver.
-
Connect to SpaceX Data in Ruby
Connect to SpaceX data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Create Power BI Visual Reports with Real-Time Samanage Data
Use CData Power BI Connectors to visualize Samanage data in Power BI.
-
Use the CData ODBC Driver for Microsoft Entra ID from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Microsoft Entra ID to connect to Microsoft Entra ID data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Entra ID data in Excel.
-
Integrating Autopilot Data in Talend Cloud Data Management Platform
Connect Autopilot Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build Voice Agents in ElevenLabs with access to Live RSS Feeds
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live RSS feeds.
-
Publish Reports with Avalara AvaTax Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Avalara AvaTax data.
-
Automated Continuous Avalara AvaTax Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to delimited files (CSV/TSV).
-
Integrate BigCommerce with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate BigCommerce with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to BigCommerce data.
-
Analyze Vertica Data in Cognos Analytics
Use CData Connect AI to connect to Vertica Data from Cognos Analytics and analyze live Vertica data.
-
Work with Airtable Data in FoxPro
Load Airtable data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Perplexity Data from HeidiSQL
Use CData Connect AI to connect to and query live Perplexity data from HeidiSQL.
-
Use the CData Software ODBC Driver for Google Translate in MicroStrategy
Connect to Google Translate data in MicroStrategy Developer using the CData Software ODBC Driver for Google Translate.
-
How to Connect to Live WordPress Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your WordPress data through natural language.
-
Add BigQuery Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for BigQuery with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect to SAP Hybris C4C Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP Hybris C4C data. Leverage the pyodbc module for ODBC in Python.
-
Access LinkedIn Ads Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live LinkedIn Ads data from HeidiSQL.
-
Query HDFS Data through ODBC in Node.js
Use node-odbc to execute SQL queries against HDFS data from Node.js.
-
Connect to Aircall Data in JRuby
Create a simple JRuby app with access to live Aircall data.
-
A PostgreSQL Interface for ClickTime Data using the CData ODBC Driver
Use the SQL Gateway and ClickTime ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Easily Query PhantomBuster Data in OpenOffice Base
Connect to PhantomBuster data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build ZohoSubscriptions Visualizations in Tableau Cloud
Use CData Connect AI to connect to live ZohoSubscriptions data and build visualizations in Tableau Cloud.
-
Automated Continuous Smartsheet Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Smartsheet replication to Apache Cassandra.
-
Visualize Hugging Face Data in TIBCO Spotfire through ADO.NET
Integrate Hugging Face data into dashboards in TIBCO Spotfire.
-
Automated Continuous HelloSign Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable HelloSign replication to Apache Kafka.
-
ZohoPeople Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to ZohoPeople data through CData Connect AI using different applications and tools.
-
Getting Started with the CData Connect AI Python SDK for Testmonitor
Install the CData Connect AI Python SDK to read live Testmonitor data with standard DB-API 2.0 Python code.
-
How to Work with Drip Data in ETL Validator JDBC
Connect to Drip from ETL Validator jobs using the CData Software JDBC Driver.
-
LinkedIn Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to LinkedIn data through CData Connect AI using different applications and tools.
-
Build a Simple VCL Application for Apify Data
How to build a simple VCL Application to view Apify data in RAD Studio using the CData ODBC Driver for Apify.
-
Getting Started with the CData JDBC Driver for MailerSend
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for MailerSend.
-
Model SAS Data Sets Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAS Data Sets, enabling the direct import of real-time SAS Data Sets data.
-
Migrating data from Landbot to Databricks using CData SSIS Components.
Easily push Landbot data to Databricks using the CData SSIS Tasks for Landbot and Databricks.
-
Visualize NetSuite Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to NetSuite data.
-
Connect to JSON Services as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for JSON services.
-
Connect to MailChimp from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from MailChimp data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build AI Agents with Oracle Eloqua Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Oracle Eloqua data through CData Connect AI.
-
Phoenix Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Phoenix data through CData Connect AI using different applications and tools.
-
Access Shopify 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 Shopify data.
-
Automate Discord Data Replication to Azure Data Lake
Use CData Sync to customize and automate Discord data replication to Azure Data Lake.
-
Build Data Flows from Outlook to SQL Server using SSIS
Easily back up Outlook data to SQL Server using the SSIS components for Outlook.
-
Replicate Multiple SAP Concur Accounts
Replicate multiple SAP Concur accounts to one or many databases.
-
Connect to Todoist Data in CloverDX (formerly CloverETL)
Transfer Todoist data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Microsoft Exchange Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to Amazon Redshift.
-
Integrating GitHub Copilot with Pinecone 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.
-
Build Visualizations of SAP Concur Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP Concur data in Birst.
-
How to Seamlessly Import SAP Hybris C4C Data into IBM SPSS Modeler
Integrate SAP Hybris C4C data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Easily Integrate Adobe Analytics Data in Lazarus Pascal IDE
Learn how to easily integrate live Adobe Analytics data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Omnisend Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Omnisend data from Filemaker Pro on Mac.
-
Connect to MessageBird Data in NetBeans
Connect to MessageBird data in NetBeans with the data source configuration wizard.
-
Getting Started with the CData Tableau Connector for Clari
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Analyze Dropbox Data in Cognos Analytics
Use CData Connect AI to connect to Dropbox Data from Cognos Analytics and analyze live Dropbox data.
-
A PostgreSQL Interface for Amazon Marketplace Data (MySQL Remoting via JDBC)
Use the Remoting features of the Amazon Marketplace JDBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Testmonitor Data to Multiple Databases via the CData Sync CLI
Replicate Testmonitor data to disparate databases with a single configuration.
-
Integrate Notion with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Notion with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Notion data.
-
Create Data Visualizations Based On Amazon DynamoDB Data in Mode
Use CData Connect AI to connect to Amazon DynamoDB Data from Mode and build visualizations using live Amazon DynamoDB data.
-
Connect to GraphQL Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for GraphQL data.
-
Automated Continuous QuickBooks Time Replication to IBM DB2
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to IBM DB2.
-
Access Live Microsoft Teams Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Microsoft Teams data from your Excel spreadsheets.
-
Create Reports from Monday.com Data in Looker Studio
Use CData Connect AI to gain access to live Monday.com data and create custom reports in Looker Studio.
-
Connect to and Query JSON Services in QlikView over ODBC
Create data visualizations with JSON services in QlikView.
-
Visualize QuickBooks Time Data in Sisense
Create an ElastiCube in Sisense app with access to QuickBooks Time data.