CData Software - Knowledge Base
Recent Articles
-
Import and Visualize Telegram Data in Power View
Create data visualizations based on Telegram data in Excel.
-
Gong Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Gong facts in real time.
-
Build Dashboards with Teamwork Data in DBxtra
Create dynamic dashboards and perform analytics based on Teamwork data in DBxtra.
-
Query Redis Data as a MySQL Database in Node.js
Execute MySQL queries against Redis data from Node.js.
-
A PostgreSQL Interface for RabbitMQ Data (MySQL Remoting via JDBC)
Use the Remoting features of the RabbitMQ JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Oracle Service Cloud Data as a MySQL Database in Node.js
Execute MySQL queries against Oracle Service Cloud data from Node.js.
-
Build Agents in Relevance AI with Access to Live Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Sybase data within intelligent agent workflows.
-
Create Opsgenie Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Opsgenie from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live Azure Synapse Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Azure Synapse data into the statistical analysis tools available in SAS JMP. This article shows how to use Azure Synapse data in the Graph Builder and Query Builder.
-
Build Tally-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Tally data.
-
Natively Connect to SageHR Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SageHR data. Leverage the native support for ODBC in PHP.
-
Integrate Twitter Ads Data in Pentaho Data Integration
Build ETL pipelines based on Twitter Ads data in the Pentaho Data Integration tool.
-
Query Hive Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Hive data from Node.js.
-
Excel Spreadsheet Automation on ChartMogul Data with the QUERY Formula
Pull data from ChartMogul, automate spreadsheets, and more with the QUERY formula.
-
Import Real-Time Mailjet Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Mailjet data in ColdFusion.
-
Automated Continuous ShipEngine Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ShipEngine replication to Amazon Redshift.
-
Automate Google Translate Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Translate data replication to Azure Data Lake.
-
Build ZohoDesk-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live ZohoDesk data and build ZohoDesk-connected web apps with Axios.
-
How to load Avalara AvaTax data into Elasticsearch via Logstash
Introducing a simple method to load Avalara AvaTax data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to work with HubDB Data in Apache Spark using SQL
Access and process HubDB Data in Apache Spark using the CData Software JDBC Driver.
-
Automate Autopilot Data Replication to SAP HANA
Use CData Sync to customize and automate Autopilot data replication to SAP HANA.
-
Connect to Salesforce Marketing Data from PowerBuilder via JDBC
This article demonstrates how to access Salesforce Marketing data from PowerBuilder using the Salesforce Marketing JDBC Driver.
-
Automate Elorus Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Elorus data from PowerShell? This article demonstrates how to utilize the Elorus Cmdlets for tasks like connecting to Elorus data, automating operations, downloading data, and more.
-
Getting Started with the CData Tableau Connector for Missive
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Use the CData Software JDBC Driver for SAP in MicroStrategy Desktop
Connect to SAP data in MicroStrategy Desktop using the CData Software JDBC Driver for SAP.
-
Getting Started with the CData JDBC Driver for SAP Business One
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP Business One.
-
How to Create Power BI Visual Reports with Real-Time EmailOctopus Data
Use CData Power BI Connectors to visualize EmailOctopus data in Power BI.
-
Automate Databricks Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Databricks data from PowerShell? This article demonstrates how to utilize the Databricks Cmdlets for tasks like connecting to Databricks data, automating operations, downloading data, and more.
-
A PostgreSQL Interface for YouTube Analytics Data (MySQL Remoting via JDBC)
Use the Remoting features of the YouTube Analytics JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import and Visualize Grafana Data in Power View
Create data visualizations based on Grafana data in Excel.
-
Connect to Power BI XMLA Data in ACL Analytics
Connect to Power BI XMLA data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Power BI XMLA data.
-
How to connect to Rootly Data from IntelliJ
Integrate connectivity to Rootly data with wizards in IntelliJ.
-
Use the CData Software ODBC Driver for Freshservice in SAS for Real-Time Reporting and Analytics
Connect to real-time Freshservice data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Freshservice.
-
Use Biml to Build SSIS Tasks to Replicate Dynamics CRM Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Dynamics CRM data to SQL Server.
-
Deploy the ADO.NET Provider for SAS xpt on an SSRS Report Server
Connect to SAS xpt 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.
-
Build a PostgreSQL Interface for TaxJar Data using the CData JDBC Driver
Use the Remoting features of the TaxJar JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Slack Data in ColdFusion
Write standard ColdFusion data access code to connect to Slack data.
-
Visualize Live SAP SuccessFactors Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP SuccessFactors data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Visualize CouchDB Data in Python with pandas
Use pandas and other modules to analyze and visualize live CouchDB data in Python.
-
Use the CData Software ODBC Driver for Google Search in MicroStrategy Web
Connect to Google Search results in MicroStrategy Web using the CData Software ODBC Driver for Google Search.
-
Connect to Typeform Data from AWS Glue
Use CData Connect AI to gain access to live Typeform data from your AWS Glue jobs.
-
Integrate Goose with Live Discord Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Discord data from within the local AI agent.
-
Query, Visualize, and Share live BambooHR Data in Redash
Use CData Connect AI to connect to live BambooHR data in Redash for querying, visualizing, and sharing.
-
Migrating data from Bright Data to Snowflake using CData SSIS Components.
Easily push Bright Data data to Snowflake using the CData SSIS Tasks for Bright Data and Snowflake.
-
Back Up Aweber data 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 Aweber data data.
-
How to Access Live Kintone Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Kintone enables you to integrate Kintone data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Zoho CRM Data from Crystal Reports
Use CData Connect AI to connect to and report on live Zoho CRM data from Crystal Reports.
-
How to Connect to Live Google Search Results 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 Google Search results for you.
-
Connect to Deel Data in NetBeans
Connect to Deel data in NetBeans with the data source configuration wizard.
-
Migrating data from Azure Data Lake Storage to Databricks using CData SSIS Components.
Easily push Azure Data Lake Storage data to Databricks using the CData SSIS Tasks for Azure Data Lake Storage and Databricks.
-
How to Connect to Live Dynamics 365 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 Dynamics 365 data through natural language.
-
Use Biml to Build SSIS Tasks to Replicate Billsby Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Billsby data to SQL Server.
-
Build Google Ad Manager-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Ad Manager data and build Google Ad Manager-connected web apps with Axios.
-
Back Up Parquet data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Parquet. In this article, we will employ an SSIS workflow to populate a database with Parquet data data.
-
Getting Started with the CData ADO.NET Provider for Salesforce Marketing
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Salesforce Marketing.
-
Connect to and Visualize Live Gmail Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Gmail data.
-
Connect to BigQuery Data from PowerBuilder via JDBC
This article demonstrates how to access BigQuery data from PowerBuilder using the BigQuery JDBC Driver.
-
Import and Visualize Instantly Data in Power View
Create data visualizations based on Instantly data in Excel.
-
Build a Simple VCL Application for Salesforce Data 360 Data
How to build a simple VCL Application to view Salesforce Data 360 data in RAD Studio using the CData ODBC Driver for Salesforce Data 360.
-
Connect Cloudflare Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Cloudflare data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Visualize GitLab Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to GitLab data.
-
Use the CData Software ODBC Driver for eBay in MicroStrategy Desktop
Connect to eBay data in MicroStrategy Desktop using the CData Software ODBC Driver for eBay.
-
Connect to Raisers Edge NXT Data in DBeaver
Use the CData ODBC Driver to connect to Raisers Edge NXT data in DBeaver.
-
Integrate with Live Dropbox Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Dropbox from the MuleSoft Anypoint Platform to integrate live Dropbox data into custom reports and dashboards.
-
Connect to Copper Data from PowerBuilder via JDBC
This article demonstrates how to access Copper data from PowerBuilder using the Copper JDBC Driver.
-
Create Informatica Mappings From/To a JDBC Data Source for GitLab
Create GitLab data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Amazon DynamoDB Data in Coginiti Pro
Connect to and query live Amazon DynamoDB data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live DB2 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 DB2 data through MCP integration.
-
Create Data Visualizations Based On Google Spanner Data in Mode
Use CData Connect AI to connect to Google Spanner Data from Mode and build visualizations using live Google Spanner data.
-
Work with Parallel Data in FoxPro
Load Parallel data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect Hugging Face to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Hugging Face data using the CData Python MCP Server.
-
Automate ServiceDesk Plus Data Replication to SAP HANA
Use CData Sync to customize and automate ServiceDesk Plus data replication to SAP HANA.
-
Connect to ZohoSubscriptions from a Connection Pool in WebLogic
Use the CData JDBC Driver for ZohoSubscriptions to connect to ZohoSubscriptions data from Web applications running on WebLogic.
-
Build SAP SuccessFactors-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP SuccessFactors data.
-
Build Act-On Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Act-On data and build visualizations in Tableau.
-
Use Biml to Build SSIS Tasks to Replicate Quickbase Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Quickbase data to SQL Server.
-
ETL SAP Concur in Oracle Data Integrator
This article shows how to transfer SAP Concur data into a data warehouse using Oracle Data Integrator.
-
How to publish and share Microsoft Ads Data dashboards with Tableau Server
The CData ODBC driver for Microsoft Ads enables you integrate Microsoft Ads data into Tableau dashboards.
-
Automated Continuous Microsoft Teams Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Azure SQL Database.
-
Integrate QuickBooks Time Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to QuickBooks Time data and integrate live QuickBooks Time data into your Power Automate tasks.
-
Create Informatica Mappings From/To an ODBC Data Source for FormSite
Create an ODBC connection to FormSite in Informatica and browse and transfer FormSite data.
-
Connecting Pipedream with Workday 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 Workday data in real time.
-
Create Power BI Reports on Real-Time Oracle Data
Use the CData ODBC Driver for Oracle to visualize Oracle data in Power BI Desktop.
-
Automated Continuous ActiveCampaign Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ActiveCampaign data replication to OneLake in Microsoft Fabric.
-
Work with Sage 300 Data in FoxPro
Load Sage 300 data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create BigQuery Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time BigQuery data access from reports, embedded analytics, and more.
-
Integrating Cursor with NetSuite 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.
-
Automated Continuous Adobe Target Replication to Databricks
Use CData Sync for automated, continuous, customizable Adobe Target replication to Databricks.
-
Integrating LangGraph with xBase Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on xBase data within automated workflows.
-
Migrating data from IBM Cloud Object Storage to Google BigQuery using CData SSIS Components.
Easily push IBM Cloud Object Storage data to Google BigQuery using the CData SSIS Tasks for IBM Cloud Object Storage and Google BigQuery.
-
SAP SuccessFactors LMS Reporting in OBIEE with the SAP SuccessFactors LMS JDBC Driver
Deploy the SAP SuccessFactors LMS JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automate Contentful Data Replication to Couchbase
Use CData Sync to Customize and automate Contentful data replication to Couchbase.
-
Automated Continuous SAP Business One Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP Business One replication to IBM DB2.
-
Import Real-Time SendPulse Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SendPulse data in ColdFusion.
-
Build Apps with Live Dynamics 365 data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Dynamics 365 data into the Adalo platform and build custom mobile and web applications with real-time Dynamics 365 data.
-
Connect to Avaza Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Avaza data.
-
Connect to Snowflake Data from PowerBuilder via ADO.NET
This article demonstrates how to access Snowflake data from Appeon PowerBuilder using the CData ADO.NET Provider for Snowflake.
-
Connect to Presto Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Presto as an External Source in Dremio.
-
How to update TaxJar from Excel
This article explains how to transfer data from Excel to TaxJar using the Excel Add-In for TaxJar.
-
Connect to ShipEngine Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ShipEngine and the SQL Gateway to access ShipEngine data from Google Apps Script.