CData Software - Knowledge Base
Recent Articles
-
A PostgreSQL Interface for HCL Domino Data (MySQL Remoting via JDBC)
Use the Remoting features of the HCL Domino JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build an OLAP Cube in SSAS from Basecamp Data
Establish a connection to Basecamp data from SQL Server Analysis Services, and use the Basecamp Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Splunk Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Splunk replication to Azure SQL Database.
-
Build Oracle-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Oracle Database and build web apps with connectivity to live Oracle Database.
-
Query Quickbase Data as a SQL Server Database in Node.js
Execute SQL Server queries against Quickbase from Node.js.
-
Automated Continuous Yelp Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Yelp replication to IBM DB2.
-
Automated Continuous ZarMoney Replication to MongoDB
Use CData Sync for automated, continuous, customizable ZarMoney replication to MongoDB.
-
Build Amazon Marketplace-Connected Apps in Choreo
Use CData Connect AI to connect to Amazon Marketplace Data from Choreo and build custom apps using live Amazon Marketplace.
-
Use Biml to Build SSIS Tasks to Replicate Google Sheets Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Sheets to SQL Server.
-
Connect to Real-Time Factorial Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Factorial in Power Apps.
-
Build Dynamics 365-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Dynamics 365 to explore live Dynamics 365 Data in Cursor to assist with building Dynamics 365-powered applications.
-
Design BIRT Reports on Bugsnag Data
Provide current Bugsnag to your embedded analytics.
-
Integrate Theia IDE with Live Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Using Cookie-Based Authentication with the CData SharePoint Data Provider.
The SharePoint Data Provider offers connectivity with an on-premise SharePoint Server as well as SharePoint Online and Office 365. This walk-through demonstrates how to properly authenticate and connect to SharePoint Online / Office 365.
-
How to publish and share Instagram Data dashboards with Tableau Server
The CData ODBC driver for Instagram enables you integrate Instagram into Tableau dashboards.
-
Load Sybase IQ Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Sybase IQ to a database.
-
Connecting Mastra with SurveyMonkey Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time SurveyMonkey, no replication required.
-
Connect SAP HANA Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP HANA using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to and Visualize Live Dynamics NAV Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Dynamics NAV.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zuora
Provide connectivity to Zuora through an SAP BusinessObjects universe.
-
ETL Recurly in Oracle Data Integrator
This article shows how to transfer Recurly into a data warehouse using Oracle Data Integrator.
-
How to Visualize Azure Synapse Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure Synapse in Python.
-
Create HBase-Connected Dashboards in Grafana
Connect to HBase Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Apache HBase.
-
How to publish and share Google Cloud Storage Data dashboards with Tableau Server
The CData ODBC driver for Google Cloud Storage enables you integrate Google Cloud Storage into Tableau dashboards.
-
Build AI/ML Models with Live SAP Data using Dataiku
Connect SAP Data with Dataiku using the CData JDBC Driver for SAP.
-
Analyze Blackbaud FE NXT Data in Cognos Analytics
Use CData Connect AI to connect to Blackbaud FE NXT Data from Cognos Analytics and analyze live Blackbaud FE NXT.
-
Visualize Live ServiceNow Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ServiceNow using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Microsoft Exchange Data in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft Exchange in FileMaker Pro to connect to Microsoft Exchange and work with Microsoft Exchange in your FileMaker applications.
-
How to Work with BambooHR Data in AWS Glue Jobs Using JDBC
Connect to BambooHR from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Visualizations of Sage Intacct Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Sage Intacct in Birst.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live ServiceNow using the Model Context Protocol.
-
Access Live JobNimbus Data in Coginiti Pro
Connect to and query live JobNimbus from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData ODBC Driver for SAP Hybris C4C from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP Hybris C4C to connect to SAP Hybris C4C from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP Hybris C4C in Excel.
-
Build Charts with Amazon S3 Data in Clear Analytics
Create dynamic charts and perform analytics based on Amazon S3 in Clear Analytics.
-
Automated Continuous Zoho Books Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Zoho Books replication to Google BigQuery.
-
Connect to Elorus in SpagoBI
Create reports featuring live Elorus in SpagoBI Studio. Host Elorus reports on SpagoBI Server.
-
Use the CData ODBC Driver for Templated from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Templated to connect to Templated from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Templated in Excel.
-
Automated Continuous Testmonitor Replication to MySQL
Use CData Sync for automated, continuous, customizable Testmonitor replication to MySQL.
-
How to Build an ETL App for Hugging Face Data in Python with CData
Create ETL applications and real-time data pipelines for Hugging Face in Python with petl.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Google Cloud Storage to Power BI dashboards. Simply drag and drop Google Cloud Storage into data visuals on the Power BI canvas.
-
A PostgreSQL Interface for Oracle Financials Cloud Data (MySQL Remoting via JDBC)
Use the Remoting features of the Oracle Financials Cloud JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Xero Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Xero Accounting in the Denodo Virtual DataPort Administrator.
-
Analyze OneNote Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft OneNote and visualize Microsoft OneNote in SAP Analytics Cloud.
-
Connect to SAS xpt Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAS XPORT from Filemaker Pro on Mac.
-
Connect to NetSuite Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use the CData ODBC Driver for SendPulse in Microsoft Power Query
You can use the CData SendPulse ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SendPulse into Microsoft Power Query.
-
Create Oracle Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Oracle data access from reports, embedded analytics, and more.
-
Natively Connect to Act-On Data in PHP
The CData ODBC driver for Act-On enables you to create PHP applications with connectivity to Act-On. Leverage the native support for ODBC in PHP.
-
Build a PostgreSQL Interface for Amazon Marketplace Data using the CData JDBC Driver
Use the Remoting features of the Amazon Marketplace JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Zoho Books Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Zoho Books and visualize live Zoho Books in Infragistics Reveal.
-
Query Egnyte Data in ColdFusion
Write standard ColdFusion data access code to connect to Egnyte.
-
Create Datasets from Postmark in Domo Workbench and Build Visualizations of Postmark Data in Domo
Use the CData Software ODBC Driver for Postmark to create datasets from Postmark in Domo Workbench and then build visualizations in the Domo service.
-
DataBind Amazon Marketplace Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Amazon Marketplace with the DevExpress Windows Forms and Web controls to provide Amazon Marketplace to a chart.
-
Connect to Google Analytics Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Analytics Data and connect to Google Analytics in Akorbi Digital RunMyProcess.
-
Integrate Anaplan Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Anaplan from Informatica Cloud.
-
Configure the CData JDBC Driver for HBase in a Connection Pool in Tomcat
Connect to Apache HBase from a connection pool in Tomcat.
-
Build a Simple VCL Application for Parquet Data
How to build a simple VCL Application to view Apache Parquet in RAD Studio using the CData ODBC Driver for Parquet.
-
LINQ to Paylocity 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 Paylocity Data Provider.
-
Query PayPal Data through ODBC in Node.js
Use node-odbc to execute SQL queries against PayPal from Node.js.
-
Connect to Adobe Experience Manager Data in RapidMiner
Integrate Adobe Experience Manager with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Okta Data from MySQL in PHP
Connect to Okta through the standard MySQL libraries in PHP.
-
Connect to SQL Analysis Services Data from a Connection Pool in Jetty
The SQL Analysis Services JDBC Driver supports connection pooling: This article shows how to connect faster to SQL Analysis Services from Web apps in Jetty.
-
Validate Customer.io Data with QuerySurge
Access and validate Customer.io in QuerySurge using the CData JDBC Driver.
-
Connect to FreshBooks Data in DBArtisan
Use wizards in DBArtisan to configure FreshBooks as a data source.
-
Visualize Live GitLab Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live GitLab.
-
How to Work with Facebook Data in ETL Validator JDBC
Connect to Facebook from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect to QuickBooks Time Data from IntelliJ
Integrate connectivity to QuickBooks Time with wizards in IntelliJ.
-
Analyze BigQuery Data in Looker
Use CData Connect AI to connect to BigQuery Data from Looker and build custom apps using live Google BigQuery.
-
Connect to Certinia Data in JRuby
Create a simple JRuby app with access to live Certinia.
-
Analyze Foursquare Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Foursquare from Power Pivot. You will use the Table Import Wizard to load Foursquare. You can visually build the import query or use any SQL supported by the driver.
-
Working with Reckon Data in LINQPad
Execute LINQ queries to Reckon in LINQPad.
-
How to Query Live Avaza Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Avaza data in natural language using Python.
-
Automated Continuous ClickTime Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ClickTime replication to PostgreSQL.
-
A PostgreSQL Interface for Quaderno Data (MySQL Remoting via JDBC)
Use the Remoting features of the Quaderno JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Databricks Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Databricks and build visualizations in Tableau.
-
How to create an RPA flow for Freshsales Data in UiPath Studio
Use the Freshsales ODBC Driver to create workflows that access real-time Freshsales without any coding.
-
Query ServiceDesk Plus Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ServiceDesk Plus from Node.js.
-
Use Agno to Talk to Your Azure Synapse 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 Azure Synapse for you.
-
Use the CData Software ODBC Driver for Azure Analysis Services in MicroStrategy Web
Connect to Azure Analysis Services in MicroStrategy Web using the CData Software ODBC Driver for Azure Analysis Services.
-
View Reports on Real-Time ClickUp Data in Power BI Report Server
Use the CData ODBC Driver for ClickUp to visualize ClickUp in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Query Rootly Data in MySQL Workbench
Execute MySQL queries against live Rootly from MySQL Workbench.
-
How to integrate Tavily with Apache Airflow
Access and process Tavily in Apache Airflow using the CData JDBC Driver.
-
Integrate Cline with Live Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Analytics from within your IDE.
-
How to Visualize LeadDesk Data in Python with pandas
Use pandas and other modules to analyze and visualize live LeadDesk in Python.
-
Connect to Hugging Face Data in Aqua Data Studio
Access Hugging Face from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Automated Workflows with Live Google Sheets Data in Workato
Use CData Connect AI to connect to live Google Sheets and build automated workflows in Workato.
-
How to Use a Microsoft Access Database to Update Snapchat Ads Data in Real Time
Update Snapchat Ads data by creating a linked table in Microsoft Access with the CData Snapchat Ads ODBC Driver.
-
Query Zuora Data as a SQL Server Database in Node.js
Execute SQL Server queries against Zuora from Node.js.
-
Connect to Pushbullet Data in JRuby
Create a simple JRuby app with access to live Pushbullet.
-
Access Autopilot Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Autopilot from HeidiSQL.
-
How to Connect to Live Cvent 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 Cvent for you.
-
Bidirectional Access to Zoho Projects Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Zoho Projects in Filemaker Pro for Mac or Windows.
-
How to Connect to Live SAP SuccessFactors LMS 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 SAP SuccessFactors LMS without replication.
-
How to Query Klaviyo Data in MySQL Workbench
Execute MySQL queries against live Klaviyo from MySQL Workbench.
-
How to Connect to & Open Yelp Data in Microsoft Excel
This article uses the CData ODBC driver for Yelp to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData SSIS Components to Insert New or Update Existing Adobe Commerce Records from SQL Server
Easily push SQL Server data to Adobe Commerce using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Adobe Commerce or update existing records with data from a SQL Server database.
-
Access Live ClickUp Data in AWS Lambda
Connect to live ClickUp in AWS Lambda using the CData JDBC Driver.
-
Enable the LinkedIn JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with LinkedIn.
-
Integrate Basecamp with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Basecamp with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Basecamp.
-
Automated Continuous IBM Informix Replication to SingleStore
Use CData Sync for automated, continuous, customizable IBM Informix replication to SingleStore.