CData Software - Knowledge Base
Recent Articles
-
Access Sage 300 Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Sage 300.
-
Build a Simple VCL Application for Tanda Data
How to build a simple VCL Application to view Tanda in RAD Studio using the CData ODBC Driver for Tanda.
-
Connect to and Visualize Live ZohoMarketingHub Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ZohoMarketingHub.
-
Create SSAS Tabular Models from MessageBird Data
How to build a SQL Server Analysis Service Tabular Model from MessageBird using CData drivers.
-
Connect to Microsoft Exchange Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Microsoft Exchange Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate XML Data in Pentaho Data Integration
Build ETL pipelines based on XML Files in the Pentaho Data Integration tool.
-
Access Live ShipEngine Data in AWS Lambda
Connect to live ShipEngine in AWS Lambda using the CData JDBC Driver.
-
Create Data Visualizations in Cognos BI with FreshBooks Data
Access FreshBooks as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create ElevenLabs Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ElevenLabs from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Easily Query SAP Business One Data in OpenOffice Base
Connect to SAP Business One data in OpenOffice Base using the CData ODBC Driver for SAP Business One and generate reports with live data insights.
-
Query Cloudflare Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Cloudflare from Node.js.
-
Create Oracle SCM-Connected Nintex Workflows
Use CData Connect AI to connect to Oracle SCM Data from Nintex Workflow Cloud and build custom workflows using live Oracle SCM.
-
Easily Integrate iContact Data in Lazarus Pascal IDE
Learn how to easily integrate live iContact in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Seamlessly Bring Airtable Data into Retool Using CData Connect AI
Integrate Airtable data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous Printify Replication to MySQL
Use CData Sync for automated, continuous, customizable Printify replication to MySQL.
-
Integrate with Adobe Experience Manager Data in JReport Designer
Create charts and reports based on Adobe Experience Manager in JReport Designer.
-
Connect to and Visualize Live Acumatica Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Acumatica ERP.
-
Connect to Monday.com Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Monday.com.
-
Connect to AlloyDB Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for AlloyDB and the Script function in FileMaker Pro to connect to AlloyDB and work with Google AlloyDB in your FileMaker application.
-
Access Azure Synapse Data from MySQL in Amazon QuickSight
Connect to Azure Synapse and build visualizations of Azure Synapse using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Cassandra Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Cassandra replication to Google BigQuery.
-
Publish MariaDB-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live MariaDB.
-
Connect to Avro Data in DBeaver
Use the CData ODBC Driver to connect to Apache Avro in DBeaver.
-
How to Query Cassandra Data in MySQL Workbench
Execute MySQL queries against live Apache Cassandra from MySQL Workbench.
-
Prepare, Blend, and Analyze Salesforce Marketing Data in Alteryx Designer (ODBC)
Build workflows to access live Salesforce Marketing Cloud for self-service data analytics.
-
Getting Started with the CData Tableau Connector for Mistral AI
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Use the CData Software ODBC Driver for Certinia in SAS for Real-Time Reporting and Analytics
Connect to real-time Certinia in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Certinia.
-
Connect to AfterShip Data in DBArtisan
Use wizards in DBArtisan to configure AfterShip as a data source.
-
Publish Crystal Reports on Bannerbear Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Bannerbear.
-
Connect to Brex Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Brex and the SQL Gateway to access Brex from Google Apps Script.
-
Analyze SendGrid Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SendGrid in Microsoft R Open.
-
Bidirectional Access to Eventbrite Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Eventbrite in Filemaker Pro for Mac or Windows.
-
Access Stripe Data from MySQL in PHP
Connect to Stripe through the standard MySQL libraries in PHP.
-
Create SSAS Tabular Models from HDFS Data
How to build a SQL Server Analysis Service Tabular Model from Apache HDFS using CData drivers.
-
How to integrate Zoom with Apache Airflow
Access and process Zoom in Apache Airflow using the CData JDBC Driver.
-
LINQ to PivotalTracker Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the PivotalTracker Data Provider.
-
Prepare, Blend, and Analyze DocuSign Data in Alteryx Designer (Connect AI)
Build workflows to access live DocuSign for self-service data analytics.
-
Seamlessly Bring Dynamics 365 Business Central Data into Retool Using CData Connect AI
Integrate Dynamics 365 Business Central data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
DataBind Controls to Jumpseller Data in Delphi
DataBind to Jumpseller in Delphi with standard data access components and controls.
-
Access Sybase IQ Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Sybase IQ from HeidiSQL.
-
Write a Simple Go Application to work with Gumroad Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Gumroad.
-
DataBind Controls to Highrise Data in C++Builder
DataBind to Highrise CRM in C++Builder with standard components and controls.
-
Connect to Google Forms Data in HULFT Integrate
Connect to Google Forms as a JDBC data source in HULFT Integrate
-
Excel Spreadsheet Automation on Ontraport Data with the QUERY Formula
Pull data from Ontraport, automate spreadsheets, and more with the QUERY formula.
-
Create Data Visualizations Based On Presto Data in Mode
Use CData Connect AI to connect to Presto Data from Mode and build visualizations using live
-
Create Informatica Mappings From/To a JDBC Data Source for Jumpseller
Create Jumpseller data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Tally Data in AWS Lambda
Connect to live Tally ERP in AWS Lambda using the CData JDBC Driver.
-
View Reports on Real-Time Yelp Data in Power BI Report Server
Use the CData ODBC Driver for Yelp to visualize Yelp in Power BI Desktop and then publish them to Power BI Report Server.
-
Migrating data from Google Calendar to Snowflake using CData SSIS Components.
Easily push Google Calendar to Snowflake using the CData SSIS Tasks for Google Calendar and Snowflake.
-
Use the CData Software ODBC Driver for Google Drive in MicroStrategy Web
Connect to Google Drive in MicroStrategy Web using the CData Software ODBC Driver for Google Drive.
-
Build Visualizations of Jira Assets Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Jira Assets in Birst.
-
A PostgreSQL Interface for Jira Assets Data (MySQL Remoting via JDBC)
Use the Remoting features of the Jira Assets JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Controls to OpenWeatherMap Data in C++Builder
DataBind to OpenWeatherMap in C++Builder with standard components and controls.
-
Analyze Sage 200 Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Sage 200 and visualize Sage 200 in SAP Analytics Cloud.
-
Publish Guru-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Guru.
-
Build AI/ML Models with Live SuiteCRM Data using Dataiku
Connect SuiteCRM Data with Dataiku using the CData JDBC Driver for SuiteCRM.
-
Build Dynamics NAV-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Dynamics NAV to explore live Dynamics NAV Data in Cursor to assist with building Dynamics NAV-powered applications.
-
Connect to Lakebase from Asprova with CData Software ODBC Driver for Lakebase
This article shows how to connect faster to Lakebase data from Asprova.
-
A PostgreSQL Interface for Microsoft Exchange Data (MySQL Remoting via JDBC)
Use the Remoting features of the Microsoft Exchange JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Oracle HCM Cloud Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Oracle HCM Cloud securely in real time.
-
How to Build an ETL App for Google Ad Manager Data in Python with CData Connect AI
Build ETL pipelines that read and write live Google Ad Manager in Python with petl and the CData Connect AI Python SDK.
-
Connect to Intercom Data in NetBeans
Connect to Intercom in NetBeans with the data source configuration wizard.
-
Connect to IBM Cloud Object Storage Data in RazorSQL
Connect to IBM Cloud Object Storage from wizards and query IBM Cloud Object Storage from the GUI in the RazorSQL database management tool.
-
Automated Cassandra Data Replication to Teradata
Use CData Sync to Customize and automate Apache Cassandra replication to Teradata.
-
How to use SQLAlchemy ORM to access Vimeo Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Vimeo.
-
Access ClickTime Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ClickTime from HeidiSQL.
-
Use the CData ODBC Driver for Guru from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Guru to connect to Guru from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Guru in Excel.
-
Work with SAP HANA XS Advanced Data in FoxPro
Load SAP HANA XS Advanced into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live Facebook Ads Data in AWS Lambda
Connect to live Facebook Ads in AWS Lambda using the CData JDBC Driver.
-
Access Live Basecamp Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Basecamp from your Excel spreadsheets.
-
Automated Continuous Egnyte Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Egnyte replication to Google Cloud SQL.
-
Choosing the Best Method to Connect ConvertAPI to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ConvertAPI from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Exact Online Data in Google Apps Script via Connect AI
Use CData Connect AI to access Exact Online in Google Apps Script.
-
ETL Google Cloud Storage in Oracle Data Integrator
This article shows how to transfer Google Cloud Storage into a data warehouse using Oracle Data Integrator.
-
Import Real-Time Notion Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Notion in ColdFusion.
-
Automated Continuous Printify Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Printify replication to PostgreSQL.
-
Connect PagerDuty to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live PagerDuty using the CData Python MCP Server.
-
How to Work with Aircall Data in AWS Glue Jobs Using JDBC
Connect to Aircall from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Adobe Commerce-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Adobe Commerce to explore live Adobe Commerce Data in Gemini Code Assist to assist with building Adobe Commerce-powered applications.
-
Visualize Adobe Experience Manager Data in Tableau
The CData ODBC driver for Adobe Experience Manager enables you integrate Adobe Experience Manager into Tableau dashboards.
-
Build Charts with SuiteCRM Data in Clear Analytics
Create dynamic charts and perform analytics based on SuiteCRM in Clear Analytics.
-
How to create Visio diagrams from SAP Concur Data
Automatically update SAP Concur with the changes you make to Visio master shapes.
-
How to connect SharePoint with SAP ByDesign Data through external lists
Provide SAP Business ByDesign to SharePoint users as an external list.
-
Connect to Printify Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Printify in the Denodo Virtual DataPort Administrator.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Zoom
Provide connectivity to Zoom through an SAP BusinessObjects universe.
-
How to import Amazon Marketplace Data into Apache Solr
Use the CData Software JDBC Driver for Amazon Marketplace in Data Import Handler and create an automated import of Amazon Marketplace to Apache Solr Enterprise Search platform.
-
Getting Started with the CData ODBC Driver for Workday
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Workday.
-
Using the CData Software ODBC Driver for Couchbase in PyCharm
Connect to Couchbase as an ODBC data source in PyCharm using the CData Software ODBC Driver for Couchbase.
-
Getting Started with the CData Python Connector for SAP SuccessFactors
Learn to install and license the CData Python Connector
-
Connect to CircleCI Data from PowerBuilder via ADO.NET
This article demonstrates how to access CircleCI from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to xBase Data in HULFT Integrate
Connect to xBase as a JDBC data source in HULFT Integrate
-
Work with SAS xpt Data in FoxPro
Load SAS XPORT into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Apps from Email Data in Qlik Sense Cloud
Use CData Connect AI to connect to Email Data and build apps from live Email in Qlik Sense Cloud.
-
Build Elasticsearch-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Elasticsearch Data from Zoho Analytics and import live Elasticsearch.
-
Connect to Everhour 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 Everhour and work with Everhour in your FileMaker application.
-
Use Azure AI Foundry to Talk to Your Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Xero Accounting for you.
-
Connect to Google Calendar Data in CloverDX (formerly CloverETL)
Transfer Google Calendar using the visual workflow in the CloverDX data integration tool.
-
How to Visualize Box Data in Python with pandas
Use pandas and other modules to analyze and visualize live Box in Python.
-
Automated Continuous Google Cloud Storage Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to Snowflake.
-
Provide OData Services of Kintone Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Kintone by developing a WCF Service Application.