CData Software - Knowledge Base
Recent Articles
-
How to Use a Microsoft Access Database to Update Dynamics 365 Business Central Data in Real Time
Update Dynamics 365 Business Central data by creating a linked table in Microsoft Access with the CData Dynamics 365 Business Central ODBC Driver.
-
Excel Spreadsheet Automation on ConvertAPI Data with the QUERY Formula
Pull data from ConvertAPI, automate spreadsheets, and more with the QUERY formula.
-
Publish Microsoft Dataverse-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Dataverse data.
-
Visualize Live Instagram Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Instagram data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData SSIS Components to Insert New or Update Existing Vault CRM Records from SQL Server
Easily push SQL Server data to Vault CRM using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Vault CRM or update existing records with data from a SQL Server database.
-
Build Square-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Square Data from Zoho Analytics and import live Square data.
-
How to Visualize OpenWeatherMap Data in Python with pandas
Use pandas and other modules to analyze and visualize live OpenWeatherMap data in Python.
-
Getting Started with the CData Tableau Connector for Perplexity
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Query MarkLogic Data as a MySQL Database in Node.js
Execute MySQL queries against MarkLogic data from Node.js.
-
How to Seamlessly Import Contentful Data into IBM SPSS Modeler
Integrate Contentful data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize Live Yelp Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Yelp data into custom reports in Power BI.
-
Automated ClickTime Data Replication to Teradata
Use CData Sync to Customize and automate ClickTime data replication to Teradata.
-
Replicate SuiteCRM Data in Heroku for Use in Salesforce Connect
Replicate SuiteCRM data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Pipelines with Live BambooHR Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to BambooHR from Google Cloud Data Fusion, enabling the integration of live BambooHR data into the building and management of effective data pipelines.
-
How to Connect to Live Tavily Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Tavily data through natural language.
-
Use ChatGPT to Talk to Your Asana 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 Asana data for you.
-
Connect to Microsoft Exchange Data in JRuby
Create a simple JRuby app with access to live Microsoft Exchange data.
-
How to Create Power BI Visual Reports with Real-Time Coda Data
Use CData Power BI Connectors to visualize Coda data in Power BI.
-
Create Procore-Connected Applications in Appsmith
Connect to Procore Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Procore data.
-
Query Blackbaud FE NXT Data as a SQL Server Database in Node.js
Execute SQL Server queries against Blackbaud FE NXT data from Node.js.
-
Connect to Zoho CRM Data in Aqua Data Studio
Access Zoho CRM data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Visualize Microsoft Dataverse Data in Tableau
The CData ODBC driver for Microsoft Dataverse enables you integrate Microsoft Dataverse data into Tableau dashboards.
-
Query Live Amazon DynamoDB Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Amazon DynamoDB data through a conversational interface.
-
Access Oracle Sales Data from MySQL in PHP
Connect to Oracle Sales through the standard MySQL libraries in PHP.
-
Stream eBay Data into Apache Kafka Topics
Access and stream eBay data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Enable the SingleStore JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SingleStore data.
-
Integrate with EnterpriseDB Data in JReport Designer
Create charts and reports based on EnterpriseDB data in JReport Designer.
-
Extract, Transform, and Load ChartMogul Data in Informatica PowerCenter
Create a simple Workflow for ChartMogul data in Informatica PowerCenter.
-
Automated Continuous ZohoMarketingHub Replication to Vertica
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to Vertica.
-
How to create Google Ad Manager federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Ad Manager data in MySQL .
-
Use Agno to Talk to Your MailerLite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your MailerLite data for you.
-
Build a Singer.io Tap for RabbitMQ With the CData Python Connector
Learn how to easily build a Singer.io Tap for live RabbitMQ data using the CData Python Connector.
-
Automated Continuous MySQL Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable MySQL replication to delimited files (CSV/TSV).
-
Process & Analyze Lakebase Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Lakebase Data.
-
Connect and Query Live Active Directory Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Active Directory data into Databricks and enable direct, live querying and analysis without replication.
-
How to load Dynamics CRM data into Elasticsearch via Logstash
Introducing a simple method to load Dynamics CRM data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Using the CData Software ODBC Driver for Rootly in PyCharm
Connect to Rootly as an ODBC data source in PyCharm using the CData Software ODBC Driver for Rootly.
-
Connect to GitLab Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live GitLab data.
-
Connect to Oracle Eloqua Data in NetBeans
Connect to Oracle Eloqua data in NetBeans with the data source configuration wizard.
-
How to create an RPA flow for Shortcut Data in UiPath Studio
Use the Shortcut ODBC Driver to create workflows that access real-time Shortcut data without any coding.
-
Working with Insightly Data in LINQPad
Execute LINQ queries to Insightly data in LINQPad.
-
Automated Continuous Customer.io Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Customer.io replication to Google BigQuery.
-
Integrating LangChain with JSON Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on JSON services within automated workflows.
-
Query Salesloft Data in ColdFusion
Write standard ColdFusion data access code to connect to Salesloft data.
-
Add Scrapfly Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Scrapfly with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData JDBC Driver for SAP Ariba Procurement
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP Ariba Procurement.
-
Create Datasets from Qualaroo in Domo Workbench and Build Visualizations of Qualaroo Data in Domo
Use the CData Software ODBC Driver for Qualaroo to create datasets from Qualaroo data in Domo Workbench and then build visualizations in the Domo service.
-
Build Charts with Dropbox Data in Clear Analytics
Create dynamic charts and perform analytics based on Dropbox data in Clear Analytics.
-
Automated Continuous Google Contacts Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Contacts replication to Google BigQuery.
-
Use Claude to Talk to Your Microsoft Exchange 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 Microsoft Exchange data for you.
-
Connecting GenSpark with JSON Services via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to JSON services without any replication or custom integration required.
-
Excel Spreadsheet Automation on Dynamics NAV Data with the QUERY Formula
Pull data from Dynamics NAV, automate spreadsheets, and more with the QUERY formula.
-
How to Work with Google Drive Data in AWS Glue Jobs Using JDBC
Connect to Google Drive from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Dashboards and Visualize Live Figshare Data in Geckoboard
Use CData Connect AI to connect to live Figshare data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrating Cursor with Avro 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.
-
Extract, Transform, and Load Salesloft Data in Informatica PowerCenter
Create a simple Workflow for Salesloft data in Informatica PowerCenter.
-
How to Connect the Power BI Service to Coinbase: Complete Guide
Connect to the CData Software Power BI Connector for Coinbase from PowerBI.com to provide real-time Coinbase data across the organization.
-
Build SendGrid-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SendGrid data and build web apps with connectivity to live SendGrid data.
-
Integrate Goose with Live Gmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Gmail data from within the local AI agent.
-
Analyze Google Search Results in Looker
Use CData Connect AI to connect to Google Search Results from Looker and build custom apps using live Google Search results.
-
Use the CData Software ODBC Driver for Nuclia in MicroStrategy Desktop
Connect to Nuclia data in MicroStrategy Desktop using the CData Software ODBC Driver for Nuclia.
-
Query, Visualize, and Share live GetResponse Data in Redash
Use CData Connect AI to connect to live GetResponse data in Redash for querying, visualizing, and sharing.
-
Build Data Flows from Humanity to SQL Server using SSIS
Easily back up Humanity data to SQL Server using the SSIS components for Humanity.
-
Build Semantic Layer Views for Act CRM Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Act CRM data.
-
How to use SQLAlchemy ORM to access Blackbaud FE NXT Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Blackbaud FE NXT data.
-
Create Datasets from Freshdesk in Domo Workbench and Build Visualizations of Freshdesk Data in Domo
Use the CData Software ODBC Driver for Freshdesk to create datasets from Freshdesk data in Domo Workbench and then build visualizations in the Domo service.
-
Import SAP BusinessObjects BI Data Using Azure Data Factory
Use CData Connect AI to connect to SAP BusinessObjects BI Data from Azure Data Factory and import live SAP BusinessObjects BI data.
-
Integrate Live Oracle Eloqua Reporting Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Oracle Eloqua Reporting data to Blue Prism using the CData ODBC Driver for Oracle Eloqua Reporting to create automated workflows for repetitive business tasks.
-
Connect to GraphQL from a Connection Pool in WebLogic
Use the CData JDBC Driver for GraphQL to connect to GraphQL data from Web applications running on WebLogic.
-
Interact with Live Xero Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Xero data.
-
Connect to Amazon DynamoDB Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Amazon DynamoDB.
-
Connect to Highrise Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Highrise to connect to Highrise data and execute queries in PowerBuilder.
-
Object-Relational Mapping (ORM) with Marketo Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Marketo data into a Java-based ORM framework, Hibernate.
-
Feed Reckon Data into FineReport
How to set Reckon data as a JDBC data source in FineReport.
-
Build Pinterest-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Pinterest data and build Pinterest-connected web apps with Axios.
-
Use Dash to Build Web Apps on SAP Ariba Procurement Data via CData Connect AI
Build interactive Dash web apps on live SAP Ariba Procurement data using pandas and the CData Connect AI Python SDK.
-
Connect to Google Tasks Data in Ruby
Connect to Google Tasks data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData SSIS Components to Insert New or Update Existing SAP SuccessFactors Records from SQL Server
Easily push SQL Server data to SAP SuccessFactors using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SAP SuccessFactors or update existing records with data from a SQL Server database.
-
Creating Salesforce CRM Analytics-Connected Applications in Unqork
You can use CData Connect AI to feed Salesforce CRM Analytics data to Unqork and build custom business apps.
-
Connect to Dropbox Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Dropbox and the SQL Gateway to access Dropbox data from Google Apps Script.
-
Access Live CapsuleCRM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to CapsuleCRM data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to FreshBooks in SpagoBI
Create reports featuring live FreshBooks data in SpagoBI Studio. Host FreshBooks reports on SpagoBI Server.
-
Publish Aircall-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Aircall data.
-
How to Use an External ID to Perform an UPSERT Operation against Salesforce
A basic overview of using External IDs to perform efficient UPSERT operations in Salesforce with the CData Salesforce Driver.
-
Automated Continuous Oracle Eloqua Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to AlloyDB.
-
PDFMonkey Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on PDFMonkey facts in real time.
-
Seamlessly Bring Monday.com Data into Retool Using CData Connect AI
Integrate Monday.com data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Oracle Sales Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Oracle Sales data in Airbyte.
-
SAS xpt Reporting in OBIEE with the SAS xpt JDBC Driver
Deploy the SAS xpt JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Calendly Data from MySQL in PHP
Connect to Calendly through the standard MySQL libraries in PHP.
-
How to create an RPA flow for Greenhouse Data in UiPath Studio
Use the Greenhouse ODBC Driver to create workflows that access real-time Greenhouse data without any coding.
-
Access Live Campaigner Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Campaigner data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Superchat
Provide connectivity to Superchat data through an SAP BusinessObjects universe.
-
Automated Tickspot Data Replication to Teradata
Use CData Sync to Customize and automate Tickspot data replication to Teradata.
-
Query, Visualize, and Share live Freshservice Data in Redash
Use CData Connect AI to connect to live Freshservice data in Redash for querying, visualizing, and sharing.
-
Create Dynamic Google Campaign Manager 360 Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Campaign Manager 360 to Infragistics XamDataGrid to build dynamic grids.
-
How to Connect to Live Azure Analysis Services Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Azure Analysis Services data through natural language.
-
Build Semantic Layer Views for Oracle Sales Data in APOS Live Data Gateway
Use the CData Connector for Oracle Sales in APOS Live Data Gateway to build Semantic Layer Views for Oracle Sales data.
-
Automated Continuous Mocean Replication to MySQL
Use CData Sync for automated, continuous, customizable Mocean replication to MySQL.
-
Getting Started with the CData Excel Add-In for Dotmailer
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Dotmailer.