CData Software - Knowledge Base
Recent Articles
-
Replicate OnePageCrm Data to Multiple Databases via the CData Sync CLI
Replicate OnePageCrm to disparate databases with a single configuration.
-
Automated Continuous SAP Ariba Source Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to delimited files (CSV/TSV).
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed MariaDB to Power BI dashboards. Simply drag and drop MariaDB into data visuals on the Power BI canvas.
-
Integrating Gumloop with Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Facebook within automated workflows.
-
DataBind Controls to Email Data in Delphi
DataBind to Email in Delphi with standard data access components and controls.
-
Operational Reporting on Shippo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Shippo.
-
Getting Started with the CData Excel Add-In for MySQL
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for MySQL.
-
How to connect and process MongoDB from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live MongoDB.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Bitbucket to Power BI dashboards. Simply drag and drop Bitbucket into data visuals on the Power BI canvas.
-
Create Data Visualizations in Cognos BI with Jumpseller Data
Access Jumpseller as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build a Singer.io Tap for Sage 200 With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Sage 200 data using
-
Back Up Outreach.io to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Outreach.io. In this article, we will employ an SSIS workflow to populate a database with Outreach.io data.
-
Integrate with Missive Data in JReport Designer
Create charts and reports based on Missive in JReport Designer.
-
How to connect to BenchmarkEmail Data in DBVisualizer
Integrate BenchmarkEmail with visual data analysis tools and data connection wizards in DBVisualizer
-
Getting Started with the CData Excel Add-In for Phoenix
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Phoenix.
-
Getting Started with the CData Python Connector for NetSuite
Learn to install and license the CData Python Connector
-
Automated Continuous Google Ads Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Ads replication to delimited files (CSV/TSV).
-
Work with Google Cloud Storage Data in FoxPro
Load Google Cloud Storage into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate ShipStation Data in Heroku for Use in Salesforce Connect
Replicate ShipStation to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Analyze Live Cvent Data in SAS Viya
Use CData Connect AI to connect to Cvent from SAS Viya and deploy self-service analytics using live Cvent.
-
Connect to Superchat Data in JRuby
Create a simple JRuby app with access to live Superchat.
-
Connect to Pipeline CRM in SpagoBI
Create reports featuring live Pipeline CRM in SpagoBI Studio. Host Pipeline CRM reports on SpagoBI Server.
-
Procore Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Procore facts in real time.
-
Integrate Open WebUI with Live Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Stripe from within the chat interface.
-
Connect to Workday Data from a Connection Pool in Jetty
The Workday JDBC Driver supports connection pooling: This article shows how to connect faster to Workday from Web apps in Jetty.
-
Access xBase Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access xBase from your Oracle system.
-
Build a Simple VCL Application for REST Data
How to build a simple VCL Application to view REST in RAD Studio using the CData ODBC Driver for REST.
-
Connect to Mode Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Mode and work with Mode in your FileMaker applications.
-
Bridge CapsuleCRM Connectivity with Apache NiFi
Access and process CapsuleCRM in Apache NiFi using the CData JDBC Driver.
-
Connect to AlloyDB Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google AlloyDB.
-
How to import Act-On Data into Apache Solr
Use the CData Software JDBC Driver for Act-On in Data Import Handler and create an automated import of Act-On to Apache Solr Enterprise Search platform.
-
Access Live GraphQL Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live GraphQL through MCP integration.
-
Consume CockroachDB OData Feeds in PowerBuilder
This article demonstrates how to consume CockroachDB as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous Aweber Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Aweber replication to PostgreSQL.
-
Use JayDeBeApi to access Sendwithus Data in Python
Use standard Python scripting and the development environment of your choice to access live Sendwithus.
-
DataBind Factorial Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Factorial to a chart.
-
How to Connect Flowise AI Agents to Live YouTube Analytics Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live YouTube Analytics without replication.
-
Build a Simple VCL Application for Google Spanner Data
How to build a simple VCL Application to view Google Spanner in RAD Studio using the CData ODBC Driver for Google Spanner.
-
Create Datasets from Supabase in Domo Workbench and Build Visualizations of Supabase Data in Domo
Use the CData Software ODBC Driver for Supabase to create datasets from Supabase in Domo Workbench and then build visualizations in the Domo service.
-
Import Real-Time Google Cloud Storage Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Cloud Storage in ColdFusion.
-
Rapidly Develop SageHR-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 SageHR.
-
Use the CData Software ODBC Driver for Instagram in MicroStrategy Desktop
Connect to Instagram in MicroStrategy Desktop using the CData Software ODBC Driver for Instagram.
-
Integrate Cursor with Live PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live PayPal from within the editor.
-
Edit and Search Reckon Accounts Hosted External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Reckon Accounts Hosted to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Reckon Accounts Hosted objects that you can access from apps and the dashboard.
-
Replicate Multiple HubDB Accounts via the CData Sync CLI
Replicate multiple HubDB accounts to one or many databases.
-
How to connect SharePoint with Cvent Data through external lists
Provide Cvent to SharePoint users as an external list.
-
Getting Started with the CData Python Connector for Ontraport
Learn to install and license the CData Python Connector
-
View Reports on Real-Time Epicor Kinetic Data in Power BI Report Server
Use the CData ODBC Driver for Epicor Kinetic to visualize Epicor Kinetic in Power BI Desktop and then publish them to Power BI Report Server.
-
Access JotForm Data from MySQL in PHP
Connect to JotForm through the standard MySQL libraries in PHP.
-
Use the CData Software ODBC Driver for Odoo in MicroStrategy Web
Connect to Odoo ERP in MicroStrategy Web using the CData Software ODBC Driver for Odoo.
-
Extend Google Sheets with SurveyMonkey Data
Make calls to SurveyMonkey from Google Apps Script via the API Server.
-
Model Avalara AvaTax Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Avalara AvaTax, enabling the direct import of real-time Avalara AvaTax.
-
Access Live Act-On Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Act-On from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate Intercom with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Intercom with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Intercom.
-
Publish Reports with Copper Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Copper.
-
Create Reports with Shippo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Shippo.
-
Integrate Dynamics CRM Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Dynamics CRM from Informatica Cloud.
-
Use the CData Software ODBC Driver for ChartMogul in SAS for Real-Time Reporting and Analytics
Connect to real-time ChartMogul in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ChartMogul.
-
Getting Started with the CData Power BI Connector for SuiteCRM
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SuiteCRM.
-
Edit and Search External Gong Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Gong to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Gong Data objects that you can access from apps and the dashboard.
-
Build Apps with Live Microsoft Ads Data Using the Low-Code Development Platform of Mendix
Connect Microsoft Ads with Mendix to build apps using the CData JDBC Driver for Microsoft Ads.
-
Connect to Onfleet Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Onfleet and the SQL Gateway to access Onfleet from Google Apps Script.
-
Natively Connect to Suadeo Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Suadeo. Leverage the native support for ODBC in PHP.
-
Access Live LaunchDarkly Data in AWS Lambda
Connect to live LaunchDarkly in AWS Lambda using the CData JDBC Driver.
-
Connect to SurveyMonkey Data from HeidiSQL
Use CData Connect AI to connect to and query live SurveyMonkey from HeidiSQL.
-
How to Access Live Datadog Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Datadog enables you to integrate Datadog into workflows built using Microsoft Power Automate Desktop.
-
Create SAP Business One-Connected Business Apps in AppSheet
Connect to SAP Business One Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP Business One.
-
Analyze Sage Cloud Accounting Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Sage Business Cloud Accounting in Microsoft R Open.
-
Connect to ElevenLabs Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ElevenLabs using standard SQL.
-
Integrating OpenCode Terminal with Parallel 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.
-
Analyze Act-On Data in Looker
Use CData Connect AI to connect to Act-On Data from Looker and build custom apps using live Act-On.
-
Connect to Salesforce CRM Analytics Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Enable the AfterShip JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with AfterShip.
-
Connect to BambooHR Data in JRuby
Create a simple JRuby app with access to live BambooHR.
-
Connect to Hacker News Data in Jaspersoft Studio
Execute SQL to remote Hacker News in Jaspersoft Studio.
-
Connect to Coda Data in CloverDX (formerly CloverETL)
Transfer Coda using the visual workflow in the CloverDX data integration tool.
-
How to Access Planio Data Using Entity Framework
This article shows how to access Planio using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect the Power BI Service to ZohoExpense: Complete Guide
Connect to the CData Software Power BI Connector for ZohoExpense from PowerBI.com to provide real-time ZohoExpense across the organization.
-
Connecting Moonlit Workflow with Dropbox 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 Dropbox in real time.
-
Integrate Optimizely Data in the Pentaho Report Designer
Publish reports based on Optimizely in the Pentaho BI tool.
-
Use Dash to Build Web Apps on Azure Analysis Services Data via CData Connect AI
Build interactive Dash web apps on live Azure Analysis Services using pandas and the CData Connect AI Python SDK.
-
Publish Reports with Discourse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Discourse.
-
DataBind Controls to ShipEngine Data in Delphi
DataBind to ShipEngine in Delphi with standard data access components and controls.
-
Automate Tasks in Power Automate Using the CData API Server
Automate SendGrid actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Moving Data from Suadeo to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Suadeo data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Dynamics 365 Business Central Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Write a Simple Go Application to work with Mocean Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Mocean.
-
Migrating data from Hive to Databricks using CData SSIS Components.
Easily push Apache Hive to Databricks using the CData SSIS Tasks for Hive and Databricks.
-
Integrate ADP Data in Pentaho Data Integration
Build ETL pipelines based on ADP in the Pentaho Data Integration tool.
-
Use the CData Software JDBC Driver for Amazon DynamoDB in MicroStrategy
Connect to Amazon DynamoDB in MicroStrategy Developer using the CData Software JDBC Driver for Amazon DynamoDB.
-
Connect to SAP Business Warehouse Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP Business Warehouse to connect to SAP Business Warehouse and execute queries in PowerBuilder.
-
Visualize Cloudant Data in TIBCO Spotfire through ADO.NET
Integrate IBM Cloudant into dashboards in TIBCO Spotfire.
-
Build Microsoft Exchange-Connected Apps in Choreo
Use CData Connect AI to connect to Microsoft Exchange Data from Choreo and build custom apps using live Microsoft Exchange.
-
PingOne Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on PingOne facts in real time.
-
Load Productboard Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Productboard to a database.
-
Use the CData Software ODBC Driver for TigerGraph in MicroStrategy Web
Connect to TigerGraph in MicroStrategy Web using the CData Software ODBC Driver for TigerGraph.
-
Getting Started with the CData Excel Add-In for Odoo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Odoo.
-
Build Dashboards with Asana Data in Dundas BI
Create dynamic dashboards and perform analytics based on Asana in Dundas BI.
-
Publish Crystal Reports on SAP Concur Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP Concur.
-
Connect to MarkLogic Data from HeidiSQL
Use CData Connect AI to connect to and query live MarkLogic from HeidiSQL.