CData Software - Knowledge Base
Recent Articles
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Workday
Provide connectivity to Workday through an SAP BusinessObjects universe.
-
Working with Flowlu Data in LINQPad
Execute LINQ queries to Flowlu in LINQPad.
-
Easily Integrate JSON Services in Lazarus Pascal IDE
Learn how to easily integrate live JSON in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Natively Connect to Act CRM Data in PHP
The CData ODBC driver for Act CRM enables you to create PHP applications with connectivity to Act CRM. Leverage the native support for ODBC in PHP.
-
Use the CData Software ODBC Driver for Eventbrite in MicroStrategy Desktop
Connect to Eventbrite in MicroStrategy Desktop using the CData Software ODBC Driver for Eventbrite.
-
Automated Continuous ShipEngine Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ShipEngine replication to Apache Kafka.
-
Visualize FTP Data in Sisense
Create an ElastiCube in Sisense app with access to FTP Servers.
-
Build Neo4J-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Neo4J Data from Zoho Analytics and import live Neo4J.
-
Automated Continuous Float Replication to SQLite
Use CData Sync for automated, continuous, customizable Float replication to SQLite.
-
Use Claude to Talk to Your Act CRM 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 Act CRM for you.
-
How to Connect to & Open Retently Data in Microsoft Excel
This article uses the CData ODBC driver for Retently to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Live PhantomBuster Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live PhantomBuster.
-
Use Databricks Agent Bricks to Talk to Your OData Services via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your OData for you.
-
Perform Batch Operations with Shopify Data in Apache NiFi
Connect to Shopify and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to Work with Recurly Data in AWS Glue Jobs Using JDBC
Connect to Recurly from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Getting Started with the CData ODBC Driver for Tickspot
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Tickspot.
-
Automated Continuous Act-On Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Act-On replication to Google BigQuery.
-
Create Data Visualizations Based On Microsoft OneDrive Data in Mode
Use CData Connect AI to connect to Microsoft OneDrive Data from Mode and build visualizations using live
-
Create a Data Access Object for Landbot Data using JDBI
A brief overview of creating a SQL Object API for Landbot in JDBI.
-
Clio Reporting in OBIEE with the Clio JDBC Driver
Deploy the Clio JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access MailChimp Data from MySQL in PHP
Connect to MailChimp through the standard MySQL libraries in PHP.
-
How to work with SharePoint Excel Services Data in Apache Spark using SQL
Access and process SharePoint Excel Services Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData SSIS Components for Demio
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Demio.
-
Automated Continuous Flowlu Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Flowlu replication to delimited files (CSV/TSV).
-
Using the CData Software ODBC Driver for Dropbox in PyCharm
Connect to Dropbox as an ODBC data source in PyCharm using the CData Software ODBC Driver for Dropbox.
-
Create Data Visualizations Based On Oracle SCM Data in Mode
Use CData Connect AI to connect to Oracle SCM Data from Mode and build visualizations using live
-
Integrate Zendesk Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zendesk from Informatica Cloud.
-
Use JayDeBeApi to access Cassandra Data in Python
Use standard Python scripting and the development environment of your choice to access live Apache Cassandra.
-
Use Manus AI to Talk to Your Zuora 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 Zuora.
-
Publish Hugging Face-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Hugging Face.
-
Getting Started with the CData ODBC Driver for Mailgun
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Mailgun.
-
Integrate with live Zendesk Data in Jitterbit
Use CData Connect AI to connect to and integrate live Zendesk in Jitterbit.
-
How to Work with Stack Exchange Data in ETL Validator JDBC
Connect to Stack Exchange from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating Gumloop with Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Azure Analysis Services within automated workflows.
-
Automated Continuous Google Ad Manager Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Azure SQL Database.
-
Enable the Guru JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Guru.
-
Access Live Xero Data in TIBCO Data Virtualization
Use the Xero Tibco DV Adapter to create a Xero Accounting data source in TIBCO Data Virtualization Studio and gain access to live Xero Accounting from your TDV Server.
-
Connect to Phoenix Data from PowerBuilder via ADO.NET
This article demonstrates how to access Apache Phoenix from Appeon PowerBuilder using the CData ADO.NET Provider for Phoenix.
-
How to connect to GitHub Data from IntelliJ
Integrate connectivity to GitHub with wizards in IntelliJ.
-
Getting Started with the CData Connect AI Python SDK for Zendesk
Install the CData Connect AI Python SDK to read and write live Zendesk with standard DB-API 2.0 Python code.
-
Integrate Goose with Live Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Acumatica ERP from within the local AI agent.
-
Consume GraphQL OData Feeds in PowerBuilder
This article demonstrates how to consume GraphQL as OData feeds from PowerBuilder using the API Server.
-
Work with Foursquare Data in FoxPro
Load Foursquare into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Trello Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Trello from Filemaker Pro on Mac.
-
Work with JSON Services in FoxPro
Load JSON into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Adobe Commerce Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Adobe Commerce from Informatica Cloud.
-
Create Dashboards and Visualize Live Stripe Data in Geckoboard
Use CData Connect AI to connect to live Stripe and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connecting Moonlit Workflow with ServiceNow Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your ServiceNow in real time.
-
Integrating Cursor CLI with Cosmos DB 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.
-
Automated Continuous PagerDuty Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable PagerDuty replication to Google BigQuery.
-
Access IBM Informix Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access IBM Informix from your Oracle system.
-
How to work with Bullhorn CRM Data in Apache Spark using SQL
Access and process Bullhorn CRM Data in Apache Spark using the CData Software JDBC Driver.
-
How to use SQLAlchemy ORM to access Redis Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Redis.
-
Edit and Search External Hive Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Apache Hive to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Hive Data objects that you can access from apps and the dashboard.
-
Access Wrike Data from MySQL in Amazon QuickSight
Connect to Wrike and build visualizations of Wrike using a MySQL Connection in Amazon QuickSight.
-
Getting Started with the CData ODBC Driver for SAP HANA XS Advanced
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP HANA XS Advanced.
-
Getting Started with the CData Excel Add-In for Missive
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Missive.
-
Visualize Teamgate Data in Tableau
The CData ODBC driver for Teamgate enables you integrate Teamgate into Tableau dashboards.
-
Use Dash to Build to Web Apps on Google Analytics Data
Create Python applications that use pandas and Dash to build Google Analytics-connected web apps.
-
Integrating Kiro CLI with Salesloft 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.
-
Import IBM Cloud Object Storage Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to IBM Cloud Object Storage Data and provide access to live IBM Cloud Object Storage for custom reports in the Power BI Service.
-
Getting Started with the CData ODBC Driver for Opsgenie
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Opsgenie.
-
How to load Apify data into Elasticsearch via Logstash
Introducing a simple method to load Apify data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Sendwithus Data in RapidMiner
Integrate Sendwithus with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Dashboards with IBM Informix Data in DBxtra
Create dynamic dashboards and perform analytics based on IBM Informix in DBxtra.
-
Use Grok to Talk to Your SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your SAP Business ByDesign for you.
-
Integrating Cursor CLI with Reply.io 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.
-
How to connect and process JotForm from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live JotForm.
-
Access Wistia 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 Wistia.
-
Connect to Salesforce CRM Analytics Data from Crystal Reports
Use CData Connect AI to connect to and report on live Salesforce CRM Analytics from Crystal Reports.
-
Automated Continuous Printful Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Printful replication to delimited files (CSV/TSV).
-
DataBind Controls to Salesforce Data in C++Builder
DataBind to Salesforce & Force.com in C++Builder with standard components and controls.
-
Use the CData Software ODBC Driver for Bugsnag in MicroStrategy
Connect to Bugsnag in MicroStrategy Developer using the CData Software ODBC Driver for Bugsnag.
-
Build Dynamics CRM-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft Dynamics CRM and build Dynamics CRM-connected web apps with Axios.
-
How to work with Outreach.io Data in Apache Spark using SQL
Access and process Outreach.io Data in Apache Spark using the CData Software JDBC Driver.
-
Visualize Mode Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Mode.
-
Build IBM Informix Visualizations in Tableau Desktop
Use CData Connect AI to connect to live IBM Informix and build visualizations in Tableau.
-
Visualize Amazon S3 Data in TIBCO Spotfire through OData
Integrate Amazon S3 into dashboards in TIBCO Spotfire.
-
Integrate Float Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Float from Informatica Cloud.
-
Use the CData Software ODBC Driver for Zoho Projects in SAS for Real-Time Reporting and Analytics
Connect to real-time Zoho Projects in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Zoho Projects.
-
Access Basecamp Data from MySQL in Amazon QuickSight
Connect to Basecamp and build visualizations of Basecamp using a MySQL Connection in Amazon QuickSight.
-
How to connect to Zoho Recruit Data from Spring Boot
Connect to Zoho Recruit in a Spring Boot Application using the CData API Driver for JDBC
-
How to create Nuclia federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Nuclia in MySQL .
-
Import Real-Time Phoenix Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Apache Phoenix in ColdFusion.
-
Load Unbounce Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Unbounce to a database.
-
Create Informatica Mappings From/To an ODBC Data Source for LeadDesk
Create an ODBC connection to LeadDesk in Informatica and browse and transfer LeadDesk.
-
Integrate with SFTP Data in JReport Designer
Create charts and reports based on SFTP in JReport Designer.
-
Build Voice Agents in ElevenLabs with access to Live SAP SuccessFactors LMS Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAP SuccessFactors LMS.
-
Connect to Anaplan Data from PowerBuilder via JDBC
This article demonstrates how to access Anaplan from PowerBuilder using the Anaplan JDBC Driver.
-
Object-Relational Mapping (ORM) with ZohoExpense 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 ZohoExpense into a Java-based ORM framework, Hibernate.
-
Import EnterpriseDB Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access EnterpriseDB. In this article, you will use the OData format to import EnterpriseDB into Microsoft Power Query.
-
Add Amazon Marketplace Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Amazon Marketplace with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData Tableau Connector for Azure Analysis Services
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Azure Analysis Services.
-
Automate Tasks in Power Automate Using the CData API Server
Automate SingleStore actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Replicate Multiple Azure DevOps Accounts
Replicate multiple Azure DevOps accounts to one or many databases.
-
Replicate Multiple Pipedrive Accounts via the CData Sync CLI
Replicate multiple Pipedrive accounts to one or many databases.
-
Build Data Flows from Aha! to SQL Server using SSIS
Easily back up Aha! to SQL Server using the SSIS components for Aha!.
-
Connect to Highrise Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Highrise CRM using standard SQL.
-
Build SendGrid-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SendGrid.
-
How to Work with Kintone Data in ETL Validator JDBC
Connect to Kintone from ETL Validator jobs using the CData Software JDBC Driver.