CData Software - Knowledge Base
Recent Articles
-
Build Agents in Relevance AI with Access to Live Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Oracle Sales within intelligent agent workflows.
-
How to integrate Productboard with Apache Airflow
Access and process Productboard in Apache Airflow using the CData JDBC Driver.
-
Build Apps with Live Freshservice in Adalo using CData Connect AI
Use CData Connect AI to integrate live Freshservice into the Adalo platform and build custom mobile and web applications with real-time Freshservice.
-
Moving Data from Instagram to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Instagram data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Viewing Salesforce CRM Analytics Data in RAD Studio Data Explorer
How to view Salesforce CRM Analytics in RAD Studio Data Explorer using the CData ODBC Driver for Salesforce CRM Analytics.
-
Use the CData Software ODBC Driver for JSON in MicroStrategy Web
Connect to JSON in MicroStrategy Web using the CData Software ODBC Driver for JSON.
-
Automated Continuous PagerDuty Replication to IBM DB2
Use CData Sync for automated, continuous, customizable PagerDuty replication to IBM DB2.
-
Connect and Query Live Databricks Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Databricks into Databricks
-
Connect to SAP ByDesign Data in RazorSQL
Connect to SAP ByDesign from wizards and query SAP Business ByDesign from the GUI in the RazorSQL database management tool.
-
Use the CData Software JDBC Driver for Discord in MicroStrategy Web
Connect to Discord in MicroStrategy Web using the CData Software JDBC Driver for Discord.
-
Create Office 365-Connected Dashboards in Grafana
Connect to Office 365 Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Microsoft Office 365.
-
Automated Continuous Act CRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Act CRM replication to IBM DB2.
-
Integrate ZohoDesk with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ZohoDesk with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ZohoDesk.
-
Import Real-Time Front Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Front in ColdFusion.
-
Automate OpenWeatherMap Integration Tasks from PowerShell
Are you in search of a quick and easy way to access OpenWeatherMap from PowerShell? This article demonstrates how to utilize the OpenWeatherMap Cmdlets for tasks like connecting to OpenWeatherMap, automating operations, downloading data, and more.
-
Connect and Visualize Live SQL Analysis Services Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SQL Analysis Services into the Databricks platform and create visualization dashboards with real-time SQL Analysis Services.
-
Connect to Azure Synapse Data in DBeaver
Use the CData ODBC Driver to connect to Azure Synapse in DBeaver.
-
Create Informatica Mappings From/To a JDBC Data Source for Close
Create Close data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to use SQLAlchemy ORM to access Telegram Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Telegram.
-
How to Connect to & Open Reckon Accounts Hosted Data in Microsoft Excel
This article uses the CData ODBC driver for Reckon Accounts Hosted to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Replicate Zoho Projects Data from PowerShell
Write a quick PowerShell script to query Zoho Projects. Use connectivity to the live data to replicate Zoho Projects to SQL Server.
-
Replicate Multiple Amazon S3 Accounts via the CData Sync CLI
Replicate multiple Amazon S3 accounts to one or many databases.
-
Connect to Impala Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Impala and the Script function in FileMaker Pro to connect to Impala and work with Apache Impala in your FileMaker application.
-
Query Cosmos DB Data in ColdFusion
Write standard ColdFusion data access code to connect to Azure Cosmos DB.
-
Integrate OnePageCrm Data in the Pentaho Report Designer
Publish reports based on OnePageCrm in the Pentaho BI tool.
-
Use the CData ODBC Driver for Hugging Face in Microsoft Power Query
You can use the CData Hugging Face ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Hugging Face into Microsoft Power Query.
-
How to Query Dotmailer Data in MySQL Workbench
Execute MySQL queries against live Dotmailer from MySQL Workbench.
-
Stream Placid Data into Apache Kafka Topics
Access and stream Placid in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Active Directory Data in TIBCO Spotfire through OData
Integrate Active Directory into dashboards in TIBCO Spotfire.
-
Analyze PivotalTracker Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze PivotalTracker in Microsoft R Open.
-
Build Apps with Live SAP Data Using the Low-Code Development Platform of Mendix
Connect SAP ERP/NetWeaver with Mendix to build apps using the CData JDBC Driver for SAP.
-
Automated Continuous Odoo Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Odoo replication to Amazon Redshift.
-
Query DocuSign Data from Node.js
Use the OData endpoint of the CData API Server to connect to your DocuSign and perform CRUD operations on DocuSign from Node.js.
-
A PostgreSQL Interface for Moosend Data (MySQL Remoting via JDBC)
Use the Remoting features of the Moosend JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Claude Code CLI with PolarTeamPro 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.
-
Analyze SurveyMonkey Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SurveyMonkey and visualize SurveyMonkey in SAP Analytics Cloud.
-
Visualize Live Wrike Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Wrike.
-
A PostgreSQL Interface for Paddle Data (MySQL Remoting via JDBC)
Use the Remoting features of the Paddle JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Oracle HCM Cloud-Connected Business Apps in AppSheet
Connect to Oracle HCM Cloud Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Oracle HCM Cloud.
-
Use the CData Software ODBC Driver for Apollo in MicroStrategy Desktop
Connect to Apollo in MicroStrategy Desktop using the CData Software ODBC Driver for Apollo.
-
Rapidly Develop HubDB-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by HubDB.
-
Integrate with HubSpot Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy HubSpot to a JSON file on disk.
-
Connect to Live Act CRM Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Act CRM in CData Connect AI and connect to your Act CRM from PostgreSQL.
-
Access Live Codat Data in AWS Lambda
Connect to live Codat in AWS Lambda using the CData JDBC Driver.
-
How to Visualize Opsgenie Data in Python with pandas
Use pandas and other modules to analyze and visualize live Opsgenie in Python.
-
Create Cvent-Connected Business Apps in AppSheet
Connect to Cvent Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Cvent.
-
Create Power BI Reports on Real-Time Act-On Data
Use the CData ODBC Driver for Act-On to visualize Act-On in Power BI Desktop.
-
Integrate MailerLite Data in Pentaho Data Integration
Build ETL pipelines based on MailerLite in the Pentaho Data Integration tool.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Pipeliner CRM
Provide connectivity to Pipeliner CRM through an SAP BusinessObjects universe.
-
Automated Continuous Apify Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Apify replication to Apache Kafka.
-
How to Query Live Oracle SCM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Oracle SCM data in natural language using Python.
-
Use JayDeBeApi to access Bitly Data in Python
Use standard Python scripting and the development environment of your choice to access live Bitly.
-
Connect to MariaDB Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for MariaDB to connect to MariaDB and execute queries in PowerBuilder.
-
Connect to Presto Data in NetBeans
Connect to Presto in NetBeans with the data source configuration wizard.
-
Work with Couchbase Data in FoxPro
Load Couchbase into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Data Visualizations in Cognos BI with CSV Data
Access CSV/TSV Files as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Rapidly Develop SAS xpt-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by SAS xpt.
-
Publish Zoho CRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Zoho CRM.
-
Automated Continuous Attio Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Attio replication to OneLake in Microsoft Fabric.
-
Use the CData Software JDBC Driver for GraphQL in MicroStrategy
Connect to GraphQL in MicroStrategy Developer using the CData Software JDBC Driver for GraphQL.
-
Build AI/ML Models with Live Zoho Recruit Data using Dataiku
Connect Zoho Recruit Data with Dataiku using the CData API Driver for JDBC.
-
A PostgreSQL Interface for GitLab Data (MySQL Remoting via JDBC)
Use the Remoting features of the GitLab JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to and Visualize Live FTP Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live FTP Servers.
-
Connect to SharePoint Excel Services Data in DBeaver
Use the CData ODBC Driver to connect to SharePoint Excel Services in DBeaver.
-
How to connect to IBM Informix Data from IntelliJ
Integrate connectivity to IBM Informix with wizards in IntelliJ.
-
Consume FHIR OData Feeds in SAP Lumira
Use the API Server to create data visualizations on FHIR feeds that reflect any changes in SAP Lumira.
-
Consume Zoho Books OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Zoho Books feeds that reflect any changes in SAP Lumira.
-
Manage Placid Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Placid.
-
Connecting Mastra with IBM Informix 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 IBM Informix, no replication required.
-
Getting Started with the CData ADO.NET Provider for Reply.io
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connecting GenSpark with EnterpriseDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to EnterpriseDB without any replication or custom integration required.
-
Use Manus AI to Talk to Your BigQuery 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 Google BigQuery.
-
How to publish and share QuickBooks Data dashboards with Tableau Server
The CData ODBC driver for QuickBooks enables you integrate QuickBooks Desktop into Tableau dashboards.
-
How to connect and process Salesforce Pardot from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Salesforce Pardot.
-
Build TaxJar-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for TaxJar to explore live TaxJar Data in GitHub Copilot to assist with building TaxJar-powered applications.
-
Operational Reporting on HDFS Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Apache HDFS.
-
Connect to YouTube Analytics Data in RapidMiner
Integrate YouTube Analytics with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Omnisend Data from PowerBuilder via JDBC
This article demonstrates how to access Omnisend from PowerBuilder using the Omnisend JDBC Driver.
-
Automate QuickBooks Online Data Replication to Couchbase
Use CData Sync to Customize and automate QuickBooks Online replication to Couchbase.
-
Use Grok to Talk to Your Sage 200 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 Sage 200 for you.
-
Bidirectional Access to Google Analytics Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Google Analytics in Filemaker Pro for Mac or Windows.
-
Build Amazon DynamoDB-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Amazon DynamoDB.
-
Integrate Live Contentful Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Contentful to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Design BIRT Reports on Templated Data
Provide current Templated to your embedded analytics.
-
Connect to Parquet Data from PowerBuilder via ADO.NET
This article demonstrates how to access Apache Parquet from Appeon PowerBuilder using the CData ADO.NET Provider for Parquet.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Datadog
Provide connectivity to Datadog through an SAP BusinessObjects universe.
-
DataBind Charts to xBase Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to xBase 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.
-
Use the CData ODBC Driver for Moosend in Microsoft Power Query
You can use the CData Moosend ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Moosend into Microsoft Power Query.
-
Integrating OpenCode Terminal with ZeroBounce 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.
-
Analyze Neo4J Data in Cognos Analytics
Use CData Connect AI to connect to Neo4J Data from Cognos Analytics and analyze live Neo4J.
-
Visualize OData Services in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load OData into TIBCO Spotfire.
-
Create a Data Access Object for LDAP Objects using JDBI
A brief overview of creating a SQL Object API for LDAP in JDBI.
-
Query QuickBooks Time Data from Node.js
Use the OData endpoint of the CData API Server to connect to your QuickBooks Time and perform CRUD operations on QuickBooks Time from Node.js.
-
How to connect to ZohoMarketingHub Data in DBVisualizer
Integrate ZohoMarketingHub with visual data analysis tools and data connection wizards in DBVisualizer
-
Getting Started with the CData SSIS Components for Superchat
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Superchat.
-
Use the CData Software ODBC Driver for Simplesat in SAS for Real-Time Reporting and Analytics
Connect to real-time Simplesat in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Simplesat.
-
Build Oracle Eloqua-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Oracle Eloqua to explore live Oracle Eloqua Data in Cursor to assist with building Oracle Eloqua-powered applications.
-
Build Data Flows from Dynamics NAV to SQL Server using SSIS
Easily back up Microsoft Dynamics NAV to SQL Server using the SSIS components for Dynamics NAV.
-
Cosmos DB Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Azure Cosmos DB through CData Connect AI using different applications and tools.
-
Operational Reporting on Sage 200 Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Sage 200.