CData Software - Knowledge Base
Recent Articles
-
Create Oracle Eloqua Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Oracle Eloqua from PowerBI.com to create Power BI Dataflows with real-time data.
-
Extend Google Sheets with HDFS Data
Make calls to HDFS from Google Apps Script via the API Server.
-
Automated Continuous Quaderno Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Quaderno replication to PostgreSQL.
-
Automated Continuous Amazon Athena Replication to Snowflake
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Snowflake.
-
How to Design CockroachDB Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to CockroachDB from mobile and tablet Power Apps.
-
Use Biml to Build SSIS Tasks to Replicate MailerLite Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate MailerLite to SQL Server.
-
Connect AlloyDB to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google AlloyDB using the CData Python MCP Server.
-
Create SSAS Tabular Models from SAP Hybris C4C Data
How to build a SQL Server Analysis Service Tabular Model from SAP Hybris C4C using CData drivers.
-
Write a Simple Go Application to work with Guru Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Guru.
-
Add Workday Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Workday with the Informatica Enterprise Data Catalog to classify and organize data.
-
Import and Visualize LDAP Objects in Power View
Create data visualizations based on LDAP in Excel.
-
Build Visualizations of Pinecone Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Pinecone in Birst.
-
Connect to Freshdesk Data from PowerBuilder via JDBC
This article demonstrates how to access Freshdesk from PowerBuilder using the Freshdesk JDBC Driver.
-
DataBind Controls to QuickBooks Time Data in C++Builder
DataBind to QuickBooks Time in C++Builder with standard components and controls.
-
Replicate Multiple PayPal Accounts via the CData Sync CLI
Replicate multiple PayPal accounts to one or many databases.
-
Create JSON Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time JSON data access from reports, embedded analytics, and more.
-
Automated Continuous ADP Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ADP replication to Apache Kafka.
-
Create Apps from Amazon Marketplace Data in Qlik Sense Cloud
Use CData Connect AI to connect to Amazon Marketplace Data and build apps from live Amazon Marketplace in Qlik Sense Cloud.
-
Create Dashboards and Visualize Live HCL Domino Data in Geckoboard
Use CData Connect AI to connect to live HCL Domino and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Enable the PayPal JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with PayPal.
-
Establish a Live Connection with Freshsales Data using Tableau Bridge
The CData ODBC Driver for Freshsales enables you to integrate live Freshsales into Tableau Cloud dashboards using the Tableau Bridge.
-
DataBind Controls to YouTube Analytics Data in Delphi
DataBind to YouTube Analytics in Delphi with standard data access components and controls.
-
Automated Zoom Data Replication to Teradata
Use CData Sync to Customize and automate Zoom replication to Teradata.
-
How to Connect to Live Workday 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 Workday through natural language.
-
Publish Crystal Reports on Timely Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Timely.
-
Connect to CircleCI Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for CircleCI.
-
Query Factorial Data as a MySQL Database in Node.js
Execute MySQL queries against Factorial from Node.js.
-
Automated Continuous eBay Replication to Vertica
Use CData Sync for automated, continuous, customizable eBay replication to Vertica.
-
Automate Kintone Data Replication to SAP HANA
Use CData Sync to customize and automate Kintone replication to SAP HANA.
-
DataBind Controls to Everhour Data in Delphi
DataBind to Everhour in Delphi with standard data access components and controls.
-
Import and Visualize Printful Data in Power View
Create data visualizations based on Printful in Excel.
-
Edit and Search External SAP SuccessFactors LMS Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP SuccessFactors LMS to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP SuccessFactors LMS Data objects that you can access from apps and the dashboard.
-
Build Active Directory-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Active Directory and build Active Directory-connected web apps with Axios.
-
How to Build an ETL App for Salesforce Marketing Data in Python with CData
Create ETL applications and real-time data pipelines for Salesforce Marketing Cloud in Python with petl.
-
How to integrate LinkedIn with Apache Airflow
Access and process LinkedIn in Apache Airflow using the CData JDBC Driver.
-
Build Agents in Relevance AI with Access to Live Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Zoho Creator within intelligent agent workflows.
-
How to Query Quaderno Data in MySQL Workbench
Execute MySQL queries against live Quaderno from MySQL Workbench.
-
Access Live SendGrid Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SendGrid from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating GitHub Copilot CLI with Tanda 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.
-
Excel Spreadsheet Automation on GetResponse Data with the QUERY Formula
Pull data from GetResponse, automate spreadsheets, and more with the QUERY formula.
-
How to create an RPA flow for AlloyDB Data in UiPath Studio
Use the AlloyDB ODBC Driver to create workflows that access real-time Google AlloyDB without any coding.
-
Connect to WordPress Data from PowerBuilder via JDBC
This article demonstrates how to access WordPress from PowerBuilder using the WordPress JDBC Driver.
-
Connect Claude to Your Finance and Accounting Data with CData Connect AI Remote MCP Server
Learn how to connect Claude to your finance and accounting data using the CData Connect AI Remote MCP Server and query live data with natural language.
-
Getting Started with the CData JDBC Driver for Bannerbear
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Bannerbear.
-
Connect to and Visualize Live Hive Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apache Hive.
-
Connect to Planio Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Planio and work with Planio in your FileMaker application.
-
Integrating Codex CLI with RSS Feeds 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.
-
Bridge Cvent Connectivity with Apache NiFi
Access and process Cvent in Apache NiFi using the CData JDBC Driver.
-
Connect to Dropbox Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Dropbox to connect to Dropbox and execute queries in PowerBuilder.
-
How to Query Planio Data in MySQL Workbench
Execute MySQL queries against live Planio from MySQL Workbench.
-
Connect to Simplesat Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Simplesat using standard SQL.
-
Use JayDeBeApi to access Confluence Data in Python
Use standard Python scripting and the development environment of your choice to access live Atlassian Confluence.
-
Automate PabblySubscriptions Data Replication to Azure Data Lake
Use CData Sync to customize and automate PabblySubscriptions replication to Azure Data Lake.
-
Connect to Nuclia Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Nuclia in the Denodo Virtual DataPort Administrator.
-
Integrate Live Oracle Service Cloud Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Oracle Service Cloud and integrate live Oracle Service Cloud into apps built in Microsoft Power Apps.
-
Getting Started with the CData Excel Add-In for DB2
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for DB2.
-
Connect to SAS xpt Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAS XPORT.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Neo4J
Provide connectivity to Neo4J through an SAP BusinessObjects universe.
-
Visualize Oracle Eloqua Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Oracle Eloqua.
-
Access Impala Data from MySQL in PHP
Connect to Impala through the standard MySQL libraries in PHP.
-
Access Act-On Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Act-On.
-
Connect to Bitly Data from PowerBuilder via JDBC
This article demonstrates how to access Bitly from PowerBuilder using the Bitly JDBC Driver.
-
Visualize Live Microsoft Planner Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft Planner and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Pinterest Data from PowerBuilder via ADO.NET
This article demonstrates how to access Pinterest from Appeon PowerBuilder using the CData ADO.NET Provider for Pinterest.
-
Automated Continuous Raisers Edge NXT Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to AlloyDB.
-
Use the CData Software ODBC Driver for SendGrid in MicroStrategy Desktop
Connect to SendGrid in MicroStrategy Desktop using the CData Software ODBC Driver for SendGrid.
-
Create Informatica Mappings From/To an ODBC Data Source for Gorgias
Create an ODBC connection to Gorgias in Informatica and browse and transfer Gorgias.
-
Connect to Klaviyo from Asprova with CData Software ODBC Driver for Klaviyo
This article shows how to connect faster to Klaviyo data from Asprova.
-
Visualize Vimeo Data in Sisense
Create an ElastiCube in Sisense app with access to Vimeo.
-
Automated Continuous PivotalTracker Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable PivotalTracker replication to delimited files (CSV/TSV).
-
DataBind Controls to Flowlu Data in C++Builder
DataBind to Flowlu in C++Builder with standard components and controls.
-
Manage Perigon Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Perigon.
-
Migrating data from Spotify to Snowflake using CData SSIS Components.
Easily push Spotify to Snowflake using the CData SSIS Tasks for Spotify and Snowflake.
-
Use the CData Software ODBC Driver for Azure Data Lake Storage in MicroStrategy Desktop
Connect to Azure Data Lake Storage in MicroStrategy Desktop using the CData Software ODBC Driver for Azure Data Lake Storage.
-
Use JayDeBeApi to access Google Cloud Storage Data in Python
Use standard Python scripting and the development environment of your choice to access live Google Cloud Storage.
-
How to connect to SQL Server Data from Spring Boot
Connect to SQL Server in a Spring Boot Application using the CData JDBC Driver for SQL Server
-
Seamlessly Bring Tally Data into Retool Using CData Connect AI
Integrate Tally data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Access SAP BusinessObjects BI Data Using Entity Framework
This article shows how to access SAP BusinessObjects BI using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Deploy the ADO.NET Provider for Paddle on an SSRS Report Server
Connect to Paddle 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 Dropbox-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Dropbox and build web apps with connectivity to live Dropbox.
-
How to Use a Microsoft Access Database to Update SFTP Data in Real Time
Update SFTP data by creating a linked table in Microsoft Access with the CData SFTP ODBC Driver.
-
Connect Quaderno to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Quaderno with IBM WebSphere for seamless data integration and connectivity.
-
Process & Analyze Simplesat Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Simplesat Data.
-
Create IBM Cloud Object Storage-Connected Nintex Workflows
Use CData Connect AI to connect to IBM Cloud Object Storage Data from Nintex Workflow Cloud and build custom workflows using live IBM Cloud Object Storage.
-
Create Reports with Dropbox Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Dropbox.
-
Use the CData Software JDBC Driver for Zoho Projects in MicroStrategy
Connect to Zoho Projects in MicroStrategy Developer using the CData Software JDBC Driver for Zoho Projects.
-
How to update WooCommerce from Excel
This article explains how to transfer data from Excel to WooCommerce using the Excel Add-In for WooCommerce.
-
Add Campaigner Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Campaigner with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Build an ETL App for SurveyMonkey Data in Python with CData
Create ETL applications and real-time data pipelines for SurveyMonkey in Python with petl.
-
How to Connect Zoom Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Zoom data in real time using natural language.
-
Automated Continuous Microsoft OneLake Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to delimited files (CSV/TSV).
-
Connect to Amazon S3 Data in DBArtisan
Use wizards in DBArtisan to configure Amazon S3 as a data source.
-
Design BIRT Reports on Power BI XMLA Data
Provide current Power BI XMLA to your embedded analytics.
-
Getting Started with the CData ODBC Driver for EnterpriseDB
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for EnterpriseDB.
-
Automate EmailOctopus Data Replication to SAP HANA
Use CData Sync to customize and automate EmailOctopus replication to SAP HANA.
-
Automated Continuous Microsoft Entra ID Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to delimited files (CSV/TSV).
-
Configure the CData JDBC Driver for Jodoo in a Connection Pool in Tomcat
Connect to Jodoo from a connection pool in Tomcat.
-
Automated Continuous Hubstaff Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Hubstaff replication to PostgreSQL.
-
Access Live Amazon DynamoDB Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Amazon DynamoDB from your Google Sheets.
-
How to Query Adobe Target Data in MySQL Workbench
Execute MySQL queries against live Adobe Target from MySQL Workbench.