CData Software - Knowledge Base
Recent Articles
-
Connect to SAS Data Sets Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAS Data Sets Data and connect to SAS Data Sets in Akorbi Digital RunMyProcess.
-
Use the CData ODBC Driver for Testmonitor from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Testmonitor to connect to Testmonitor from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Testmonitor in Excel.
-
Connect to HDFS Data in Ruby
Connect to Apache HDFS in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData ADO.NET Provider for Simplesat
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Add Amazon DynamoDB Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Amazon DynamoDB with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Pipelines with Live SAP SuccessFactors Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP SuccessFactors from Google Cloud Data Fusion, enabling the integration of live SAP SuccessFactors into the building and management of effective data pipelines.
-
How to Connect Flowise AI Agents to Live Microsoft Teams Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Microsoft Teams without replication.
-
Integrating Codex CLI with Sage 200 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.
-
Automated Continuous Square Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Square replication to Amazon S3.
-
Automate SendGrid Data Replication to Azure Data Lake
Use CData Sync to customize and automate SendGrid replication to Azure Data Lake.
-
Build WordPress-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for WordPress Data and create custom apps in Bubble.
-
How to connect PolyBase to Avalara AvaTax
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Avalara AvaTax.
-
Access SAP BusinessObjects BI 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 SAP BusinessObjects BI.
-
Use Claude to Talk to Your SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SAP Business One for you.
-
Access ElevenLabs Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ElevenLabs from your Oracle system.
-
Publish Crystal Reports on Certinia Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Certinia.
-
Connect to SQL Analysis Services Data in RazorSQL
Connect to SQL Analysis Services from wizards and query SQL Analysis Services from the GUI in the RazorSQL database management tool.
-
How to Build an ETL App for Intercom Data in Python with CData
Create ETL applications and real-time data pipelines for Intercom in Python with petl.
-
Access Google Spanner Data from MySQL in PHP
Connect to Google Spanner through the standard MySQL libraries in PHP.
-
Automated Continuous SuiteCRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Amazon Redshift.
-
Access Live Attio Data in Coginiti Pro
Connect to and query live Attio from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData Tableau Connector for Notion
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate with Certinia Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Certinia to a JSON file on disk.
-
Easily Integrate Nuclia Data in Lazarus Pascal IDE
Learn how to easily integrate live Nuclia in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Google Cloud Storage-Connected Nintex Workflows
Use CData Connect AI to connect to Google Cloud Storage Data from Nintex Workflow Cloud and build custom workflows using live Google Cloud Storage.
-
Design BIRT Reports on Excel Data
Provide current Microsoft Excel to your embedded analytics.
-
Use Grok to Talk to Your SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your SAP Concur for you.
-
How to integrate Metabase with MongoDB Data
Use CData Connect AI to connect to live MongoDB and create an interactive dashboard in Metabase from MongoDB.
-
Connect to Parallel Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Parallel in the Denodo Virtual DataPort Administrator.
-
How to Easily Query Redis Data in OpenOffice Base
Connect to Redis data in OpenOffice Base using the CData ODBC Driver for Redis and generate reports with live data insights.
-
Build a Singer.io Tap for MailerSend With the CData Python Connector
Learn how to easily build a Singer.io Tap for live MailerSend data using
-
Access Live Airtable Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Airtable from your Excel spreadsheets.
-
Create Pipedrive-Connected Applications in Appsmith
Connect to Pipedrive Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Pipedrive.
-
How to Visualize Pushbullet Data in Python with pandas
Use pandas and other modules to analyze and visualize live Pushbullet in Python.
-
Build Highrise-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Highrise Data and create custom apps in Bubble.
-
Access Oracle Eloqua 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 Oracle Eloqua.
-
Using the CData Software ODBC Driver for CloudConvert in PyCharm
Connect to CloudConvert as an ODBC data source in PyCharm using the CData Software ODBC Driver for CloudConvert.
-
Query, Visualize, and Share live FTP Data in Redash
Use CData Connect AI to connect to live FTP Servers in Redash for querying, visualizing, and sharing.
-
Create Power BI Reports on Real-Time Paymo Data
Use the CData ODBC Driver for Paymo to visualize Paymo in Power BI Desktop.
-
Visualize CloudConvert Data in Tableau
The CData ODBC driver for CloudConvert enables you integrate CloudConvert into Tableau dashboards.
-
How to integrate Rootly with Apache Airflow
Access and process Rootly in Apache Airflow using the CData JDBC Driver.
-
Connect to SAS xpt Data in HULFT Integrate
Connect to SAS xpt as a JDBC data source in HULFT Integrate
-
Automated Continuous Microsoft Teams Replication to SQL Server
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to SQL Server.
-
Connect to Templated Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Templated in the Denodo Virtual DataPort Administrator.
-
Connect to Brex from Asprova with CData Software ODBC Driver for Brex
This article shows how to connect faster to Brex data from Asprova.
-
Use the CData ODBC Driver for Google Translate in Microsoft Power Query
You can use the CData Google Translate ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Translate into Microsoft Power Query.
-
How to Create Power BI Visual Reports with Real-Time EnterpriseDB Data
Use CData Power BI Connectors to visualize EnterpriseDB in Power BI.
-
Salesforce CRM Analytics Reporting in OBIEE with the Salesforce CRM Analytics JDBC Driver
Deploy the Salesforce CRM Analytics JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Query SAP Ariba Procurement Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP Ariba Procurement and perform CRUD operations on SAP Ariba Procurement from Node.js.
-
Automate Samanage Data Replication to Azure Synapse
Use CData Sync to customize and automate Samanage replication to Azure Synapse.
-
Integrate ZendeskSell with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ZendeskSell with External Services.
-
How to Create Power BI Visual Reports with Real-Time FreeAgent Data
Use CData Power BI Connectors to visualize FreeAgent in Power BI.
-
Work with Timely Data in FoxPro
Load Timely into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Apps from SAP Concur Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP Concur Data and build apps from live SAP Concur in Qlik Sense Cloud.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Act-On
Provide connectivity to Act-On through an SAP BusinessObjects universe.
-
DataBind Controls to Freshteam Data in C++Builder
DataBind to Freshteam in C++Builder with standard components and controls.
-
Connect to Productboard Data from PowerBuilder via JDBC
This article demonstrates how to access Productboard from PowerBuilder using the Productboard JDBC Driver.
-
Build Dashboards with Tally Data in Dundas BI
Create dynamic dashboards and perform analytics based on Tally ERP in Dundas BI.
-
Getting Started with the CData Connect AI Python SDK for Workday
Install the CData Connect AI Python SDK to read and write live Workday with standard DB-API 2.0 Python code.
-
How to connect to AfterShip Data from IntelliJ
Integrate connectivity to AfterShip with wizards in IntelliJ.
-
Access Live Paylocity Data in TIBCO Data Virtualization
Use the Paylocity Tibco DV Adapter to create a Paylocity data source in TIBCO Data Virtualization Studio and gain access to live Paylocity from your TDV Server.
-
Azure Analysis Services Reporting in OBIEE with the Azure Analysis Services JDBC Driver
Deploy the Azure Analysis Services JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Informatica Mappings From/To a JDBC Data Source for Aircall
Create Aircall data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Twitter Ads Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Twitter Ads from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Data Flows from SQL Server to Adobe Commerce through SSIS
Easily push SQL Server data to Adobe Commerce using the CData SSIS Tasks for Adobe Commerce.
-
Integrate Open WebUI with Live BigQuery Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google BigQuery from within the chat interface.
-
Connect to and Visualize Live Campaigner Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Campaigner.
-
Getting Started with the CData ADO.NET Provider for Freshsales
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Use the CData Software ODBC Driver for Zuora in MicroStrategy Web
Connect to Zuora in MicroStrategy Web using the CData Software ODBC Driver for Zuora.
-
Consume Microsoft Teams OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Microsoft Teams feeds that reflect any changes in SAP Lumira.
-
Build an OLAP Cube in SSAS from Okta Data
Establish a connection to Okta data from SQL Server Analysis Services, and use the Okta Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Informatica Mappings From/To an ODBC Data Source for Timely
Create an ODBC connection to Timely in Informatica and browse and transfer Timely.
-
ETL Zoho Recruit in Oracle Data Integrator
This article shows how to transfer Zoho Recruit into a data warehouse using Oracle Data Integrator.
-
Validate Active Directory Data with QuerySurge
Access and validate Active Directory in QuerySurge using the CData JDBC Driver.
-
Build ActiveCampaign-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for ActiveCampaign to explore live ActiveCampaign Data in Cursor to assist with building ActiveCampaign-powered applications.
-
Getting Started with the CData SSIS Components for SageHR
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SageHR.
-
Create Informatica Mappings From/To a JDBC Data Source for SFTP
Create SFTP data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous ShipStation Replication to SingleStore
Use CData Sync for automated, continuous, customizable ShipStation replication to SingleStore.
-
Configure the CData JDBC Driver for Pinecone in a Connection Pool in Tomcat
Connect to Pinecone from a connection pool in Tomcat.
-
Use the CData Software ODBC Driver for ZohoInvoice in MicroStrategy Desktop
Connect to ZohoInvoice in MicroStrategy Desktop using the CData Software ODBC Driver for ZohoInvoice.
-
Automate Amazon DynamoDB Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Amazon DynamoDB from PowerShell? This article demonstrates how to utilize the Amazon DynamoDB Cmdlets for tasks like connecting to Amazon DynamoDB, automating operations, downloading data, and more.
-
How to Query Live Quickbase Data in Claude Desktop
Connect to and query live Quickbase Data in Claude Desktop using CData MCP Server.
-
Add Google Ads Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Ads with the Informatica Enterprise Data Catalog to classify and organize data.
-
Replicate Multiple Sugar CRM Accounts
Replicate multiple Sugar CRM accounts to one or many databases.
-
Build Greenhouse-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Greenhouse to explore live Greenhouse Data in GitHub Copilot to assist with building Greenhouse-powered applications.
-
Create Dashboards and Visualize Live Zoom Data in Geckoboard
Use CData Connect AI to connect to live Zoom and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Configure the CData JDBC Driver for Shortcut in a Connection Pool in Tomcat
Connect to Shortcut from a connection pool in Tomcat.
-
Connect to SAP HANA Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP HANA to connect to SAP HANA and execute queries in PowerBuilder.
-
Connect to Jodoo Data in DBeaver
Use the CData ODBC Driver to connect to Jodoo in DBeaver.
-
Use the CData Software JDBC Driver for TigerGraph in MicroStrategy Desktop
Connect to TigerGraph in MicroStrategy Desktop using the CData Software JDBC Driver for TigerGraph.
-
Visualize Live Databricks Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Databricks into custom reports in Power BI.
-
Visualize Anaplan Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Anaplan.
-
How to integrate Zoho Books with Apache Airflow
Access and process Zoho Books in Apache Airflow using the CData JDBC Driver.
-
How to create Visio diagrams from Pipedrive Data
Automatically update Pipedrive with the changes you make to Visio master shapes.
-
Automated Continuous Zoom Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Zoom replication to Amazon Redshift.
-
DataBind Controls to Nuclia Data in Delphi
DataBind to Nuclia in Delphi with standard data access components and controls.
-
Deploy the ADO.NET Provider for Typeform on an SSRS Report Server
Connect to Typeform 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 Easily Query ZohoMarketingHub Data in OpenOffice Base
Connect to ZohoMarketingHub data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to connect Amazon QuickSight to Okta Data
Create a connection to Okta in CData Connect AI and insert Okta into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Seamlessly Import OnePageCrm Data into IBM SPSS Modeler
Integrate OnePageCrm data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.