CData Software - Knowledge Base
Recent Articles
-
Deploy the ADO.NET Provider for Facebook on an SSRS Report Server
Connect to Facebook 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.
-
Getting Started with the CData SSIS Components for Oracle Financials Cloud
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Oracle Financials Cloud.
-
Automated Continuous Salesforce CRM Analytics Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to PostgreSQL.
-
Create Data Visualizations Based On QuickBooks Time Data in Mode
Use CData Connect AI to connect to QuickBooks Time Data from Mode and build visualizations using live
-
How to Query Live SingleStore Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SingleStore data in natural language using Python.
-
Connect to Live Google Ads Data in MicroStrategy through CData Connect AI
Create a live connection to Google Ads Data in CData Connect AI and connect to your Google Ads from MicroStrategy.
-
How to Work with SAP Data in ETL Validator JDBC
Connect to SAP from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to SurveyMonkey Data in CloverDX (formerly CloverETL)
Transfer SurveyMonkey using the visual workflow in the CloverDX data integration tool.
-
Create NetSuite SuiteAnalytics-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to NetSuite SuiteAnalytics Data from OutSystems and build custom enterprise apps using live NetSuite SuiteAnalytics.
-
Connect to BigCommerce Data in HULFT Integrate
Connect to BigCommerce as a JDBC data source in HULFT Integrate
-
Integrate Quaderno with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Quaderno with External Services.
-
Analyze Salesforce CRM Analytics Data in Looker
Use CData Connect AI to connect to Salesforce CRM Analytics Data from Looker and build custom apps using live Salesforce CRM Analytics.
-
Integrate Simplesat with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Simplesat with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Simplesat.
-
Query SendGrid Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SendGrid and perform CRUD operations on SendGrid from Node.js.
-
Bridge Flowlu Connectivity with Apache NiFi
Access and process Flowlu in Apache NiFi using the CData JDBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate Basecamp Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Basecamp to SQL Server.
-
A PostgreSQL Interface for FreshBooks Data (MySQL Remoting via JDBC)
Use the Remoting features of the FreshBooks JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Vault CRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Veeva Vault & Vault CRM.
-
Publish Reports with Float Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Float.
-
Access Calendly Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Calendly from HeidiSQL.
-
How to Access Live Azure Analysis Services Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Azure Analysis Services enables you to integrate Azure Analysis Services into workflows built using Microsoft Power Automate Desktop.
-
How to use SQLAlchemy ORM to access Codat Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Codat.
-
Create a Data Access Object for Azure DevOps Data using JDBI
A brief overview of creating a SQL Object API for Azure DevOps in JDBI.
-
Integrate ActiveCampaign Data into Power Automate Desktop using CData Connect
CData Connect for ActiveCampaign Data enables you to integrate ActiveCampaign into workflows built using Microsoft Power Automate Desktop.
-
Connect Elasticsearch Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Elasticsearch using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Microsoft Exchange Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to PostgreSQL.
-
How to Work with Reckon Data in AWS Glue Jobs Using JDBC
Connect to Reckon from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Using the CData Software ODBC Driver for Onfleet in PyCharm
Connect to Onfleet as an ODBC data source in PyCharm using the CData Software ODBC Driver for Onfleet.
-
Connect to PolarTeamPro Data in DBeaver
Use the CData ODBC Driver to connect to PolarTeamPro in DBeaver.
-
Connect to Mailgun Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Mailgun.
-
Operational Reporting on SFTP Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SFTP.
-
Validate Google Directory Data with QuerySurge
Access and validate Google Directory in QuerySurge using the CData JDBC Driver.
-
Create Reports with Splunk Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Splunk.
-
How to connect to Miro Data from Spring Boot
Connect to Miro in a Spring Boot Application using the CData API Driver for JDBC
-
Connect and Visualize Live LinkedIn Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live LinkedIn into the Databricks platform and create visualization dashboards with real-time LinkedIn.
-
Getting Started with the CData Tableau Connector for GraphQL
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for GraphQL.
-
Integrate SQL Analysis Services with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SQL Analysis Services with External Services.
-
Migrating data from Dynamics CRM to Snowflake using CData SSIS Components.
Easily push Microsoft Dynamics CRM to Snowflake using the CData SSIS Tasks for Dynamics CRM and Snowflake.
-
Build Agents in Relevance AI with Access to Live Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Atlassian Confluence within intelligent agent workflows.
-
How to integrate Metabase with Freshservice Data
Use CData Connect AI to connect to live Freshservice and create an interactive dashboard in Metabase from Freshservice.
-
Access Live Google Cloud Storage Data in Excel 365 Online (Excel for the web)
Connect to Google Cloud Storage from Excel 365 Online (Excel for the web) with CData Connect AI.
-
A PostgreSQL Interface for SAP ByDesign Data using the CData ODBC Driver
Use the SQL Gateway and SAP ByDesign ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Snowflake Data in Jaspersoft Studio
Execute SQL to remote Snowflake in Jaspersoft Studio.
-
How to Connect to Live Azure Table 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 Azure Table Storage without replication.
-
Connect to FreeAgent Data in RazorSQL
Connect to FreeAgent from wizards and query FreeAgent from the GUI in the RazorSQL database management tool.
-
Using the CData Software ODBC Driver for MongoDB in PyCharm
Connect to MongoDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for MongoDB.
-
Connect to Helpscout Data in DBArtisan
Use wizards in DBArtisan to configure Helpscout as a data source.
-
Work with Live SAP HANA Data in Power Query
Use CData Connect AI to connect to SAP HANA and work with live SAP HANA in Microsoft Power Query.
-
How to Query Live GraphQL Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live GraphQL data in natural language using Python.
-
Connect to Salesforce Marketing Data in Google Apps Script via Connect AI
Use CData Connect AI to access Salesforce Marketing Cloud in Google Apps Script.
-
How to publish and share Miro Data dashboards with Tableau Server
The CData ODBC driver for Miro enables you integrate Miro into Tableau dashboards.
-
Integrate Live Zoho CRM Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Zoho CRM and integrate live Zoho CRM into apps built in Microsoft Power Apps.
-
Connect to Cosmos DB Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Azure Cosmos DB using standard SQL.
-
A PostgreSQL Interface for Clockify Data using the CData ODBC Driver
Use the SQL Gateway and Clockify ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Data Flows from SingleStore to SQL Server using SSIS
Easily back up SingleStore to SQL Server using the SSIS components for SingleStore.
-
Bidirectional Access to Oracle Eloqua Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Oracle Eloqua in Filemaker Pro for Mac or Windows.
-
Connect to and Visualize Live Avro Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apache Avro.
-
How to load Dynamics 365 data into Elasticsearch via Logstash
Introducing a simple method to load Dynamics 365 data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Eventbrite Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Eventbrite and work with Eventbrite in your FileMaker applications.
-
Replicate Multiple Microsoft OneLake Accounts via the CData Sync CLI
Replicate multiple Microsoft OneLake accounts to one or many databases.
-
Access Dropbox Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Dropbox from your Oracle system.
-
Integrate EmailOctopus Data in Pentaho Data Integration
Build ETL pipelines based on EmailOctopus in the Pentaho Data Integration tool.
-
Connect to Templated Data from a Connection Pool in Jetty
The Templated JDBC Driver supports connection pooling: This article shows how to connect faster to Templated from Web apps in Jetty.
-
Integrating SAP BusinessObjects BI Data in Talend Cloud Data Management Platform
Connect SAP BusinessObjects BI Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP BusinessObjects BI.
-
How to create Sybase IQ federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Sybase IQ in MySQL .
-
Connect to Dynamics CRM Data in CloverDX (formerly CloverETL)
Transfer Microsoft Dynamics CRM using the visual workflow in the CloverDX data integration tool.
-
Add ZohoSubscriptions Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ZohoSubscriptions with the Informatica Enterprise Data Catalog to classify and organize data.
-
Explore Geographical Relationships in Samanage Data with Power Map
Create data visualizations with Samanage in Power Map.
-
Connect to Excel Data in RapidMiner
Integrate Microsoft Excel with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData Tableau Connector for Close
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Seamlessly Bring Active Directory Data into Retool Using CData Connect AI
Integrate Active Directory data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to HDFS Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for HDFS and the SQL Gateway to access Apache HDFS from Google Apps Script.
-
How to Connect the Power BI Service to Adobe Experience Manager: Complete Guide
Connect to the CData Software Power BI Connector for Adobe Experience Manager from PowerBI.com to provide real-time Adobe Experience Manager across the organization.
-
How to connect SharePoint with Blackbaud FE NXT Data through external lists
Provide Blackbaud FE NXT to SharePoint users as an external list.
-
Create a Data Access Object for CouchDB Data using JDBI
A brief overview of creating a SQL Object API for Apache CouchDB in JDBI.
-
Create Dynamic Omnisend Grids Using the Infragistics XamDataGrid
Learn how you can connect Omnisend to Infragistics XamDataGrid to build dynamic grids.
-
Connect to IBM Informix Data from a Connection Pool in Jetty
The IBM Informix JDBC Driver supports connection pooling: This article shows how to connect faster to IBM Informix from Web apps in Jetty.
-
Build AI/ML Models with Live Xero Data using Dataiku
Connect Xero Data with Dataiku using the CData JDBC Driver for Xero.
-
Connect OData Services to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your OData using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Query Monday.com Data in MySQL Workbench
Execute MySQL queries against live Monday.com from MySQL Workbench.
-
Use Microsoft Copilot Studio to talk to your MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your MailChimp for you.
-
Connect to Real-Time AgileCRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use AgileCRM in Power Apps.
-
Getting Started with the CData ODBC Driver for Paylocity
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Paylocity.
-
Operational Reporting on SQL Server Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft SQL Server.
-
Build Charts with Azure DevOps Data in Clear Analytics
Create dynamic charts and perform analytics based on Azure DevOps in Clear Analytics.
-
Deploy the ADO.NET Provider for Freshservice on an SSRS Report Server
Connect to Freshservice 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.
-
Analyze Microsoft Teams Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft Teams and visualize live Microsoft Teams in Infragistics Reveal.
-
Automated Continuous Microsoft Planner Replication to Vertica
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Vertica.
-
Automate Moosend Data Replication to Azure Data Lake
Use CData Sync to customize and automate Moosend replication to Azure Data Lake.
-
Create Reports with Google Drive Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Drive.
-
Automated Continuous PivotalTracker Replication to Vertica
Use CData Sync for automated, continuous, customizable PivotalTracker replication to Vertica.
-
Analyze ZohoDesk Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ZohoDesk from Power Pivot. You will use the Table Import Wizard to load ZohoDesk. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Cursor CLI with MySQL 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.
-
How to connect to Hacker News Data with Squirrel SQL client
Connect to Hacker News and execute queries in the Squirrel SQL Client.
-
Access Live Avro Data in AWS Lambda
Connect to live Apache Avro in AWS Lambda using the CData JDBC Driver.
-
Build Dashboards with LeadDesk Data in DBxtra
Create dynamic dashboards and perform analytics based on LeadDesk in DBxtra.
-
Build Stripe-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Stripe.
-
Integrate Cursor with Live Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Blackbaud FE NXT from within the editor.
-
Build AI/ML Models with Live Datadog Data using Dataiku
Connect Datadog Data with Dataiku using the CData API Driver for JDBC.
-
Integrating OpenCode Terminal with eBay Analytics 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.