CData Software - Knowledge Base
Recent Articles
-
Integrating Claude Code with SAP Business One Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAP Business One within assisted coding and automated development workflows.
-
Access SingleStore Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SingleStore from your Oracle system.
-
Connecting Moonlit Workflow with Spark 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 Apache Spark SQL in real time.
-
Getting Started with the CData ODBC Driver for Pushbullet
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Pushbullet.
-
Manage Snowflake Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Snowflake.
-
Access Bullhorn CRM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Bullhorn CRM from HeidiSQL.
-
DataBind Controls to Outreach.io Data in C++Builder
DataBind to Outreach.io in C++Builder with standard components and controls.
-
Build a Singer.io Tap for Neo4J With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Neo4J data using
-
Access Live Oracle Sales Data in Coginiti Pro
Connect to and query live Oracle Sales from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Migrating data from PostgreSQL to Databricks using CData SSIS Components.
Easily push PostgreSQL to Databricks using the CData SSIS Tasks for PostgreSQL and Databricks.
-
Design BIRT Reports on Cassandra Data
Provide current Apache Cassandra to your embedded analytics.
-
How to Access Google Analytics Data Using Entity Framework
This article shows how to access Google Analytics using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Enable the Drift JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Drift.
-
Build MYOB AccountRight-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live MYOB AccountRight.
-
Import Real-Time ClickTime Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ClickTime in ColdFusion.
-
Build Sage Intacct-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Sage Intacct to explore live Sage Intacct Data in GitHub Copilot to assist with building Sage Intacct-powered applications.
-
Getting Started with the CData Power BI Connector for Mocean
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Design BIRT Reports on OData Services
Provide current OData to your embedded analytics.
-
Visualize Live Everhour Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Everhour.
-
Build AI/ML Models with Live AfterShip Data using Dataiku
Connect AfterShip Data with Dataiku using the CData API Driver for JDBC.
-
Operational Reporting on Flowlu Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Flowlu.
-
Build Data Flows from Bitbucket to SQL Server using SSIS
Easily back up Bitbucket to SQL Server using the SSIS components for Bitbucket.
-
Build Pipelines with Live GitLab Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to GitLab from Google Cloud Data Fusion, enabling the integration of live GitLab into the building and management of effective data pipelines.
-
Create Presto Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Presto data access from reports, embedded analytics, and more.
-
Build YouTube Analytics-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to YouTube Analytics Data from Zoho Analytics and import live YouTube Analytics.
-
Use the CData Software JDBC Driver for Customer.io in MicroStrategy Web
Connect to Customer.io in MicroStrategy Web using the CData Software JDBC Driver for Customer.io.
-
Manage Float Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Float.
-
How to connect to Perplexity Data with Squirrel SQL client
Connect to Perplexity and execute queries in the Squirrel SQL Client.
-
Connect to Adobe Commerce Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Adobe Commerce as an External Source in Dremio.
-
Connect to Authorize.Net Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Authorize.Net.
-
Perform Batch Operations with Impala Data in Apache NiFi
Connect to Apache Impala and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Create Dynamic Xero Grids Using the Infragistics XamDataGrid
Learn how you can connect Xero to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Front Data in CloverDX (formerly CloverETL)
Transfer Front using the visual workflow in the CloverDX data integration tool.
-
A PostgreSQL Interface for Airtable Data (MySQL Remoting via JDBC)
Use the Remoting features of the Airtable JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Apify Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Apify as an External Source in Dremio.
-
How to integrate Salesforce with Apache Airflow
Access and process Salesforce & Force.com in Apache Airflow using the CData JDBC Driver.
-
Build Basecamp-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Basecamp and build Basecamp-connected web apps with Axios.
-
Automated Continuous CockroachDB Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable CockroachDB replication to Google BigQuery.
-
Build Instagram-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Instagram Data and create custom apps in Bubble.
-
Build a Singer.io Tap for IBM Informix With the CData Python Connector
Learn how to easily build a Singer.io Tap for live IBM Informix data using
-
Connect to Bannerbear Data in HULFT Integrate
Connect to Bannerbear as a JDBC data source in HULFT Integrate
-
Import Confluence Data Using Azure Data Factory
Use CData Connect AI to connect to Confluence Data from Azure Data Factory and import live Atlassian Confluence.
-
Use JayDeBeApi to access Freshdesk Data in Python
Use standard Python scripting and the development environment of your choice to access live Freshdesk.
-
Automated Continuous SendInBlue Replication to Snowflake
Use CData Sync for automated, continuous, customizable SendInBlue replication to Snowflake.
-
Access Live DB2 Data in Coginiti Pro
Connect to and query live IBM DB2 from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Telegram Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to connect to QuickBooks Online Data from Spring Boot
Connect to QuickBooks Online in a Spring Boot Application using the CData JDBC Driver for QuickBooks Online
-
Access Zoho Projects Data from MySQL in Amazon QuickSight
Connect to Zoho Projects and build visualizations of Zoho Projects using a MySQL Connection in Amazon QuickSight.
-
Establish a Live Connection with Okta Data using Tableau Bridge
The CData ODBC Driver for Okta enables you to integrate live Okta into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Greenhouse Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Greenhouse replication to IBM DB2.
-
Connect to IBM Cloud Object Storage Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for IBM Cloud Object Storage Data and connect to IBM Cloud Object Storage in Akorbi Digital RunMyProcess.
-
Build Dashboards with ZohoSubscriptions Data in Dundas BI
Create dynamic dashboards and perform analytics based on ZohoSubscriptions in Dundas BI.
-
Integrate Live Rebilly Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Rebilly to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build Apps with Live Dropbox in Adalo using CData Connect AI
Use CData Connect AI to integrate live Dropbox into the Adalo platform and build custom mobile and web applications with real-time Dropbox.
-
Getting Started with the CData ODBC Driver for TaxJar
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for TaxJar.
-
Query Monday.com Data as a MySQL Database in Node.js
Execute MySQL queries against Monday.com from Node.js.
-
Connect Azure Analysis Services to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Azure Analysis Services with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect to Live Paylocity Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Paylocity for you.
-
Connect to Greenplum Data in Ruby
Connect to Pivotal GreenPlum in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate LinkedIn Ads with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate LinkedIn Ads with External Services.
-
Build Visualizations of AfterShip Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of AfterShip in Birst.
-
Excel Spreadsheet Automation on Pipeliner CRM Data with the QUERY Formula
Pull data from Pipeliner CRM, automate spreadsheets, and more with the QUERY formula.
-
Connect to Klipfolio Data in DBeaver
Use the CData ODBC Driver to connect to Klipfolio in DBeaver.
-
How to connect PolyBase to PDFMonkey
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PDFMonkey.
-
Analyze Sybase Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Sybase and visualize Sybase in SAP Analytics Cloud.
-
How to Access Live Paddle Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Paddle enables you to integrate Paddle into workflows built using Microsoft Power Automate Desktop.
-
How to Visualize Billsby Data in Python with pandas
Use pandas and other modules to analyze and visualize live Billsby in Python.
-
Connect to Bannerbear Data from a Connection Pool in JBoss
Integrate Bannerbear into Java servlets: Use the Management Console in JBoss to install the Bannerbear JDBC Driver.
-
Load Zoho CRM Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Zoho CRM to a database.
-
Connect to Telegram Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Telegram to connect to Telegram and execute queries in PowerBuilder.
-
Use the CData Software ODBC Driver for PagerDuty in MicroStrategy
Connect to PagerDuty in MicroStrategy Developer using the CData Software ODBC Driver for PagerDuty.
-
Create Square-Connected Nintex Workflows
Use CData Connect AI to connect to Square Data from Nintex Workflow Cloud and build custom workflows using live Square.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Directory
Provide connectivity to Google Directory through an SAP BusinessObjects universe.
-
How to connect to Instagram Data from Spring Boot
Connect to Instagram in a Spring Boot Application using the CData JDBC Driver for Instagram
-
Connect to Impala Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Apache Impala.
-
Import Real-Time Ontraport Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Ontraport in ColdFusion.
-
How to connect to SharePoint Excel Services Data from Spring Boot
Connect to SharePoint Excel Services in a Spring Boot Application using the CData JDBC Driver for SharePoint Excel Services
-
How to work with Strava Data in Apache Spark using SQL
Access and process Strava Data in Apache Spark using the CData Software JDBC Driver.
-
How to Easily Query Google Tasks Data in OpenOffice Base
Connect to Google Tasks data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Bidirectional Access to SAP BusinessObjects BI Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP BusinessObjects BI in Filemaker Pro for Mac or Windows.
-
Integrating GitHub Copilot CLI with Shopify 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 create GitHub federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for GitHub in MySQL .
-
Automate JotForm Data Replication to Azure Synapse
Use CData Sync to customize and automate JotForm replication to Azure Synapse.
-
Integrate with Landbot Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Landbot to a JSON file on disk.
-
Automate SAP Hybris C4C Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP Hybris C4C from PowerShell? This article demonstrates how to utilize the SAP Hybris C4C Cmdlets for tasks like connecting to SAP Hybris C4C, automating operations, downloading data, and more.
-
LINQ to Amazon Athena Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Amazon Athena Data Provider.
-
Enable the Adobe Target JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Adobe Target.
-
ETL Acumatica in Oracle Data Integrator
This article shows how to transfer Acumatica ERP into a data warehouse using Oracle Data Integrator.
-
Work with Live FTP Data in Power Query
Use CData Connect AI to connect to FTP Servers and work with live FTP Servers in Microsoft Power Query.
-
Use Dash to Build to Web Apps on Hugging Face Data
Create Python applications that use pandas and Dash to build Hugging Face-connected web apps.
-
Viewing Copper Data in RAD Studio Data Explorer
How to view Copper in RAD Studio Data Explorer using the CData ODBC Driver for Copper.
-
Automated Continuous LinkedIn Replication to MySQL
Use CData Sync for automated, continuous, customizable LinkedIn replication to MySQL.
-
Connect to Sage 300 Data from PowerBuilder via ADO.NET
This article demonstrates how to access Sage 300 from Appeon PowerBuilder using the CData ADO.NET Provider for Sage 300.
-
How to load Tavily data into Elasticsearch via Logstash
Introducing a simple method to load Tavily data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Replicate Azure DevOps Data in Heroku for Use in Salesforce Connect
Replicate Azure DevOps to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Migrating data from Customer.io to Snowflake using CData SSIS Components.
Easily push Customer.io to Snowflake using the CData SSIS Tasks for Customer.io and Snowflake.
-
Add Dynamics 365 Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Dynamics 365 with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Biml to Build SSIS Tasks to Replicate GitLab Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate GitLab to SQL Server.
-
Natively Connect to QuickBooks Online Data in PHP
The CData ODBC driver for QuickBooks Online enables you to create PHP applications with connectivity to QuickBooks Online. Leverage the native support for ODBC in PHP.
-
LINQ to Lakebase Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Lakebase Data Provider.