CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData SSIS Components for HCL Domino
Complete guide to installing, licensing, and connecting with the CData SSIS Components for HCL Domino.
-
Build a Singer.io Tap for Instantly With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Instantly data using the CData Python Connector.
-
Publish Avalara AvaTax-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Avalara AvaTax data.
-
Analyze Live Dynamics 365 Business Central Data in SAS Viya
Use CData Connect AI to connect to Dynamics 365 Business Central data from SAS Viya and deploy self-service analytics using live Dynamics 365 Business Central data.
-
Integrate Cline with Live Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Cassandra data from within your IDE.
-
Build MVC Applications with Connectivity to Cvent Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Cvent from an ASP.NET MVC application.
-
Bright Data Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Bright Data data through CData Connect AI using different applications and tools.
-
Access Live MYOB AccountRight Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live MYOB AccountRight data through MCP integration.
-
Access Live Microsoft Teams Data in Coginiti Pro
Connect to and query live Microsoft Teams data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Import and Visualize Strava Data in Power View
Create data visualizations based on Strava data in Excel.
-
Visualize Avro Data in TIBCO Spotfire through ADO.NET
Integrate Avro data into dashboards in TIBCO Spotfire.
-
Connect to XML in SpagoBI
Create reports featuring live XML data in SpagoBI Studio. Host XML reports on SpagoBI Server.
-
Integrating Cursor with Superchat 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 & Open Salesforce Pardot Data in Microsoft Excel
This article uses the CData ODBC driver for Salesforce Pardot to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build MariaDB-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for MariaDB Data and create custom apps in Bubble.
-
How to integrate Postmark with Apache Airflow
Access and process Postmark data in Apache Airflow using the CData JDBC Driver.
-
Back Up PayPal data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for PayPal. In this article, we will employ an SSIS workflow to populate a database with PayPal data data.
-
Visualize Typeform Data in TIBCO Spotfire through ADO.NET
Integrate Typeform data into dashboards in TIBCO Spotfire.
-
How to connect PolyBase to Box
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Box data.
-
Build Charts with FTP Data in Clear Analytics
Create dynamic charts and perform analytics based on FTP data in Clear Analytics.
-
Use Grok to Talk to Your Excel Online 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 Excel Online data for you.
-
Connect to Salesforce CRM Analytics Data in CloverDX (formerly CloverETL)
Transfer Salesforce CRM Analytics data using the visual workflow in the CloverDX data integration tool.
-
Connect to Wave Financial Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Wave Financial data in Airbyte.
-
Connect to ZohoDesk Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to ZohoDesk and work with ZohoDesk data in your FileMaker application.
-
Create Azure Data Catalog-Connected Dashboards in Grafana
Connect to Azure Data Catalog Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Azure Data Catalog data.
-
Integrating Claude Code CLI with Retently 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.
-
Automated Continuous BigCommerce Replication to Databricks
Use CData Sync for automated, continuous, customizable BigCommerce replication to Databricks.
-
Replicate Multiple Clari Accounts via the CData Sync CLI
Replicate multiple Clari accounts to one or many databases.
-
Build MVC Applications with Connectivity to Optimizely Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Optimizely from an ASP.NET MVC application.
-
Create Reports from SharePoint Data in Looker Studio
Use CData Connect AI to gain access to live SharePoint data and create custom reports in Looker Studio.
-
Integrate Google Directory Data into Power Automate Desktop using CData Connect
CData Connect for Google Directory Data enables you to integrate Google Directory data into workflows built using Microsoft Power Automate Desktop.
-
Analyze Airtable Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Airtable from Power Pivot. You will use the Table Import Wizard to load Airtable data. You can visually build the import query or use any SQL supported by the driver.
-
How to Query Live DocuSign Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live DocuSign data data in natural language using Python.
-
Replicate Guru Data in Heroku for Use in Salesforce Connect
Replicate Guru data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to create an RPA flow for Superchat Data in UiPath Studio
Use the Superchat ODBC Driver to create workflows that access real-time Superchat data without any coding.
-
How to connect PolyBase to Couchbase
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Couchbase data.
-
Integrate Kintone Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Kintone data and integrate live Kintone data into your Power Automate tasks.
-
Rapidly Develop Placid-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Placid.
-
How to connect to SAP Business Warehouse Data from Spring Boot
Connect to SAP Business Warehouse in a Spring Boot Application using the CData JDBC Driver for SAP Business Warehouse
-
Integrate Google's Vertex AI Agent with Live PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live PostgreSQL data within intelligent workflows.
-
Create Reports with JobNimbus Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date JobNimbus data.
-
How to Connect LDAP Objects to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live LDAP data in real time using natural language.
-
Use Dash to Build Web Apps on ZohoMarketingHub Data via CData Connect AI
Build interactive Dash web apps on live ZohoMarketingHub data using pandas and the CData Connect AI Python SDK.
-
Connect to Optimizely Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Optimizely data.
-
Use the CData SSIS Components to Insert New or Update Existing Quickbase Records from SQL Server
Easily push SQL Server data to Quickbase using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Quickbase or update existing records with data from a SQL Server database.
-
Replicate Multiple Jumpseller Accounts via the CData Sync CLI
Replicate multiple Jumpseller accounts to one or many databases.
-
Getting Started with the CData Tableau Connector for SAP Ariba Procurement
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP Ariba Procurement.
-
Use the CData Software JDBC Driver for Printful in MicroStrategy
Connect to Printful data in MicroStrategy Developer using the CData Software JDBC Driver for Printful.
-
Import and Visualize BenchmarkEmail Data in Power View
Create data visualizations based on BenchmarkEmail data in Excel.
-
Integrating GitHub Copilot with CampaignMonitor 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.
-
Automate Clio Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Clio data from PowerShell? This article demonstrates how to utilize the Clio Cmdlets for tasks like connecting to Clio data, automating operations, downloading data, and more.
-
Work with Google Drive Data in FoxPro
Load Google Drive data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to CapsuleCRM Data from HeidiSQL
Use CData Connect AI to connect to and query live CapsuleCRM data from HeidiSQL.
-
Getting Started with the CData ODBC Driver for Excel Online
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Excel Online.
-
Import Real-Time Bright Data Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Bright Data data in ColdFusion.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Printful
Provide connectivity to Printful data through an SAP BusinessObjects universe.
-
Publish Hacker News-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Hacker News data.
-
Analyze Live MYOB AccountRight Data in SAS Viya
Use CData Connect AI to connect to MYOB AccountRight data from SAS Viya and deploy self-service analytics using live MYOB AccountRight data.
-
Create Dynamic JobNimbus Grids Using the Infragistics XamDataGrid
Learn how you can connect JobNimbus to Infragistics XamDataGrid to build dynamic grids.
-
Connect to ZohoPeople Data in RazorSQL
Connect to ZohoPeople from wizards and query ZohoPeople data from the GUI in the RazorSQL database management tool.
-
Connect to Zoho Creator Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Zoho Creator.
-
Access Live SparkPost Data in Coginiti Pro
Connect to and query live SparkPost data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software ODBC Driver for MySQL in MicroStrategy Desktop
Connect to MySQL data in MicroStrategy Desktop using the CData Software ODBC Driver for MySQL.
-
Connect to Email Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Email and the Script function in FileMaker Pro to connect to Email and work with Email data in your FileMaker application.
-
Build SAS xpt-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAS xpt data and build web apps with connectivity to live SAS xpt data.
-
Use the CData Software ODBC Driver for RSS in MicroStrategy Web
Connect to RSS feeds in MicroStrategy Web using the CData Software ODBC Driver for RSS.
-
Search External xBase Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of xBase data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create xBase Data objects that you can access from apps and the dashboard.
-
Replicate Multiple Twitter Ads Accounts via the CData Sync CLI
Replicate multiple Twitter Ads accounts to one or many databases.
-
Analyze Microsoft Dataverse Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft Dataverse data and visualize Microsoft Dataverse data in SAP Analytics Cloud.
-
Add SharePoint Excel Services Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SharePoint Excel Services with the Informatica Enterprise Data Catalog to classify and organize data.
-
View Reports on Real-Time Asana Data in Power BI Report Server
Use the CData ODBC Driver for Asana to visualize Asana data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Work with Hacker News Data in AWS Glue Jobs Using JDBC
Connect to Hacker News from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated ZohoInvoice Data Replication to Teradata
Use CData Sync to Customize and automate ZohoInvoice data replication to Teradata.
-
Configure the CData Connect AI Connector for Looker Studio
Use the CData Connect AI Connector to connect to your CData Connect AI instance from Looker Studio.
-
How to connect Amazon QuickSight to Apify Data
Create a connection to Apify data in CData Connect AI and insert Apify data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Adobe Experience Manager Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Adobe Experience Manager.
-
How to Access Google Drive Data Using Entity Framework
This article shows how to access Google Drive data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Kafka-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Kafka Data and create custom apps in Mendix.
-
Connect Elasticsearch to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Elasticsearch with IBM WebSphere for seamless data integration and connectivity.
-
How to connect and process CloudConvert data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live CloudConvert data.
-
Connect to Campaigner Data from AWS Glue
Use CData Connect AI to gain access to live Campaigner data from your AWS Glue jobs.
-
QuickBooks Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on QuickBooks facts in real time.
-
Extract, Transform, and Load SAP Ariba Source Data in Informatica PowerCenter
Create a simple Workflow for SAP Ariba Source data in Informatica PowerCenter.
-
How to publish and share Salesforce Data 360 Data dashboards with Tableau Server
The CData ODBC driver for Salesforce Data 360 enables you integrate Salesforce Data 360 data into Tableau dashboards.
-
Integrate LibreChat with Live IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live IBM Cloud Object Storage data from within the chat interface.
-
Use Microsoft Copilot Studio to talk to your MongoDB 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 MongoDB data for you.
-
Load Chargebee Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Chargebee data to a database.
-
Build Reckon Accounts Hosted Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Reckon Accounts Hosted data and build visualizations in Tableau Cloud.
-
Access Live Bannerbear Data in AWS Lambda
Connect to live Bannerbear data in AWS Lambda using the CData JDBC Driver.
-
A PostgreSQL Interface for Sage Intacct Data (MySQL Remoting via JDBC)
Use the Remoting features of the Sage Intacct JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Email Replication to Vertica
Use CData Sync for automated, continuous, customizable Email replication to Vertica.
-
Visualize Live SurveyMonkey Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SurveyMonkey data.
-
Visualize Facebook Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Facebook data into TIBCO Spotfire.
-
Migrating data from Dynamics 365 to Google BigQuery using CData SSIS Components.
Easily push Dynamics 365 data to Google BigQuery using the CData SSIS Tasks for Dynamics 365 and Google BigQuery.
-
How to create Amplitude federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Amplitude data in MySQL .
-
Connect to Apify Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Apify to connect to Apify data and execute queries in PowerBuilder.
-
Connecting Moonlit Workflow with Aweber 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 Aweber data in real time.
-
Connect to Tanda Data in DBArtisan
Use wizards in DBArtisan to configure Tanda data as a data source.
-
How to Connect to Live Wistia Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Wistia data for you.
-
How to Work with Oracle Service Cloud Data in ETL Validator JDBC
Connect to Oracle Service Cloud from ETL Validator jobs using the CData Software JDBC Driver.