CData Software - Knowledge Base
Recent Articles
-
Create Dynamic Keap Grids Using the Infragistics XamDataGrid
Learn how you can connect Keap to Infragistics XamDataGrid to build dynamic grids.
-
Integrating Dataiku with SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP Business ByDesign.
-
Build Shopify-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Shopify and build Shopify-connected web apps with Axios.
-
Replicate Multiple ZohoInvoice Accounts
Replicate multiple ZohoInvoice accounts to one or many databases.
-
Import and Visualize Yelp Data in Power View
Create data visualizations based on Yelp in Excel.
-
Object-Relational Mapping (ORM) with LeadDesk 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 LeadDesk into a Java-based ORM framework, Hibernate.
-
How to Query Live Zoho Inventory Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Zoho Inventory data in natural language using Python.
-
Analyze Live Cosmos DB Data in SAS Viya
Use CData Connect AI to connect to Azure Cosmos DB from SAS Viya and deploy self-service analytics using live Azure Cosmos DB.
-
Create a Data Access Object for Azure Data Lake Storage Data using JDBI
A brief overview of creating a SQL Object API for Azure Data Lake Storage in JDBI.
-
Use the CData Software JDBC Driver for Jira Assets in MicroStrategy Web
Connect to Jira Assets in MicroStrategy Web using the CData Software JDBC Driver for Jira Assets.
-
Analyze NASA Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze NASA in Microsoft R Open.
-
A PostgreSQL Interface for BigQuery Data (MySQL Remoting via JDBC)
Use the Remoting features of the BigQuery JDBC Driver to create a PostgreSQL entry-point for data access.
-
Excel Online Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Excel Online through CData Connect AI using different applications and tools.
-
Connect to Float Data from PowerBuilder via ADO.NET
This article demonstrates how to access Float from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to ZarMoney Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to ZarMoney and work with ZarMoney in your FileMaker application.
-
Build AI/ML Models with Live ShipStation Data using Dataiku
Connect ShipStation Data with Dataiku using the CData JDBC Driver for ShipStation.
-
Integrate Cursor with Live AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google AlloyDB from within the editor.
-
Model IBM Informix Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and IBM Informix, enabling the direct import of real-time IBM Informix.
-
Use the CData Software JDBC Driver for Anaplan in MicroStrategy
Connect to Anaplan in MicroStrategy Developer using the CData Software JDBC Driver for Anaplan.
-
Build Apps with Live Apache Phoenix in Adalo using CData Connect AI
Use CData Connect AI to integrate live Apache Phoenix into the Adalo platform and build custom mobile and web applications with real-time Apache Phoenix.
-
Access Epicor Kinetic Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Epicor Kinetic from your Oracle system.
-
Connect to Bitbucket Data from a Connection Pool in JBoss
Integrate Bitbucket into Java servlets: Use the Management Console in JBoss to install the Bitbucket JDBC Driver.
-
Feed Amazon Marketplace Data into FineReport
How to set Amazon Marketplace as a JDBC data source in FineReport.
-
Process & Analyze Sage Cloud Accounting Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Sage Cloud Accounting Data.
-
Getting Started with the CData ADO.NET Provider for Impala
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Impala.
-
Create Informatica Mappings From/To an ODBC Data Source for Intercom
Create an ODBC connection to Intercom in Informatica and browse and transfer Intercom.
-
Access Salesforce Pardot Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Salesforce Pardot from HeidiSQL.
-
Manage ChargeOver Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ChargeOver.
-
Access Zuora Data from MySQL in PHP
Connect to Zuora through the standard MySQL libraries in PHP.
-
Connect to LaunchDarkly Data in NetBeans
Connect to LaunchDarkly in NetBeans with the data source configuration wizard.
-
Create Power BI Reports on Real-Time LightSpeedRetail Data
Use the CData ODBC Driver for LightSpeedRetail to visualize LightSpeedRetail in Power BI Desktop.
-
Connect Splunk to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Splunk with IBM WebSphere for seamless data integration and connectivity.
-
Integrating OpenCode Terminal with Printify 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.
-
A PostgreSQL Interface for Mode Data using the CData ODBC Driver
Use the SQL Gateway and Mode ODBC Driver to create a PostgreSQL entry-point for data access.
-
Natively Connect to Jumpseller Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Jumpseller. Leverage the native support for ODBC in PHP.
-
How to Create Power BI Visual Reports with Real-Time OnePageCrm Data
Use CData Power BI Connectors to visualize OnePageCrm in Power BI.
-
Create Dynamic eBay Grids Using the Infragistics XamDataGrid
Learn how you can connect eBay to Infragistics XamDataGrid to build dynamic grids.
-
Integrate FTP with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate FTP with External Services.
-
How to connect to Attio Data with Squirrel SQL client
Connect to Attio and execute queries in the Squirrel SQL Client.
-
Consume DB2 OData Feeds in SAP Lumira
Use the API Server to create data visualizations on DB2 feeds that reflect any changes in SAP Lumira.
-
Moving Data from SingleStore to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SingleStore data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Biml to Build SSIS Tasks to Replicate Acumatica Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Acumatica ERP to SQL Server.
-
Build Dashboards with Pinterest Data in Dundas BI
Create dynamic dashboards and perform analytics based on Pinterest in Dundas BI.
-
Connect to Aircall Data in RapidMiner
Integrate Aircall with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Everhour Data in the Pentaho Report Designer
Publish reports based on Everhour in the Pentaho BI tool.
-
Access Oracle Financials Cloud Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Oracle Financials Cloud from HeidiSQL.
-
Use the CData SSIS Components to Insert New or Update Existing Wave Financial Records from SQL Server
Easily push SQL Server data to Wave Financial using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Wave Financial or update existing records with data from a SQL Server database.
-
Access Live PabblySubscriptions Data in AWS Lambda (with IntelliJ IDEA)
Connect to live PabblySubscriptions in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
LINQ to Superchat 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 Superchat Data Provider.
-
Automated Continuous Sage Cloud Accounting Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Google BigQuery.
-
Automate Retently Data Replication to Azure Data Lake
Use CData Sync to customize and automate Retently replication to Azure Data Lake.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAP Ariba Procurement within intelligent workflows.
-
Connect to Office 365 Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Office 365 to connect to Microsoft Office 365 and execute queries in PowerBuilder.
-
Automated Continuous JotForm Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable JotForm replication to Apache Cassandra.
-
Bidirectional Access to Microsoft Planner Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Planner in Filemaker Pro for Mac or Windows.
-
Process & Analyze Workable Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Workable Data.
-
Use the CData ODBC Driver for Act-On in Microsoft Power Query
You can use the CData Act-On ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Act-On into Microsoft Power Query.
-
Establish a Live Connection with Drift Data using Tableau Bridge
The CData ODBC Driver for Drift enables you to integrate live Drift into Tableau Cloud dashboards using the Tableau Bridge.
-
Connecting Agentforce with Sage Cloud Accounting Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Sage Business Cloud Accounting for you.
-
Automated Continuous Salesforce Marketing Replication to SQL Server
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to SQL Server.
-
Build MVC Applications with Connectivity to Workable Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Workable from an ASP.NET MVC application.
-
Replicate Epicor Kinetic Data in Heroku for Use in Salesforce Connect
Replicate Epicor Kinetic to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Microsoft OneDrive Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Microsoft OneDrive facts in real time.
-
Replicate HubSpot Data to Multiple Databases via the CData Sync CLI
Replicate HubSpot to disparate databases with a single configuration.
-
Use Biml to Build SSIS Tasks to Replicate Tanda Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Tanda to SQL Server.
-
How to Connect the Power BI Service to Adobe Target: Complete Guide
Connect to the CData Software Power BI Connector for Adobe Target from PowerBI.com to provide real-time Adobe Target across the organization.
-
Automated Continuous Oracle Service Cloud Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Apache Cassandra.
-
Connect to Productboard Data from PowerBuilder via ADO.NET
This article demonstrates how to access Productboard from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Couchbase Data in RapidMiner
Integrate Couchbase with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Real-Time Access to Google Directory in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Directory in real time.
-
Stream Microsoft Entra ID Data into Apache Kafka Topics
Access and stream Microsoft Entra ID in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Replicate Google Calendar Data to Multiple Databases via the CData Sync CLI
Replicate Google Calendar to disparate databases with a single configuration.
-
Import and Visualize Optimizely Data in Power View
Create data visualizations based on Optimizely in Excel.
-
Working with SAP HANA Data in LINQPad
Execute LINQ queries to SAP HANA in LINQPad.
-
Connect to FHIR Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for FHIR in Airbyte.
-
How to connect and process Teamwork from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Teamwork.
-
Access Live Excel Online Data in Coginiti Pro
Connect to and query live Microsoft Excel Online from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Webex Data in Aqua Data Studio
Access Webex from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Stream SQL Server Data into Apache Kafka Topics
Access and stream Microsoft SQL Server in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Back Up Salesforce Data 360 to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Salesforce Data 360. In this article, we will employ an SSIS workflow to populate a database with Salesforce Data 360 data.
-
Viewing DB2 Data in RAD Studio Data Explorer
How to view IBM DB2 in RAD Studio Data Explorer using the CData ODBC Driver for DB2.
-
Integrating OpenCode Terminal with Demio 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.
-
Create Authorize.Net-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Authorize.Net Data from Klipfolio and build custom visualizations using live Authorize.Net.
-
Integrating Cursor CLI with Foursquare 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.
-
Connect to Basecamp Data from a Connection Pool in JBoss
Integrate Basecamp into Java servlets: Use the Management Console in JBoss to install the Basecamp JDBC Driver.
-
Query Sage 200 Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Sage 200 from Node.js.
-
Connect to Azure Table Data in RapidMiner
Integrate Azure Table Storage with standard components and data source configuration wizards in RapidMiner Studio.
-
How to create Stack Exchange federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Stack Exchange in MySQL .
-
Connect to Humanity Data from PowerBuilder via ADO.NET
This article demonstrates how to access Humanity from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Stream Bugsnag Data into Apache Kafka Topics
Access and stream Bugsnag in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access ActiveCampaign Data from MySQL in PHP
Connect to ActiveCampaign through the standard MySQL libraries in PHP.
-
How to Access Live ServiceNow Data in Visual Studio Code via Cline
Run CData MCP Server for ServiceNow on Windows Subsytem for Linux (WSL) and connect to live ServiceNow from the Cline extension in Visual Studio Code.
-
Integrating Antigravity CLI with Shopify via CData CLI
Connect Shopify to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use ChatGPT to Talk to Your SAP BusinessObjects BI 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 SAP BusinessObjects BI for you.
-
Connect to ClickTime Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ClickTime as an External Source in Dremio.
-
Use Dash to Build Web Apps on Google Directory Data via CData Connect AI
Build interactive Dash web apps on live Google Directory using pandas and the CData Connect AI Python SDK.
-
Connect to ChartMogul Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ChartMogul as an External Source in Dremio.
-
Access Live Cassandra Data in TIBCO Data Virtualization
Use the Cassandra Tibco DV Adapter to create a Apache Cassandra data source in TIBCO Data Virtualization Studio and gain access to live Apache Cassandra from your TDV Server.
-
How to load EnterpriseDB data into Elasticsearch via Logstash
Introducing a simple method to load EnterpriseDB data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Dynamic AfterShip Grids Using the Infragistics XamDataGrid
Learn how you can connect AfterShip to Infragistics XamDataGrid to build dynamic grids.