CData Software - Knowledge Base
Recent Articles
-
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.
-
Connect to Harvest Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Harvest as an External Source in Dremio.
-
Use the CData Software ODBC Driver for ChartMogul in MicroStrategy Web
Connect to ChartMogul in MicroStrategy Web using the CData Software ODBC Driver for ChartMogul.
-
Create Informatica Mappings From/To an ODBC Data Source for Hubstaff
Create an ODBC connection to Hubstaff in Informatica and browse and transfer Hubstaff.
-
How to Work with Landbot Data in ETL Validator JDBC
Connect to Landbot from ETL Validator jobs using the CData Software JDBC Driver.
-
Analyze SharePoint Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Microsoft SharePoint and visualize live Microsoft SharePoint in Infragistics Reveal.
-
Getting Started with the CData JDBC Driver for Google Ad Manager
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Ad Manager.
-
Validate Impala Data with QuerySurge
Access and validate Apache Impala in QuerySurge using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Dynamics NAV in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft Dynamics NAV in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Dynamics NAV.
-
Connecting Mastra with Office 365 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 Microsoft Office 365, no replication required.
-
How to Connect DBeaver to Gumroad via a JDBC Driver
Manage Gumroad with visual tools in DBeaver like the query browser.
-
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.
-
Integrate Live Printify Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Printify to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
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.
-
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.
-
Extract, Transform, and Load Short.io Data in Informatica PowerCenter
Create a simple Workflow for Short.io in Informatica PowerCenter.
-
Automated Continuous Vault CRM Replication to Databricks
Use CData Sync for automated, continuous, customizable Vault CRM replication to Databricks.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for FormSite
Provide connectivity to FormSite through an SAP BusinessObjects universe.
-
Connect to Pushbullet Data in RapidMiner
Integrate Pushbullet with standard components and data source configuration wizards in RapidMiner Studio.
-
Publish Billsby-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Billsby.
-
How to Seamlessly Import FTP Data into IBM SPSS Modeler
Integrate FTP data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Dynamics CRM Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft Dynamics CRM and build visualizations in Tableau.
-
Integrating Gumloop with QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on QuickBooks Time within automated workflows.
-
Build Vimeo-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Vimeo.
-
Integrate with Cosmos DB Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Azure Cosmos DB to a JSON file on disk.
-
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.
-
Getting Started with the CData ODBC Driver for ZohoInvoice
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ZohoInvoice.
-
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.
-
How to Import Data from Opsgenie into Google Sheets
Import Opsgenie into a Google spreadsheet that is automatically refreshed.
-
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.
-
How to Easily Query ZeroBounce Data in OpenOffice Base
Connect to ZeroBounce data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Connect to Live Greenhouse Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Greenhouse securely in real time.
-
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 Splunk Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Splunk. Leverage the pyodbc module for ODBC in Python.
-
How to Seamlessly Import Oracle Data into IBM SPSS Modeler
Integrate Oracle data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Connect to Live LinkedIn Ads Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your LinkedIn Ads for you.
-
Connect to Bitbucket Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Bitbucket in the Denodo Virtual DataPort Administrator.
-
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.
-
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.
-
Access Google Spanner Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Spanner from your Oracle system.
-
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.
-
Import Real-Time Coinbase Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Coinbase in ColdFusion.
-
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.
-
How to Create Power BI Visual Reports with Real-Time CouchDB Data
Use CData Power BI Connectors to visualize Apache CouchDB in Power BI.
-
Connect to Google Directory Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Google Directory and the Script function in FileMaker Pro to connect to Google Directory and work with Google Directory in your FileMaker application.
-
Use Biml to Build SSIS Tasks to Replicate HBase Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Apache HBase to SQL Server.
-
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.
-
DataBind Charts to Airtable Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Airtable 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.
-
Object-Relational Mapping (ORM) with Google Campaign Manager 360 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 Google Campaign Manager 360 into a Java-based ORM framework, Hibernate.
-
How to connect SharePoint with ShipEngine Data through external lists
Provide ShipEngine to SharePoint users as an external list.
-
Viewing Chargebee Data in RAD Studio Data Explorer
How to view Chargebee in RAD Studio Data Explorer using the CData ODBC Driver for Chargebee.
-
Query Scrapfly Data in DataGrip
Create a Data Source for Scrapfly in DataGrip and use SQL to query live Scrapfly.
-
Publish Chargebee-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Chargebee.
-
Connect to Avro Data in ACL Analytics
Connect to Apache Avro via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Apache Avro.
-
Connect to Square Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Square Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automated Continuous SAP Concur Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP Concur replication to Apache Cassandra.
-
Build Visualizations of MongoDB Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of MongoDB in Birst.
-
Connect to Oracle Service Cloud Data in ACL Analytics
Connect to Oracle Service Cloud via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Oracle Service Cloud.
-
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.
-
Connect to and Visualize Live Billsby Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Billsby.
-
Create Informatica Mappings From/To an ODBC Data Source for JobNimbus
Create an ODBC connection to JobNimbus in Informatica and browse and transfer JobNimbus.
-
Build Dashboards with ZohoPeople Data in DBxtra
Create dynamic dashboards and perform analytics based on ZohoPeople in DBxtra.
-
Visualize Live SAP Ariba Source Data in the Power BI Service
Use CData Connect AI to connect to live SAP Ariba Source and create custom reports in the Power BI Service through the On-Premises Gateway.
-
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.
-
Access Live Splunk Data in Excel 365 Online (Excel for the web)
Connect to Splunk from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Invoiced Data in Jaspersoft Studio
Execute SQL to remote Invoiced in Jaspersoft Studio.
-
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.
-
Connect to Act CRM Data from a Connection Pool in JBoss
Integrate Act CRM into Java servlets: Use the Management Console in JBoss to install the Act CRM JDBC Driver.
-
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 Webex Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Webex and perform CRUD operations on Webex from Node.js.
-
Build SAP ByDesign Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP Business ByDesign and build visualizations in Tableau.
-
Integrate with GitLab Data in JReport Designer
Create charts and reports based on GitLab in JReport Designer.
-
Create a Data Access Object for CloudConvert Data using JDBI
A brief overview of creating a SQL Object API for CloudConvert in JDBI.
-
Visualize Salesforce Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Salesforce & Force.com.
-
Connect to and Visualize Live PayPal Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live PayPal.
-
Write a Simple Go Application to work with Sybase Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sybase.
-
Connect to Webex Data in HULFT Integrate
Connect to Webex as a JDBC data source in HULFT Integrate