CData Software - Knowledge Base
Recent Articles
-
Explore Geographical Relationships in Zoom Data with Power Map
Create data visualizations with Zoom data in Power Map.
-
Natively Connect to Rebilly Data in PHP
The CData ODBC driver for Rebilly enables you to create PHP applications with connectivity to Rebilly data. Leverage the native support for ODBC in PHP.
-
Manage Brex Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Brex.
-
Getting Started with the CData Connect AI Python SDK for AfterShip
Install the CData Connect AI Python SDK to read live AfterShip data with standard DB-API 2.0 Python code.
-
Migrating data from Lakebase to Snowflake using CData SSIS Components.
Easily push Lakebase data to Snowflake using the CData SSIS Tasks for Lakebase and Snowflake.
-
Connecting GenSpark with Google Directory Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Google Directory data without any replication or custom integration required.
-
Connect to Zoho Projects Data in Jaspersoft Studio
Execute SQL to remote Zoho Projects data in Jaspersoft Studio.
-
Automated Continuous Smartsheet Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Smartsheet replication to delimited files (CSV/TSV).
-
QuickBooks Time Reporting in OBIEE with the QuickBooks Time JDBC Driver
Deploy the QuickBooks Time JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate Live Presto Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Presto data from within the IDE.
-
Use ChatGPT to Talk to Your SAP HANA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SAP HANA data for you.
-
Prepare, Blend, and Analyze Contentful Data in Alteryx Designer (ODBC)
Build workflows to access live Contentful data for self-service data analytics.
-
Connecting GenSpark with HubDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to HubDB data without any replication or custom integration required.
-
Create Snowflake-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Snowflake Data from OutSystems and build custom enterprise apps using live Snowflake data.
-
Integrate Avro with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Avro with External Services.
-
Query Stripe Data in DataGrip
Create a Data Source for Stripe in DataGrip and use SQL to query live Stripe data.
-
Prepare, Blend, and Analyze Freshteam Data in Alteryx Designer (ODBC)
Build workflows to access live Freshteam data for self-service data analytics.
-
Connect to Suadeo Data in RapidMiner
Integrate Suadeo data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software ODBC Driver for Jira in MicroStrategy
Connect to Jira data in MicroStrategy Developer using the CData Software ODBC Driver for Jira.
-
How to use SQLAlchemy ORM to access Printful Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Printful data.
-
Connect Typeform Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Typeform data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to integrate Apify with Apache Airflow
Access and process Apify data in Apache Airflow using the CData JDBC Driver.
-
How to create Facebook federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Facebook data in MySQL .
-
Query Zendesk Data in DataGrip
Create a Data Source for Zendesk in DataGrip and use SQL to query live Zendesk data.
-
Visualize Adobe Target 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 Adobe Target data into TIBCO Spotfire.
-
Integrating Claude Code CLI with MySQL 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.
-
Create Informatica Mappings From/To a JDBC Data Source for ZohoPeople
Create ZohoPeople data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Connect Flowise AI Agents to Live Samanage 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 Samanage data without replication.
-
Connect to SpaceX Data from a Connection Pool in JBoss
Integrate SpaceX data into Java servlets: Use the Management Console in JBoss to install the SpaceX JDBC Driver.
-
Back Up SAP ByDesign data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP ByDesign. In this article, we will employ an SSIS workflow to populate a database with SAP ByDesign data data.
-
Query VWO Data as a MySQL Database in Node.js
Execute MySQL queries against VWO data from Node.js.
-
Integrating Cursor with Asana 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.
-
Configure the CData JDBC Driver for HDFS in a Connection Pool in Tomcat
Connect to HDFS data from a connection pool in Tomcat.
-
Build HBase-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to HBase Data from Zoho Analytics and import live HBase data.
-
Query HCL Domino Data through ODBC in Node.js
Use node-odbc to execute SQL queries against HCL Domino data from Node.js.
-
How to Work with Sage 200 Data in AWS Glue Jobs Using JDBC
Connect to Sage 200 from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating Kiro with Clockify 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 Chargebee Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Chargebee data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect to Live ActiveCampaign Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live ActiveCampaign data securely in real time.
-
Create SAP Business One-Connected Applications in Appsmith
Connect to SAP Business One Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Business One data.
-
Build Semantic Layer Views for Procore Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Procore data.
-
Connect to Live Sage Cloud Accounting Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Sage Cloud Accounting in CData Connect AI and connect to your Sage Cloud Accounting data from PostgreSQL.
-
Establish a Live Connection with SAS xpt Data using Tableau Bridge
The CData ODBC Driver for SAS xpt enables you to integrate live SAS xpt data into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Live Raisers Edge NXT Data in the Power BI Service
Use CData Connect AI to connect to live Raisers Edge NXT data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Query Live Databricks Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Databricks data data in natural language using Python.
-
How to Access MySQL Data Using Entity Framework
This article shows how to access MySQL data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect the Power BI Service to Oracle Eloqua: Complete Guide
Connect to the CData Software Power BI Connector for Oracle Eloqua from PowerBI.com to provide real-time Oracle Eloqua data across the organization.
-
Work with Live Bright Data Data in Power Query
Use CData Connect AI to connect to Bright Data data and work with live Bright Data data in Microsoft Power Query.
-
DataBind Facebook Ads Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Facebook Ads with the DevExpress Windows Forms and Web controls to provide Facebook Ads data to a chart.
-
How to Seamlessly Import Accelo Data into IBM SPSS Modeler
Integrate Accelo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build MVC Applications with Connectivity to Gorgias Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Gorgias from an ASP.NET MVC application.
-
Create Reports with Clockify Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Clockify data.
-
Connect to WooCommerce Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for WooCommerce data in the Denodo Virtual DataPort Administrator.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ConvertAPI
Provide connectivity to ConvertAPI data through an SAP BusinessObjects universe.
-
Connect to Okta Data in Aqua Data Studio
Access Okta data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Access Live Dynamics 365 Business Central Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Dynamics 365 Business Central enables you to integrate Dynamics 365 Business Central data into workflows built using Microsoft Power Automate Desktop.
-
Add Asana Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Asana with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Biml to Build SSIS Tasks to Replicate Oracle Financials Cloud Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle Financials Cloud data to SQL Server.
-
Connect to ZohoMarketingHub Data from PowerBuilder via JDBC
This article demonstrates how to access ZohoMarketingHub data from PowerBuilder using the ZohoMarketingHub JDBC Driver.
-
Create SSAS Tabular Models from Recurly Data
How to build a SQL Server Analysis Service Tabular Model from Recurly data using CData drivers.
-
How to use SQLAlchemy ORM to access Datadog Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Datadog data.
-
Connect to ActiveCampaign Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live ActiveCampaign data.
-
Automated Continuous Productboard Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Productboard replication to delimited files (CSV/TSV).
-
Integrate Devin with Live Yelp Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Yelp data.
-
Migrating data from Highrise to Google BigQuery using CData SSIS Components.
Easily push Highrise data to Google BigQuery using the CData SSIS Tasks for Highrise and Google BigQuery.
-
Visualize Nethunt Data in TIBCO Spotfire through ADO.NET
Integrate Nethunt data into dashboards in TIBCO Spotfire.
-
Integrating LangGraph with TaxJar Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on TaxJar data within automated workflows.
-
Publish Webflow-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Webflow data.
-
Build Semantic Layer Views for Neo4J Data in APOS Live Data Gateway
Use the CData Connector for Neo4J in APOS Live Data Gateway to build Semantic Layer Views for Neo4J data.
-
How to Work with JSON Services in AWS Glue Jobs Using JDBC
Connect to JSON from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate CSV with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate CSV with External Services.
-
Build Dashboards with ActiveCampaign Data in Dundas BI
Create dynamic dashboards and perform analytics based on ActiveCampaign data in Dundas BI.
-
Stream SAP Ariba Source Data into Apache Kafka Topics
Access and stream SAP Ariba Source data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for CloudConvert
Provide connectivity to CloudConvert data through an SAP BusinessObjects universe.
-
SQL Analysis Services Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SQL Analysis Services facts in real time.
-
How to Query Beeminder Data in MySQL Workbench
Execute MySQL queries against live Beeminder data from MySQL Workbench.
-
How to Create Power BI Visual Reports with Real-Time MailerSend Data
Use CData Power BI Connectors to visualize MailerSend data in Power BI.
-
Build a Singer.io Tap for SQL Server With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SQL Server data using the CData Python Connector.
-
Build EnterpriseDB-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to EnterpriseDB data and build web apps with connectivity to live EnterpriseDB data.
-
Use the CData Software JDBC Driver for SAP HANA XS Advanced in MicroStrategy Desktop
Connect to SAP HANA XS Advanced data in MicroStrategy Desktop using the CData Software JDBC Driver for SAP HANA XS Advanced.
-
Planio Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Planio facts in real time.
-
Build a PostgreSQL Interface for Freshsales Data using the CData JDBC Driver
Use the Remoting features of the Freshsales JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Simplesat Data in JReport Designer
Create charts and reports based on Simplesat data in JReport Designer.
-
Build Semantic Layer Views for SAP Business One Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP Business One data.
-
How to create an RPA flow for ConvertKit Data in UiPath Studio
Use the ConvertKit ODBC Driver to create workflows that access real-time ConvertKit data without any coding.
-
Connect to Gorgias Data in NetBeans
Connect to Gorgias data in NetBeans with the data source configuration wizard.
-
Build Databricks-Connected Apps in Choreo
Use CData Connect AI to connect to Databricks Data from Choreo and build custom apps using live Databricks data.
-
How to Build an ETL App for BambooHR Data in Python with CData Connect AI
Extract and transform live BambooHR data in Python with petl and the CData Connect AI Python SDK.
-
Connect to Adobe Commerce Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Adobe Commerce Data and connect to Adobe Commerce data in Akorbi Digital RunMyProcess.
-
Getting Started with the CData ODBC Driver for Hacker News
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Hacker News.
-
Visualize Live Smartsheet Data in the Power BI Service
Use CData Connect AI to connect to live Smartsheet data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous BigCommerce Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable BigCommerce replication to Apache Cassandra.
-
Analyze Vault CRM Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Vault CRM data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Datasets from Keap in Domo Workbench and Build Visualizations of Keap Data in Domo
Use the CData Software ODBC Driver for Keap to create datasets from Keap data in Domo Workbench and then build visualizations in the Domo service.
-
How to Query Outlook Data in MySQL Workbench
Execute MySQL queries against live Outlook data from MySQL Workbench.
-
Getting Started with the CData JDBC Driver for Cassandra
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Cassandra.
-
Using the CData Software ODBC Driver for Pushbullet in PyCharm
Connect to Pushbullet as an ODBC data source in PyCharm using the CData Software ODBC Driver for Pushbullet.
-
Visualize Live MongoDB Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live MongoDB data.
-
Access Live Airtable Data in AWS Lambda
Connect to live Airtable data in AWS Lambda using the CData JDBC Driver.
-
Build Charts with Clio Data in Clear Analytics
Create dynamic charts and perform analytics based on Clio data in Clear Analytics.