CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for Instantly in MicroStrategy
Connect to Instantly in MicroStrategy Developer using the CData Software ODBC Driver for Instantly.
-
A PostgreSQL Interface for Toggl Data (MySQL Remoting via JDBC)
Use the Remoting features of the Toggl JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live CockroachDB Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live CockroachDB.
-
Stream Amazon DynamoDB Data into Apache Kafka Topics
Access and stream Amazon DynamoDB in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Bidirectional Access to LinkedIn Ads Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate LinkedIn Ads in Filemaker Pro for Mac or Windows.
-
Integrate Jira Data in the Pentaho Report Designer
Publish reports based on Atlassian Jira in the Pentaho BI tool.
-
Connect to Nuclia from Asprova with CData Software ODBC Driver for Nuclia
This article shows how to connect faster to Nuclia data from Asprova.
-
How to Connect to Live Microsoft Planner 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 Microsoft Planner through natural language.
-
Build AI/ML Models with Live SAP SuccessFactors Data using Dataiku
Connect SAP SuccessFactors Data with Dataiku using the CData JDBC Driver for SAP SuccessFactors.
-
Integrating LlamaIndex with Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Azure Data Lake Storage in real time.
-
Short.io Reporting in OBIEE with the Short.io JDBC Driver
Deploy the Short.io JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Google Directory Data Replication to Teradata
Use CData Sync to Customize and automate Google Directory replication to Teradata.
-
Automated Continuous Float Replication to SQL Server
Use CData Sync for automated, continuous, customizable Float replication to SQL Server.
-
Visualize Perigon Data in Tableau
The CData ODBC driver for Perigon enables you integrate Perigon into Tableau dashboards.
-
Connect to Recurly Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Recurly and work with Recurly in your FileMaker application.
-
How to Connect to Live Oracle SCM 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 Oracle SCM through natural language.
-
How to connect to Mailjet Data with Squirrel SQL client
Connect to Mailjet and execute queries in the Squirrel SQL Client.
-
Integrating Codex CLI with ZohoInvoice 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 Klaviyo in SpagoBI
Create reports featuring live Klaviyo in SpagoBI Studio. Host Klaviyo reports on SpagoBI Server.
-
Integrating Boomi Agentstudio with Smartsheet Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Smartsheet, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Oracle SCM Data in HULFT Integrate
Connect to Oracle SCM as a JDBC data source in HULFT Integrate
-
A PostgreSQL Interface for Parquet Data (MySQL Remoting via JDBC)
Use the Remoting features of the Parquet JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Google Ad Manager-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Ad Manager and build web apps with connectivity to live Google Ad Manager.
-
Excel Spreadsheet Automation on Jumpseller Data with the QUERY Formula
Pull data from Jumpseller, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData Power BI Connector for Aircall
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Access Live Act-On Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Act-On in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software ODBC Driver for Access in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft Access in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Access.
-
Build an OLAP Cube in SSAS from Vimeo Data
Establish a connection to Vimeo data from SQL Server Analysis Services, and use the Vimeo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to IBM Cloud Object Storage Data as an External Source in Dremio
Use the CData JDBC Driver to connect to IBM Cloud Object Storage as an External Source in Dremio.
-
Configure the CData JDBC Driver for Exact Online in a Connection Pool in Tomcat
Connect to Exact Online from a connection pool in Tomcat.
-
Write a Simple Go Application to work with Browserless Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Browserless.
-
How to create an RPA flow for Attio Data in UiPath Studio
Use the Attio ODBC Driver to create workflows that access real-time Attio without any coding.
-
Query, Visualize, and Share live Azure Table Data in Redash
Use CData Connect AI to connect to live Azure Table Storage in Redash for querying, visualizing, and sharing.
-
Connect to Freshservice Data in NetBeans
Connect to Freshservice in NetBeans with the data source configuration wizard.
-
Access Adobe Experience Manager Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Adobe Experience Manager from HeidiSQL.
-
Use CData Connect AI to Access MYOB AccountRight Data in Microsoft Power Pivot
Use CData Connect AI to connect to live MYOB AccountRight in the Power Pivot business intelligence tool.
-
Connect Optimizely Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Optimizely using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Chargebee 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 Chargebee.
-
Connect to Beeminder Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Beeminder in the Denodo Virtual DataPort Administrator.
-
Viewing Elasticsearch Data in RAD Studio Data Explorer
How to view Elasticsearch in RAD Studio Data Explorer using the CData ODBC Driver for Elasticsearch.
-
Bridge eBay Connectivity with Apache NiFi
Access and process eBay in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous PostgreSQL Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable PostgreSQL replication to OneLake in Microsoft Fabric.
-
Connect to Facebook Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Facebook.
-
Getting Started with the CData Excel Add-In for SAP Business Warehouse
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP Business Warehouse.
-
Excel Spreadsheet Automation on Hive Data with the QUERY Formula
Pull data from Hive, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Drift Replication to SingleStore
Use CData Sync for automated, continuous, customizable Drift replication to SingleStore.
-
Query Copper Data in ColdFusion
Write standard ColdFusion data access code to connect to Copper.
-
Integrate Databricks Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Databricks from Informatica Cloud.
-
Integrate Box Data in the Pentaho Report Designer
Publish reports based on Box in the Pentaho BI tool.
-
Getting Started with the CData ADO.NET Provider for Klipfolio
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous Datadog Replication to SQLite
Use CData Sync for automated, continuous, customizable Datadog replication to SQLite.
-
Integrate Goose with Live Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Salesforce Marketing Cloud from within the local AI agent.
-
Build ServiceNow-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for ServiceNow to explore live ServiceNow Data in Cursor to assist with building ServiceNow-powered applications.
-
Use the CData ODBC Driver for Parquet in Microsoft Power Query
You can use the CData Parquet ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Apache Parquet into Microsoft Power Query.
-
Automated Continuous Cassandra Replication to Databricks
Use CData Sync for automated, continuous, customizable Cassandra replication to Databricks.
-
Connect to Monday.com Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Monday.com Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to load Workable data into Elasticsearch via Logstash
Introducing a simple method to load Workable data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Mode Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Mode replication to Google Cloud SQL.
-
How to Visualize Sugar CRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live Sugar CRM in Python.
-
How to Easily Query Suadeo Data in OpenOffice Base
Connect to Suadeo data in OpenOffice Base using the CData ODBC Driver for Suadeo and generate reports with live data insights.
-
How to Build an ETL App for Amazon DynamoDB Data in Python with CData Connect AI
Build ETL pipelines that read and write live Amazon DynamoDB in Python with petl and the CData Connect AI Python SDK.
-
Feed Sugar CRM Data into FineReport
How to set Sugar CRM as a JDBC data source in FineReport.
-
Analyze LaunchDarkly Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze LaunchDarkly in Microsoft R Open.
-
Back Up SAP HANA to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP HANA. In this article, we will employ an SSIS workflow to populate a database with SAP HANA data.
-
How to Connect Flowise AI Agents to Live Zendesk 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 Zendesk without replication.
-
How to publish and share Access Data dashboards with Tableau Server
The CData ODBC driver for Access enables you integrate Microsoft Access into Tableau dashboards.
-
Publish ScrapingBee-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ScrapingBee.
-
Connect to Adobe Target Data in Jaspersoft Studio
Execute SQL to remote Adobe Target in Jaspersoft Studio.
-
Use the CData Software ODBC Driver for Mixpanel in MicroStrategy Web
Connect to Mixpanel in MicroStrategy Web using the CData Software ODBC Driver for Mixpanel.
-
Create Box-Connected Business Apps in AppSheet
Connect to Box Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Box.
-
Integrate Live xBase Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live xBase to Blue Prism using the CData ODBC Driver for xBase to create automated workflows for repetitive business tasks.
-
Query, Visualize, and Share live Jira Assets Data in Redash
Use CData Connect AI to connect to live Jira Assets in Redash for querying, visualizing, and sharing.
-
Connect to CouchDB in SpagoBI
Create reports featuring live Apache CouchDB in SpagoBI Studio. Host CouchDB reports on SpagoBI Server.
-
A PostgreSQL Interface for Bright Data Data using the CData ODBC Driver
Use the SQL Gateway and Bright Data ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous SAP Fieldglass Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to PostgreSQL.
-
Create Reports with Jira Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Atlassian Jira.
-
Connect to Google Campaign Manager 360 Data in DBArtisan
Use wizards in DBArtisan to configure Google Campaign Manager 360 as a data source.
-
Query Teamwork Data in DataGrip
Create a Data Source for Teamwork in DataGrip and use SQL to query live Teamwork.
-
Visualize Epicor Kinetic Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Epicor Kinetic.
-
Connect to and Visualize Live DocuSign Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live DocuSign.
-
Connect to and Visualize Live Copper Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Copper.
-
Getting Started with the CData Connect AI Python SDK for Epicor Kinetic
Install the CData Connect AI Python SDK to read and write live Epicor Kinetic with standard DB-API 2.0 Python code.
-
Integrating LlamaIndex with FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on FTP Servers in real time.
-
Publish Codat-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Codat.
-
Connect to ZohoPeople from a Connection Pool in WebLogic
Use the CData JDBC Driver for ZohoPeople to connect to ZohoPeople from Web applications running on WebLogic.
-
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 from MicroStrategy.
-
Automated Continuous Azure Data Lake Storage Replication to Snowflake
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Snowflake.
-
Connect to HubSpot Data from a Connection Pool in Jetty
The HubSpot JDBC Driver supports connection pooling: This article shows how to connect faster to HubSpot from Web apps in Jetty.
-
Connect to SAP Business Warehouse Data in JRuby
Create a simple JRuby app with access to live SAP Business Warehouse.
-
Connect to LightSpeedRetail Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrating Cursor CLI with Demio 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 an OLAP Cube in SSAS from Amazon DynamoDB Data
Establish a connection to Amazon DynamoDB data from SQL Server Analysis Services, and use the Amazon DynamoDB Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to create Act CRM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Act CRM in MySQL .
-
Connect to CouchDB Data from HeidiSQL
Use CData Connect AI to connect to and query live Apache CouchDB from HeidiSQL.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Highrise
Provide connectivity to Highrise CRM through an SAP BusinessObjects universe.
-
Build MYOB AccountRight-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for MYOB AccountRight to explore live MYOB AccountRight Data in Cursor to assist with building MYOB AccountRight-powered applications.
-
Import Oracle Data Using Azure Data Factory
Use CData Connect AI to connect to Oracle Data from Azure Data Factory and import live Oracle Database.
-
Natively Connect to Wrike Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Wrike. Leverage the native support for ODBC in PHP.
-
Access Live Apify Data in Coginiti Pro
Connect to and query live Apify from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect to & Open SAP Netweaver Gateway Data in Microsoft Excel
This article uses the CData ODBC driver for SAP Netweaver Gateway to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.