CData Software - Knowledge Base
Recent Articles
-
Connect to Cloudflare Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Cloudflare to connect to Cloudflare and execute queries in PowerBuilder.
-
Amazon S3 Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Amazon S3 through CData Connect AI using different applications and tools.
-
Establish a Live Connection with Customer.io Data using Tableau Bridge
The CData ODBC Driver for Customer.io enables you to integrate live Customer.io into Tableau Cloud dashboards using the Tableau Bridge.
-
Natively Connect to Quaderno Data in PHP
The CData ODBC driver for Quaderno enables you to create PHP applications with connectivity to Quaderno. Leverage the native support for ODBC in PHP.
-
Connecting Pipedream with CSV Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on CSV data in real time.
-
Using the CData Software ODBC Driver for FHIR in PyCharm
Connect to FHIR as an ODBC data source in PyCharm using the CData Software ODBC Driver for FHIR.
-
Model, Search, and Visualize Live Hive Data in ThoughtSpot
Use CData Connect AI to connect to live Apache Hive for modeling, searching, and visualizing.
-
Connect Placid to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Placid using the CData Python MCP Server.
-
Create Google Spanner-Connected Dashboards in Grafana
Connect to Google Spanner Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Spanner.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Google Search using the Model Context Protocol.
-
Connect to HCL Domino Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for HCL Domino.
-
Use JayDeBeApi to access Stripe Data in Python
Use standard Python scripting and the development environment of your choice to access live Stripe.
-
Integrating Antigravity CLI with BigCommerce via CData CLI
Connect BigCommerce to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to ShipStation Data in JRuby
Create a simple JRuby app with access to live ShipStation.
-
A PostgreSQL Interface for Power BI XMLA Data using the CData ODBC Driver
Use the SQL Gateway and Power BI XMLA ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Agents in Relevance AI with Access to Live Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Facebook Ads within intelligent agent workflows.
-
Migrating data from SAP HANA to Snowflake using CData SSIS Components.
Easily push SAP HANA to Snowflake using the CData SSIS Tasks for SAP HANA and Snowflake.
-
Visualize Freshservice Data in Sisense
Create an ElastiCube in Sisense app with access to Freshservice.
-
How to import Jumpseller Data into Apache Solr
Use the CData Software JDBC Driver for Jumpseller in Data Import Handler and create an automated import of Jumpseller to Apache Solr Enterprise Search platform.
-
How to Design Gmail Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Gmail from mobile and tablet Power Apps.
-
Design BIRT Reports on MYOB AccountRight Data
Provide current MYOB AccountRight to your embedded analytics.
-
Replicate Multiple Shortcut Accounts via the CData Sync CLI
Replicate multiple Shortcut accounts to one or many databases.
-
Create Datasets from Contentful in Domo Workbench and Build Visualizations of Contentful Data in Domo
Use the CData Software ODBC Driver for Contentful to create datasets from Contentful in Domo Workbench and then build visualizations in the Domo service.
-
Connecting Moonlit Workflow with Square 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 Square in real time.
-
Connect to SAP Concur Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP Concur in Airbyte.
-
Integrate with SAP SuccessFactors LMS Data in JReport Designer
Create charts and reports based on SAP SuccessFactors LMS in JReport Designer.
-
Seamlessly Bring SAP Ariba Procurement Data into Retool Using CData Connect AI
Integrate SAP Ariba Procurement data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate Adobe Analytics with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Adobe Analytics with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Adobe Analytics.
-
Connect to Printify Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Printify as an External Source in Dremio.
-
Rootly Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Rootly facts in real time.
-
Automated Continuous Salesforce Pardot Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Amazon S3.
-
Build Apps with Live Snapchat Ads in Adalo using CData Connect AI
Use CData Connect AI to integrate live Snapchat Ads into the Adalo platform and build custom mobile and web applications with real-time Snapchat Ads.
-
Build Automated Dynamics 365-Connected Workflows in Zapier
Use CData Connect AI to connect to live Microsoft Dynamics 365 and build automated workflows in Zapier.
-
How to use SQLAlchemy ORM to access Sage 200 Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sage 200.
-
Automated Continuous NetSuite SuiteAnalytics Replication to SQLite
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to SQLite.
-
Connect to SAP HANA XS Advanced Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP HANA XS Advanced in FileMaker Pro to connect to SAP HANA XS Advanced and work with SAP HANA XS Advanced in your FileMaker applications.
-
Build Visualizations of CloudConvert Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of CloudConvert in Birst.
-
Integrate LibreChat with Live Certinia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Certinia from within the chat interface.
-
Use the CData Software JDBC Driver for Accelo in MicroStrategy Desktop
Connect to Accelo in MicroStrategy Desktop using the CData Software JDBC Driver for Accelo.
-
Integrating Codex CLI with Oracle Sales 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.
-
Access Live SAS Data Sets Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAS Data Sets from your Excel spreadsheets.
-
Integrating Kiro CLI with ElevenLabs 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.
-
How to create LDAP federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for LDAP in MySQL .
-
DataBind Azure DevOps Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Azure DevOps with the DevExpress Windows Forms and Web controls to provide Azure DevOps to a chart.
-
Use the CData Software ODBC Driver for ADP in MicroStrategy Web
Connect to ADP in MicroStrategy Web using the CData Software ODBC Driver for ADP.
-
Connect to Qualaroo Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Act-On from a Connection Pool in WebLogic
Use the CData JDBC Driver for Act-On to connect to Act-On from Web applications running on WebLogic.
-
Edit and Search External Sybase IQ Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Sybase IQ to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Sybase IQ Data objects that you can access from apps and the dashboard.
-
Use JayDeBeApi to access Avaza Data in Python
Use standard Python scripting and the development environment of your choice to access live Avaza.
-
Prepare, Blend, and Analyze JotForm Data in Alteryx Designer (ODBC)
Build workflows to access live JotForm for self-service data analytics.
-
Access Live Spark Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Apache Spark SQL into the statistical analysis tools available in SAS JMP. This article shows how to use Apache Spark SQL in the Graph Builder and Query Builder.
-
Replicate OneNote Data to Multiple Databases
Replicate Microsoft OneNote to disparate databases with a point-and-click configuration.
-
Automated Continuous API Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable API replication to Apache Kafka.
-
Work with ServiceDesk Plus Data in FoxPro
Load ServiceDesk Plus into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Cursor CLI with HubSpot 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.
-
Import Real-Time Landbot Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Landbot in ColdFusion.
-
Create SSAS Tabular Models from AdRoll Data
How to build a SQL Server Analysis Service Tabular Model from AdRoll using CData drivers.
-
Getting Started with the CData ODBC Driver for ShipEngine
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ShipEngine.
-
Automated Continuous Exa Replication to SingleStore
Use CData Sync for automated, continuous, customizable Exa replication to SingleStore.
-
How to publish and share Typeform Data dashboards with Tableau Server
The CData ODBC driver for Typeform enables you integrate Typeform into Tableau dashboards.
-
Query SQL Server Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft SQL Server from Node.js.
-
Build Apps with Live ZohoDesk Data Using the Low-Code Development Platform of Mendix
Connect ZohoDesk with Mendix to build apps using the CData API Driver for JDBC.
-
Use the CData Software JDBC Driver for Guru in MicroStrategy Desktop
Connect to Guru in MicroStrategy Desktop using the CData Software JDBC Driver for Guru.
-
Connect to Google Campaign Manager 360 from Asprova with CData Software ODBC Driver for Google Campaign Manager 360
This article shows how to connect faster to Google Campaign Manager 360 data from Asprova.
-
Integrate with PivotalTracker Data in JReport Designer
Create charts and reports based on PivotalTracker in JReport Designer.
-
Use JayDeBeApi to access TigerGraph Data in Python
Use standard Python scripting and the development environment of your choice to access live TigerGraph.
-
Import HCL Domino Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access HCL Domino. In this article, you will use the OData format to import HCL Domino into Microsoft Power Query.
-
Connect to ServiceNow Data from a Connection Pool in JBoss
Integrate ServiceNow into Java servlets: Use the Management Console in JBoss to install the ServiceNow JDBC Driver.
-
Connect and Query Live Google Cloud Storage Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Google Cloud Storage into Databricks
-
Integrate Productboard Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Productboard from Informatica Cloud.
-
Model, Search, and Visualize Live ActiveCampaign Data in ThoughtSpot
Use CData Connect AI to connect to live ActiveCampaign for modeling, searching, and visualizing.
-
Access Live PostgreSQL Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live PostgreSQL data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build a Simple VCL Application for Databricks Data
How to build a simple VCL Application to view Databricks in RAD Studio using the CData ODBC Driver for Databricks.
-
Build a PostgreSQL Interface for iContact Data using the CData JDBC Driver
Use the Remoting features of the iContact JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Bright Data from Asprova with CData Software ODBC Driver for Bright Data
This article shows how to connect faster to Bright Data data from Asprova.
-
Choosing the Best Method to Connect Airtable to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Airtable from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Analyze Microsoft Dataverse Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft Dataverse (CDS) and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrating Cursor CLI with SAP HANA 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.
-
Use Dash to Build Web Apps on GraphQL Data via CData Connect AI
Build interactive Dash web apps on live GraphQL using pandas and the CData Connect AI Python SDK.
-
Create Grafana Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Grafana data access from reports, embedded analytics, and more.
-
Use CData Connect AI to Access Blackbaud FE NXT Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Blackbaud FE NXT in the Power Pivot business intelligence tool.
-
Build Apps with Live Perplexity Data Using the Low-Code Development Platform of Mendix
Connect Perplexity with Mendix to build apps using the CData API Driver for JDBC.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Calendar
Create Google Calendar data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Goose with Live Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Microsoft Exchange from within the local AI agent.
-
A PostgreSQL Interface for Databricks Data using the CData ODBC Driver
Use the SQL Gateway and Databricks ODBC Driver to create a PostgreSQL entry-point for data access.
-
LINQ to Quickbase 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 Quickbase Data Provider.
-
Automated Continuous Google Forms Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Forms replication to SQLite.
-
Use the CData Software JDBC Driver for Bitbucket in MicroStrategy Web
Connect to Bitbucket in MicroStrategy Web using the CData Software JDBC Driver for Bitbucket.
-
Automated Continuous Sybase IQ Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sybase IQ replication to Apache Cassandra.
-
Build Adobe Analytics-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Adobe Analytics.
-
Build a Simple VCL Application for SAS xpt Data
How to build a simple VCL Application to view SAS XPORT in RAD Studio using the CData ODBC Driver for SAS xpt.
-
How to Connect to Live FHIR Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your FHIR for you.
-
How to Connect Flowise AI Agents to Live Zuora 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 Zuora without replication.
-
Feed Trello Data into FineReport
How to set Trello as a JDBC data source in FineReport.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Directory
Create an ODBC connection to Google Directory in Informatica and browse and transfer Google Directory.
-
Working with MySQL Data in LINQPad
Execute LINQ queries to MySQL in LINQPad.
-
Query Azure Analysis Services Data as a SQL Server Database in Node.js
Execute SQL Server queries against Azure Analysis Services from Node.js.
-
Getting Started with the CData Excel Add-In for Rebilly
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Rebilly.
-
Automated Continuous Retently Replication to Databricks
Use CData Sync for automated, continuous, customizable Retently replication to Databricks.
-
Integrate Bright Data with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Bright Data with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Bright Data.