CData Software - Knowledge Base
Recent Articles
-
How to Build an ETL App for RSS Feeds in Python with CData
Create ETL applications and real-time data pipelines for RSS Feeds in Python with petl.
-
How to integrate Metabase with Paylocity Data
Use CData Connect AI to connect to live Paylocity and create an interactive dashboard in Metabase from Paylocity.
-
Publish Reports with Twilio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Twilio.
-
Integrating OpenCode Terminal with Notion 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.
-
Access Live SAS xpt Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAS XPORT from your Excel spreadsheets.
-
Access Live Excel Online Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Excel Online from your Google Sheets.
-
Build a PostgreSQL Interface for Omnisend Data using the CData JDBC Driver
Use the Remoting features of the Omnisend JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Data Visualizations in Cognos BI with CockroachDB Data
Access CockroachDB as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Replicate Multiple Hubstaff Accounts
Replicate multiple Hubstaff accounts to one or many databases.
-
Connect to ShipEngine Data from a Connection Pool in Jetty
The ShipEngine JDBC Driver supports connection pooling: This article shows how to connect faster to ShipEngine from Web apps in Jetty.
-
Automate Amazon DynamoDB Data Replication to SAP HANA
Use CData Sync to customize and automate Amazon DynamoDB replication to SAP HANA.
-
How to create Avro federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Apache Avro in MySQL .
-
Automated Continuous SageHR Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SageHR replication to Azure SQL Database.
-
Easily Integrate Google Cloud Storage Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Cloud Storage in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Add SAS xpt Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAS xpt with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Dotmailer with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Dotmailer with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Dotmailer.
-
Automated Continuous IBM Informix Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable IBM Informix replication to Google Cloud SQL.
-
Access Live Toggl Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Toggl into the statistical analysis tools available in SAS JMP. This article shows how to use Toggl in the Graph Builder and Query Builder.
-
Visualize Live Zoom Data in the Power BI Service
Use CData Connect AI to connect to live Zoom and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Write a Simple Go Application to work with Gong Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Gong.
-
How to Import Data from Acumatica into Google Sheets
Import Acumatica ERP into a Google spreadsheet that is automatically refreshed.
-
Automated Continuous Yelp Replication to SingleStore
Use CData Sync for automated, continuous, customizable Yelp replication to SingleStore.
-
Create SSAS Tabular Models from Dotmailer Data
How to build a SQL Server Analysis Service Tabular Model from Dotmailer using CData drivers.
-
Automated Continuous API Replication to Amazon S3
Use CData Sync for automated, continuous, customizable API replication to Amazon S3.
-
How to connect and process Anaplan from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Anaplan.
-
Connect to LightSpeedRetail Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for LightSpeedRetail.
-
Query SendGrid Data as a SQL Server Database in Node.js
Execute SQL Server queries against SendGrid from Node.js.
-
DataBind Microsoft Planner Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Microsoft Planner with the DevExpress Windows Forms and Web controls to provide Microsoft Planner to a chart.
-
How to Work with Neo4J Data in AWS Glue Jobs Using JDBC
Connect to Neo4J from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to connect to Pipeline CRM Data from Spring Boot
Connect to Pipeline CRM in a Spring Boot Application using the CData API Driver for JDBC
-
Natively Connect to HubSpot Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to HubSpot. Leverage the native support for ODBC in PHP.
-
Build Charts with SendGrid Data in Clear Analytics
Create dynamic charts and perform analytics based on SendGrid in Clear Analytics.
-
Automated Continuous Cloudant Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Cloudant replication to IBM DB2.
-
Create Reports from Google Analytics Data in Looker Studio
Use CData Connect AI to gain access to live Google Analytics and create custom reports in Looker Studio.
-
Create Data Visualizations Based On MySQL Data in Mode
Use CData Connect AI to connect to MySQL Data from Mode and build visualizations using live
-
Establish a Live Connection with JSON Services using Tableau Bridge
The CData ODBC Driver for JSON enables you to integrate live JSON into Tableau Cloud dashboards using the Tableau Bridge.
-
Connecting Pipedream with Snowflake Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Snowflake data in real time.
-
Create Informatica Mappings From/To a JDBC Data Source for MYOB AccountRight
Create MYOB AccountRight data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Stream Hugging Face Data into Apache Kafka Topics
Access and stream Hugging Face in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Suadeo Data from MySQL in PHP
Connect to Suadeo through the standard MySQL libraries in PHP.
-
Connect to Google Campaign Manager 360 Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Campaign Manager 360 from Appeon PowerBuilder using the CData ADO.NET Provider for Google Campaign Manager 360.
-
Connect to and Visualize Live Oracle Eloqua Reporting Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Oracle Eloqua Reporting.
-
Build Pipelines with Live SAP Ariba Procurement Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP Ariba Procurement from Google Cloud Data Fusion, enabling the integration of live SAP Ariba Procurement into the building and management of effective data pipelines.
-
Use the CData ODBC Driver for Salesforce CRM Analytics in Microsoft Power Query
You can use the CData Salesforce CRM Analytics ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Salesforce CRM Analytics into Microsoft Power Query.
-
Model Gong Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Gong, enabling the direct import of real-time Gong.
-
Connect to Live Greenhouse Data in MicroStrategy through CData Connect AI
Create a live connection to Greenhouse Data in CData Connect AI and connect to your Greenhouse from MicroStrategy.
-
Create Azure Analysis Services-Connected Dashboards in Grafana
Connect to Azure Analysis Services Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Azure Analysis Services.
-
Replicate Multiple Azure Data Catalog Accounts
Replicate multiple Azure Data Catalog accounts to one or many databases.
-
Integrating Cursor CLI with Oracle Eloqua 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.
-
Add Postmark Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Postmark with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData Software JDBC Driver for Amazon DynamoDB in MicroStrategy Desktop
Connect to Amazon DynamoDB in MicroStrategy Desktop using the CData Software JDBC Driver for Amazon DynamoDB.
-
Automated Continuous SAP Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP replication to IBM DB2.
-
Create Dynamic SpaceX Grids Using the Infragistics XamDataGrid
Learn how you can connect SpaceX to Infragistics XamDataGrid to build dynamic grids.
-
Access Live Act CRM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Act CRM from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Publish OnePageCrm-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live OnePageCrm.
-
Connect to Sugar CRM Data from a Connection Pool in JBoss
Integrate Sugar CRM into Java servlets: Use the Management Console in JBoss to install the Sugar CRM JDBC Driver.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Apache HBase using the Model Context Protocol.
-
How to Connect DBeaver to Reckon Accounts Hosted via a JDBC Driver
Manage Reckon Accounts Hosted with visual tools in DBeaver like the query browser.
-
Build a Simple VCL Application for PagerDuty Data
How to build a simple VCL Application to view PagerDuty in RAD Studio using the CData ODBC Driver for PagerDuty.
-
How to connect to FTP Data with Squirrel SQL client
Connect to FTP Servers and execute queries in the Squirrel SQL Client.
-
Connecting Moonlit Workflow with Confluence 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 Atlassian Confluence in real time.
-
Visualize Live Retently Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Retently using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Live SAP Concur Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP Concur.
-
Extend Google Sheets with Avro Data
Make calls to Avro from Google Apps Script via the API Server.
-
How to integrate Metabase with Snowflake Data
Use CData Connect AI to connect to live Snowflake and create an interactive dashboard in Metabase from Snowflake.
-
Build an OLAP Cube in SSAS from Google Analytics Data
Establish a connection to Google Analytics data from SQL Server Analysis Services, and use the Google Analytics Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate with NetSuite Data in SnapLogic
Use CData Connect AI to connect to and integrate with live NetSuite CRM & ERP in SnapLogic.
-
Access JobNimbus Data from MySQL in Amazon QuickSight
Connect to JobNimbus and build visualizations of JobNimbus using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Bugsnag Replication to MongoDB
Use CData Sync for automated, continuous, customizable Bugsnag replication to MongoDB.
-
Connect to Phoenix Data from PowerBuilder via JDBC
This article demonstrates how to access Apache Phoenix from PowerBuilder using the Phoenix JDBC Driver.
-
Configure the CData JDBC Driver for Elasticsearch in a Connection Pool in Tomcat
Connect to Elasticsearch from a connection pool in Tomcat.
-
Migrating data from Outreach.io to Google BigQuery using CData SSIS Components.
Easily push Outreach.io to Google BigQuery using the CData SSIS Tasks for Outreach.io and Google BigQuery.
-
Use JayDeBeApi to access HCL Domino Data in Python
Use standard Python scripting and the development environment of your choice to access live HCL Domino.
-
Integrating Cursor CLI with Miro 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.
-
Visualize Live Zoom Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Zoom using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software JDBC Driver for Apollo in MicroStrategy Web
Connect to Apollo in MicroStrategy Web using the CData Software JDBC Driver for Apollo.
-
How to work with Splunk Data in Apache Spark using SQL
Access and process Splunk Data in Apache Spark using the CData Software JDBC Driver.
-
How to Build an ETL App for Perigon Data in Python with CData
Create ETL applications and real-time data pipelines for Perigon in Python with petl.
-
Build Automated ServiceNow-Connected Workflows in Zapier
Use CData Connect AI to connect to live ServiceNow and build automated workflows in Zapier.
-
Migrating data from Amazon DynamoDB to Snowflake using CData SSIS Components.
Easily push Amazon DynamoDB to Snowflake using the CData SSIS Tasks for Amazon DynamoDB and Snowflake.
-
How to Access Tally Data Using Entity Framework
This article shows how to access Tally ERP using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Manage Zoho Inventory Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Zoho Inventory.
-
Getting Started with the CData SSIS Components for Zendesk
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Zendesk.
-
Create a Data Access Object for Hubstaff Data using JDBI
A brief overview of creating a SQL Object API for Hubstaff in JDBI.
-
Build Zoom-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Zoom and build web apps with connectivity to live Zoom.
-
How to Connect Salesforce 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 Salesforce data in real time using natural language.
-
Connect to Datadog Data from PowerBuilder via JDBC
This article demonstrates how to access Datadog from PowerBuilder using the Datadog JDBC Driver.
-
How to Access Live Microsoft Exchange Data in Visual Studio Code via Cline
Run CData MCP Server for Microsoft Exchange on Windows Subsytem for Linux (WSL) and connect to live Microsoft Exchange from the Cline extension in Visual Studio Code.
-
Build AI Agents with CouchDB Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Apache CouchDB through CData Connect AI.
-
Use Databricks Agent Bricks to Talk to Your HCL Domino Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your HCL Domino for you.
-
Integrate Theia IDE with Live Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Access Superchat Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Superchat from HeidiSQL.
-
Integrate Live Harvest Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Harvest to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Create Data Visualizations Based On PayPal Data in Mode
Use CData Connect AI to connect to PayPal Data from Mode and build visualizations using live
-
Integrating Codex CLI with Twilio 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.
-
Access XML Data from MySQL in Amazon QuickSight
Connect to XML and build visualizations of XML Files using a MySQL Connection in Amazon QuickSight.
-
Access JSON Services from MySQL in Amazon QuickSight
Connect to JSON and build visualizations of JSON using a MySQL Connection in Amazon QuickSight.
-
Automate LionDesk Data Replication to Azure Data Lake
Use CData Sync to customize and automate LionDesk replication to Azure Data Lake.
-
Connect to YouTube Analytics Data in Claris FileMaker Pro
Use the CData ODBC Driver for YouTube Analytics in FileMaker Pro to connect to YouTube Analytics and work with YouTube Analytics in your FileMaker applications.
-
Access Live Google Drive Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Drive from your Excel spreadsheets.