CData Software - Knowledge Base
Recent Articles
-
Integrating ZohoInvoice Data in Talend Cloud Data Management Platform
Connect ZohoInvoice Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access Live CSV Data in AWS Lambda (with IntelliJ IDEA)
Connect to live CSV/TSV Files in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating GitHub Copilot CLI with Pushbullet 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.
-
Getting Started with the CData ODBC Driver for Tally
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Tally.
-
Getting Started with the CData Python Connector for Retently
Learn to install and license the CData Python Connector
-
Integrate Live Spark Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Apache Spark SQL and integrate live Apache Spark SQL into apps built in Microsoft Power Apps.
-
Integrate Open WebUI with Live Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Amazon Athena from within the chat interface.
-
Import Salesforce Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Salesforce & Force.com. In this article, you will use the OData format to import Salesforce & Force.com into Microsoft Power Query.
-
Visualize Gong Data in Tableau
The CData ODBC driver for Gong enables you integrate Gong into Tableau dashboards.
-
Analyze Avro Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Apache Avro and visualize live Apache Avro in Infragistics Reveal.
-
Write a Simple Go Application to work with Office 365 Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Office 365.
-
Working with Mistral AI Data in LINQPad
Execute LINQ queries to Mistral AI in LINQPad.
-
Automated Continuous Act CRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Act CRM replication to Amazon Redshift.
-
Integrate Browserless with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Browserless with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Browserless.
-
Integrating GitHub Copilot CLI with Invoiced 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.
-
How to Visualize Facebook Data in Python with pandas
Use pandas and other modules to analyze and visualize live Facebook in Python.
-
Build BigQuery-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google BigQuery and build BigQuery-connected web apps with Axios.
-
Query Pipedrive Data in ColdFusion
Write standard ColdFusion data access code to connect to Pipedrive.
-
How to connect SharePoint with Box Data through external lists
Provide Box to SharePoint users as an external list.
-
Edit and Search Slack External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Slack to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Slack objects that you can access from apps and the dashboard.
-
Connect to Google Contacts Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google Contacts from Crystal Reports.
-
Create Pingdom Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Pingdom data access from reports, embedded analytics, and more.
-
Connect and Visualize Live Marketo Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Marketo into the Databricks platform and create visualization dashboards with real-time Marketo.
-
Bridge Shortcut Connectivity with Apache NiFi
Access and process Shortcut in Apache NiFi using the CData JDBC Driver.
-
Transfer Company File Data using the CData Excel Add-In
This article shows how to use the CData Excel Add-In for QuickBooks to transfer data from one company file to another. You will use the Excel Add-In to manage multiple connections and transfer customer records from one company file to another.
-
How to connect to PabblySubscriptions Data with Squirrel SQL client
Connect to PabblySubscriptions and execute queries in the Squirrel SQL Client.
-
Integrate Vertica Data into Power Automate Desktop using CData Connect
CData Connect for Vertica Data enables you to integrate Vertica into workflows built using Microsoft Power Automate Desktop.
-
Automate Excel Online Data Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Excel Online replication to Couchbase.
-
Create Informatica Mappings From/To an ODBC Data Source for Perigon
Create an ODBC connection to Perigon in Informatica and browse and transfer Perigon.
-
Getting Started with the CData ODBC Driver for SpaceX
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SpaceX.
-
Analyze SQL Analysis Services Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SQL Analysis Services from Power Pivot. You will use the Table Import Wizard to load SQL Analysis Services. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect to Live Salesforce Marketing Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Salesforce Marketing Cloud for you.
-
Build Authorize.Net-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Authorize.Net to explore live Authorize.Net Data in Claude Code to assist with building Authorize.Net-powered applications.
-
Connect to WooCommerce Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with WooCommerce Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automate MailerLite Data Replication to SAP HANA
Use CData Sync to customize and automate MailerLite replication to SAP HANA.
-
Build a Simple VCL Application for Google Cloud Storage Data
How to build a simple VCL Application to view Google Cloud Storage in RAD Studio using the CData ODBC Driver for Google Cloud Storage.
-
Connect to Typeform Data in RazorSQL
Connect to Typeform from wizards and query Typeform from the GUI in the RazorSQL database management tool.
-
Automated Continuous Everhour Replication to SQLite
Use CData Sync for automated, continuous, customizable Everhour replication to SQLite.
-
Use Dash to Build to Web Apps on Access Data
Create Python applications that use pandas and Dash to build Access-connected web apps.
-
Automate HBase Data Replication to Azure Synapse
Use CData Sync to customize and automate Apache HBase replication to Azure Synapse.
-
Connect to Freshservice Data from HeidiSQL
Use CData Connect AI to connect to and query live Freshservice from HeidiSQL.
-
Integrate Real-Time Access to Salesforce Pardot in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Salesforce Pardot in real time.
-
Connect to Oracle Eloqua Reporting Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Oracle Eloqua Reporting.
-
Visualize MailChimp Data in TIBCO Spotfire through OData
Integrate MailChimp into dashboards in TIBCO Spotfire.
-
Object-Relational Mapping (ORM) with ConvertKit Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to ConvertKit into a Java-based ORM framework, Hibernate.
-
Use the CData Software ODBC Driver for Freshservice in MicroStrategy Desktop
Connect to Freshservice in MicroStrategy Desktop using the CData Software ODBC Driver for Freshservice.
-
Build CSV-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for CSV to explore live CSV Data in Claude Code to assist with building CSV-powered applications.
-
Integrating LangGraph with Act-On Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Act-On within automated workflows.
-
Publish Reports with EnterpriseDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date EnterpriseDB.
-
Connect to Rootly Data in DBArtisan
Use wizards in DBArtisan to configure Rootly as a data source.
-
Integrate Live Zoho Inventory Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Zoho Inventory from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zoho Inventory.
-
Connecting Mastra with Zoho Books 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 Zoho Books, no replication required.
-
Connect to and Visualize Live Placid Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Placid.
-
Enable the Zoom JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Zoom.
-
Integrating OpenCode Terminal with SQL Analysis Services 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.
-
Access Live ChargeOver Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ChargeOver into the statistical analysis tools available in SAS JMP. This article shows how to use ChargeOver in the Graph Builder and Query Builder.
-
Build a PostgreSQL Interface for MailerLite Data using the CData JDBC Driver
Use the Remoting features of the MailerLite JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData ODBC Driver for Outlook in Microsoft Power Query
You can use the CData Outlook ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Outlook into Microsoft Power Query.
-
Connect to Google Drive Data in DBArtisan
Use wizards in DBArtisan to configure Google Drive as a data source.
-
Create Reports with SharePoint Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft SharePoint.
-
Connect to Google Sheets Data in Claris FileMaker Pro
Use the CData ODBC Driver for Google Sheets in FileMaker Pro to connect to Google Sheets and work with Google Sheets in your FileMaker applications.
-
Replicate Amazon Marketplace Data to Multiple Databases
Replicate Amazon Marketplace to disparate databases with a point-and-click configuration.
-
Enable the Slack JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Slack.
-
Design BIRT Reports on Gorgias Data
Provide current Gorgias to your embedded analytics.
-
How to connect and process Planio from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Planio.
-
Use CData Connect AI to Access Redis Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Redis in the Power Pivot business intelligence tool.
-
Getting Started with the CData SSIS Components for Greenplum
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Greenplum.
-
Use Biml to Build SSIS Tasks to Replicate Browserless Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Browserless to SQL Server.
-
Connect to Real-Time Placid Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Placid in Power Apps.
-
Automated Continuous Office 365 Replication to Snowflake
Use CData Sync for automated, continuous, customizable Office 365 replication to Snowflake.
-
Visualize Notion Data in TIBCO Spotfire through ADO.NET
Integrate Notion into dashboards in TIBCO Spotfire.
-
Analyze Blackbaud FE NXT Data in Looker
Use CData Connect AI to connect to Blackbaud FE NXT Data from Looker and build custom apps using live Blackbaud FE NXT.
-
Connect to Microsoft Entra ID Data from PowerBuilder via JDBC
This article demonstrates how to access Microsoft Entra ID from PowerBuilder using the Microsoft Entra ID JDBC Driver.
-
Build a Singer.io Tap for Mailjet With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Mailjet data using
-
Connect to and Query SageHR Data in QlikView over ODBC
Create data visualizations with SageHR in QlikView.
-
Integrate Exa Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Exa from Informatica Cloud.
-
Access Zoho Inventory Data from MySQL in Amazon QuickSight
Connect to Zoho Inventory and build visualizations of Zoho Inventory using a MySQL Connection in Amazon QuickSight.
-
Use the CData Software ODBC Driver for Zuora in SAS for Real-Time Reporting and Analytics
Connect to real-time Zuora in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Zuora.
-
Visualize Live Wave Financial Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Wave Financial using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Object-Relational Mapping (ORM) with SAP Business Warehouse Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SAP Business Warehouse into a Java-based ORM framework, Hibernate.
-
Integrating Claude Code with Hive Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Apache Hive within assisted coding and automated development workflows.
-
Analyze Jira Data in Cognos Analytics
Use CData Connect AI to connect to Jira Data from Cognos Analytics and analyze live Atlassian Jira.
-
Integrating Codex CLI with SAP Business ByDesign 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 Codat Data in Ruby
Connect to Codat in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect Nuclia Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Nuclia using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Xero Data in NetBeans
Connect to Xero Accounting in NetBeans with the data source configuration wizard.
-
How to integrate Twilio with Apache Airflow
Access and process Twilio in Apache Airflow using the CData JDBC Driver.
-
Create Power BI Reports on Real-Time Hive Data
Use the CData ODBC Driver for Hive to visualize Apache Hive in Power BI Desktop.
-
Automated Continuous Sage Intacct Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Sage Intacct replication to Amazon S3.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google AlloyDB within intelligent workflows.
-
Connect to Discourse Data from PowerBuilder via JDBC
This article demonstrates how to access Discourse from PowerBuilder using the Discourse JDBC Driver.
-
Connect to SAP Hybris C4C Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP Hybris C4C Data and connect to SAP Hybris C4C in Akorbi Digital RunMyProcess.
-
Visualize HCL Domino Data in Sisense
Create an ElastiCube in Sisense app with access to HCL Domino.
-
Integrating Antigravity CLI with CapsuleCRM via CData CLI
Connect CapsuleCRM to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Query SFTP Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SFTP and perform CRUD operations on SFTP from Node.js.
-
How to Connect to Presto Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Presto. Leverage the pyodbc module for ODBC in Python.
-
Getting Started with the CData Connect AI Python SDK for Cloudant
Install the CData Connect AI Python SDK to read and write live IBM Cloudant with standard DB-API 2.0 Python code.
-
Getting Started with the CData Excel Add-In for Bannerbear
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Bannerbear.
-
How to Build an ETL App for Amazon Athena Data in Python with CData Connect AI
Build ETL pipelines that read and write live Amazon Athena in Python with petl and the CData Connect AI Python SDK.
-
Automated Continuous MailerLite Replication to SingleStore
Use CData Sync for automated, continuous, customizable MailerLite replication to SingleStore.