CData Software - Knowledge Base
Recent Articles
-
Connect to Humanity Data in Ruby
Connect to Humanity data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Google Campaign Manager 360 Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Databricks.
-
Load Hugging Face Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Hugging Face data to a database.
-
Query Landbot Data as a MySQL Database in Node.js
Execute MySQL queries against Landbot data from Node.js.
-
Connect and Query Live CouchDB Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live CouchDB data into Databricks and enable direct, live querying and analysis without replication.
-
How to connect SharePoint with Salesforce Data through external lists
Provide Salesforce data to SharePoint users as an external list.
-
Automated Continuous Google Sheets Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Sheets replication to IBM DB2.
-
Explore Geographical Relationships in NetSuite Data with Power Map
Create data visualizations with NetSuite data in Power Map.
-
Connect to ActiveCampaign Data from AWS Glue
Use CData Connect AI to gain access to live ActiveCampaign data from your AWS Glue jobs.
-
Use CData Connect AI to Access Google Contacts Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Contacts data in the Power Pivot business intelligence tool.
-
Choosing the Best Method to Connect ZarMoney to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZarMoney data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
DataBind Controls to Salesforce Data 360 Data in Delphi
DataBind to Salesforce Data 360 data in Delphi with standard data access components and controls.
-
Build Xero-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Xero data and build Xero-connected web apps with Axios.
-
Automated Continuous Oracle Eloqua Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Apache Kafka.
-
Connect to SAP in SpagoBI
Create reports featuring live SAP data in SpagoBI Studio. Host SAP reports on SpagoBI Server.
-
Connect to and Visualize Live Azure Table Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Azure Table data.
-
Establish a Live Connection with FTP Data using Tableau Bridge
The CData ODBC Driver for FTP enables you to integrate live FTP data into Tableau Cloud dashboards using the Tableau Bridge.
-
Interact with Live Zuora Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Zuora data.
-
Feed Azure Data Lake Storage Data into FineReport
How to set Azure Data Lake Storage data as a JDBC data source in FineReport.
-
Analyze Oracle Financials Cloud Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Oracle Financials Cloud data and visualize Oracle Financials Cloud data in SAP Analytics Cloud.
-
FreshBooks Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to FreshBooks data through CData Connect AI using different applications and tools.
-
Connect to Xero in SpagoBI
Create reports featuring live Xero data in SpagoBI Studio. Host Xero reports on SpagoBI Server.
-
How to use SQLAlchemy ORM to access Dynamics CRM Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Dynamics CRM data.
-
Automated Continuous Mouseflow Replication to SingleStore
Use CData Sync for automated, continuous, customizable Mouseflow replication to SingleStore.
-
Integrating Antigravity CLI with Box data via CData CLI
Connect Box data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Wave Financial Data in HULFT Integrate
Connect to Wave Financial as a JDBC data source in HULFT Integrate
-
Extract, Transform, and Load Shopify Data in Informatica PowerCenter
Create a simple Workflow for Shopify data in Informatica PowerCenter.
-
Back Up ClickTime data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with ClickTime data data.
-
Use the CData Software JDBC Driver for MariaDB in MicroStrategy Desktop
Connect to MariaDB data in MicroStrategy Desktop using the CData Software JDBC Driver for MariaDB.
-
How to Build an ETL App for Kintone Data in Python with CData
Create ETL applications and real-time data pipelines for Kintone data in Python with petl.
-
Access Live Greenhouse Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Greenhouse data into the statistical analysis tools available in SAS JMP. This article shows how to use Greenhouse data in the Graph Builder and Query Builder.
-
Build xBase-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to xBase data and build web apps with connectivity to live xBase data.
-
Automated Continuous Google Directory Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google Directory data replication to OneLake in Microsoft Fabric.
-
How to Connect the Power BI Service to Oracle Financials Cloud: Complete Guide
Connect to the CData Software Power BI Connector for Oracle Financials Cloud from PowerBI.com to provide real-time Oracle Financials Cloud data across the organization.
-
Visualize Amplitude 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 Amplitude data into TIBCO Spotfire.
-
Import Real-Time eBay Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use eBay data in ColdFusion.
-
A PostgreSQL Interface for Snapchat Ads Data (MySQL Remoting via JDBC)
Use the Remoting features of the Snapchat Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Live Bitbucket Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Bitbucket from the MuleSoft Anypoint Platform to integrate live Bitbucket data into custom reports and dashboards.
-
Design BIRT Reports on Certinia Data
Provide current Certinia data to your embedded analytics.
-
Publish Crystal Reports on Onfleet Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Onfleet data.
-
Import Box Data Using Azure Data Factory
Use CData Connect AI to connect to Box Data from Azure Data Factory and import live Box data.
-
Create Gmail-Connected Dashboards in Grafana
Connect to Gmail Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Gmail data.
-
Connect to Splunk Data in CloverDX (formerly CloverETL)
Transfer Splunk data using the visual workflow in the CloverDX data integration tool.
-
Integrating GitHub Copilot with PDFMonkey 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.
-
Connect to Printify Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Printify Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Instantly Data in Jaspersoft Studio
Execute SQL to remote Instantly data in Jaspersoft Studio.
-
How to create Freshsales federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Freshsales data in MySQL .
-
Connect to Productboard Data from a Connection Pool in Jetty
The Productboard JDBC Driver supports connection pooling: This article shows how to connect faster to Productboard data from Web apps in Jetty.
-
Use Grok to Talk to Your SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your SendGrid data for you.
-
Integrate Zoho Creator with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Zoho Creator with External Services.
-
How to Seamlessly Import Brex Data into IBM SPSS Modeler
Integrate Brex data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Query Live Freshteam Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Freshteam data data in natural language using Python.
-
Link Authorize.Net with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Authorize.Net data in Filemaker Pro for Mac or Windows.
-
How to Use a Microsoft Access Database to Update IBM Informix Data in Real Time
Update IBM Informix data by creating a linked table in Microsoft Access with the CData IBM Informix ODBC Driver.
-
LINQ to Asana 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 Asana Data Provider.
-
Integrate Trae with Live CouchDB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live CouchDB data from within the AI-powered IDE.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP HANA XS Advanced
Provide connectivity to SAP HANA XS Advanced data through an SAP BusinessObjects universe.
-
Build MVC Applications with Connectivity to Campaigner Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Campaigner from an ASP.NET MVC application.
-
Integrate Drip Data in Pentaho Data Integration
Build ETL pipelines based on Drip data in the Pentaho Data Integration tool.
-
Publish Reports with Notion Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Notion data.
-
Connect to Oracle Financials Cloud Data in Jaspersoft Studio
Execute SQL to remote Oracle Financials Cloud data in Jaspersoft Studio.
-
Automated Continuous Samanage Replication to Oracle
Use CData Sync for automated, continuous, customizable Samanage replication to Oracle.
-
Analyze Flowlu Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Flowlu from Power Pivot. You will use the Table Import Wizard to load Flowlu data. You can visually build the import query or use any SQL supported by the driver.
-
How to use SQLAlchemy ORM to access Google Calendar Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Calendar data.
-
Connect to Placid Data in Jaspersoft Studio
Execute SQL to remote Placid data in Jaspersoft Studio.
-
Connect to Azure Table Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Azure Table.
-
Build an OLAP Cube in SSAS from Shopify Data
Establish a connection to Shopify data data from SQL Server Analysis Services, and use the Shopify Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Apollo Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Apollo from PowerBI.com to create Power BI Dataflows with real-time data.
-
Enable the ChargeOver JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ChargeOver data.
-
LINQ to LightSpeedRetail 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 LightSpeedRetail Data Provider.
-
Getting Started with the CData Python Connector for Impala
Learn to install and license the CData Python Connector and configure a connection to live Impala data.
-
Use the CData Software JDBC Driver for Act-On in MicroStrategy Desktop
Connect to Act-On data in MicroStrategy Desktop using the CData Software JDBC Driver for Act-On.
-
How to load Act-On data into Elasticsearch via Logstash
Introducing a simple method to load Act-On data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Real-Time Access to SAP Business One in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP Business One data in real time.
-
Create Google Ads-Connected Dashboards in Grafana
Connect to Google Ads Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Ads data.
-
Connect Microsoft Exchange Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft Exchange data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate with Rootly Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Rootly data to a JSON file on disk.
-
Query Monday.com Data in ColdFusion
Write standard ColdFusion data access code to connect to Monday.com data.
-
LINQ to Outlook 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 Outlook Data Provider.
-
Connecting Moonlit Workflow with Snapchat Ads 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 Snapchat Ads data in real time.
-
How to create Visio diagrams from QuickBooks Data
Automatically update QuickBooks data with the changes you make to Visio master shapes.
-
Natively Connect to MailerSend Data in PHP
The CData ODBC driver for MailerSend enables you to create PHP applications with connectivity to MailerSend data. Leverage the native support for ODBC in PHP.
-
How to Connect the Power BI Service to ZohoPeople: Complete Guide
Connect to the CData Software Power BI Connector for ZohoPeople from PowerBI.com to provide real-time ZohoPeople data across the organization.
-
How to Connect the Power BI Service to Typeform: Complete Guide
Connect to the CData Software Power BI Connector for Typeform from PowerBI.com to provide real-time Typeform data across the organization.
-
Prepare, Blend, and Analyze Cloudflare Data in Alteryx Designer (Connect AI)
Build workflows to access live Cloudflare data for self-service data analytics.
-
Integrate Open WebUI with Live Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft OneDrive data from within the chat interface.
-
How to connect SharePoint with Google Ad Manager Data through external lists
Provide Google Ad Manager data to SharePoint users as an external list.
-
Create Reports with SAP Ariba Procurement Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Ariba Procurement data.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Ads
Create Google Ads data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use Databricks Agent Bricks to Talk to Your HubSpot Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your HubSpot data for you.
-
Build Dashboards with eBay Analytics Data in Dundas BI
Create dynamic dashboards and perform analytics based on eBay Analytics data in Dundas BI.
-
Connect to Guru Data from a Connection Pool in JBoss
Integrate Guru data into Java servlets: Use the Management Console in JBoss to install the Guru JDBC Driver.
-
Connect to HBase Data in Jaspersoft Studio
Execute SQL to remote HBase data in Jaspersoft Studio.
-
Connect to Databricks Data in DBeaver
Use the CData ODBC Driver to connect to Databricks data in DBeaver.
-
How to Access Live Acumatica Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Acumatica enables you to integrate Acumatica data into workflows built using Microsoft Power Automate Desktop.
-
Query SAS Data Sets Data in ColdFusion
Write standard ColdFusion data access code to connect to SAS Data Sets data.
-
Import and Visualize FTP Data in Power View
Create data visualizations based on FTP data in Excel.
-
Access Live CouchDB Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live CouchDB data from your Google Sheets.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ZeroBounce
Provide connectivity to ZeroBounce data through an SAP BusinessObjects universe.
-
How to connect PolyBase to OneNote
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live OneNote data.