CData Software - Knowledge Base
Recent Articles
-
Visualize Bullhorn CRM 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 Bullhorn CRM data into TIBCO Spotfire.
-
Connect to Sendwithus 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 Sendwithus and work with Sendwithus data in your FileMaker application.
-
Connect to Salesforce Pardot Data from Crystal Reports
Use CData Connect AI to connect to and report on live Salesforce Pardot data from Crystal Reports.
-
Integrate Cursor with Live Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Sheets data from within the editor.
-
Create SSAS Tabular Models from SAP Concur Data
How to build a SQL Server Analysis Service Tabular Model from SAP Concur data using CData drivers.
-
How to Build an ETL App for Kafka Data in Python with CData Connect AI
Build ETL pipelines that read and write live Kafka data in Python with petl and the CData Connect AI Python SDK.
-
Create Apps from SuiteCRM Data in Qlik Sense Cloud
Use CData Connect AI to connect to SuiteCRM Data and build apps from live SuiteCRM data in Qlik Sense Cloud.
-
Operational Reporting on Tanda Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Tanda data.
-
How to Connect to Live SAP Concur Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SAP Concur data without replication.
-
Access GetResponse Data from MySQL in Amazon QuickSight
Connect to GetResponse and build visualizations of GetResponse data using a MySQL Connection in Amazon QuickSight.
-
Replicate Multiple ChartMogul Accounts
Replicate multiple ChartMogul accounts to one or many databases.
-
Establish a Live Connection with Cosmos DB Data using Tableau Bridge
The CData ODBC Driver for Cosmos DB enables you to integrate live Cosmos DB data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Phoenix-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Phoenix data.
-
Automate Clockify Data Replication to Couchbase
Use CData Sync to Customize and automate Clockify data replication to Couchbase.
-
Getting Started with the CData Python Connector for Pipeliner CRM
Learn to install and license the CData Python Connector and configure a connection to live Pipeliner CRM data.
-
Build Semantic Layer Views for Mailjet Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Mailjet data.
-
Automate OnePageCrm Data Replication to Azure Synapse
Use CData Sync to customize and automate OnePageCrm data replication to Azure Synapse.
-
How to Connect to Google Translate Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Translate data. Leverage the pyodbc module for ODBC in Python.
-
Visualize Live AfterShip Data in the Power BI Service
Use CData Connect AI to connect to live AfterShip data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to work with HubSpot Data in Apache Spark using SQL
Access and process HubSpot Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to Live HBase Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your HBase data for you.
-
Connect ShipEngine Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ShipEngine data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Oracle HCM Cloud Data in Jaspersoft Studio
Execute SQL to remote Oracle HCM Cloud data in Jaspersoft Studio.
-
Create Adobe Commerce-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Adobe Commerce Data from OutSystems and build custom enterprise apps using live Adobe Commerce data.
-
Integrate Dify with Live Marketo 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 Marketo data.
-
Analyze Zoho Books Data in Cognos Analytics
Use CData Connect AI to connect to Zoho Books Data from Cognos Analytics and analyze live Zoho Books data.
-
Import RSS Feeds into the Power BI Service for Visualizations
Use CData Connect AI to connect to RSS Feeds and provide access to live RSS feeds for custom reports in the Power BI Service.
-
Create Informatica Mappings From/To an ODBC Data Source for NetSuite
Create an ODBC connection to NetSuite in Informatica and browse and transfer NetSuite data.
-
How to connect SharePoint with Zendesk Data through external lists
Provide Zendesk data to SharePoint users as an external list.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for AdRoll
Provide connectivity to AdRoll data through an SAP BusinessObjects universe.
-
How to integrate MarkLogic with Apache Airflow
Access and process MarkLogic data in Apache Airflow using the CData JDBC Driver.
-
Building Dynamic Web Pages with Zoho Books Data Using AngularJS
Create single-page applications with live connectivity to Zoho Books using the CData API Server.
-
Create a Data Access Object for Printify Data using JDBI
A brief overview of creating a SQL Object API for Printify data in JDBI.
-
Connect to Discord Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Discord Data and connect to Discord data in Akorbi Digital RunMyProcess.
-
Build an OLAP Cube in SSAS from ShipStation Data
Establish a connection to ShipStation data data from SQL Server Analysis Services, and use the ShipStation Data Provider to build OLAP cubes for use in analytics and reporting.
-
Getting Started with the CData Tableau Connector for Mouseflow
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate with Live Marketo Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Marketo from the MuleSoft Anypoint Platform to integrate live Marketo data into custom reports and dashboards.
-
Integrate Spotify with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Spotify with External Services.
-
Use the CData Software JDBC Driver for Toggl in MicroStrategy Desktop
Connect to Toggl data in MicroStrategy Desktop using the CData Software JDBC Driver for Toggl.
-
LINQ to Klaviyo 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 Klaviyo Data Provider.
-
Visualize Campaigner Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Campaigner data.
-
Getting Started with the CData JDBC Driver for Act CRM
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Act CRM.
-
Connect to Parallel Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Parallel data.
-
Analyze SendGrid Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SendGrid from Power Pivot. You will use the Table Import Wizard to load SendGrid data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Hugging Face Data in DBeaver
Use the CData ODBC Driver to connect to Hugging Face data in DBeaver.
-
Connect to Dynamics 365 Data in JRuby
Create a simple JRuby app with access to live Dynamics 365 data.
-
Access Live ZohoExpense Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ZohoExpense data from your Google Sheets.
-
Automated Continuous Hugging Face Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Hugging Face replication to Azure SQL Database.
-
Visualize ZohoDesk Data in Tableau
The CData ODBC driver for ZohoDesk enables you integrate ZohoDesk data into Tableau dashboards.
-
Easily Integrate WooCommerce Data in Lazarus Pascal IDE
Learn how to easily integrate live WooCommerce data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData Software JDBC Driver for Oracle Sales in MicroStrategy
Connect to Oracle Sales data in MicroStrategy Developer using the CData Software JDBC Driver for Oracle Sales.
-
How to Easily Query LeadDesk Data in OpenOffice Base
Connect to LeadDesk data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use the CData Software ODBC Driver for HBase in MicroStrategy Web
Connect to HBase data in MicroStrategy Web using the CData Software ODBC Driver for HBase.
-
Automate FormSite Data Replication to SAP HANA
Use CData Sync to customize and automate FormSite data replication to SAP HANA.
-
Access Live Google Cloud Storage Data in Coginiti Pro
Connect to and query live Google Cloud Storage data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Live Adobe Commerce Data in the Power BI Service
Use CData Connect AI to connect to live Adobe Commerce data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Choosing the Best Method to Connect Aha! to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Aha! data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate with live Google Calendar Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google Calendar data in Jitterbit.
-
Automated Continuous Simplesat Replication to SingleStore
Use CData Sync for automated, continuous, customizable Simplesat replication to SingleStore.
-
Build Exa-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Exa data and build Exa-connected web apps with Axios.
-
Connect to Bitly Data from HeidiSQL
Use CData Connect AI to connect to and query live Bitly data from HeidiSQL.
-
Integrating Antigravity CLI with Adobe Commerce data via CData CLI
Connect Adobe Commerce data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous JobNimbus Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable JobNimbus replication to Google BigQuery.
-
Connect to Hive Data in RapidMiner
Integrate Hive data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous HCL Domino Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable HCL Domino replication to Amazon Redshift.
-
Bridge Exact Online Connectivity with Apache NiFi
Access and process Exact Online data in Apache NiFi using the CData JDBC Driver.
-
Access Live WooCommerce 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 WooCommerce data through MCP integration.
-
Connect to HCL Domino from Asprova with CData Software ODBC Driver for HCL Domino
This article shows how to connect faster to HCL Domino data from Asprova.
-
Connect to DocuSign Data in Claris FileMaker Pro
Use the CData ODBC Driver for DocuSign in FileMaker Pro to connect to DocuSign and work with DocuSign data in your FileMaker applications.
-
A PostgreSQL Interface for Clockify Data (MySQL Remoting via JDBC)
Use the Remoting features of the Clockify JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Zoho Creator Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Zoho Creator data from Node.js.
-
Build a Simple VCL Application for WooCommerce Data
How to build a simple VCL Application to view WooCommerce data in RAD Studio using the CData ODBC Driver for WooCommerce.
-
Use the CData ODBC Driver for SageHR in Microsoft Power Query
You can use the CData SageHR ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SageHR data into Microsoft Power Query.
-
How to Connect to Live Adobe Commerce Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Adobe Commerce data for you.
-
How to Seamlessly Import Intercom Data into IBM SPSS Modeler
Integrate Intercom data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Extract, Transform, and Load Quaderno Data in Informatica PowerCenter
Create a simple Workflow for Quaderno data in Informatica PowerCenter.
-
Teamgate Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Teamgate facts in real time.
-
Search External ZohoMarketingHub Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of ZohoMarketingHub data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ZohoMarketingHub Data objects that you can access from apps and the dashboard.
-
Connect to and Visualize Live Okta Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Okta data.
-
Automated Continuous SendInBlue Replication to SQL Server
Use CData Sync for automated, continuous, customizable SendInBlue replication to SQL Server.
-
Integrating Avro Data in Talend Cloud Data Management Platform
Connect Avro Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Avro.
-
Create Informatica Mappings From/To a JDBC Data Source for QuickBooks Online
Create QuickBooks Online data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Interact with Live Azure Data Lake Storage Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Azure Data Lake Storage data.
-
Validate Email Data with QuerySurge
Access and validate Email data in QuerySurge using the CData JDBC Driver.
-
Analyze Salesforce Pardot Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Salesforce Pardot data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Work with ZohoDesk Data in AWS Glue Jobs Using JDBC
Connect to ZohoDesk from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect to Live Exact Online Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Exact Online data for you.
-
Access Live FreeAgent Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate FreeAgent data into the statistical analysis tools available in SAS JMP. This article shows how to use FreeAgent data in the Graph Builder and Query Builder.
-
Visualize Live Chargebee Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Chargebee data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Klipfolio-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Klipfolio Data and create custom apps in Bubble.
-
Access Live SAP HANA XS Advanced 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 SAP HANA XS Advanced data through MCP integration.
-
Build Apps with Live Hive data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Hive data into the Adalo platform and build custom mobile and web applications with real-time Hive data.
-
Getting Started with the CData SSIS Components for ZarMoney
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ZarMoney.
-
Access SpaceX Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SpaceX data from HeidiSQL.
-
Integrating Codex with WordPress 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 IBM Informix Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live IBM Informix data from Informatica Cloud.
-
Connect to IBM Informix Data in RazorSQL
Connect to IBM Informix from wizards and query IBM Informix data from the GUI in the RazorSQL database management tool.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Paylocity
Provide connectivity to Paylocity data through an SAP BusinessObjects universe.
-
Helpscout Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Helpscout facts in real time.
-
Natively Connect to Mode Data in PHP
The CData ODBC driver for Mode enables you to create PHP applications with connectivity to Mode data. Leverage the native support for ODBC in PHP.