CData Software - Knowledge Base
Recent Articles
-
Integrate Open WebUI with Live SFTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SFTP data from within the chat interface.
-
Use Databricks Agent Bricks to Talk to Your Salesforce Data 360 Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Salesforce Data 360 data for you.
-
Connect to Webex Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Webex data.
-
Analyze Testmonitor Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Testmonitor data and visualize Testmonitor data in SAP Analytics Cloud.
-
Access Azure Synapse Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Azure Synapse data from your Oracle system.
-
Use the CData Software JDBC Driver for Greenhouse in MicroStrategy Web
Connect to Greenhouse data in MicroStrategy Web using the CData Software JDBC Driver for Greenhouse.
-
How to Query ZendeskSell Data in MySQL Workbench
Execute MySQL queries against live ZendeskSell data from MySQL Workbench.
-
Query Float Data in DataGrip
Create a Data Source for Float in DataGrip and use SQL to query live Float data.
-
ETL Active Directory in Oracle Data Integrator
This article shows how to transfer Active Directory data into a data warehouse using Oracle Data Integrator.
-
Integrate PostgreSQL Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to PostgreSQL data and integrate live PostgreSQL data into your Power Automate tasks.
-
Connect to Productboard Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Productboard and work with Productboard data in your FileMaker applications.
-
Connect to Gong Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Gong data in Airbyte.
-
Use the CData Software JDBC Driver for Pipeline CRM in MicroStrategy Desktop
Connect to Pipeline CRM data in MicroStrategy Desktop using the CData Software JDBC Driver for Pipeline CRM.
-
Connect GraphQL Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your GraphQL data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Import and Visualize Exact Online Data in Power View
Create data visualizations based on Exact Online data in Excel.
-
Analyze GitHub Data in Cognos Analytics
Use CData Connect AI to connect to GitHub Data from Cognos Analytics and analyze live GitHub data.
-
Establish a Live Connection with Hacker News Data using Tableau Bridge
The CData ODBC Driver for Hacker News enables you to integrate live Hacker News data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Microsoft OneDrive Data in JRuby
Create a simple JRuby app with access to live Microsoft OneDrive data.
-
How to Seamlessly Import MongoDB Data into IBM SPSS Modeler
Integrate MongoDB data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Query Salesforce Pardot Data in ColdFusion
Write standard ColdFusion data access code to connect to Salesforce Pardot data.
-
Connect to ZohoExpense Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ZohoExpense data.
-
Analyze WordPress Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of WordPress data and visualize WordPress data in SAP Analytics Cloud.
-
Automate HubSpot Data Replication to Couchbase
Use CData Sync to Customize and automate HubSpot data replication to Couchbase.
-
Work with Live Printify Data in Power Query
Use CData Connect AI to connect to Printify data and work with live Printify data in Microsoft Power Query.
-
Create Reports with Pipeline CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pipeline CRM data.
-
Create Reports with Clio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Clio data.
-
Import Real-Time Zoho Books Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zoho Books data in ColdFusion.
-
Automated Continuous Ontraport Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Ontraport replication to PostgreSQL.
-
Access Live Freshsales Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Freshsales data into the statistical analysis tools available in SAS JMP. This article shows how to use Freshsales data in the Graph Builder and Query Builder.
-
Automated Continuous ServiceDesk Plus Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ServiceDesk Plus replication to Azure SQL Database.
-
A PostgreSQL Interface for CSV Data using the CData ODBC Driver
Use the SQL Gateway and CSV ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Brex Data Replication to Azure Data Lake
Use CData Sync to customize and automate Brex data replication to Azure Data Lake.
-
Integrating Excel Online Data in Talend Cloud Data Management Platform
Connect Excel Online Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Excel Online.
-
Connect to Clio from Asprova with CData Software ODBC Driver for Clio
This article shows how to connect faster to Clio data from Asprova.
-
Connect to Trello Data in JRuby
Create a simple JRuby app with access to live Trello data.
-
Integrate Devin with Live xBase 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 xBase data.
-
Analyze Zoho Projects Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Zoho Projects data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Work with Trello Data in ETL Validator JDBC
Connect to Trello from ETL Validator jobs using the CData Software JDBC Driver.
-
Use Claude to Talk to Your Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Microsoft OneDrive data for you.
-
Connect to PostgreSQL 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 PostgreSQL data.
-
Integrate Live Freshteam 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 Freshteam data from within the IDE.
-
Create Asana Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Asana from PowerBI.com to create Power BI Dataflows with real-time data.
-
Object-Relational Mapping (ORM) with Epicor Kinetic Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Epicor Kinetic data into a Java-based ORM framework, Hibernate.
-
Automate Microsoft Teams Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft Teams data replication to Azure Synapse.
-
Bridge Lakebase Connectivity with Apache NiFi
Access and process Lakebase data in Apache NiFi using the CData JDBC Driver.
-
Connect to SparkPost Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SparkPost data in the Denodo Virtual DataPort Administrator.
-
Connect to Microsoft OneDrive Data in HULFT Integrate
Connect to Microsoft OneDrive as a JDBC data source in HULFT Integrate
-
How to Build an ETL App for NetSuite SuiteAnalytics Data in Python with CData Connect AI
Extract and transform live NetSuite SuiteAnalytics data in Python with petl and the CData Connect AI Python SDK.
-
Access Live Samanage Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Samanage data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query VWO Data in DataGrip
Create a Data Source for VWO in DataGrip and use SQL to query live VWO data.
-
Integrating OpenCode with Apify 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 Connect to & Open Hubstaff Data in Microsoft Excel
This article uses the CData ODBC driver for Hubstaff to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Bridge SAP HANA Connectivity with Apache NiFi
Access and process SAP HANA data in Apache NiFi using the CData JDBC Driver.
-
Validate Nuclia Data with QuerySurge
Access and validate Nuclia data in QuerySurge using the CData JDBC Driver.
-
How to connect Amazon QuickSight to Vertica Data
Create a connection to Vertica data in CData Connect AI and insert Vertica data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Facebook Ads Data from Crystal Reports
Use CData Connect AI to connect to and report on live Facebook Ads data from Crystal Reports.
-
Create ZohoExpense-Connected Business Apps in AppSheet
Connect to ZohoExpense Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to ZohoExpense data.
-
Add Supabase Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Supabase with the Informatica Enterprise Data Catalog to classify and organize data.
-
DataBind Charts to Okta Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Okta data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Automated Continuous Facebook Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Amazon S3.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SuiteCRM
Provide connectivity to SuiteCRM data through an SAP BusinessObjects universe.
-
Create Datasets from Sendwithus in Domo Workbench and Build Visualizations of Sendwithus Data in Domo
Use the CData Software ODBC Driver for Sendwithus to create datasets from Sendwithus data in Domo Workbench and then build visualizations in the Domo service.
-
Create a Data Access Object for NetSuite Data using JDBI
A brief overview of creating a SQL Object API for NetSuite data in JDBI.
-
Build ServiceNow-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ServiceNow data.
-
Visualize Live Excel Online Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Excel Online data into custom reports in Power BI.
-
Import Real-Time PagerDuty Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use PagerDuty data in ColdFusion.
-
Use the CData Software JDBC Driver for Stack Exchange in MicroStrategy Web
Connect to Stack Exchange data in MicroStrategy Web using the CData Software JDBC Driver for Stack Exchange.
-
DataBind Charts to Intercom Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Intercom data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Automated Continuous Pipeliner CRM Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to Azure SQL Database.
-
Getting Started with the CData JDBC Driver for Dropbox
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Dropbox.
-
How to integrate eBay Analytics with Apache Airflow
Access and process eBay Analytics data in Apache Airflow using the CData JDBC Driver.
-
Getting Started with the CData ADO.NET Provider for SingleStore
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SingleStore.
-
How to Work with Neo4J Data in ETL Validator JDBC
Connect to Neo4J from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Hacker News Data in RapidMiner
Integrate Hacker News data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software JDBC Driver for Zoho Projects in MicroStrategy Desktop
Connect to Zoho Projects data in MicroStrategy Desktop using the CData Software JDBC Driver for Zoho Projects.
-
Process & Analyze Auth0 Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Auth0 Data.
-
How to Connect the Power BI Service to Stack Exchange: Complete Guide
Connect to the CData Software Power BI Connector for Stack Exchange from PowerBI.com to provide real-time Stack Exchange data across the organization.
-
Access Live Oracle Financials Cloud 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 Oracle Financials Cloud data through MCP integration.
-
How to connect PolyBase to Confluence
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Confluence data.
-
Build Box-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Box Data and create custom apps in Bubble.
-
Query Live Avro 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 Avro data directly from the development environment.
-
Visualize Live Bullhorn CRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Bullhorn CRM data.
-
How to publish and share Salesforce Data dashboards with Tableau Server
The CData ODBC driver for Salesforce enables you integrate Salesforce data into Tableau dashboards.
-
How to Build an ETL App for Facebook Data in Python with CData
Create ETL applications and real-time data pipelines for Facebook data in Python with petl.
-
Automated Continuous ActiveCampaign Replication to SQL Server
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to SQL Server.
-
Analyze Microsoft Ads Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Microsoft Ads from Power Pivot. You will use the Table Import Wizard to load Microsoft Ads data. You can visually build the import query or use any SQL supported by the driver.
-
Access Live BigQuery Data in TIBCO Data Virtualization
Use the BigQuery Tibco DV Adapter to create a BigQuery data data source in TIBCO Data Virtualization Studio and gain access to live BigQuery data from your TDV Server.
-
Automated Continuous Codat Replication to MySQL
Use CData Sync for automated, continuous, customizable Codat replication to MySQL.
-
Visualize Live ServiceDesk Plus Data in the Power BI Service
Use CData Connect AI to connect to live ServiceDesk Plus data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Publish Helpscout-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Helpscout data.
-
Analyze Xero Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Xero data with the CData JDBC Driver for Xero.
-
Connect to Bitly Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Bitly.
-
Link Mode with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Mode data in Filemaker Pro for Mac or Windows.
-
Use JayDeBeApi to access Clari Data in Python
Use standard Python scripting and the development environment of your choice to access live Clari data.
-
Connect to Instagram Data from Crystal Reports
Use CData Connect AI to connect to and report on live Instagram data from Crystal Reports.
-
How to Visualize Klipfolio Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Klipfolio data in Python.
-
Import and Visualize Outreach.io Data in Power View
Create data visualizations based on Outreach.io data in Excel.
-
Connect to HCL Domino Data in CloverDX (formerly CloverETL)
Transfer HCL Domino data using the visual workflow in the CloverDX data integration tool.
-
How to Query Live RabbitMQ Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live RabbitMQ data data in natural language using Python.
-
Query Live Paymo Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Paymo data through a conversational interface.