CData Software - Knowledge Base
Recent Articles
-
Connect to Google Analytics Data from a Connection Pool in Jetty
The Google Analytics JDBC Driver supports connection pooling: This article shows how to connect faster to Google Analytics from Web apps in Jetty.
-
Integrating GitHub Copilot CLI with Customer.io 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 to SAP Business Warehouse Data in CloverDX (formerly CloverETL)
Transfer SAP Business Warehouse using the visual workflow in the CloverDX data integration tool.
-
Configure the CData JDBC Driver for Oracle Eloqua Reporting in a Connection Pool in Tomcat
Connect to Oracle Eloqua Reporting from a connection pool in Tomcat.
-
LINQ to BigCommerce 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 BigCommerce Data Provider.
-
Publish Confluence-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Atlassian Confluence.
-
Feed PivotalTracker Data into FineReport
How to set PivotalTracker as a JDBC data source in FineReport.
-
Connect to PostgreSQL Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for PostgreSQL.
-
Visualize Sybase IQ Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Sybase IQ.
-
How to create an RPA flow for Jodoo Data in UiPath Studio
Use the Jodoo ODBC Driver to create workflows that access real-time Jodoo without any coding.
-
Integrate IBM Informix Data into Power Automate Desktop using CData Connect
CData Connect for IBM Informix Data enables you to integrate IBM Informix into workflows built using Microsoft Power Automate Desktop.
-
How to use SQLAlchemy ORM to access SparkPost Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SparkPost.
-
Establish a Live Connection with Elorus Data using Tableau Bridge
The CData ODBC Driver for Elorus enables you to integrate live Elorus into Tableau Cloud dashboards using the Tableau Bridge.
-
Publish CloudConvert-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live CloudConvert.
-
Visualize Live Webex Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Webex.
-
Import Real-Time Salesforce Pardot Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Salesforce Pardot in ColdFusion.
-
Edit and Search Zoho Books External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Zoho Books to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Zoho Books objects that you can access from apps and the dashboard.
-
Query FormSite Data in DataGrip
Create a Data Source for FormSite in DataGrip and use SQL to query live FormSite.
-
Excel Spreadsheet Automation on Zendesk Data with the QUERY Formula
Pull data from Zendesk, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData JDBC Driver for Mistral AI
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Mistral AI.
-
Deploy the ADO.NET Provider for ConvertKit on an SSRS Report Server
Connect to ConvertKit from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Create Reports with Sugar CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sugar CRM.
-
How to load PostgreSQL data into Elasticsearch via Logstash
Introducing a simple method to load PostgreSQL data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Epicor Kinetic Replication to SQLite
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to SQLite.
-
Back Up JotForm 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 JotForm data.
-
Publish Reports with FormSite Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date FormSite.
-
Automated Continuous SurveyMonkey Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Google Cloud SQL.
-
Connecting Pipedream with MongoDB 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 MongoDB data in real time.
-
Create Informatica Mappings From/To a JDBC Data Source for PhantomBuster
Create PhantomBuster data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect and process Airtable from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Airtable.
-
Import Real-Time Pinecone Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Pinecone in ColdFusion.
-
Getting Started with the CData Python Connector for AlloyDB
Learn to install and license the CData Python Connector
-
Connect to Microsoft OneDrive Data in RazorSQL
Connect to Microsoft OneDrive from wizards and query Microsoft OneDrive from the GUI in the RazorSQL database management tool.
-
Integrate Landbot Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Landbot from Informatica Cloud.
-
Create a Data Access Object for SAS Data Sets Data using JDBI
A brief overview of creating a SQL Object API for SAS Data Sets in JDBI.
-
Excel Spreadsheet Automation on PivotalTracker Data with the QUERY Formula
Pull data from PivotalTracker, automate spreadsheets, and more with the QUERY formula.
-
How to use SQLAlchemy ORM to access Unbounce Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Unbounce.
-
Access NASA Data from MySQL in Amazon QuickSight
Connect to NASA and build visualizations of NASA using a MySQL Connection in Amazon QuickSight.
-
ETL SharePoint in Oracle Data Integrator
This article shows how to transfer Microsoft SharePoint into a data warehouse using Oracle Data Integrator.
-
Write a Simple Go Application to work with LinkedIn Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to LinkedIn.
-
Visualize Hubstaff Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Hubstaff.
-
Integrate Cline with Live Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Campaign Manager 360 from within your IDE.
-
SAP Hybris C4C Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP Hybris C4C facts in real time.
-
How to Connect to & Open Insightly Data in Microsoft Excel
This article uses the CData ODBC driver for Insightly to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous SAP Ariba Procurement Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Apache Kafka.
-
Connecting Moonlit Workflow with Klaviyo 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 Klaviyo in real time.
-
Create Amazon DynamoDB-Connected Dashboards in Grafana
Connect to Amazon DynamoDB Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Amazon DynamoDB.
-
Design BIRT Reports on JobNimbus Data
Provide current JobNimbus to your embedded analytics.
-
View Reports on Real-Time ChargeOver Data in Power BI Report Server
Use the CData ODBC Driver for ChargeOver to visualize ChargeOver in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize Live Guru Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Guru using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to SAP HANA Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP HANA in Google Apps Script.
-
Perform Batch Operations with Salesloft Data in Apache NiFi
Connect to Salesloft and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Process & Analyze NASA Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live NASA Data.
-
Visualize Certinia 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 Certinia into TIBCO Spotfire.
-
Build Charts with Figshare Data in Clear Analytics
Create dynamic charts and perform analytics based on Figshare in Clear Analytics.
-
Import Real-Time Retently Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Retently in ColdFusion.
-
How to Connect to Live eBay Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your eBay for you.
-
Moving Data from Oracle Service Cloud to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Oracle Service Cloud data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use the CData Software JDBC Driver for Adobe Target in MicroStrategy
Connect to Adobe Target in MicroStrategy Developer using the CData Software JDBC Driver for Adobe Target.
-
DataBind Controls to LightSpeedRetail Data in Delphi
DataBind to LightSpeedRetail in Delphi with standard data access components and controls.
-
Integrate Live Facebook Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Facebook to Blue Prism using the CData ODBC Driver for Facebook to create automated workflows for repetitive business tasks.
-
Connect to and Visualize Live Google Directory Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Directory.
-
Feed Greenhouse Data into FineReport
How to set Greenhouse as a JDBC data source in FineReport.
-
Enable the ConvertKit JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ConvertKit.
-
Visualize WordPress Data in Tableau
The CData ODBC driver for WordPress enables you integrate WordPress into Tableau dashboards.
-
How to Connect to Reckon Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Reckon. Leverage the pyodbc module for ODBC in Python.
-
Import Vault CRM Data Using Azure Data Factory
Use CData Connect AI to connect to Vault CRM Data from Azure Data Factory and import live Veeva Vault & Vault CRM.
-
How to Connect to Live Redis Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Redis without replication.
-
Connect to Live Freshdesk Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Freshdesk in CData Connect AI and connect to your Freshdesk from PostgreSQL.
-
Integrate with Chargebee Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Chargebee to a JSON file on disk.
-
Access Live Stripe 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 Stripe through MCP integration.
-
Access Live Grafana Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Grafana into the statistical analysis tools available in SAS JMP. This article shows how to use Grafana in the Graph Builder and Query Builder.
-
DataBind Controls to MessageBird Data in C++Builder
DataBind to MessageBird in C++Builder with standard components and controls.
-
Build AI Agents with Freshservice Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Freshservice through CData Connect AI.
-
Establish a Live Connection with Missive Data using Tableau Bridge
The CData ODBC Driver for Missive enables you to integrate live Missive into Tableau Cloud dashboards using the Tableau Bridge.
-
Replicate Multiple ZohoPeople Accounts via the CData Sync CLI
Replicate multiple ZohoPeople accounts to one or many databases.
-
Configure the CData JDBC Driver for Xero in a Connection Pool in Tomcat
Connect to Xero Accounting from a connection pool in Tomcat.
-
Import and Visualize Cloudant Data in Power View
Create data visualizations based on IBM Cloudant in Excel.
-
How to Query Live CloudConvert Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live CloudConvert data in natural language using Python.
-
How to Query Salesforce Marketing Data in MySQL Workbench
Execute MySQL queries against live Salesforce Marketing Cloud from MySQL Workbench.
-
Connect to Salesforce Marketing from Asprova with CData Software ODBC Driver for Salesforce Marketing
This article shows how to connect faster to Salesforce Marketing data from Asprova.
-
Use JayDeBeApi to access Nuclia Data in Python
Use standard Python scripting and the development environment of your choice to access live Nuclia.
-
Query Teradata Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Teradata and perform CRUD operations on Teradata from Node.js.
-
Choosing the Best Method to Connect Guru to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Guru from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Procore Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Procore replication to Azure SQL Database.
-
Build AI/ML Models with Live Blackbaud FE NXT Data using Dataiku
Connect Blackbaud FE NXT Data with Dataiku using the CData JDBC Driver for Blackbaud FE NXT.
-
DataBind Controls to SharePoint Excel Services Data in Delphi
DataBind to SharePoint Excel Services in Delphi with standard data access components and controls.
-
DataBind Lakebase Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Lakebase with the DevExpress Windows Forms and Web controls to provide Lakebase to a chart.
-
Access Live MYOB AccountRight Data in Coginiti Pro
Connect to and query live MYOB AccountRight from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Browserless Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Browserless using standard SQL.
-
How to Connect to Shopify Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Shopify. Leverage the pyodbc module for ODBC in Python.
-
Migrating data from SAP Netweaver Gateway to Databricks using CData SSIS Components.
Easily push SAP Netweaver Gateway to Databricks using the CData SSIS Tasks for SAP Netweaver Gateway and Databricks.
-
Connect to Spotify Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Spotify using standard SQL.
-
How to create an RPA flow for VWO Data in UiPath Studio
Use the VWO ODBC Driver to create workflows that access real-time VWO without any coding.
-
Create a Data Access Object for Egnyte Data using JDBI
A brief overview of creating a SQL Object API for Egnyte in JDBI.
-
How to Connect to Live Oracle Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Oracle Database for you.
-
Access Live LinkedIn 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 LinkedIn through MCP integration.
-
Analyze Box Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Box from Power Pivot. You will use the Table Import Wizard to load Box. You can visually build the import query or use any SQL supported by the driver.
-
Building Dynamic Web Pages with Bitbucket Data Using AngularJS
Create single-page applications with live connectivity to Bitbucket using the CData API Server.
-
Integrate Apify with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Apify with External Services.