CData Software - Knowledge Base
Recent Articles
-
Access Short.io 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 Short.io data.
-
How to connect to Accelo Data from Spring Boot
Connect to Accelo in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous ConstantContact Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ConstantContact replication to AlloyDB.
-
Visualize SFTP Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SFTP data.
-
Creating WooCommerce-Connected Applications in Unqork
You can use CData Connect AI to feed WooCommerce data to Unqork and build custom business apps.
-
Connect to Azure Analysis Services Data from PowerBuilder via ADO.NET
This article demonstrates how to access Azure Analysis Services data from Appeon PowerBuilder using the CData ADO.NET Provider for Azure Analysis Services.
-
Automated Continuous Helpscout Replication to Oracle
Use CData Sync for automated, continuous, customizable Helpscout replication to Oracle.
-
Access AgileCRM Data from MySQL in Amazon QuickSight
Connect to AgileCRM and build visualizations of AgileCRM data using a MySQL Connection in Amazon QuickSight.
-
Query, Visualize, and Share live GitLab Data in Redash
Use CData Connect AI to connect to live GitLab data in Redash for querying, visualizing, and sharing.
-
Create Dashboards and Visualize Live Oracle Data in Geckoboard
Use CData Connect AI to connect to live Oracle data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create Dynamic SAP HANA Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP HANA to Infragistics XamDataGrid to build dynamic grids.
-
Query Google Tasks Data in DataGrip
Create a Data Source for Google Tasks in DataGrip and use SQL to query live Google Tasks data.
-
Connect Email Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Email data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData Python Connector for Apollo
Learn to install and license the CData Python Connector and configure a connection to live Apollo data.
-
Migrating data from MYOB AccountRight to Google BigQuery using CData SSIS Components.
Easily push MYOB AccountRight data to Google BigQuery using the CData SSIS Tasks for MYOB AccountRight and Google BigQuery.
-
How to integrate LightSpeedRetail with Apache Airflow
Access and process LightSpeedRetail data in Apache Airflow using the CData JDBC Driver.
-
Use ChatGPT to Talk to Your Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Pipedrive data for you.
-
Connect to HBase from Asprova with CData Software ODBC Driver for HBase
This article shows how to connect faster to HBase data from Asprova.
-
Integrating Dataiku with Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Salesforce Marketing data.
-
How to create BenchmarkEmail federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for BenchmarkEmail data in MySQL .
-
Automated Continuous GitHub Replication to SQL Server
Use CData Sync for automated, continuous, customizable GitHub replication to SQL Server.
-
Use the CData Software JDBC Driver for Freshteam in MicroStrategy
Connect to Freshteam data in MicroStrategy Developer using the CData Software JDBC Driver for Freshteam.
-
Connect to MailChimp Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for MailChimp data in Airbyte.
-
Getting Started with the CData Connect AI Python SDK for Zuora
Install the CData Connect AI Python SDK to read live Zuora data with standard DB-API 2.0 Python code.
-
Connect to Tanda Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Tanda and the SQL Gateway to access Tanda data from Google Apps Script.
-
How to Create Power BI Visual Reports with Real-Time DB2 Data
Use CData Power BI Connectors to visualize DB2 data in Power BI.
-
Create Reports with Tally Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Tally data.
-
Getting Started with the CData ODBC Driver for Autopilot
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Autopilot.
-
How to Work with HDFS Data in ETL Validator JDBC
Connect to HDFS from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Reckon Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Reckon replication to IBM DB2.
-
How to connect to Oracle HCM Cloud Data with Squirrel SQL client
Connect to Oracle HCM Cloud data and execute queries in the Squirrel SQL Client.
-
Migrating data from OData to Databricks using CData SSIS Components.
Easily push OData services to Databricks using the CData SSIS Tasks for OData and Databricks.
-
Connect to OData Services from PowerBuilder via JDBC
This article demonstrates how to access OData services from PowerBuilder using the OData JDBC Driver.
-
Automate Excel Online Data Replication to Azure Data Lake
Use CData Sync to customize and automate Excel Online data replication to Azure Data Lake.
-
Create Power BI Reports on Real-Time Exact Online Data
Use the CData ODBC Driver for Exact Online to visualize Exact Online data in Power BI Desktop.
-
Integrating Cursor with SharePoint 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.
-
Use the CData Software ODBC Driver for Missive in MicroStrategy
Connect to Missive data in MicroStrategy Developer using the CData Software ODBC Driver for Missive.
-
How to Connect to Airtable Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Airtable data. Leverage the pyodbc module for ODBC in Python.
-
Import GitLab Data Using Azure Data Factory
Use CData Connect AI to connect to GitLab Data from Azure Data Factory and import live GitLab data.
-
Moving Data from Sybase to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Sybase data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to connect to ConvertKit Data with Squirrel SQL client
Connect to ConvertKit data and execute queries in the Squirrel SQL Client.
-
Access Live Oracle Service Cloud Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Oracle Service Cloud data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Enable the CampaignMonitor JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with CampaignMonitor data.
-
Integrate LibreChat with Live Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google Ads data from within the chat interface.
-
Create Google Ad Manager-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Google Ad Manager Data from OutSystems and build custom enterprise apps using live Google Ad Manager data.
-
Connect to Box from a Connection Pool in WebLogic
Use the CData JDBC Driver for Box to connect to Box data from Web applications running on WebLogic.
-
Connect to Databricks Data in Aqua Data Studio
Access Databricks data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect and Query Live Salesforce Marketing Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Salesforce Marketing data into Databricks and enable direct, live querying and analysis without replication.
-
Build Workday-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Workday Data from Zoho Analytics and import live Workday data.
-
Integrate with Pinterest Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Pinterest data to a JSON file on disk.
-
Integrate Cursor with Live Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Zendesk data from within the editor.
-
How to Build an ETL App for Zendesk Data in Python with CData Connect AI
Build ETL pipelines that read and write live Zendesk data in Python with petl and the CData Connect AI Python SDK.
-
How to Connect to Paylocity Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Paylocity data. Leverage the pyodbc module for ODBC in Python.
-
Getting Started with the CData Excel Add-In for ZohoDesk
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ZohoDesk.
-
Migrating data from SharePoint to Databricks using CData SSIS Components.
Easily push SharePoint data to Databricks using the CData SSIS Tasks for SharePoint and Databricks.
-
How to Build an ETL App for SFTP Data in Python with CData
Create ETL applications and real-time data pipelines for SFTP data in Python with petl.
-
Access Live Stripe 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 Stripe data through MCP integration.
-
Getting Started with the CData Power BI Connector for Nuclia
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create Informatica Mappings From/To an ODBC Data Source for MYOB AccountRight
Create an ODBC connection to MYOB AccountRight in Informatica and browse and transfer MYOB AccountRight data.
-
Connect to Tickspot Data in HULFT Integrate
Connect to Tickspot as a JDBC data source in HULFT Integrate
-
Create SSAS Tabular Models from OData Services
How to build a SQL Server Analysis Service Tabular Model from OData services using CData drivers.
-
Integrating Antigravity CLI with EmailOctopus data via CData CLI
Connect EmailOctopus data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Create Power BI Visual Reports with Real-Time Dynamics 365 Business Central Data
Use CData Power BI Connectors to visualize Dynamics 365 Business Central data in Power BI.
-
Automated Continuous IBM Informix Replication to Snowflake
Use CData Sync for automated, continuous, customizable IBM Informix replication to Snowflake.
-
Build Dynamics 365 Business Central-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Dynamics 365 Business Central data.
-
Connect to IBM Cloud Object Storage Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time IBM Cloud Object Storage data using standard SQL.
-
Connect to Dropbox from a Connection Pool in WebLogic
Use the CData JDBC Driver for Dropbox to connect to Dropbox data from Web applications running on WebLogic.
-
Design BIRT Reports on Hubstaff Data
Provide current Hubstaff data to your embedded analytics.
-
How to create an RPA flow for Salesforce Marketing Data in UiPath Studio
Use the Salesforce Marketing ODBC Driver to create workflows that access real-time Salesforce Marketing data without any coding.
-
Build a Singer.io Tap for Amazon Athena With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Amazon Athena data using the CData Python Connector.
-
Import and Visualize Oracle SCM Data in Power View
Create data visualizations based on Oracle SCM data in Excel.
-
Validate SAP BusinessObjects BI Data with QuerySurge
Access and validate SAP BusinessObjects BI data in QuerySurge using the CData JDBC Driver.
-
Query Live Vault CRM Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Vault CRM data directly from the development environment.
-
Connect to Greenplum from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Greenplum data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to connect to REST Data with Squirrel SQL client
Connect to REST data and execute queries in the Squirrel SQL Client.
-
Integrating Gumloop with Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft Dataverse data within automated workflows.
-
Query Printify Data as a SQL Server Database in Node.js
Execute SQL Server queries against Printify data from Node.js.
-
Publish Eventbrite-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Eventbrite data.
-
Automated Continuous HubSpot Replication to SingleStore
Use CData Sync for automated, continuous, customizable HubSpot replication to SingleStore.
-
Deploy the ADO.NET Provider for SAP on an SSRS Report Server
Connect to SAP 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.
-
Access Live Reckon Accounts Hosted Data in AWS Lambda
Connect to live Reckon Accounts Hosted data in AWS Lambda using the CData JDBC Driver.
-
Connect to QuickBooks Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for QuickBooks data.
-
Use Agno to Talk to Your Odoo 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 Odoo data for you.
-
Build Apify-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Apify Data and create custom apps in Mendix.
-
How to import Sage 200 Data into Apache Solr
Use the CData Software JDBC Driver for Sage 200 in Data Import Handler and create an automated import of Sage 200 data to Apache Solr Enterprise Search platform.
-
Create Impala-Connected Nintex Workflows
Use CData Connect AI to connect to Impala Data from Nintex Workflow Cloud and build custom workflows using live Impala data.
-
Replicate Deel Data from PowerShell
Write a quick PowerShell script to query Deel data. Use connectivity to the live data to replicate Deel data to SQL Server.
-
Connect to WordPress from Asprova with CData Software ODBC Driver for WordPress
This article shows how to connect faster to WordPress data from Asprova.
-
Analyze Exa Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Exa data with the CData JDBC Driver for Exa.
-
Replicate Mode Data in Heroku for Use in Salesforce Connect
Replicate Mode data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Apps with Live Recurly Data Using the Low-Code Development Platform of Mendix
Connect Recurly data with Mendix to build apps using the CData API Driver for JDBC.
-
DataBind Pipeliner CRM Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Pipeliner CRM data to a chart.
-
Viewing SQL Server Data in RAD Studio Data Explorer
How to view SQL Server data in RAD Studio Data Explorer using the CData ODBC Driver for SQL Server.
-
Apollo Reporting in OBIEE with the Apollo JDBC Driver
Deploy the Apollo JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Exact Online Data Replication to Teradata
Use CData Sync to Customize and automate Exact Online data replication to Teradata.
-
Use Dash to Build to Web Apps on ChargeOver Data
Create Python applications that use pandas and Dash to build ChargeOver-connected web apps.
-
Connect to Smartsheet Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Smartsheet data.
-
Create WooCommerce Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time WooCommerce data access from reports, embedded analytics, and more.
-
Visualize Live Elasticsearch Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Elasticsearch data.
-
Connect to Sage Intacct Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Sage Intacct.