CData Software - Knowledge Base
Recent Articles
-
Query Elasticsearch Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Elasticsearch entities in PHP by modeling them as objects.
-
Automated Continuous SAP HANA Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP HANA replication to PostgreSQL.
-
Connect Landbot Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Landbot data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Feed Office 365 Data into FineReport
How to set Office 365 data as a JDBC data source in FineReport.
-
How to Query Pingdom Data in MySQL Workbench
Execute MySQL queries against live Pingdom data from MySQL Workbench.
-
Validate SAP Netweaver Gateway Data with QuerySurge
Access and validate SAP Netweaver Gateway data in QuerySurge using the CData JDBC Driver.
-
Create Datasets from Close in Domo Workbench and Build Visualizations of Close Data in Domo
Use the CData Software ODBC Driver for Close to create datasets from Close data in Domo Workbench and then build visualizations in the Domo service.
-
Feed SAP Concur Data into FineReport
How to set SAP Concur data as a JDBC data source in FineReport.
-
Getting Started with the CData Tableau Connector for Amplitude
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Use Biml to Build SSIS Tasks to Replicate Unbounce Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Unbounce data to SQL Server.
-
Create MongoDB-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to MongoDB Data from OutSystems and build custom enterprise apps using live MongoDB data.
-
Automated Continuous SharePoint Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SharePoint data replication to OneLake in Microsoft Fabric.
-
Visualize Live Elorus Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Elorus data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Link Toggl with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Toggl data in Filemaker Pro for Mac or Windows.
-
Replicate Multiple Dynamics CRM Accounts
Replicate multiple Dynamics CRM accounts to one or many databases.
-
Build Greenplum-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Greenplum Data and create custom apps in Mendix.
-
Natively Connect to Couchbase Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Couchbase data. Leverage the native support for ODBC in PHP.
-
Use Databricks Agent Bricks to Talk to Your ServiceNow Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your ServiceNow data for you.
-
Query Azure Data Catalog Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Azure Data Catalog entities in PHP by modeling them as objects.
-
Getting Started with the CData Tableau Connector for PagerDuty
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to and Visualize Live Webex Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Webex data.
-
Connecting Pipedream with AlloyDB 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 AlloyDB data in real time.
-
Build a PostgreSQL Interface for FreshBooks Data using the CData JDBC Driver
Use the Remoting features of the FreshBooks JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Power BI Reports on Real-Time SageHR Data
Use the CData ODBC Driver for SageHR to visualize SageHR data in Power BI Desktop.
-
Query Amazon S3 Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Amazon S3 entities in PHP by modeling them as objects.
-
Visualize Live Dropbox Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Dropbox data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Migrating data from Shopify to Snowflake using CData SSIS Components.
Easily push Shopify data to Snowflake using the CData SSIS Tasks for Shopify and Snowflake.
-
Automate Avalara AvaTax Data Replication to SAP HANA
Use CData Sync to customize and automate Avalara AvaTax data replication to SAP HANA.
-
Query Apify Data in ColdFusion
Write standard ColdFusion data access code to connect to Apify data.
-
Connect to Nuclia Data in CloverDX (formerly CloverETL)
Transfer Nuclia data using the visual workflow in the CloverDX data integration tool.
-
How to Connect to Live ShipEngine 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 ShipEngine data for you.
-
Build Apps with Live Wave Financial Data Using the Low-Code Development Platform of Mendix
Connect Wave Financial data with Mendix to build apps using the CData JDBC Driver for Wave Financial.
-
How to Access Microsoft Ads Data Using Entity Framework
This article shows how to access Microsoft Ads data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData Software JDBC Driver for Clockify in MicroStrategy Desktop
Connect to Clockify data in MicroStrategy Desktop using the CData Software JDBC Driver for Clockify.
-
Build Automated SharePoint-Connected Workflows in Zapier
Use CData Connect AI to connect to live SharePoint data and build automated workflows in Zapier.
-
Integrate with ZarMoney Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ZarMoney data to a JSON file on disk.
-
How to Connect to & Open PagerDuty Data in Microsoft Excel
This article uses the CData ODBC driver for PagerDuty to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Antigravity CLI with SQL Analysis Services data via CData CLI
Connect SQL Analysis Services data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Teamwork from Asprova with CData Software ODBC Driver for Teamwork
This article shows how to connect faster to Teamwork data from Asprova.
-
How to connect to Epicor Kinetic Data from Spring Boot
Connect to Epicor Kinetic in a Spring Boot Application using the CData JDBC Driver for Epicor Kinetic
-
Automated Continuous Zoho Projects Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Zoho Projects replication to delimited files (CSV/TSV).
-
How to connect to MailerLite Data with Squirrel SQL client
Connect to MailerLite data and execute queries in the Squirrel SQL Client.
-
Publish Impala-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Impala data.
-
How to use SQLAlchemy ORM to access ADP Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ADP data.
-
Create Reckon Accounts Hosted-Connected Business Apps in AppSheet
Connect to Reckon Accounts Hosted Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Reckon Accounts Hosted data.
-
Visualize Live Google Sheets Data in the Power BI Service
Use CData Connect AI to connect to live Google Sheets data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Outreach.io Data in Tableau
The CData ODBC driver for Outreach.io enables you integrate Outreach.io data into Tableau dashboards.
-
Create Zendesk-Connected Nintex Workflows
Use CData Connect AI to connect to Zendesk Data from Nintex Workflow Cloud and build custom workflows using live Zendesk data.
-
How to connect to Zoho Creator Data in DBVisualizer
Integrate Zoho Creator data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to YouTube Analytics Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for YouTube Analytics data.
-
How to Query Cohere Data in MySQL Workbench
Execute MySQL queries against live Cohere data from MySQL Workbench.
-
Integrating Codex with YouTube Analytics 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 iContact Data in ACL Analytics
Connect to iContact data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to iContact data.
-
Rapidly Develop CapsuleCRM-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by CapsuleCRM.
-
Connect to Testmonitor Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Testmonitor as an External Source in Dremio.
-
Automated Continuous Sage Cloud Accounting Replication to MongoDB
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to MongoDB.
-
Viewing MailerSend Data in RAD Studio Data Explorer
How to view MailerSend data in RAD Studio Data Explorer using the CData ODBC Driver for MailerSend.
-
A PostgreSQL Interface for Apify Data (MySQL Remoting via JDBC)
Use the Remoting features of the Apify JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to create an RPA flow for NetSuite Data in UiPath Studio
Use the NetSuite ODBC Driver to create workflows that access real-time NetSuite data without any coding.
-
Connect to MariaDB Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for MariaDB data.
-
Use the CData Software JDBC Driver for Testmonitor in MicroStrategy Web
Connect to Testmonitor data in MicroStrategy Web using the CData Software JDBC Driver for Testmonitor.
-
Analyze Exa Data in Looker
Use CData Connect AI to connect to Exa Data from Looker and build custom apps using live Exa data.
-
Create Informatica Mappings From/To a JDBC Data Source for Paylocity
Create Paylocity data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData Excel Add-In for Copper
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Copper.
-
Use the CData Software ODBC Driver for Bitbucket in MicroStrategy Desktop
Connect to Bitbucket data in MicroStrategy Desktop using the CData Software ODBC Driver for Bitbucket.
-
Integrating Claude Code CLI with Gmail 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.
-
How to connect SharePoint with Adobe Analytics Data through external lists
Provide Adobe Analytics data to SharePoint users as an external list.
-
Use Grok to Talk to Your Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Splunk data for you.
-
Avaza Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Avaza facts in real time.
-
Publish Miro-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Miro data.
-
Build Data Flows from Zoho Creator to SQL Server using SSIS
Easily back up Zoho Creator data to SQL Server using the SSIS components for Zoho Creator.
-
Publish Foursquare-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Foursquare data.
-
How to connect to SageHR Data with Squirrel SQL client
Connect to SageHR data and execute queries in the Squirrel SQL Client.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Insightly
Provide connectivity to Insightly data through an SAP BusinessObjects universe.
-
Explore Geographical Relationships in SAP HANA XS Advanced Data with Power Map
Create data visualizations with SAP HANA XS Advanced data in Power Map.
-
Access Live MailChimp Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MailChimp data from your Excel spreadsheets.
-
Analyze ShipEngine Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ShipEngine data with the CData JDBC Driver for ShipEngine.
-
Connect to GitHub Data in RapidMiner
Integrate GitHub data with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Apps with Live JDBC-ODBC Bridge Data Using the Low-Code Development Platform of Mendix
Connect JDBC-ODBC Bridge data with Mendix to build apps using the CData JDBC-ODBC Bridge.
-
Moving Data from SharePoint to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SharePoint data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating GitHub Copilot with Azure Table 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.
-
How to Easily Query Parallel Data in OpenOffice Base
Connect to Parallel data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to connect to ClickUp Data from Spring Boot
Connect to ClickUp in a Spring Boot Application using the CData API Driver for JDBC
-
Build an OLAP Cube in SSAS from CapsuleCRM Data
Establish a connection to CapsuleCRM data data from SQL Server Analysis Services, and use the CapsuleCRM Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Use a Microsoft Access Database to Update BigCommerce Data in Real Time
Update BigCommerce data by creating a linked table in Microsoft Access with the CData BigCommerce ODBC Driver.
-
Visualize Live MYOB AccountRight Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MYOB AccountRight data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Migrating data from WordPress to Google BigQuery using CData SSIS Components.
Easily push WordPress data to Google BigQuery using the CData SSIS Tasks for WordPress and Google BigQuery.
-
Use the CData Software ODBC Driver for FHIR in MicroStrategy Web
Connect to FHIR data in MicroStrategy Web using the CData Software ODBC Driver for FHIR.
-
Getting Started with the CData Python Connector for ZohoMarketingHub
Learn to install and license the CData Python Connector and configure a connection to live ZohoMarketingHub data.
-
How to Work with CapsuleCRM Data in ETL Validator JDBC
Connect to CapsuleCRM from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to GitLab Data in DBeaver
Use the CData ODBC Driver to connect to GitLab data in DBeaver.
-
Query Microsoft OneDrive Data as a SQL Server Database in Node.js
Execute SQL Server queries against Microsoft OneDrive data from Node.js.
-
Migrating data from Everhour to Databricks using CData SSIS Components.
Easily push Everhour data to Databricks using the CData SSIS Tasks for Everhour and Databricks.
-
Build Jumpseller-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Jumpseller data and build Jumpseller-connected web apps with Axios.
-
Connect PagerDuty to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect PagerDuty with IBM WebSphere for seamless data integration and connectivity.
-
Natively Connect to Cvent Data in PHP
The CData ODBC driver for Cvent enables you to create PHP applications with connectivity to Cvent data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Planio Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Planio replication to Amazon Redshift.
-
Access Mouseflow Data from MySQL in Amazon QuickSight
Connect to Mouseflow and build visualizations of Mouseflow data using a MySQL Connection in Amazon QuickSight.
-
Visualize Twilio Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Twilio data into TIBCO Spotfire.
-
How to Connect the Power BI Service to Front: Complete Guide
Connect to the CData Software Power BI Connector for Front from PowerBI.com to provide real-time Front data across the organization.