CData Software - Knowledge Base
Recent Articles
-
Deploy the ADO.NET Provider for ConvertAPI on an SSRS Report Server
Connect to ConvertAPI 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.
-
Build Automated Salesforce-Connected Workflows in Zapier
Use CData Connect AI to connect to live Salesforce & Force.com and build automated workflows in Zapier.
-
Connect to ZohoInvoice Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Freshservice Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Freshservice.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ShipEngine
Provide connectivity to ShipEngine through an SAP BusinessObjects universe.
-
Query Facebook Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Facebook and perform CRUD operations on Facebook from Node.js.
-
Build Apps with Live ConvertAPI Data Using the Low-Code Development Platform of Mendix
Connect ConvertAPI with Mendix to build apps using the CData API Driver for JDBC.
-
Use JayDeBeApi to access Helpscout Data in Python
Use standard Python scripting and the development environment of your choice to access live Helpscout.
-
How to Connect to Live Salesforce Pardot Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Salesforce Pardot without replication.
-
Use ChatGPT to Talk to Your Azure Synapse 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 Azure Synapse for you.
-
Automated Continuous Humanity Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Humanity replication to OneLake in Microsoft Fabric.
-
Connect to Amazon S3 Data in RapidMiner
Integrate Amazon S3 with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect Splunk to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Splunk using the CData Python MCP Server.
-
Use Dash to Build to Web Apps on Act CRM Data
Create Python applications that use pandas and Dash to build Act CRM-connected web apps.
-
Connect to Lakebase Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Lakebase from Filemaker Pro on Mac.
-
How to Connect Epicor Kinetic 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 Epicor Kinetic data in real time using natural language.
-
Visualize Live Reply.io Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Reply.io using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Apps with Live Microsoft OneNote in Adalo using CData Connect AI
Use CData Connect AI to integrate live Microsoft OneNote into the Adalo platform and build custom mobile and web applications with real-time Microsoft OneNote.
-
Use the CData Software JDBC Driver for ZohoMarketingHub in MicroStrategy
Connect to ZohoMarketingHub in MicroStrategy Developer using the CData Software JDBC Driver for ZohoMarketingHub.
-
How to create an RPA flow for Teamgate Data in UiPath Studio
Use the Teamgate ODBC Driver to create workflows that access real-time Teamgate without any coding.
-
Query Zoom Data in DataGrip
Create a Data Source for Zoom in DataGrip and use SQL to query live Zoom.
-
Build a Singer.io Tap for Instagram With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Instagram data using
-
Integrate Theia IDE with Live GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to ChartMogul Data in CloverDX (formerly CloverETL)
Transfer ChartMogul using the visual workflow in the CloverDX data integration tool.
-
Use the CData Software ODBC Driver for Access in MicroStrategy
Connect to Microsoft Access in MicroStrategy Developer using the CData Software ODBC Driver for Access.
-
Create Informatica Mappings From/To a JDBC Data Source for Billsby
Create Billsby data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to and Visualize Live Google Drive Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Drive.
-
How to connect SharePoint with Sage Intacct Data through external lists
Provide Sage Intacct to SharePoint users as an external list.
-
Create Azure Data Lake Storage-Connected Nintex Workflows
Use CData Connect AI to connect to Azure Data Lake Storage Data from Nintex Workflow Cloud and build custom workflows using live Azure Data Lake Storage.
-
Migrating data from Zoom to Snowflake using CData SSIS Components.
Easily push Zoom to Snowflake using the CData SSIS Tasks for Zoom and Snowflake.
-
Design BIRT Reports on Outlook Data
Provide current Outlook to your embedded analytics.
-
How to integrate Google Sheets with Apache Airflow
Access and process Google Sheets in Apache Airflow using the CData JDBC Driver.
-
How to Connect SAS xpt 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 SAS xpt data in real time using natural language.
-
Connect to CouchDB Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Apache CouchDB.
-
Work with Live Outreach.io Data in Power Query
Use CData Connect AI to connect to Outreach.io and work with live Outreach.io in Microsoft Power Query.
-
Query, Visualize, and Share live ShipStation Data in Redash
Use CData Connect AI to connect to live ShipStation in Redash for querying, visualizing, and sharing.
-
How to connect to Couchbase Data from Spring Boot
Connect to Couchbase in a Spring Boot Application using the CData JDBC Driver for Couchbase
-
Migrating data from Productboard to Databricks using CData SSIS Components.
Easily push Productboard to Databricks using the CData SSIS Tasks for Productboard and Databricks.
-
Bind Live Xero Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Xero data
-
Connect to Salesforce Pardot Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Salesforce Pardot in the Denodo Virtual DataPort Administrator.
-
Use the CData ODBC Driver for Attio in Microsoft Power Query
You can use the CData Attio ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Attio into Microsoft Power Query.
-
Use the CData Software JDBC Driver for Xero in MicroStrategy Desktop
Connect to Xero Accounting in MicroStrategy Desktop using the CData Software JDBC Driver for Xero.
-
Build a Singer.io Tap for Oracle Eloqua With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Oracle Eloqua data using
-
How to Query Live ZohoExpense Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ZohoExpense data in natural language using Python.
-
Integrate IBM Cloud Object Storage Data in Pentaho Data Integration
Build ETL pipelines based on IBM Cloud Object Storage in the Pentaho Data Integration tool.
-
Connect to Zoom Data in DBeaver
Use the CData ODBC Driver to connect to Zoom in DBeaver.
-
Integrate Facebook Ads Data into Power Automate Desktop using CData Connect
CData Connect for Facebook Ads Data enables you to integrate Facebook Ads into workflows built using Microsoft Power Automate Desktop.
-
Connect to Webflow Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Webflow as an External Source in Dremio.
-
Read and Modify Google Sheets Directly from Microsoft Access
Learn how to connect Microsoft Access with Google Sheets to read, update, and manage spreadsheet data in real time.
-
Connect to PolarTeamPro Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for PolarTeamPro to connect to PolarTeamPro and execute queries in PowerBuilder.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Outreach.io within intelligent workflows.
-
Visualize Rebilly Data in TIBCO Spotfire through ADO.NET
Integrate Rebilly into dashboards in TIBCO Spotfire.
-
Connect to Placid Data in Aqua Data Studio
Access Placid from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Migrating data from ConstantContact to Snowflake using CData SSIS Components.
Easily push ConstantContact to Snowflake using the CData SSIS Tasks for ConstantContact and Snowflake.
-
Getting Started with the CData Python Connector for Zoom
Learn to install and license the CData Python Connector
-
Use the CData Software ODBC Driver for ServiceNow in SAS for Real-Time Reporting and Analytics
Connect to real-time ServiceNow in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ServiceNow.
-
Create Datasets from Workday in Domo Workbench and Build Visualizations of Workday Data in Domo
Use the CData Software ODBC Driver for Workday to create datasets from Workday in Domo Workbench and then build visualizations in the Domo service.
-
Analyze ActiveCampaign Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ActiveCampaign with the CData JDBC Driver for ActiveCampaign.
-
Publish Kintone-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Kintone.
-
View Reports on Real-Time Parallel Data in Power BI Report Server
Use the CData ODBC Driver for Parallel to visualize Parallel in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Dash to Build to Web Apps on ZohoSubscriptions Data
Create Python applications that use pandas and Dash to build ZohoSubscriptions-connected web apps.
-
Import Real-Time Exa Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Exa in ColdFusion.
-
Automate Marketo Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Marketo from PowerShell? This article demonstrates how to utilize the Marketo Cmdlets for tasks like connecting to Marketo, automating operations, downloading data, and more.
-
Connect to Azure Synapse Data in RazorSQL
Connect to Azure Synapse from wizards and query Azure Synapse from the GUI in the RazorSQL database management tool.
-
Deploy the ADO.NET Provider for Pipedrive on an SSRS Report Server
Connect to Pipedrive 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 create an RPA flow for Amplitude Data in UiPath Studio
Use the Amplitude ODBC Driver to create workflows that access real-time Amplitude without any coding.
-
Create Dynamic ConvertKit Grids Using the Infragistics XamDataGrid
Learn how you can connect ConvertKit to Infragistics XamDataGrid to build dynamic grids.
-
How to Connect the Power BI Service to ScrapingBee: Complete Guide
Connect to the CData Software Power BI Connector for ScrapingBee from PowerBI.com to provide real-time ScrapingBee across the organization.
-
Connect to SAP ByDesign Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP Business ByDesign in Google Apps Script.
-
Use Dash to Build Web Apps on Dropbox Data via CData Connect AI
Build interactive Dash web apps on live Dropbox using pandas and the CData Connect AI Python SDK.
-
Access Live Azure Synapse Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Azure Synapse through MCP integration.
-
How to Connect DBeaver to Excel Online via a JDBC Driver
Manage Microsoft Excel Online with visual tools in DBeaver like the query browser.
-
Connect to Parallel Data from a Connection Pool in Jetty
The Parallel JDBC Driver supports connection pooling: This article shows how to connect faster to Parallel from Web apps in Jetty.
-
Use Claude to Talk to Your eCommerce Data
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your eCommerce data for you.
-
Use Biml to Build SSIS Tasks to Replicate Redshift Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Amazon Redshift to SQL Server.
-
Build Dashboards with Sybase Data in DBxtra
Create dynamic dashboards and perform analytics based on Sybase in DBxtra.
-
Build AI/ML Models with Live Stripe Data using Dataiku
Connect Stripe Data with Dataiku using the CData JDBC Driver for Stripe.
-
Getting Started with the CData JDBC Driver for Rebilly
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Rebilly.
-
Access Klipfolio Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Klipfolio from your Oracle system.
-
How to connect to Webex Data with Squirrel SQL client
Connect to Webex and execute queries in the Squirrel SQL Client.
-
Connect to Live Azure Data Lake Storage Data in MicroStrategy through CData Connect AI
Create a live connection to Azure Data Lake Storage Data in CData Connect AI and connect to your Azure Data Lake Storage from MicroStrategy.
-
Migrating data from FTP to Google BigQuery using CData SSIS Components.
Easily push FTP Servers to Google BigQuery using the CData SSIS Tasks for FTP and Google BigQuery.
-
Getting Started with the CData Tableau Connector for Onfleet
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Work with Raisers Edge NXT Data in AWS Glue Jobs Using JDBC
Connect to Raisers Edge NXT from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Live Square Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to Slack Data in HULFT Integrate
Connect to Slack as a JDBC data source in HULFT Integrate
-
Use Azure AI Foundry to Talk to Your Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Azure DevOps for you.
-
How to Access Couchbase Data Using Entity Framework
This article shows how to access Couchbase using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Replicate Multiple Oracle Eloqua Reporting Accounts
Replicate multiple Oracle Eloqua Reporting accounts to one or many databases.
-
Work with Zoho Projects Data in FoxPro
Load Zoho Projects into a FoxPro database. This article includes full code and a walk-through of the process.
-
Choosing the Best Method to Connect Billsby to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Billsby from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Freshsales in SpagoBI
Create reports featuring live Freshsales in SpagoBI Studio. Host Freshsales reports on SpagoBI Server.
-
Connect Oracle Sales Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Oracle Sales using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Apps from Google Drive Data in Qlik Sense Cloud
Use CData Connect AI to connect to Google Drive Data and build apps from live Google Drive in Qlik Sense Cloud.
-
Build a PostgreSQL Interface for Freshteam Data using the CData JDBC Driver
Use the Remoting features of the Freshteam JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Pipelines with Live Salesforce Pardot Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Salesforce Pardot from Google Cloud Data Fusion, enabling the integration of live Salesforce Pardot into the building and management of effective data pipelines.
-
Create Informatica Mappings From/To a JDBC Data Source for DB2
Create DB2 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect/Disconnect the QuickBooks Online Products
In this entry you will learn to use the CData Excel Add-In for QuickBooks Online or the CData Sync Application for QuickBooks Online to connect to or disconnect from your QuickBooks Online data.
-
Connect to Zoho Creator Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Zoho Creator in Airbyte.
-
Access Live Blackbaud FE NXT Data in Coginiti Pro
Connect to and query live Blackbaud FE NXT from the GUI in the Coginiti Pro: SQL Analytics Tool.