CData Software - Knowledge Base
Recent Articles
-
Use Agno to Talk to Your Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Atlassian Jira for you.
-
How to connect to Adobe Commerce Data from Spring Boot
Connect to Adobe Commerce in a Spring Boot Application using the CData JDBC Driver for Adobe Commerce
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live IBM Cloudant within intelligent workflows.
-
Analyze SAS Data Sets Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAS Data Sets in Microsoft R Open.
-
Connect to Freshservice Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Freshservice.
-
Connect Neo4J Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Neo4J using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Theia IDE with Live Google Calendar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to Amazon Athena Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Amazon Athena Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Connect to Live FTP 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 FTP Servers for you.
-
Connect to Perplexity in SpagoBI
Create reports featuring live Perplexity in SpagoBI Studio. Host Perplexity reports on SpagoBI Server.
-
Integrating ZarMoney Data in Talend Cloud Data Management Platform
Connect ZarMoney Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access Live Sybase IQ Data in Coginiti Pro
Connect to and query live Sybase IQ from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize ActiveCampaign Data in TIBCO Spotfire through ADO.NET
Integrate ActiveCampaign into dashboards in TIBCO Spotfire.
-
Automated Continuous NetSuite Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable NetSuite CRM & ERP replication to OneLake in Microsoft Fabric.
-
How to connect and process Pingdom from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Pingdom.
-
Access Live Raisers Edge NXT Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Raisers Edge NXT from your Excel spreadsheets.
-
Create a Data Access Object for SAP ByDesign Data using JDBI
A brief overview of creating a SQL Object API for SAP Business ByDesign in JDBI.
-
Automated Continuous Salesloft Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Salesloft replication to Apache Cassandra.
-
Build an OLAP Cube in SSAS from SAP Business Warehouse Data
Establish a connection to SAP Business Warehouse data from SQL Server Analysis Services, and use the SAP Business Warehouse Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Reports from Splunk Data in Looker Studio
Use CData Connect AI to gain access to live Splunk and create custom reports in Looker Studio.
-
Process & Analyze Bullhorn CRM Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Bullhorn CRM Data.
-
How to connect to CockroachDB Data from IntelliJ
Integrate connectivity to CockroachDB with wizards in IntelliJ.
-
Integrating GitHub Copilot CLI with Tavily 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.
-
Build SAP Ariba Procurement-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP Ariba Procurement Data and create custom apps in Bubble.
-
Connect to Amazon S3 Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Amazon S3 in Airbyte.
-
Getting Started with the CData Connect AI Python SDK for eBay
Install the CData Connect AI Python SDK to read and write live eBay with standard DB-API 2.0 Python code.
-
Access CSV 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 CSV/TSV Files.
-
Use Grok to Talk to Your SAP Ariba Procurement 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 SAP Ariba Procurement for you.
-
Connect Amazon Marketplace Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Amazon Marketplace using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Replicate OData Services from PowerShell
Write a quick PowerShell script to query OData. Use connectivity to the live data to replicate OData to SQL Server.
-
View Reports on Real-Time Factorial Data in Power BI Report Server
Use the CData ODBC Driver for Factorial to visualize Factorial in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Kiro CLI with Snowflake 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.
-
Automated Continuous Facebook Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Facebook replication to IBM DB2.
-
Integrate Miro with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Miro with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Miro.
-
Connect to WooCommerce Data from PowerBuilder via JDBC
This article demonstrates how to access WooCommerce from PowerBuilder using the WooCommerce JDBC Driver.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAS XPORT within intelligent workflows.
-
Automated Continuous Ontraport Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Ontraport replication to OneLake in Microsoft Fabric.
-
How to Query Live Email Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Email data in natural language using Python.
-
Access Live Gmail Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Gmail in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Azure Data Lake Storage Reporting in OBIEE with the Azure Data Lake Storage JDBC Driver
Deploy the Azure Data Lake Storage JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Establish a Live Connection with Wistia Data using Tableau Bridge
The CData ODBC Driver for Wistia enables you to integrate live Wistia into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Oracle-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Oracle Data and create custom apps in Bubble.
-
Use the CData ODBC Driver for ShipEngine in Microsoft Power Query
You can use the CData ShipEngine ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ShipEngine into Microsoft Power Query.
-
Work with SingleStore Data in FoxPro
Load SingleStore into a FoxPro database. This article includes full code and a walk-through of the process.
-
Migrating data from Billsby to Databricks using CData SSIS Components.
Easily push Billsby to Databricks using the CData SSIS Tasks for Billsby and Databricks.
-
Automated Continuous Google Tasks Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Tasks replication to IBM DB2.
-
Build a Singer.io Tap for Stripe With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Stripe data using
-
Visualize Live Avaza Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Avaza.
-
Connect to Live Workday Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Workday in CData Connect AI and connect to your Workday from PostgreSQL.
-
Visualize Splunk Data in Tableau
The CData ODBC driver for Splunk enables you integrate Splunk into Tableau dashboards.
-
Configure the CData JDBC Driver for ZendeskSell in a Connection Pool in Tomcat
Connect to ZendeskSell from a connection pool in Tomcat.
-
Use the CData Software ODBC Driver for SAP Ariba Source in MicroStrategy Web
Connect to SAP Ariba Source in MicroStrategy Web using the CData Software ODBC Driver for SAP Ariba Source.
-
Automated Continuous Pipedrive Replication to SingleStore
Use CData Sync for automated, continuous, customizable Pipedrive replication to SingleStore.
-
Query Live Pipedrive Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Pipedrive directly from the development environment.
-
Getting Started with the CData SSIS Components for Oracle HCM Cloud
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Oracle HCM Cloud.
-
Viewing Delighted Data in RAD Studio Data Explorer
How to view Delighted in RAD Studio Data Explorer using the CData ODBC Driver for Delighted.
-
Design BIRT Reports on Brex Data
Provide current Brex to your embedded analytics.
-
Build AI/ML Models with Live PayPal Data using Dataiku
Connect PayPal Data with Dataiku using the CData JDBC Driver for PayPal.
-
Use the CData ODBC Driver for Oracle Sales from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Oracle Sales to connect to Oracle Sales from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Oracle Sales in Excel.
-
Migrating data from SingleStore to Snowflake using CData SSIS Components.
Easily push SingleStore to Snowflake using the CData SSIS Tasks for SingleStore and Snowflake.
-
Connect and Query Live OneNote Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Microsoft OneNote into Databricks
-
How to integrate WooCommerce with Apache Airflow
Access and process WooCommerce in Apache Airflow using the CData JDBC Driver.
-
Query ZarMoney Data as a MySQL Database in Node.js
Execute MySQL queries against ZarMoney from Node.js.
-
Connect to SurveyMonkey from Asprova with CData Software ODBC Driver for SurveyMonkey
This article shows how to connect faster to SurveyMonkey data from Asprova.
-
Connect to Helpscout in SpagoBI
Create reports featuring live Helpscout in SpagoBI Studio. Host Helpscout reports on SpagoBI Server.
-
Connect to Hive Data from a Connection Pool in Jetty
The Hive JDBC Driver supports connection pooling: This article shows how to connect faster to Apache Hive from Web apps in Jetty.
-
Create Datasets from MailChimp in Domo Workbench and Build Visualizations of MailChimp Data in Domo
Use the CData Software ODBC Driver for MailChimp to create datasets from MailChimp in Domo Workbench and then build visualizations in the Domo service.
-
Nethunt Reporting in OBIEE with the Nethunt JDBC Driver
Deploy the Nethunt JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Kiro CLI with Act CRM 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 with live Excel Online Data in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft Excel Online in Jitterbit.
-
Build Visualizations of PostgreSQL Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PostgreSQL in Birst.
-
Access Live Vault CRM Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Veeva Vault & Vault CRM through MCP integration.
-
Access Oracle Eloqua Reporting Data from MySQL in Amazon QuickSight
Connect to Oracle Eloqua Reporting and build visualizations of Oracle Eloqua Reporting using a MySQL Connection in Amazon QuickSight.
-
Enable the Moosend JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Moosend.
-
Automate ShipStation Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ShipStation from PowerShell? This article demonstrates how to utilize the ShipStation Cmdlets for tasks like connecting to ShipStation, automating operations, downloading data, and more.
-
Connect to Customer.io Data in Jaspersoft Studio
Execute SQL to remote Customer.io in Jaspersoft Studio.
-
A PostgreSQL Interface for Tickspot Data (MySQL Remoting via JDBC)
Use the Remoting features of the Tickspot JDBC Driver to create a PostgreSQL entry-point for data access.
-
Moving Data from Jodoo to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Jodoo data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to SAS Data Sets Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAS Data Sets in Google Apps Script.
-
How to Query Live SendGrid Data in Perplexity MacOS Desktop
Connect to and query live SendGrid Data in Perplexity Desktop using CData MCP Server.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SAP Hybris C4C to Power BI dashboards. Simply drag and drop SAP Hybris C4C into data visuals on the Power BI canvas.
-
Automate SAP SuccessFactors Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP SuccessFactors and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to Mode Data in HULFT Integrate
Connect to Mode as a JDBC data source in HULFT Integrate
-
How to connect to Copper Data from IntelliJ
Integrate connectivity to Copper with wizards in IntelliJ.
-
Add Mistral AI Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Mistral AI with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live SAS xpt Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAS XPORT from your Google Sheets.
-
Accessing Website Data Using ADO.NET
An article from iProgrammer explores accessing Web data through the CData Data Providers: Interacting with websites via the wide range of APIs that are on offer is attractive because it provides new possibilities but is slightly depressing because you have to find out how to do the job all over again for each API. Now there is a better way...
-
Connect to JSON in SpagoBI
Create reports featuring live JSON in SpagoBI Studio. Host JSON reports on SpagoBI Server.
-
Connect to Azure Data Catalog Data in RazorSQL
Connect to Azure Data Catalog from wizards and query Azure Data Catalog from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData Tableau Connector for Box
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Box.
-
Automated Continuous GetResponse Replication to MongoDB
Use CData Sync for automated, continuous, customizable GetResponse replication to MongoDB.
-
How to create Contentful federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Contentful in MySQL .
-
Analyze Email Data in Cognos Analytics
Use CData Connect AI to connect to Email Data from Cognos Analytics and analyze live Email.
-
Connect to WooCommerce Data from a Connection Pool in Jetty
The WooCommerce JDBC Driver supports connection pooling: This article shows how to connect faster to WooCommerce from Web apps in Jetty.
-
Access Microsoft Exchange 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 Microsoft Exchange.
-
Access Live Oracle Sales Data in TIBCO Data Virtualization
Use the Oracle Sales Tibco DV Adapter to create a Oracle Sales data source in TIBCO Data Virtualization Studio and gain access to live Oracle Sales from your TDV Server.
-
Automated Continuous QuickBooks Time Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Google Cloud SQL.
-
Automated Continuous Mouseflow Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Mouseflow replication to Azure SQL Database.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Stripe using the Model Context Protocol.
-
Query, Visualize, and Share live Zendesk Data in Redash
Use CData Connect AI to connect to live Zendesk in Redash for querying, visualizing, and sharing.