CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live SAP Netweaver Gateway Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your SAP Netweaver Gateway for you.
-
Import DB2 Data Using Azure Data Factory
Use CData Connect AI to connect to DB2 Data from Azure Data Factory and import live IBM DB2.
-
Connect to Google Calendar Data in DBeaver
Use the CData ODBC Driver to connect to Google Calendar in DBeaver.
-
How to Query Live Tally Data in Perplexity MacOS Desktop
Connect to and query live Tally Data in Perplexity Desktop using CData MCP Server.
-
Automated Continuous ADP Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ADP replication to Apache Cassandra.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Paylocity to Power BI dashboards. Simply drag and drop Paylocity into data visuals on the Power BI canvas.
-
A PostgreSQL Interface for Printify Data using the CData ODBC Driver
Use the SQL Gateway and Printify ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Bannerbear Replication to Oracle
Use CData Sync for automated, continuous, customizable Bannerbear replication to Oracle.
-
Integrate with Campaigner Data in JReport Designer
Create charts and reports based on Campaigner in JReport Designer.
-
Integrate Grafana with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Grafana with External Services.
-
Create Dynamic Mode Grids Using the Infragistics XamDataGrid
Learn how you can connect Mode to Infragistics XamDataGrid to build dynamic grids.
-
Integrate with Perplexity Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Perplexity to a JSON file on disk.
-
Build an OLAP Cube in SSAS from LeadDesk Data
Establish a connection to LeadDesk data from SQL Server Analysis Services, and use the LeadDesk Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Jodoo Data from PowerBuilder via JDBC
This article demonstrates how to access Jodoo from PowerBuilder using the Jodoo JDBC Driver.
-
How to create an RPA flow for Google Sheets Data in UiPath Studio
Use the Google Sheets ODBC Driver to create workflows that access real-time Google Sheets without any coding.
-
MySQL Reporting in OBIEE with the MySQL JDBC Driver
Deploy the MySQL JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Data Visualizations in Cognos BI with Unbounce Data
Access Unbounce as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to connect and process SharePoint Excel Services from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SharePoint Excel Services.
-
Automated Continuous Humanity Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Humanity replication to Apache Cassandra.
-
Access Todoist Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Todoist from HeidiSQL.
-
Create Datasets from Vault CRM in Domo Workbench and Build Visualizations of Vault CRM Data in Domo
Use the CData Software ODBC Driver for Vault CRM to create datasets from Veeva Vault & Vault CRM in Domo Workbench and then build visualizations in the Domo service.
-
How to integrate Cloudant with Apache Airflow
Access and process IBM Cloudant in Apache Airflow using the CData JDBC Driver.
-
Connect to Yelp Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Yelp in the Denodo Virtual DataPort Administrator.
-
Using the CData Software ODBC Driver for PostgreSQL in PyCharm
Connect to PostgreSQL as an ODBC data source in PyCharm using the CData Software ODBC Driver for PostgreSQL.
-
Integrate Mixpanel Data in the Pentaho Report Designer
Publish reports based on Mixpanel in the Pentaho BI tool.
-
Getting Started with the CData Excel Add-In for Act-On
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Act-On.
-
Access Live Customer.io Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Customer.io into the statistical analysis tools available in SAS JMP. This article shows how to use Customer.io in the Graph Builder and Query Builder.
-
How to load Pushbullet data into Elasticsearch via Logstash
Introducing a simple method to load Pushbullet data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to work with Dynamics 365 Data in Apache Spark using SQL
Access and process Dynamics 365 Data in Apache Spark using the CData Software JDBC Driver.
-
How to Generate Updategrams with the CData BizTalk Adapter for Salesforce
You can use updategrams to insert, update, and delete Salesforce data. This guide shows how to use the adapter for Salesforce to generate updategram schemas and instances.
-
Build Dashboards with Databricks Data in Dundas BI
Create dynamic dashboards and perform analytics based on Databricks in Dundas BI.
-
Automated Toggl Data Replication to Teradata
Use CData Sync to Customize and automate Toggl replication to Teradata.
-
Access Live Asana Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Asana into the statistical analysis tools available in SAS JMP. This article shows how to use Asana in the Graph Builder and Query Builder.
-
Extend Google Sheets with Sage 200 Data
Make calls to Sage 200 from Google Apps Script via the API Server.
-
Connect to Oracle Service Cloud from Asprova with CData Software ODBC Driver for Oracle Service Cloud
This article shows how to connect faster to Oracle Service Cloud data from Asprova.
-
Connect to Google Spanner Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Spanner in Airbyte.
-
ETL Impala in Oracle Data Integrator
This article shows how to transfer Apache Impala into a data warehouse using Oracle Data Integrator.
-
Automated Continuous CData Connect AI Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable CData Connect AI replication to Apache Cassandra.
-
Build Dashboards with XML Data in Dundas BI
Create dynamic dashboards and perform analytics based on XML Files in Dundas BI.
-
Trigger Vault CRM IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Vault CRM with standard wizards in Logic Apps.
-
Replicate Square Data from PowerShell
Write a quick PowerShell script to query Square. Use connectivity to the live data to replicate Square to SQL Server.
-
Automated Continuous ZohoMarketingHub Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to PostgreSQL.
-
Create SAP Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use CData Connect AI to Access Amazon Marketplace Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Amazon Marketplace in the Power Pivot business intelligence tool.
-
Connect to Productboard Data in RapidMiner
Integrate Productboard with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Reports from QuickBooks Online Data in Looker Studio
Use CData Connect AI to gain access to live QuickBooks Online and create custom reports in Looker Studio.
-
How to publish and share Zuora Data dashboards with Tableau Server
The CData ODBC driver for Zuora enables you integrate Zuora into Tableau dashboards.
-
Automated Continuous Adobe Commerce Replication to MongoDB
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to MongoDB.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Asana within intelligent workflows.
-
Access Live iContact Data in AWS Lambda
Connect to live iContact in AWS Lambda using the CData JDBC Driver.
-
Build Basecamp Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Basecamp and build visualizations in Tableau.
-
Connect Freshsales to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Freshsales with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software ODBC Driver for Drift in MicroStrategy Web
Connect to Drift in MicroStrategy Web using the CData Software ODBC Driver for Drift.
-
Visualize YouTube Analytics Data in TIBCO Spotfire through OData
Integrate YouTube Analytics into dashboards in TIBCO Spotfire.
-
Connect to Reckon Data in DBeaver
Use the CData ODBC Driver to connect to Reckon in DBeaver.
-
Import Adobe Analytics Data Using Azure Data Factory
Use CData Connect AI to connect to Adobe Analytics Data from Azure Data Factory and import live Adobe Analytics.
-
Publish Amazon Athena-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Amazon Athena.
-
How to Seamlessly Import ZohoPeople Data into IBM SPSS Modeler
Integrate ZohoPeople data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Vault CRM Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Veeva Vault & Vault CRM and build visualizations in Tableau.
-
Analyze Todoist Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Todoist in Microsoft R Open.
-
How to Work with Suadeo Data in ETL Validator JDBC
Connect to Suadeo from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Cline with Live Office 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Office 365 from within your IDE.
-
Automated Continuous Freshservice Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Freshservice replication to IBM DB2.
-
Create xBase Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time xBase data access from reports, embedded analytics, and more.
-
Build Apps with Live Sage Business Cloud Accounting in Adalo using CData Connect AI
Use CData Connect AI to integrate live Sage Business Cloud Accounting into the Adalo platform and build custom mobile and web applications with real-time Sage Business Cloud Accounting.
-
Build Redshift-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Amazon Redshift and build Redshift-connected web apps with Axios.
-
Automated Continuous Zuora Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Zuora replication to Google Cloud SQL.
-
Connect to Live Amazon Athena Data in MicroStrategy through CData Connect AI
Create a live connection to Amazon Athena Data in CData Connect AI and connect to your Amazon Athena from MicroStrategy.
-
Integrate ServiceDesk Plus Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ServiceDesk Plus from Informatica Cloud.
-
Connect to Bullhorn CRM Data from a Connection Pool in JBoss
Integrate Bullhorn CRM into Java servlets: Use the Management Console in JBoss to install the Bullhorn CRM JDBC Driver.
-
Integrating Claude Code CLI with SendGrid 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.
-
Connect to Stack Exchange Data from PowerBuilder via ADO.NET
This article demonstrates how to access Stack Exchange from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use Dash to Build to Web Apps on PDFMonkey Data
Create Python applications that use pandas and Dash to build PDFMonkey-connected web apps.
-
Use JayDeBeApi to access Figshare Data in Python
Use standard Python scripting and the development environment of your choice to access live Figshare.
-
Integrate with Google Ad Manager Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Ad Manager in SnapLogic.
-
Build a PostgreSQL Interface for ZohoDesk Data using the CData JDBC Driver
Use the Remoting features of the ZohoDesk JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build AI Agents with Acumatica 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 Acumatica ERP through CData Connect AI.
-
Use Agno to Talk to Your SAS xpt 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 SAS XPORT for you.
-
How to Access Live SAP HANA Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP HANA enables you to integrate SAP HANA into workflows built using Microsoft Power Automate Desktop.
-
LINQ to OneNote 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 OneNote Data Provider.
-
Build an OLAP Cube in SSAS from Amazon Athena Data
Establish a connection to Amazon Athena data from SQL Server Analysis Services, and use the Amazon Athena Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Auth0 Data in RapidMiner
Integrate Auth0 with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Data Visualizations Based On BigCommerce Data in Mode
Use CData Connect AI to connect to BigCommerce Data from Mode and build visualizations using live
-
Using the CData Software ODBC Driver for Autopilot in PyCharm
Connect to Autopilot as an ODBC data source in PyCharm using the CData Software ODBC Driver for Autopilot.
-
Load Azure Data Lake Storage Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Azure Data Lake Storage to a database.
-
Connect to Sage Cloud Accounting Data in RapidMiner
Integrate Sage Business Cloud Accounting with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Dash to Build Web Apps on FTP Data via CData Connect AI
Build interactive Dash web apps on live FTP Servers using pandas and the CData Connect AI Python SDK.
-
Create Data Visualizations in Cognos BI with eBay Data
Access eBay as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software JDBC Driver for Sugar CRM in MicroStrategy Desktop
Connect to Sugar CRM in MicroStrategy Desktop using the CData Software JDBC Driver for Sugar CRM.
-
How to Query ADP Data in MySQL Workbench
Execute MySQL queries against live ADP from MySQL Workbench.
-
Add Hugging Face Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Hugging Face with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Pipeliner CRM Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Pipeliner CRM from Informatica Cloud.
-
How to Connect to Short.io Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Short.io. Leverage the pyodbc module for ODBC in Python.
-
Integrate with Tavily Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Tavily to a JSON file on disk.
-
Use the CData Software ODBC Driver for Google Contacts in MicroStrategy Desktop
Connect to Google Contacts in MicroStrategy Desktop using the CData Software ODBC Driver for Google Contacts.
-
How to Query Live CockroachDB Data in Perplexity MacOS Desktop
Connect to and query live CockroachDB Data in Perplexity Desktop using CData MCP Server.
-
Connect Calendly to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Calendly using the CData Python MCP Server.
-
How to Connect to Live SAS Data Sets Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your SAS Data Sets for you.
-
How to Build an ETL App for Excel Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Excel in Python with petl.
-
Build Data Flows from SQL Server to Amazon Athena through SSIS
Easily push SQL Server data to Amazon Athena using the CData SSIS Tasks for Amazon Athena.