CData Software - Knowledge Base
Recent Articles
-
Publish Crystal Reports on PhantomBuster Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date PhantomBuster.
-
Edit and Search SAP ByDesign External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SAP Business ByDesign to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SAP ByDesign objects that you can access from apps and the dashboard.
-
Build Sybase IQ-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Sybase IQ and build web apps with connectivity to live Sybase IQ.
-
Visualize Quaderno Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Quaderno.
-
Migrating data from Office 365 to Snowflake using CData SSIS Components.
Easily push Microsoft Office 365 to Snowflake using the CData SSIS Tasks for Office 365 and Snowflake.
-
Build Zuora-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Zuora.
-
How to Query Live Dropbox Data in Perplexity MacOS Desktop
Connect to and query live Dropbox Data in Perplexity Desktop using CData MCP Server.
-
Query Sybase Data as a MySQL Database in Node.js
Execute MySQL queries against Sybase from Node.js.
-
How to connect to JDBC-ODBC Bridge Data from Spring Boot
Connect to JDBC-ODBC Bridge in a Spring Boot Application using the CData JDBC-ODBC Bridge Driver
-
How to connect to Paylocity Data from Spring Boot
Connect to Paylocity in a Spring Boot Application using the CData JDBC Driver for Paylocity
-
Design BIRT Reports on ShipEngine Data
Provide current ShipEngine to your embedded analytics.
-
Create Reports with Simplesat Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Simplesat.
-
Connect to Autopilot 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 Autopilot and work with Autopilot in your FileMaker application.
-
Build Charts with Keap Data in Clear Analytics
Create dynamic charts and perform analytics based on Keap in Clear Analytics.
-
Provide OData Services of HubDB Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for HubDB by developing a WCF Service Application.
-
Connect to Discord Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Discord and the SQL Gateway to access Discord from Google Apps Script.
-
Connect to Aircall Data from PowerBuilder via JDBC
This article demonstrates how to access Aircall from PowerBuilder using the Aircall JDBC Driver.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed FHIR to Power BI dashboards. Simply drag and drop FHIR into data visuals on the Power BI canvas.
-
Write a Simple Go Application to work with SendInBlue Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SendInBlue.
-
A PostgreSQL Interface for Reply.io Data using the CData ODBC Driver
Use the SQL Gateway and Reply.io ODBC Driver to create a PostgreSQL entry-point for data access.
-
Viewing Avro Data in RAD Studio Data Explorer
How to view Apache Avro in RAD Studio Data Explorer using the CData ODBC Driver for Avro.
-
Integrate Cursor with Live Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Zoom from within the editor.
-
Access Workable Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Workable from your Oracle system.
-
Analyze ADP Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of ADP and visualize live ADP in Infragistics Reveal.
-
Access BigCommerce Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access BigCommerce from your Oracle system.
-
Import Real-Time ClickTime Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ClickTime in ColdFusion.
-
Automate ZohoSubscriptions Data Replication to Azure Synapse
Use CData Sync to customize and automate ZohoSubscriptions replication to Azure Synapse.
-
Automated Continuous Acumatica Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Acumatica replication to AlloyDB.
-
Automated Continuous Slack Replication to SQLite
Use CData Sync for automated, continuous, customizable Slack replication to SQLite.
-
Visualize Mouseflow Data in Sisense
Create an ElastiCube in Sisense app with access to Mouseflow.
-
Connect to Google Translate Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Translate using standard SQL.
-
Import SuiteCRM Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SuiteCRM. In this article, you will use the OData format to import SuiteCRM into Microsoft Power Query.
-
How to Access Live SuiteCRM Data in Visual Studio Code via Cline
Run CData MCP Server for SuiteCRM on Windows Subsytem for Linux (WSL) and connect to live SuiteCRM from the Cline extension in Visual Studio Code.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Sugar CRM using the Model Context Protocol.
-
Visualize Live FreeAgent Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live FreeAgent.
-
How to create ConvertKit federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ConvertKit in MySQL .
-
Automated Continuous CapsuleCRM Replication to Snowflake
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Snowflake.
-
Replicate Multiple Google Forms Accounts via the CData Sync CLI
Replicate multiple Google Forms accounts to one or many databases.
-
Build MVC Applications with Connectivity to Jodoo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Jodoo from an ASP.NET MVC application.
-
Integrate Real-Time Access to ShipStation in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to ShipStation in real time.
-
How to Connect Flowise AI Agents to Live HCL Domino 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 HCL Domino without replication.
-
Use the CData Software ODBC Driver for Impala in MicroStrategy Desktop
Connect to Apache Impala in MicroStrategy Desktop using the CData Software ODBC Driver for Impala.
-
How to Access SAP Concur Data Using Entity Framework
This article shows how to access SAP Concur using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to HubDB Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Import Data from SharePoint into Google Sheets
Import Microsoft SharePoint into a Google spreadsheet that is automatically refreshed.
-
Visualize Parallel 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 Parallel into TIBCO Spotfire.
-
Analyze Act CRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Act CRM from Power Pivot. You will use the Table Import Wizard to load Act CRM. You can visually build the import query or use any SQL supported by the driver.
-
Create SSAS Tabular Models from Oracle SCM Data
How to build a SQL Server Analysis Service Tabular Model from Oracle SCM using CData drivers.
-
Integrate with SAP SuccessFactors Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP SuccessFactors to a JSON file on disk.
-
How to Query SAP ByDesign Data in MySQL Workbench
Execute MySQL queries against live SAP Business ByDesign from MySQL Workbench.
-
How to connect and process Klaviyo from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Klaviyo.
-
DataBind Controls to Cassandra Data in Delphi
DataBind to Apache Cassandra in Delphi with standard data access components and controls.
-
Visualize Klaviyo Data in TIBCO Spotfire through OData
Integrate Klaviyo into dashboards in TIBCO Spotfire.
-
How to Work with MySQL Data in ETL Validator JDBC
Connect to MySQL from ETL Validator jobs using the CData Software JDBC Driver.
-
Use Dash to Build to Web Apps on Bitly Data
Create Python applications that use pandas and Dash to build Bitly-connected web apps.
-
A PostgreSQL Interface for Office 365 Data (MySQL Remoting via JDBC)
Use the Remoting features of the Office 365 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Semantic Layer Views for Stripe Data in APOS Live Data Gateway
Use the CData Connector for Stripe in APOS Live Data Gateway to build Semantic Layer Views for Stripe.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Retently
Provide connectivity to Retently through an SAP BusinessObjects universe.
-
Use Agno to Talk to Your OData Services 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 OData for you.
-
Stream Exact Online Data into Apache Kafka Topics
Access and stream Exact Online in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating Antigravity CLI with SAP Business One via CData CLI
Connect SAP Business One to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous Figshare Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Figshare replication to IBM DB2.
-
Build a Simple VCL Application for EnterpriseDB Data
How to build a simple VCL Application to view EnterpriseDB in RAD Studio using the CData ODBC Driver for EnterpriseDB.
-
Build Airtable Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Airtable and build visualizations in Tableau Cloud.
-
Build Oracle Service Cloud-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Oracle Service Cloud and build Oracle Service Cloud-connected web apps with Axios.
-
Integrating Codex CLI with Freshservice 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.
-
Build Contentful-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Contentful Data in Claude Code to assist with building Contentful-powered applications.
-
Connect to and Query Drift Data in QlikView over ODBC
Create data visualizations with Drift in QlikView.
-
DataBind Databricks Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Databricks with the DevExpress Windows Forms and Web controls to provide Databricks to a chart.
-
View Reports on Real-Time Strava Data in Power BI Report Server
Use the CData ODBC Driver for Strava to visualize Strava in Power BI Desktop and then publish them to Power BI Report Server.
-
Import Microsoft Ads Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft Ads. In this article, you will use the OData format to import Microsoft Ads into Microsoft Power Query.
-
Automated Continuous Xero Replication to Snowflake
Use CData Sync for automated, continuous, customizable Xero replication to Snowflake.
-
Build Automated Workflows with Live Redis Data in Workato
Use CData Connect AI to connect to live Redis and build automated workflows in Workato.
-
Create Data Visualizations in Cognos BI with TigerGraph Data
Access TigerGraph as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Apps from Google Ads Data in Qlik Sense Cloud
Use CData Connect AI to connect to Google Ads Data and build apps from live Google Ads in Qlik Sense Cloud.
-
How to Connect DBeaver to LinkedIn Ads via a JDBC Driver
Manage LinkedIn Ads with visual tools in DBeaver like the query browser.
-
How to integrate Bullhorn CRM with Apache Airflow
Access and process Bullhorn CRM in Apache Airflow using the CData JDBC Driver.
-
How to Connect to Live WooCommerce 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 WooCommerce through natural language.
-
How to Visualize Slack Data in Python with pandas
Use pandas and other modules to analyze and visualize live Slack in Python.
-
How to Connect to Live SAP Business One Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP Business One securely in real time.
-
Automated Continuous Front Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Front replication to AlloyDB.
-
Query ShipEngine Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ShipEngine from Node.js.
-
Analyze ConvertKit Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of ConvertKit and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Postmark Data in Pentaho Data Integration
Build ETL pipelines based on Postmark in the Pentaho Data Integration tool.
-
Build Semantic Layer Views for Vault CRM Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Veeva Vault & Vault CRM.
-
Use the CData Software JDBC Driver for Sybase in MicroStrategy Web
Connect to Sybase in MicroStrategy Web using the CData Software JDBC Driver for Sybase.
-
Visualize Instagram Data in TIBCO Spotfire through OData
Integrate Instagram into dashboards in TIBCO Spotfire.
-
How to connect to Pipedrive Data from IntelliJ
Integrate connectivity to Pipedrive with wizards in IntelliJ.
-
How to Connect to NetSuite Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to NetSuite CRM & ERP. Leverage the pyodbc module for ODBC in Python.
-
Analyze Redis Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Redis and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to connect to Workable Data from IntelliJ
Integrate connectivity to Workable with wizards in IntelliJ.
-
Automated Continuous Smartsheet Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Smartsheet replication to Google Cloud SQL.
-
Publish Crystal Reports on ClickTime Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ClickTime.
-
How to connect to Sugar CRM Data with Squirrel SQL client
Connect to Sugar CRM and execute queries in the Squirrel SQL Client.
-
Build a Simple VCL Application for Pingdom Data
How to build a simple VCL Application to view Pingdom in RAD Studio using the CData ODBC Driver for Pingdom.
-
Automate Reckon Accounts Hosted Data Replication to Couchbase
Use CData Sync to Customize and automate Reckon Accounts Hosted replication to Couchbase.
-
How to connect to IBM Informix Data in DBVisualizer
Integrate IBM Informix with visual data analysis tools and data connection wizards in DBVisualizer
-
Creating SingleStore-Connected Applications in Unqork
You can use CData Connect AI to feed SingleStore to Unqork and build custom business apps.
-
Automated Continuous Jira Replication to SQLite
Use CData Sync for automated, continuous, customizable Jira replication to SQLite.
-
Visualize Bitbucket 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 Bitbucket into TIBCO Spotfire.