CData Software - Knowledge Base
Recent Articles
-
How to integrate TigerGraph with Apache Airflow
Access and process TigerGraph in Apache Airflow using the CData JDBC Driver.
-
Analyze Retently Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Retently with the CData JDBC Driver for Retently.
-
Access Live MongoDB Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live MongoDB through MCP integration.
-
Import Real-Time BigCommerce Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use BigCommerce in ColdFusion.
-
Connect to Microsoft Ads Data in HULFT Integrate
Connect to Microsoft Ads as a JDBC data source in HULFT Integrate
-
DataBind Charts to GitLab Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to GitLab 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.
-
Getting Started with the CData JDBC Driver for Twitter Ads
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Twitter Ads.
-
How to Seamlessly Import LionDesk Data into IBM SPSS Modeler
Integrate LionDesk data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize SendGrid Data in TIBCO Spotfire through ADO.NET
Integrate SendGrid into dashboards in TIBCO Spotfire.
-
Connect to Dynamics 365 Data in Aqua Data Studio
Access Microsoft Dynamics 365 from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connecting GenSpark with Salesforce Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Salesforce & Force.com without any replication or custom integration required.
-
Use ChatGPT to Talk to Your ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your ActiveCampaign for you.
-
Use the CData Software JDBC Driver for Flowlu in MicroStrategy Desktop
Connect to Flowlu in MicroStrategy Desktop using the CData Software JDBC Driver for Flowlu.
-
How to Work with Landbot Data in ETL Validator JDBC
Connect to Landbot from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Amazon DynamoDB Replication to SQL Server
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to SQL Server.
-
How to Access Live Pinterest Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Pinterest enables you to integrate Pinterest into workflows built using Microsoft Power Automate Desktop.
-
Validate Impala Data with QuerySurge
Access and validate Apache Impala in QuerySurge using the CData JDBC Driver.
-
Choosing the Best Method to Connect QuickBooks Online to SQL Server: 5 Options Explained
Discover multiple ways to connect and use QuickBooks Online from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Feed NetSuite Data into FineReport
How to set NetSuite CRM & ERP as a JDBC data source in FineReport.
-
Natively Connect to Spark Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Apache Spark SQL. Leverage the native support for ODBC in PHP.
-
Provide OData Services of Microsoft Dataverse Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft Dataverse (CDS) by developing a WCF Service Application.
-
How to Build an ETL App for Pipeliner CRM Data in Python with CData
Create ETL applications and real-time data pipelines for Pipeliner CRM in Python with petl.
-
Integrating GitHub Copilot CLI with Neo4J 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.
-
Visualize Live Freshdesk Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Freshdesk into custom reports in Power BI.
-
Back Up Azure Data Lake Storage to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Azure Data Lake Storage. In this article, we will employ an SSIS workflow to populate a database with Azure Data Lake Storage data.
-
Automated ZohoExpense Data Replication to Teradata
Use CData Sync to Customize and automate ZohoExpense replication to Teradata.
-
Build Dashboards with Instantly Data in Dundas BI
Create dynamic dashboards and perform analytics based on Instantly in Dundas BI.
-
Manage Google Forms Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Forms.
-
Connect Presto Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Presto using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build AI/ML Models with Live Teradata Data using Dataiku
Connect Teradata Data with Dataiku using the CData JDBC Driver for Teradata.
-
DataBind Charts to SFTP Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SFTP 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.
-
Build Epicor Kinetic Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Epicor Kinetic and build visualizations in Tableau.
-
Automate ZohoExpense Data Replication to SAP HANA
Use CData Sync to customize and automate ZohoExpense replication to SAP HANA.
-
Automated Continuous CSV Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable CSV/TSV Files replication to OneLake in Microsoft Fabric.
-
Integrating GitHub Copilot CLI with LinkedIn Ads 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.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for FormSite
Provide connectivity to FormSite through an SAP BusinessObjects universe.
-
Build Visualizations of IBM Cloud Object Storage Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of IBM Cloud Object Storage in Birst.
-
Analyze Microsoft Entra ID Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft Entra ID in Microsoft R Open.
-
How to connect to PostgreSQL Data from Spring Boot
Connect to PostgreSQL in a Spring Boot Application using the CData JDBC Driver for PostgreSQL
-
Automated Continuous Elorus Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Elorus replication to Google Cloud SQL.
-
Integrating LangGraph with Odoo Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Odoo ERP within automated workflows.
-
Automated Continuous Highrise Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Highrise replication to PostgreSQL.
-
Replicate Multiple Adobe Analytics Accounts via the CData Sync CLI
Replicate multiple Adobe Analytics accounts to one or many databases.
-
Design BIRT Reports on Tickspot Data
Provide current Tickspot to your embedded analytics.
-
Publish SAP Concur-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP Concur.
-
Create Reports with LaunchDarkly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date LaunchDarkly.
-
Automate Planio Data Replication to Couchbase
Use CData Sync to Customize and automate Planio replication to Couchbase.
-
Work with SAP Ariba Procurement Data in FoxPro
Load SAP Ariba Procurement into a FoxPro database. This article includes full code and a walk-through of the process.
-
Working with Simplesat Data in LINQPad
Execute LINQ queries to Simplesat in LINQPad.
-
Visualize Databricks Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Databricks into TIBCO Spotfire.
-
How to create an RPA flow for LinkedIn Data in UiPath Studio
Use the LinkedIn ODBC Driver to create workflows that access real-time LinkedIn without any coding.
-
Use the CData ODBC Driver for Microsoft Dataverse in Microsoft Power Query
You can use the CData Microsoft Dataverse ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft Dataverse (CDS) into Microsoft Power Query.
-
How to Connect to ZeroBounce Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ZeroBounce. Leverage the pyodbc module for ODBC in Python.
-
How to connect to CampaignMonitor Data from IntelliJ
Integrate connectivity to CampaignMonitor with wizards in IntelliJ.
-
Access TigerGraph Data from MySQL in Amazon QuickSight
Connect to TigerGraph and build visualizations of TigerGraph using a MySQL Connection in Amazon QuickSight.
-
Integrating OpenCode Terminal 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.
-
Replicate Multiple Zoom Accounts via the CData Sync CLI
Replicate multiple Zoom accounts to one or many databases.
-
Access Azure Analysis Services Data from MySQL in Amazon QuickSight
Connect to Azure Analysis Services and build visualizations of Azure Analysis Services using a MySQL Connection in Amazon QuickSight.
-
Build AI Agents with Office 365 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 Microsoft Office 365 through CData Connect AI.
-
Getting Started with the CData JDBC Driver for Bullhorn CRM
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Bullhorn CRM.
-
Integrating Antigravity CLI with Act CRM via CData CLI
Connect Act CRM to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize ChargeOver Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load ChargeOver into TIBCO Spotfire.
-
Load Google Ad Manager Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Ad Manager to a database.
-
Build Brex-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Brex.
-
Analyze Live Salesforce Pardot Data in SAS Viya
Use CData Connect AI to connect to Salesforce Pardot from SAS Viya and deploy self-service analytics using live Salesforce Pardot.
-
Connect to Contentful Data in RapidMiner
Integrate Contentful with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Mistral AI Data from a Connection Pool in JBoss
Integrate Mistral AI into Java servlets: Use the Management Console in JBoss to install the Mistral AI JDBC Driver.
-
How to Build an ETL App for SAP HANA Data in Python with CData
Create ETL applications and real-time data pipelines for SAP HANA in Python with petl.
-
How to Work with SingleStore Data in AWS Glue Jobs Using JDBC
Connect to SingleStore from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Replicate AdRoll Data from PowerShell
Write a quick PowerShell script to query AdRoll. Use connectivity to the live data to replicate AdRoll to SQL Server.
-
Connect to Cassandra Data in Google Apps Script via Connect AI
Use CData Connect AI to access Apache Cassandra in Google Apps Script.
-
Connect to Pipeline CRM Data in DBeaver
Use the CData ODBC Driver to connect to Pipeline CRM in DBeaver.
-
How to Connect to Live Okta Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Okta for you.
-
Query Scrapfly Data in DataGrip
Create a Data Source for Scrapfly in DataGrip and use SQL to query live Scrapfly.
-
Replicate Multiple Google Directory Accounts via the CData Sync CLI
Replicate multiple Google Directory accounts to one or many databases.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Elasticsearch using the Model Context Protocol.
-
Publish Chargebee-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Chargebee.
-
Automated Continuous Hive Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Hive replication to Azure SQL Database.
-
Create SSAS Tabular Models from Discord Data
How to build a SQL Server Analysis Service Tabular Model from Discord using CData drivers.
-
Automated Continuous SAP Concur Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP Concur replication to Apache Cassandra.
-
Load Twitter Ads Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Twitter Ads to a database.
-
Connect to Highrise Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Highrise and the SQL Gateway to access Highrise CRM from Google Apps Script.
-
Object-Relational Mapping (ORM) with Rootly 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 Rootly into a Java-based ORM framework, Hibernate.
-
Query Live BambooHR Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live BambooHR directly from the development environment.
-
Build Visualizations of MongoDB Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of MongoDB in Birst.
-
Build CouchDB-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for CouchDB to explore live CouchDB Data in GitHub Copilot to assist with building CouchDB-powered applications.
-
Integrate Live Highrise Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Highrise CRM to Blue Prism using the CData ODBC Driver for Highrise to create automated workflows for repetitive business tasks.
-
View Reports on Real-Time SingleStore Data in Power BI Report Server
Use the CData ODBC Driver for SingleStore to visualize SingleStore in Power BI Desktop and then publish them to Power BI Report Server.
-
Easily Integrate SQL Server Data in Lazarus Pascal IDE
Learn how to easily integrate live Microsoft SQL Server in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Analyze Oracle Service Cloud Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Oracle Service Cloud and visualize Oracle Service Cloud in SAP Analytics Cloud.
-
Use the CData Software ODBC Driver for Access in MicroStrategy Web
Connect to Microsoft Access in MicroStrategy Web using the CData Software ODBC Driver for Access.
-
Automated Continuous SharePoint Replication to SQL Server
Use CData Sync for automated, continuous, customizable SharePoint replication to SQL Server.
-
Analyze Microsoft Ads Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Microsoft Ads and visualize live Microsoft Ads in Infragistics Reveal.
-
Visualize Live Pinterest Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Pinterest using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to AlloyDB Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google AlloyDB.
-
Deploy the ADO.NET Provider for MySQL on an SSRS Report Server
Connect to MySQL from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrating Claude Code CLI with Nethunt 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.
-
Excel Spreadsheet Automation on HBase Data with the QUERY Formula
Pull data from HBase, automate spreadsheets, and more with the QUERY formula.
-
Use the CData Software ODBC Driver for SAP HANA in MicroStrategy
Connect to SAP HANA in MicroStrategy Developer using the CData Software ODBC Driver for SAP HANA.
-
Query ChartMogul Data as a MySQL Database in Node.js
Execute MySQL queries against ChartMogul from Node.js.