CData Software - Knowledge Base
Recent Articles
-
Automate Parallel Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Parallel and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Bidirectional Access to ZohoMarketingHub Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ZohoMarketingHub in Filemaker Pro for Mac or Windows.
-
Build Zoho Recruit-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Zoho Recruit Data in Cursor to assist with building Zoho Recruit-powered applications.
-
Working with IBM Cloud Object Storage Data in LINQPad
Execute LINQ queries to IBM Cloud Object Storage in LINQPad.
-
Connect to and Visualize Live JotForm Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live JotForm.
-
Automate Dynamics NAV Data Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Dynamics NAV replication to Couchbase.
-
Create WooCommerce-Connected Nintex Workflows
Use CData Connect AI to connect to WooCommerce Data from Nintex Workflow Cloud and build custom workflows using live WooCommerce.
-
Integrate Real-Time Access to Azure DevOps in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Azure DevOps in real time.
-
Natively Connect to Smartsheet Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Smartsheet. Leverage the native support for ODBC in PHP.
-
Connect to SAP Business One Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP Business One in Airbyte.
-
Create OneNote-Connected Business Apps in AppSheet
Connect to OneNote Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft OneNote.
-
Access Live SAP Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SAP data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use Dash to Build to Web Apps on Redshift Data
Create Python applications that use pandas and Dash to build Redshift-connected web apps.
-
Use the CData Software ODBC Driver for LionDesk in MicroStrategy Web
Connect to LionDesk in MicroStrategy Web using the CData Software ODBC Driver for LionDesk.
-
Connect to BigQuery Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for BigQuery Data and connect to Google BigQuery in Akorbi Digital RunMyProcess.
-
Connect to and Query GitLab Data in QlikView over ODBC
Create data visualizations with GitLab in QlikView.
-
How to Connect SAP ByDesign Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live SAP ByDesign data in real time using natural language.
-
Extract, Transform, and Load Clari Data in Informatica PowerCenter
Create a simple Workflow for Clari in Informatica PowerCenter.
-
Connect to Splunk Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Splunk as an External Source in Dremio.
-
Import and Visualize Front Data in Power View
Create data visualizations based on Front in Excel.
-
Create a Data Access Object for MarkLogic Data using JDBI
A brief overview of creating a SQL Object API for MarkLogic in JDBI.
-
Automate NetSuite SuiteAnalytics Data Replication to SAP HANA
Use CData Sync to customize and automate NetSuite SuiteAnalytics replication to SAP HANA.
-
How to Connect to Live Salesforce Pardot 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 Salesforce Pardot for you.
-
Easily Integrate Instantly Data in Lazarus Pascal IDE
Learn how to easily integrate live Instantly in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Load Snowflake Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Snowflake to a database.
-
Automate Teradata Data Replication to Azure Data Lake
Use CData Sync to customize and automate Teradata replication to Azure Data Lake.
-
Access Live Elasticsearch Data in Coginiti Pro
Connect to and query live Elasticsearch from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Publish AdRoll-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live AdRoll.
-
Back Up Airtable to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Airtable. In this article, we will employ an SSIS workflow to populate a database with Airtable data.
-
How to create an RPA flow for PostgreSQL Data in UiPath Studio
Use the PostgreSQL ODBC Driver to create workflows that access real-time PostgreSQL without any coding.
-
Integrate Live Everhour Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Everhour to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
A PostgreSQL Interface for Azure Data Lake Storage Data using the CData ODBC Driver
Use the SQL Gateway and Azure Data Lake Storage ODBC Driver to create a PostgreSQL entry-point for data access.
-
Prepare, Blend, and Analyze Mouseflow Data in Alteryx Designer (ODBC)
Build workflows to access live Mouseflow for self-service data analytics.
-
Integrate ZohoInvoice Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ZohoInvoice from Informatica Cloud.
-
Connecting Moonlit Workflow with Salesforce Marketing 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 Salesforce Marketing Cloud in real time.
-
Publish HDFS-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Apache HDFS.
-
Build Drift-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Drift Data in Gemini Code Assist to assist with building Drift-powered applications.
-
Build Semantic Layer Views for Instantly Data in APOS Live Data Gateway
Use the CData Connector for Instantly in APOS Live Data Gateway to build Semantic Layer Views for Instantly.
-
Build eBay Analytics-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live eBay Analytics.
-
How to load Google Calendar data into Elasticsearch via Logstash
Introducing a simple method to load Google Calendar data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software ODBC Driver for Todoist in MicroStrategy Web
Connect to Todoist in MicroStrategy Web using the CData Software ODBC Driver for Todoist.
-
Integrating LangChain with SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SAP Ariba Source within automated workflows.
-
Design BIRT Reports on Zoho Books Data
Provide current Zoho Books to your embedded analytics.
-
Use CData Connect AI to Access Stripe Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Stripe in the Power Pivot business intelligence tool.
-
How to connect to Cohere Data with Squirrel SQL client
Connect to Cohere and execute queries in the Squirrel SQL Client.
-
Connect to DB2 Data in JRuby
Create a simple JRuby app with access to live IBM DB2.
-
Connect to Perigon Data in CloverDX (formerly CloverETL)
Transfer Perigon using the visual workflow in the CloverDX data integration tool.
-
Analyze Keap Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Keap and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Easily Integrate Act CRM Data in Lazarus Pascal IDE
Learn how to easily integrate live Act CRM in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Work with Todoist Data in AWS Glue Jobs Using JDBC
Connect to Todoist from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Seamlessly Import Sage 300 Data into IBM SPSS Modeler
Integrate Sage 300 data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Explore Geographical Relationships in Freshsales Data with Power Map
Create data visualizations with Freshsales in Power Map.
-
Connect to Customer.io Data in HULFT Integrate
Connect to Customer.io as a JDBC data source in HULFT Integrate
-
Build Semantic Layer Views for Exact Online Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Exact Online.
-
Migrating data from eBay to Google BigQuery using CData SSIS Components.
Easily push eBay to Google BigQuery using the CData SSIS Tasks for eBay and Google BigQuery.
-
Integrate Mailjet with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Mailjet with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Mailjet.
-
Connect and Visualize Live Quickbase Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Quickbase into the Databricks platform and create visualization dashboards with real-time Quickbase.
-
How to connect PolyBase to Reply.io
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Reply.io.
-
Integrating Claude Code CLI with GraphQL 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.
-
Build Oracle Service Cloud-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Oracle Service Cloud to explore live Oracle Service Cloud Data in Claude Code to assist with building Oracle Service Cloud-powered applications.
-
Visualize Live Apify Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Apify.
-
Publish Reports with Zoom Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoom.
-
Automate Adobe Commerce Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Adobe Commerce and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Getting Started with the CData Excel Add-In for eBay
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for eBay.
-
Use the CData SSIS Components to Insert New or Update Existing eBay Records from SQL Server
Easily push SQL Server data to eBay using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into eBay or update existing records with data from a SQL Server database.
-
Enable the Yelp JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Yelp.
-
Integrate Smartsheet with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Smartsheet with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Smartsheet.
-
Create Act CRM-Connected Business Apps in AppSheet
Connect to Act CRM Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Act CRM.
-
Getting Started with the CData Power BI Connector for Toggl
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create Datasets from Bitbucket in Domo Workbench and Build Visualizations of Bitbucket Data in Domo
Use the CData Software ODBC Driver for Bitbucket to create datasets from Bitbucket in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Amazon Marketplace from Asprova with CData Software ODBC Driver for Amazon Marketplace
This article shows how to connect faster to Amazon Marketplace data from Asprova.
-
How to Connect to Teamgate Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Teamgate. Leverage the pyodbc module for ODBC in Python.
-
Use the CData Software ODBC Driver for ZohoExpense in SAS for Real-Time Reporting and Analytics
Connect to real-time ZohoExpense in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ZohoExpense.
-
Use the CData ODBC Driver for Onfleet from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Onfleet to connect to Onfleet from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Onfleet in Excel.
-
Connect to GitHub Data in Ruby
Connect to GitHub in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous GraphQL Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable GraphQL replication to OneLake in Microsoft Fabric.
-
Easily Integrate ADP Data in Lazarus Pascal IDE
Learn how to easily integrate live ADP in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build a PostgreSQL Interface for Optimizely Data using the CData JDBC Driver
Use the Remoting features of the Optimizely JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live MYOB AccountRight Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your MYOB AccountRight for you.
-
DataBind Controls to Drift Data in C++Builder
DataBind to Drift in C++Builder with standard components and controls.
-
Access BigQuery Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google BigQuery from your Oracle system.
-
Publish Reports with Odoo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Odoo ERP.
-
Connect Wave Financial to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Wave Financial with IBM WebSphere for seamless data integration and connectivity.
-
Query Miro Data as a MySQL Database in Node.js
Execute MySQL queries against Miro from Node.js.
-
Integrate with Live Vertica Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Vertica from the MuleSoft Anypoint Platform to integrate live Vertica into custom reports and dashboards.
-
Visualize Blackbaud FE NXT Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Blackbaud FE NXT.
-
How to import IBM Informix Data into Apache Solr
Use the CData Software JDBC Driver for IBM Informix in Data Import Handler and create an automated import of IBM Informix to Apache Solr Enterprise Search platform.
-
Connect to Pingdom Data in Jaspersoft Studio
Execute SQL to remote Pingdom in Jaspersoft Studio.
-
Create Reports with MariaDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MariaDB.
-
Publish Crystal Reports on SAS xpt Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAS XPORT.
-
Migrating data from Google Sheets to Snowflake using CData SSIS Components.
Easily push Google Sheets to Snowflake using the CData SSIS Tasks for Google Sheets and Snowflake.
-
Connecting Agentforce with Shopify 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 Shopify for you.
-
Use the CData Software ODBC Driver for Accelo in MicroStrategy Desktop
Connect to Accelo in MicroStrategy Desktop using the CData Software ODBC Driver for Accelo.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Xero
Provide connectivity to Xero Accounting through an SAP BusinessObjects universe.
-
Create Dashboards and Visualize Live SAS xpt Data in Geckoboard
Use CData Connect AI to connect to live SAS XPORT and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Publish Sage 200-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Sage 200.
-
Query Browserless Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Browserless entities in PHP by modeling them as objects.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Billsby to Power BI dashboards. Simply drag and drop Billsby into data visuals on the Power BI canvas.
-
Visualize GraphQL Data in TIBCO Spotfire through OData
Integrate GraphQL into dashboards in TIBCO Spotfire.
-
How to connect to Supabase Data from Spring Boot
Connect to Supabase in a Spring Boot Application using the CData API Driver for JDBC