CData Software - Knowledge Base
Recent Articles
-
Enable the Azure DevOps JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Azure DevOps data.
-
How to import Freshsales Data into Apache Solr
Use the CData Software JDBC Driver for Freshsales in Data Import Handler and create an automated import of Freshsales data to Apache Solr Enterprise Search platform.
-
Use the CData Software ODBC Driver for Acumatica in MicroStrategy Web
Connect to Acumatica data in MicroStrategy Web using the CData Software ODBC Driver for Acumatica.
-
Getting Started with the CData JDBC Driver for Lakebase
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Lakebase.
-
Integrate Trae with Live Reckon Accounts Hosted Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Reckon Accounts Hosted data from within the AI-powered IDE.
-
Connect to Live Vault CRM Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Vault CRM in CData Connect AI and connect to your Vault CRM data from PostgreSQL.
-
Access Bitbucket Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Bitbucket data from your Oracle system.
-
Publish Freshservice-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Freshservice data.
-
Build Bullhorn CRM-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Bullhorn CRM data without replication.
-
How to Connect to Live SFTP 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 SFTP data for you.
-
Integrate Goose with Live Moosend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Moosend data from within the local AI agent.
-
Consume Oracle Financials Cloud OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Oracle Financials Cloud feeds that reflect any changes in SAP Lumira.
-
Connect Zuora to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Zuora with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software ODBC Driver for Flowlu in MicroStrategy Desktop
Connect to Flowlu data in MicroStrategy Desktop using the CData Software ODBC Driver for Flowlu.
-
Automated Continuous Short.io Replication to Vertica
Use CData Sync for automated, continuous, customizable Short.io replication to Vertica.
-
Create Dashboards and Visualize Live Jumpseller Data in Geckoboard
Use CData Connect AI to connect to live Jumpseller data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access Live Adobe Experience Manager Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Adobe Experience Manager data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Visualize Tanda Data in Tableau
The CData ODBC driver for Tanda enables you integrate Tanda data into Tableau dashboards.
-
Connect to ServiceNow Data from HeidiSQL
Use CData Connect AI to connect to and query live ServiceNow data from HeidiSQL.
-
Migrating data from Salesforce Marketing to Google BigQuery using CData SSIS Components.
Easily push Salesforce Marketing data to Google BigQuery using the CData SSIS Tasks for Salesforce Marketing and Google BigQuery.
-
ETL Salesforce in Oracle Data Integrator
This article shows how to transfer Salesforce data into a data warehouse using Oracle Data Integrator.
-
Provide OData Services of Nuclia Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Nuclia data by developing a WCF Service Application.
-
Automated Continuous Guru Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Guru replication to PostgreSQL.
-
Create Freshteam-Connected Applications in Appsmith
Connect to Freshteam Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Freshteam data.
-
Automate Productboard Data Replication to Azure Data Lake
Use CData Sync to customize and automate Productboard data replication to Azure Data Lake.
-
Extract, Transform, and Load Box Data in Informatica PowerCenter
Create a simple Workflow for Box data in Informatica PowerCenter.
-
Build Dashboards with Bullhorn CRM Data in DBxtra
Create dynamic dashboards and perform analytics based on Bullhorn CRM data in DBxtra.
-
Connect to Airtable Data in ACL Analytics
Connect to Airtable data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Airtable data.
-
Connect to ZohoPeople Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to ZohoPeople.
-
Integrating GitHub Copilot with Teradata 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.
-
Migrating data from PingOne to Snowflake using CData SSIS Components.
Easily push PingOne data to Snowflake using the CData SSIS Tasks for PingOne and Snowflake.
-
Query Facebook Ads Data in DataGrip
Create a Data Source for Facebook Ads in DataGrip and use SQL to query live Facebook Ads data.
-
Query WordPress Data as a SQL Server Database in Node.js
Execute SQL Server queries against WordPress data from Node.js.
-
Access Guru Data from MySQL in Amazon QuickSight
Connect to Guru and build visualizations of Guru data using a MySQL Connection in Amazon QuickSight.
-
Access Sage 200 Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sage 200 data from your Oracle system.
-
Create Power BI Reports on Real-Time Neo4J Data
Use the CData ODBC Driver for Neo4J to visualize Neo4J data in Power BI Desktop.
-
Build Amazon S3-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Amazon S3 Data from Zoho Analytics and import live Amazon S3 data.
-
Connect to Monday.com Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Monday.com data.
-
Query SAP Concur Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP Concur entities in PHP by modeling them as objects.
-
Integrate LibreChat with Live SageHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SageHR data from within the chat interface.
-
Visualize Live Dynamics NAV Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Dynamics NAV data.
-
Create Dashboards and Visualize Live Google Directory Data in Geckoboard
Use CData Connect AI to connect to live Google Directory data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create PostgreSQL Dataflows on PowerBI.com
Connect to the CData Power BI Connector for PostgreSQL from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query Perplexity Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Perplexity data from Node.js.
-
Integrating Codex with PayPal 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 Jira Data from PowerBuilder via ADO.NET
This article demonstrates how to access Jira data from Appeon PowerBuilder using the CData ADO.NET Provider for Jira.
-
Enable the Scrapfly JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Scrapfly data.
-
Create Azure Table-Connected Applications in Appsmith
Connect to Azure Table Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Azure Table data.
-
Integrate Asana with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Asana with External Services.
-
Access Live Greenplum Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Greenplum data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Import and Visualize ShipStation Data in Power View
Create data visualizations based on ShipStation data in Excel.
-
How to use SQLAlchemy ORM to access Google Forms Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Forms data.
-
Integrate with Teradata Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Teradata data to a JSON file on disk.
-
Easily Integrate TaxJar Data in Lazarus Pascal IDE
Learn how to easily integrate live TaxJar data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Use a Microsoft Access Database to Update SAP Netweaver Gateway Data in Real Time
Update SAP Netweaver Gateway data by creating a linked table in Microsoft Access with the CData SAP Netweaver Gateway ODBC Driver.
-
Use Dash to Build to Web Apps on Vault CRM Data
Create Python applications that use pandas and Dash to build Vault CRM-connected web apps.
-
Deploy the ADO.NET Provider for SAP Business One on an SSRS Report Server
Connect to SAP Business One data 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.
-
Integrate Google's Antigravity Agent with Live Bright Data Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Bright Data data using the Model Context Protocol.
-
Create Act CRM-Connected Applications in Appsmith
Connect to Act CRM Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Act CRM data.
-
Create MarkLogic-Connected Applications in Appsmith
Connect to MarkLogic Data via CData Connect AI in Appsmith and create custom business applications with real-time access to MarkLogic data.
-
Create a Data Access Object for Simplesat Data using JDBI
A brief overview of creating a SQL Object API for Simplesat data in JDBI.
-
Analyze SendPulse Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SendPulse from Power Pivot. You will use the Table Import Wizard to load SendPulse data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Zoho Recruit Data in HULFT Integrate
Connect to Zoho Recruit as a JDBC data source in HULFT Integrate
-
Connect to Databricks Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Databricks to connect to Databricks data and execute queries in PowerBuilder.
-
Connect to Azure Table Data in DBeaver
Use the CData ODBC Driver to connect to Azure Table data in DBeaver.
-
Replicate Multiple Hubstaff Accounts via the CData Sync CLI
Replicate multiple Hubstaff accounts to one or many databases.
-
Analyze eBay Analytics Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze eBay Analytics data in Microsoft R Open.
-
Bidirectional Access to Zoho Creator Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Zoho Creator data in Filemaker Pro for Mac or Windows.
-
A PostgreSQL Interface for Retently Data (MySQL Remoting via JDBC)
Use the Remoting features of the Retently JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Live Salesforce Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Salesforce data from within the IDE.
-
Connect to Stack Exchange from Asprova with CData Software ODBC Driver for Stack Exchange
This article shows how to connect faster to Stack Exchange data from Asprova.
-
How to integrate Miro with Apache Airflow
Access and process Miro data in Apache Airflow using the CData JDBC Driver.
-
Build Google Directory-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Google Directory Data and create custom apps in Bubble.
-
Integrating Dataiku with SAP HANA 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 HANA data.
-
Connect to Gmail Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Gmail and the Script function in FileMaker Pro to connect to Gmail and work with Gmail data in your FileMaker application.
-
Access Live Apollo Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apollo data from your Google Sheets.
-
How to work with Dynamics CRM Data in Apache Spark using SQL
Access and process Dynamics CRM Data in Apache Spark using the CData Software JDBC Driver.
-
Connecting Pipedream with SAP ByDesign Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on SAP ByDesign data in real time.
-
Visualize Live Marketo Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Marketo data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Sentry Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Sentry data.
-
Integrate with Live ActiveCampaign Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to ActiveCampaign from the MuleSoft Anypoint Platform to integrate live ActiveCampaign data into custom reports and dashboards.
-
Create a Data Access Object for Auth0 Data using JDBI
A brief overview of creating a SQL Object API for Auth0 data in JDBI.
-
Prepare, Blend, and Analyze Vault CRM Data in Alteryx Designer (Connect AI)
Build workflows to access live Vault CRM data for self-service data analytics.
-
How to Connect to Live ShipEngine 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 ShipEngine data for you.
-
Automated Continuous Splunk Replication to MongoDB
Use CData Sync for automated, continuous, customizable Splunk replication to MongoDB.
-
Work with Superchat Data in FoxPro
Load Superchat data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData Python Connector for JotForm
Learn to install and license the CData Python Connector and configure a connection to live JotForm data.
-
Connect Dropbox to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Dropbox with IBM WebSphere for seamless data integration and connectivity.
-
Access Live Avalara AvaTax Data in Excel 365 Online (Excel for the web)
Connect to Avalara AvaTax data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Access Salesloft Data Using Entity Framework
This article shows how to access Salesloft data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to ShipEngine Data from Crystal Reports
Use CData Connect AI to connect to and report on live ShipEngine data from Crystal Reports.
-
Integrating LangChain with Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Airtable data within automated workflows.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Dynamics 365
Provide connectivity to Dynamics 365 data through an SAP BusinessObjects universe.
-
Connect to Deel from Asprova with CData Software ODBC Driver for Deel
This article shows how to connect faster to Deel data from Asprova.
-
Creating Oracle HCM Cloud-Connected Applications in Unqork
You can use CData Connect AI to feed Oracle HCM Cloud data to Unqork and build custom business apps.
-
Integrate Google's Antigravity Agent with Live Cloudflare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Cloudflare data using the Model Context Protocol.
-
Integrate Cline with Live HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live HCL Domino data from within your IDE.
-
Deploy the ADO.NET Provider for Google Tasks on an SSRS Report Server
Connect to Google Tasks data 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.
-
How to connect to Couchbase Data from IntelliJ
Integrate connectivity to Couchbase data with wizards in IntelliJ.
-
Explore Geographical Relationships in Hubstaff Data with Power Map
Create data visualizations with Hubstaff data in Power Map.