CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for SAP Ariba Source in MicroStrategy
Connect to SAP Ariba Source data in MicroStrategy Developer using the CData Software ODBC Driver for SAP Ariba Source.
-
How to connect to MySQL Data from Spring Boot
Connect to MySQL in a Spring Boot Application using the CData JDBC Driver for MySQL
-
Automated Continuous Google Tasks Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Tasks replication to Vertica.
-
Build Apps with Live Sage Cloud Accounting Data Using the Low-Code Development Platform of Mendix
Connect Sage Cloud Accounting data with Mendix to build apps using the CData JDBC Driver for Sage Cloud Accounting.
-
Query IBM Informix Data through ODBC in Node.js
Use node-odbc to execute SQL queries against IBM Informix data from Node.js.
-
Connect to Harvest from a Connection Pool in WebLogic
Use the CData JDBC Driver for Harvest to connect to Harvest data from Web applications running on WebLogic.
-
Access Live Paymo Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Paymo data from your Google Sheets.
-
How to integrate Metabase with Google Cloud Storage Data
Use CData Connect AI to connect to live Google Cloud Storage data and create an interactive dashboard in Metabase from Google Cloud Storage data.
-
Automated Continuous Greenhouse Replication to Snowflake
Use CData Sync for automated, continuous, customizable Greenhouse replication to Snowflake.
-
Import ZohoPeople Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to ZohoPeople Data and provide access to live ZohoPeople data for custom reports in the Power BI Service.
-
Connect to Kintone Data from a Connection Pool in JBoss
Integrate Kintone data into Java servlets: Use the Management Console in JBoss to install the Kintone JDBC Driver.
-
Automated Continuous Zoho Creator Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Apache Kafka.
-
Deploy the ADO.NET Provider for Discord on an SSRS Report Server
Connect to Discord data 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.
-
Use JayDeBeApi to access Neo4J Data in Python
Use standard Python scripting and the development environment of your choice to access live Neo4J data.
-
Visualize Live OpenWeatherMap Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live OpenWeatherMap data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Add Templated Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Templated with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Pinecone Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Pinecone replication to Apache Cassandra.
-
Connect to xBase Data in DBArtisan
Use wizards in DBArtisan to configure xBase data as a data source.
-
Visualize Live JSON Services of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live JSON services using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Airtable Data from PowerShell
Write a quick PowerShell script to query Airtable data. Use connectivity to the live data to replicate Airtable data to SQL Server.
-
Integrating Kiro with Google Translate 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.
-
Import Paylocity Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Paylocity Data and provide access to live Paylocity data for custom reports in the Power BI Service.
-
Access Live Chargebee Data in Coginiti Pro
Connect to and query live Chargebee data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to connect to GetResponse Data with Squirrel SQL client
Connect to GetResponse data and execute queries in the Squirrel SQL Client.
-
Replicate Multiple Strava Accounts via the CData Sync CLI
Replicate multiple Strava accounts to one or many databases.
-
Build Charts with Neo4J Data in Clear Analytics
Create dynamic charts and perform analytics based on Neo4J data in Clear Analytics.
-
How to create ConstantContact federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ConstantContact data in MySQL .
-
Connect and Query Live Reckon Accounts Hosted Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Reckon Accounts Hosted data into Databricks and enable direct, live querying and analysis without replication.
-
How to Query Live CSV Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live CSV data data in natural language using Python.
-
Automated Continuous Lakebase Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Lakebase replication to Apache Kafka.
-
Create Informatica Mappings From/To an ODBC Data Source for Dropbox
Create an ODBC connection to Dropbox in Informatica and browse and transfer Dropbox data.
-
Integrating Azure Data Lake Storage Data in Talend Cloud Data Management Platform
Connect Azure Data Lake Storage Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Azure Data Lake Storage.
-
Build Charts with Ontraport Data in Clear Analytics
Create dynamic charts and perform analytics based on Ontraport data in Clear Analytics.
-
Create Power BI Reports on Real-Time ClickTime Data
Use the CData ODBC Driver for ClickTime to visualize ClickTime data in Power BI Desktop.
-
Replicate Multiple Perplexity Accounts via the CData Sync CLI
Replicate multiple Perplexity accounts to one or many databases.
-
Build Visualizations of Datadog Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Datadog data in Birst.
-
Automate Sage 200 Data Replication to SAP HANA
Use CData Sync to customize and automate Sage 200 data replication to SAP HANA.
-
Natively Connect to Retently Data in PHP
The CData ODBC driver for Retently enables you to create PHP applications with connectivity to Retently data. Leverage the native support for ODBC in PHP.
-
Build a Simple VCL Application for Optimizely Data
How to build a simple VCL Application to view Optimizely data in RAD Studio using the CData ODBC Driver for Optimizely.
-
Integrate DB2 with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate DB2 with External Services.
-
Integrate LibreChat with Live SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SAP SuccessFactors LMS data from within the chat interface.
-
Integrating Dataiku with EnterpriseDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live EnterpriseDB data.
-
How to Connect to Live Asana Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Asana data through natural language.
-
How to connect and process Zoho Recruit data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Zoho Recruit data.
-
Use the CData Software ODBC Driver for ActiveCampaign in SAS for Real-Time Reporting and Analytics
Connect to real-time ActiveCampaign data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ActiveCampaign.
-
Automated Continuous Kafka Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Kafka replication to Amazon S3.
-
Use the CData Software JDBC Driver for Monday.com in MicroStrategy Desktop
Connect to Monday.com data in MicroStrategy Desktop using the CData Software JDBC Driver for Monday.com.
-
Feed eBay Data into FineReport
How to set eBay data as a JDBC data source in FineReport.
-
Connect to Oracle Service Cloud Data from AWS Glue
Use CData Connect AI to gain access to live Oracle Service Cloud data from your AWS Glue jobs.
-
Getting Started with the CData Excel Add-In for Figshare
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Figshare.
-
Model Workday Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Workday, enabling the direct import of real-time Workday data.
-
Build AI/ML Models with Live QuickBooks Data using Dataiku
Connect QuickBooks Data with Dataiku using the CData JDBC Driver for QuickBooks.
-
How to import HubSpot Data into Apache Solr
Use the CData Software JDBC Driver for HubSpot in Data Import Handler and create an automated import of HubSpot data to Apache Solr Enterprise Search platform.
-
Build BigQuery-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live BigQuery data.
-
Connect to FreeAgent Data in RapidMiner
Integrate FreeAgent data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Short.io Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Short.io replication to Google BigQuery.
-
Connect to PolarTeamPro Data from Crystal Reports
Use CData Connect AI to connect to and report on live PolarTeamPro data from Crystal Reports.
-
Build a Simple VCL Application for Hacker News Data
How to build a simple VCL Application to view Hacker News data in RAD Studio using the CData ODBC Driver for Hacker News.
-
Deploy the ADO.NET Provider for MariaDB on an SSRS Report Server
Connect to MariaDB data 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.
-
Connect to IBM Cloud Object Storage Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for IBM Cloud Object Storage data.
-
CData SAP Driver Deep Dive: Use SAP Gateway Service Builder for SAP S/4HANA and Set Up OData Service
A guide for using the SAP Gateway Service Builder for SAP S/4 HANA and setting up an SAP OData Service
-
How to Work with Teamgate Data in ETL Validator JDBC
Connect to Teamgate from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to WooCommerce Data from Crystal Reports
Use CData Connect AI to connect to and report on live WooCommerce data from Crystal Reports.
-
DataBind Controls to Sentry Data in C++Builder
DataBind to Sentry data in C++Builder with standard components and controls.
-
Replicate Azure DevOps Data from PowerShell
Write a quick PowerShell script to query Azure DevOps data. Use connectivity to the live data to replicate Azure DevOps data to SQL Server.
-
Configure the CData JDBC Driver for Confluence in a Connection Pool in Tomcat
Connect to Confluence data from a connection pool in Tomcat.
-
Integrate Devin with Live Basecamp 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 Basecamp data.
-
Replicate Multiple Salesloft Accounts via the CData Sync CLI
Replicate multiple Salesloft accounts to one or many databases.
-
Automated Continuous Avaza Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Avaza replication to AlloyDB.
-
Connect to OnePageCrm Data from a Connection Pool in JBoss
Integrate OnePageCrm data into Java servlets: Use the Management Console in JBoss to install the OnePageCrm JDBC Driver.
-
Use the CData Software JDBC Driver for Superchat in MicroStrategy Web
Connect to Superchat data in MicroStrategy Web using the CData Software JDBC Driver for Superchat.
-
Connect to Freshteam Data in NetBeans
Connect to Freshteam data in NetBeans with the data source configuration wizard.
-
Choosing the Best Method to Connect Cosmos DB to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Cosmos DB data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Getting Started with the CData JDBC Driver for Google Ads
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Ads.
-
Integrate Google's Antigravity Agent with Live Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Amazon Marketplace data using the Model Context Protocol.
-
Automate Humanity Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Humanity data from PowerShell? This article demonstrates how to utilize the Humanity Cmdlets for tasks like connecting to Humanity data, automating operations, downloading data, and more.
-
Automated Continuous Sendwithus Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sendwithus replication to Amazon Redshift.
-
Automated Continuous Certinia Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Certinia replication to Amazon Redshift.
-
Model, Search, and Visualize Live Jumpseller Data in ThoughtSpot
Use CData Connect AI to connect to live Jumpseller data for modeling, searching, and visualizing.
-
Connect to Live Phoenix Data in MicroStrategy through CData Connect AI
Create a live connection to Phoenix Data in CData Connect AI and connect to your Phoenix data from MicroStrategy.
-
Use the CData SSIS Components to Insert New or Update Existing QuickBooks Online Records from SQL Server
Easily push SQL Server data to QuickBooks Online using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into QuickBooks Online or update existing records with data from a SQL Server database.
-
How to connect and process PayPal data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live PayPal data.
-
Build Twitter Ads-Connected Apps in Choreo
Use CData Connect AI to connect to Twitter Ads Data from Choreo and build custom apps using live Twitter Ads data.
-
How to integrate Metabase with CSV Data
Use CData Connect AI to connect to live CSV data and create an interactive dashboard in Metabase from CSV data.
-
Automate Aha! Data Replication to SAP HANA
Use CData Sync to customize and automate Aha! data replication to SAP HANA.
-
Easily Integrate ZendeskSell Data in Lazarus Pascal IDE
Learn how to easily integrate live ZendeskSell data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Publish Crystal Reports on Yelp Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Yelp data.
-
Getting Started with the CData Power BI Connector for Onfleet
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create SSAS Tabular Models from Intercom Data
How to build a SQL Server Analysis Service Tabular Model from Intercom data using CData drivers.
-
How to create Missive federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Missive data in MySQL .
-
Create HCL Domino-Connected Applications in Appsmith
Connect to HCL Domino Data via CData Connect AI in Appsmith and create custom business applications with real-time access to HCL Domino data.
-
How to connect to ZeroBounce Data from IntelliJ
Integrate connectivity to ZeroBounce data with wizards in IntelliJ.
-
Automate Outreach.io Data Replication to Azure Synapse
Use CData Sync to customize and automate Outreach.io data replication to Azure Synapse.
-
Design BIRT Reports on Basecamp Data
Provide current Basecamp data to your embedded analytics.
-
Viewing Presto Data in RAD Studio Data Explorer
How to view Presto data in RAD Studio Data Explorer using the CData ODBC Driver for Presto.
-
Use Microsoft Copilot Studio to talk to your API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your API data for you.
-
Feed QuickBooks Online Data into FineReport
How to set QuickBooks Online data as a JDBC data source in FineReport.
-
How to Query Oracle Sales Data in MySQL Workbench
Execute MySQL queries against live Oracle Sales data from MySQL Workbench.
-
Create AlloyDB-Connected Applications in Appsmith
Connect to AlloyDB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to AlloyDB data.
-
Connect to and Query YouTube Analytics Data in QlikView over ODBC
Create data visualizations with YouTube Analytics data in QlikView.