CData Software - Knowledge Base
Recent Articles
-
Building Dynamic Web Pages with Jira Assets Data Using AngularJS
Create single-page applications with live connectivity to Jira Assets using the CData API Server.
-
Connect to AgileCRM Data in RapidMiner
Integrate AgileCRM with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Kiro CLI with Helpscout 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 Query Live Codat Data in Claude Desktop
Connect to and query live Codat Data in Claude Desktop using CData MCP Server.
-
Getting Started with the CData Power BI Connector for Pipedrive
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Pipedrive.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Quickbase
Provide connectivity to Quickbase through an SAP BusinessObjects universe.
-
How to Work with FreeAgent Data in ETL Validator JDBC
Connect to FreeAgent from ETL Validator jobs using the CData Software JDBC Driver.
-
Prepare, Blend, and Analyze Wrike Data in Alteryx Designer (ODBC)
Build workflows to access live Wrike for self-service data analytics.
-
Build AI/ML Models with Live Acumatica Data using Dataiku
Connect Acumatica Data with Dataiku using the CData JDBC Driver for Acumatica.
-
Analyze AlloyDB Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Google AlloyDB and visualize live Google AlloyDB in Infragistics Reveal.
-
Connect ADP to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ADP with IBM WebSphere for seamless data integration and connectivity.
-
How to import Google Ads Data into Apache Solr
Use the CData Software JDBC Driver for Google Ads in Data Import Handler and create an automated import of Google Ads to Apache Solr Enterprise Search platform.
-
Integrating Clio Data in Talend Cloud Data Management Platform
Connect Clio Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Import Demio Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Demio. In this article, you will use the OData format to import Demio into Microsoft Power Query.
-
How to Easily Query Deel Data in OpenOffice Base
Connect to Deel data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use Agno to Talk to Your Active Directory 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 Active Directory for you.
-
Automated Continuous Supabase Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Supabase replication to Google Cloud SQL.
-
Migrating data from Presto to Databricks using CData SSIS Components.
Easily push Presto to Databricks using the CData SSIS Tasks for Presto and Databricks.
-
Integrating Kiro CLI with Gorgias 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.
-
DataBind Controls to SQL Server Data in C++Builder
DataBind to Microsoft SQL Server in C++Builder with standard components and controls.
-
Build Visualizations of Gong Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Gong in Birst.
-
Use the CData API Server to Access AdRoll Data in Microsoft PowerPivot
Use the CData API Server to connect to live AdRoll in the Power Pivot business intelligence tool.
-
Back Up ZohoExpense to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with ZohoExpense data.
-
Connect Mouseflow to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Mouseflow with IBM WebSphere for seamless data integration and connectivity.
-
Back Up Eventbrite to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Eventbrite data.
-
A PostgreSQL Interface for Quickbase Data using the CData ODBC Driver
Use the SQL Gateway and Quickbase ODBC Driver to create a PostgreSQL entry-point for data access.
-
Natively Connect to Redshift Data in PHP
The CData ODBC driver for Redshift enables you to create PHP applications with connectivity to Amazon Redshift. Leverage the native support for ODBC in PHP.
-
Perform Batch Operations with TaxJar Data in Apache NiFi
Connect to TaxJar and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrate Azure Table Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Azure Table Storage and integrate live Azure Table Storage into your Power Automate tasks.
-
Integrating Antigravity CLI with Freshdesk via CData CLI
Connect Freshdesk to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Query Live EnterpriseDB Data in Perplexity MacOS Desktop
Connect to and query live EnterpriseDB Data in Perplexity Desktop using CData MCP Server.
-
Getting Started with the CData Python Connector for Close
Learn to install and license the CData Python Connector
-
Visualize Live Brex Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Brex using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Access
Provide connectivity to Microsoft Access through an SAP BusinessObjects universe.
-
Build Marketo-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Marketo.
-
Connect to SpaceX Data in JRuby
Create a simple JRuby app with access to live SpaceX.
-
Connect to OnePageCrm Data in HULFT Integrate
Connect to OnePageCrm as a JDBC data source in HULFT Integrate
-
Build a PostgreSQL Interface for BigQuery Data using the CData JDBC Driver
Use the Remoting features of the BigQuery JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to create ShipEngine federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ShipEngine in MySQL .
-
Connect to and Query Greenplum Data in QlikView over ODBC
Create data visualizations with Pivotal GreenPlum in QlikView.
-
Integrating LangGraph with Redshift Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Amazon Redshift within automated workflows.
-
Connect to Authorize.Net Data in Aqua Data Studio
Access Authorize.Net from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to create Jira Assets federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Jira Assets in MySQL .
-
Connect to Tally Data from AWS Glue
Use CData Connect AI to gain access to live Tally ERP from your AWS Glue jobs.
-
DataBind Charts to SendGrid Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SendGrid 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.
-
Publish Presto-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Presto.
-
How to connect SharePoint with Procore Data through external lists
Provide Procore to SharePoint users as an external list.
-
Connect to Float Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Float as an External Source in Dremio.
-
Automated Continuous Clari Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Clari replication to AlloyDB.
-
Access Live Azure Data Catalog Data in Coginiti Pro
Connect to and query live Azure Data Catalog from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to CouchDB Data in Claris FileMaker Pro
Use the CData ODBC Driver for CouchDB in FileMaker Pro to connect to CouchDB and work with Apache CouchDB in your FileMaker applications.
-
Integrating OpenCode Terminal with Amazon Athena 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 Jumpseller Data in Pentaho Data Integration
Build ETL pipelines based on Jumpseller in the Pentaho Data Integration tool.
-
Import Real-Time Sage 200 Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Sage 200 in ColdFusion.
-
Create Dynamic Superchat Grids Using the Infragistics XamDataGrid
Learn how you can connect Superchat to Infragistics XamDataGrid to build dynamic grids.
-
Enable the Freshsales JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Freshsales.
-
Working with EnterpriseDB Data in LINQPad
Execute LINQ queries to EnterpriseDB in LINQPad.
-
Connect to and Visualize Live SageHR Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SageHR.
-
ChargeOver Reporting in OBIEE with the ChargeOver JDBC Driver
Deploy the ChargeOver JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Greenhouse Replication to SingleStore
Use CData Sync for automated, continuous, customizable Greenhouse replication to SingleStore.
-
Use the CData Software ODBC Driver for Rebilly in SAS for Real-Time Reporting and Analytics
Connect to real-time Rebilly in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Rebilly.
-
Connect to Superchat Data from PowerBuilder via JDBC
This article demonstrates how to access Superchat from PowerBuilder using the Superchat JDBC Driver.
-
How to Access Live Google Cloud Storage Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Cloud Storage enables you to integrate Google Cloud Storage into workflows built using Microsoft Power Automate Desktop.
-
Access Live Stripe Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Stripe into the statistical analysis tools available in SAS JMP. This article shows how to use Stripe in the Graph Builder and Query Builder.
-
Automated Continuous CouchDB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable CouchDB replication to IBM DB2.
-
Access Nethunt Data from MySQL in Amazon QuickSight
Connect to Nethunt and build visualizations of Nethunt using a MySQL Connection in Amazon QuickSight.
-
Integrating Kiro CLI with Samanage 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.
-
Replicate Multiple Oracle Eloqua Accounts
Replicate multiple Oracle Eloqua accounts to one or many databases.
-
Integrating Cursor CLI with Google Directory 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 Foursquare Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Foursquare from Informatica Cloud.
-
Create Apps from Facebook Data in Qlik Sense Cloud
Use CData Connect AI to connect to Facebook Data and build apps from live Facebook in Qlik Sense Cloud.
-
How to Access Live Omnisend Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Omnisend from the Cline extension in Visual Studio Code.
-
How to Access Live Strava Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Strava from the Cline extension in Visual Studio Code.
-
Access Live JobNimbus Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a JobNimbus data source in TIBCO Data Virtualization Studio and gain access to live JobNimbus from your TDV Server.
-
Migrating data from Strava to Snowflake using CData SSIS Components.
Easily push Strava to Snowflake using the CData SSIS Tasks for Strava and Snowflake.
-
Visualize Pushbullet Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pushbullet.
-
Edit and Search Instantly External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Instantly to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Instantly objects that you can access from apps and the dashboard.
-
Build Google Sheets-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Sheets and build Google Sheets-connected web apps with Axios.
-
Connect to Vault CRM Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Veeva Vault & Vault CRM in Airbyte.
-
Natively Connect to Microsoft Dataverse Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Dataverse (CDS). Leverage the native support for ODBC in PHP.
-
Create Informatica Mappings From/To a JDBC Data Source for Perplexity
Create Perplexity data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Pipelines with Live Workday Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Workday from Google Cloud Data Fusion, enabling the integration of live Workday into the building and management of effective data pipelines.
-
Connect to WooCommerce Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Live Zoho CRM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Zoho CRM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Hugging Face to Power BI dashboards. Simply drag and drop Hugging Face into data visuals on the Power BI canvas.
-
Use the CData ODBC Driver for HCL Domino from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for HCL Domino to connect to HCL Domino from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring HCL Domino in Excel.
-
Automated Continuous Front Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Front replication to Google Cloud SQL.
-
Connecting Pipedream with QuickBooks Time 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 QuickBooks Time data in real time.
-
Creating Phoenix-Connected Applications in Unqork
You can use CData Connect AI to feed Apache Phoenix to Unqork and build custom business apps.
-
Add PayPal Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for PayPal with the Informatica Enterprise Data Catalog to classify and organize data.
-
Publish OpenWeatherMap-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live OpenWeatherMap.
-
Build Apps with Live Smartsheet in Adalo using CData Connect AI
Use CData Connect AI to integrate live Smartsheet into the Adalo platform and build custom mobile and web applications with real-time Smartsheet.
-
How to Build an ETL App for Aha! Data in Python with CData
Create ETL applications and real-time data pipelines for Aha! in Python with petl.
-
Extend Google Sheets with Onfleet Data
Make calls to Onfleet from Google Apps Script via the API Server.
-
Connect SAP Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP ERP/NetWeaver using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Publish CampaignMonitor-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live CampaignMonitor.
-
Prepare, Blend, and Analyze BigQuery Data in Alteryx Designer (ODBC)
Build workflows to access live Google BigQuery for self-service data analytics.
-
Managing Snowflake TIMESTAMP discrepancies with CData Drivers
TIMESTAMP columns can be difficult thing to manage when insert data into Snowflake. This article explains what you need to know about Snowflake TIMESTAMP types and how to manage them with CData Drivers.
-
How to Access Live Couchbase Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Couchbase enables you to integrate Couchbase into workflows built using Microsoft Power Automate Desktop.
-
How to Create Power BI Visual Reports with Real-Time Airtable Data
Use CData Power BI Connectors to visualize Airtable in Power BI.