CData Software - Knowledge Base
Recent Articles
-
How to publish and share Shopify Data dashboards with Tableau Server
The CData ODBC driver for Shopify enables you integrate Shopify data into Tableau dashboards.
-
Automated Continuous PabblySubscriptions Replication to SQL Server
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to SQL Server.
-
Automated Continuous MongoDB Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable MongoDB replication to Apache Cassandra.
-
Create Datasets from Google Directory in Domo Workbench and Build Visualizations of Google Directory Data in Domo
Use the CData Software ODBC Driver for Google Directory to create datasets from Google Directory data in Domo Workbench and then build visualizations in the Domo service.
-
Link Omnisend with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Omnisend data in Filemaker Pro for Mac or Windows.
-
Integrate Live Bitly Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Bitly data and integrate live Bitly data into apps built in Microsoft Power Apps.
-
Build Apps with Live SendInBlue Data Using the Low-Code Development Platform of Mendix
Connect SendInBlue data with Mendix to build apps using the CData API Driver for JDBC.
-
Access SAP ByDesign Data from MySQL in PHP
Connect to SAP ByDesign through the standard MySQL libraries in PHP.
-
Integrating GitHub Copilot with FreshBooks 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.
-
ETL SAP HANA XS Advanced in Oracle Data Integrator
This article shows how to transfer SAP HANA XS Advanced data into a data warehouse using Oracle Data Integrator.
-
Use the CData Software JDBC Driver for FreshBooks in MicroStrategy
Connect to FreshBooks data in MicroStrategy Developer using the CData Software JDBC Driver for FreshBooks.
-
Create Datasets from SAP HANA in Domo Workbench and Build Visualizations of SAP HANA Data in Domo
Use the CData Software ODBC Driver for SAP HANA to create datasets from SAP HANA data in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Google Analytics Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Analytics data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query Codat Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Codat data from Node.js.
-
Connect to Microsoft Dataverse in SpagoBI
Create reports featuring live Microsoft Dataverse data in SpagoBI Studio. Host Microsoft Dataverse reports on SpagoBI Server.
-
Analyze Zoho CRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Zoho CRM data in Microsoft R Open.
-
Connect to Salesforce Pardot Data in RazorSQL
Connect to Salesforce Pardot from wizards and query Salesforce Pardot data from the GUI in the RazorSQL database management tool.
-
DataBind Superchat Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Superchat data to a chart.
-
Integrating GitHub Copilot with Testmonitor 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.
-
Integrate Trae with Live Cloudant Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Cloudant data from within the AI-powered IDE.
-
How to Query MariaDB Data in MySQL Workbench
Execute MySQL queries against live MariaDB data from MySQL Workbench.
-
Visualize WordPress Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to WordPress data.
-
Build a Simple VCL Application for Facebook Ads Data
How to build a simple VCL Application to view Facebook Ads data in RAD Studio using the CData ODBC Driver for Facebook Ads.
-
Build Visualizations of Adobe Commerce Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Adobe Commerce data in Birst.
-
Replicate Dynamics 365 Data to Multiple Databases via the CData Sync CLI
Replicate Dynamics 365 data to disparate databases with a single configuration.
-
Automate Short.io Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Short.io data from PowerShell? This article demonstrates how to utilize the Short.io Cmdlets for tasks like connecting to Short.io data, automating operations, downloading data, and more.
-
Integrate Apify Data in Pentaho Data Integration
Build ETL pipelines based on Apify data in the Pentaho Data Integration tool.
-
Natively Connect to Highrise Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Highrise data. Leverage the native support for ODBC in PHP.
-
Create ConstantContact-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to ConstantContact Data from Klipfolio and build custom visualizations using live ConstantContact data.
-
Load MessageBird Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load MessageBird data to a database.
-
Connect to Dynamics 365 Data in RapidMiner
Integrate Dynamics 365 data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Azure Synapse Data in the Pentaho Report Designer
Publish reports based on Azure Synapse data in the Pentaho BI tool.
-
Connect to Google Directory in SpagoBI
Create reports featuring live Google Directory data in SpagoBI Studio. Host Google Directory reports on SpagoBI Server.
-
Build SAP BusinessObjects BI-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP BusinessObjects BI Data and create custom apps in Bubble.
-
Interact with Live PostgreSQL Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live PostgreSQL data.
-
Integrate OpenCode with Live Adobe Commerce Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Adobe Commerce data from within your AI coding agent.
-
Connect to SAP Business Warehouse Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP Business Warehouse data using standard SQL.
-
Integrate Dify with Live Elasticsearch Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Elasticsearch data.
-
Create Adobe Analytics Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Adobe Analytics data access from reports, embedded analytics, and more.
-
Create a Data Access Object for Aweber Data using JDBI
A brief overview of creating a SQL Object API for Aweber data in JDBI.
-
Deploy the ADO.NET Provider for Authorize.Net on an SSRS Report Server
Connect to Authorize.Net data 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 Connect to Live Dynamics 365 Business Central Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Dynamics 365 Business Central data securely in real time.
-
Integrate Google's Vertex AI Agent with Live Certinia 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 Certinia data within intelligent workflows.
-
Create Datasets from Google Ad Manager in Domo Workbench and Build Visualizations of Google Ad Manager Data in Domo
Use the CData Software ODBC Driver for Google Ad Manager to create datasets from Google Ad Manager data in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData Python Connector for PhantomBuster
Learn to install and license the CData Python Connector and configure a connection to live PhantomBuster data.
-
Connect to Factorial 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 Factorial and work with Factorial data in your FileMaker application.
-
Query SAP Business One Data in DataGrip
Create a Data Source for SAP Business One in DataGrip and use SQL to query live SAP Business One data.
-
Consume Monday.com OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Monday.com feeds that reflect any changes in SAP Lumira.
-
How to connect to PayPal Data from Spring Boot
Connect to PayPal in a Spring Boot Application using the CData JDBC Driver for PayPal
-
How to connect Amazon QuickSight to SAP Hybris C4C Data
Create a connection to SAP Hybris C4C data in CData Connect AI and insert SAP Hybris C4C data into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Data Visualizations Based On HBase Data in Mode
Use CData Connect AI to connect to HBase Data from Mode and build visualizations using live HBase data.
-
Deploy the ADO.NET Provider for Impala on an SSRS Report Server
Connect to Impala data 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 Connect to SAS Data Sets Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAS Data Sets data. Leverage the pyodbc module for ODBC in Python.
-
Prepare, Blend, and Analyze Reply.io Data in Alteryx Designer (ODBC)
Build workflows to access live Reply.io data for self-service data analytics.
-
Seamlessly Bring Sugar CRM Data into Retool Using CData Connect AI
Integrate Sugar CRM data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Dashboards with Teamgate Data in Dundas BI
Create dynamic dashboards and perform analytics based on Teamgate data in Dundas BI.
-
Create SAP Netweaver Gateway-Connected Applications in Appsmith
Connect to SAP Netweaver Gateway Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Netweaver Gateway data.
-
Connect to Teamwork from a Connection Pool in WebLogic
Use the CData JDBC Driver for Teamwork to connect to Teamwork data from Web applications running on WebLogic.
-
Build Semantic Layer Views for GitLab Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for GitLab data.
-
How to Create Power BI Visual Reports with Real-Time Vimeo Data
Use CData Power BI Connectors to visualize Vimeo data in Power BI.
-
Build a Singer.io Tap for Oracle Service Cloud With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Oracle Service Cloud data using the CData Python Connector.
-
Consume Power BI XMLA OData Feeds in PowerBuilder
This article demonstrates how to consume Power BI XMLA data as OData feeds from PowerBuilder using the API Server.
-
Query Billsby Data in DataGrip
Create a Data Source for Billsby in DataGrip and use SQL to query live Billsby data.
-
Automated Continuous Google Contacts Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Contacts replication to delimited files (CSV/TSV).
-
Analyze Live HubDB Data in SAS Viya
Use CData Connect AI to connect to HubDB data from SAS Viya and deploy self-service analytics using live HubDB data.
-
How to publish and share Sendwithus Data dashboards with Tableau Server
The CData ODBC driver for Sendwithus enables you integrate Sendwithus data into Tableau dashboards.
-
Feed GetResponse Data into FineReport
How to set GetResponse data as a JDBC data source in FineReport.
-
Connect to Live SparkPost Data in MicroStrategy through CData Connect AI
Create a live connection to SparkPost Data in CData Connect AI and connect to your SparkPost data from MicroStrategy.
-
Integrating LangGraph with NetSuite Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on NetSuite data within automated workflows.
-
Build MVC Applications with Connectivity to Dynamics 365 Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Dynamics 365 from an ASP.NET MVC application.
-
Operational Reporting on Bitbucket Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Bitbucket data.
-
Access Live SpaceX Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SpaceX data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating Access Data in Talend Cloud Data Management Platform
Connect Access Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Access.
-
Create Blackbaud FE NXT Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Blackbaud FE NXT from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Bitly Data in HULFT Integrate
Connect to Bitly as a JDBC data source in HULFT Integrate
-
Use Databricks Agent Bricks to Talk to Your SharePoint Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SharePoint data for you.
-
Connect to Mode Data in Aqua Data Studio
Access Mode data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Voice Agents in ElevenLabs with access to Live Marketo Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Marketo data.
-
Establish a Live Connection with Office 365 Data using Tableau Bridge
The CData ODBC Driver for Office 365 enables you to integrate live Office 365 data into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Live eBay Data in the Power BI Service
Use CData Connect AI to connect to live eBay data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live PingOne Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate PingOne data into the statistical analysis tools available in SAS JMP. This article shows how to use PingOne data in the Graph Builder and Query Builder.
-
How to Connect to & Open SFTP Data in Microsoft Excel
This article uses the CData ODBC driver for SFTP to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Prepare, Blend, and Analyze Xero Data in Alteryx Designer (ODBC)
Build workflows to access live Xero data for self-service data analytics.
-
Automated Continuous Pushbullet Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Pushbullet replication to Apache Kafka.
-
Process & Analyze Google Ads Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Ads Data.
-
Use Dash to Build to Web Apps on Demio Data
Create Python applications that use pandas and Dash to build Demio-connected web apps.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Apollo
Provide connectivity to Apollo data through an SAP BusinessObjects universe.
-
Migrating data from Oracle HCM Cloud to Google BigQuery using CData SSIS Components.
Easily push Oracle HCM Cloud data to Google BigQuery using the CData SSIS Tasks for Oracle HCM Cloud and Google BigQuery.
-
Build an OLAP Cube in SSAS from Epicor Kinetic Data
Establish a connection to Epicor Kinetic data data from SQL Server Analysis Services, and use the Epicor Kinetic Data Provider to build OLAP cubes for use in analytics and reporting.
-
DataBind Controls to Autopilot Data in C++Builder
DataBind to Autopilot data in C++Builder with standard components and controls.
-
Work with Live Typeform Data in Power Query
Use CData Connect AI to connect to Typeform data and work with live Typeform data in Microsoft Power Query.
-
Access Workable Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Workable data from HeidiSQL.
-
Connect to TigerGraph Data from PowerBuilder via JDBC
This article demonstrates how to access TigerGraph data from PowerBuilder using the TigerGraph JDBC Driver.
-
Getting Started with the CData ADO.NET Provider for ClickTime
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous Stack Exchange Replication to Snowflake
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Snowflake.
-
Analyze YouTube Analytics Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of YouTube Analytics data and visualize YouTube Analytics data in SAP Analytics Cloud.
-
Write a Simple Go Application to work with Mistral AI Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Mistral AI data.
-
Replicate Multiple OpenWeatherMap Accounts via the CData Sync CLI
Replicate multiple OpenWeatherMap accounts to one or many databases.
-
Build Apps with Live VWO data in Adalo using CData Connect AI
Use CData Connect AI to integrate live VWO data into the Adalo platform and build custom mobile and web applications with real-time VWO data.
-
Presto Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Presto facts in real time.