CData Software - Knowledge Base
Recent Articles
-
Automated Continuous HubSpot Replication to Snowflake
Use CData Sync for automated, continuous, customizable HubSpot replication to Snowflake.
-
How to connect PolyBase to Gmail
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Gmail.
-
Seamlessly Bring Databricks into Retool Using CData Connect AI
Integrate Databricks data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Xero from Asprova with CData Software ODBC Driver for Xero
This article shows how to connect faster to Xero data from Asprova.
-
Use Dash to Build to Web Apps on Act-On
Create Python applications that use pandas and Dash to build Act-On-connected web apps.
-
Connect to SuiteCRM in RazorSQL
Connect to SuiteCRM from wizards and query SuiteCRM from the GUI in the RazorSQL database management tool.
-
Automated Continuous Parquet Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Parquet replication to AlloyDB.
-
How to connect SharePoint with Cosmos DB through external lists
Provide Azure Cosmos DB to SharePoint users as an external list.
-
Automated Continuous Coinbase Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Coinbase replication to PostgreSQL.
-
Natively Connect to Zoho Books in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Zoho Books. Leverage the native support for ODBC in PHP.
-
Using the CData Software ODBC Driver for Dynamics 365 Business Central in PyCharm
Connect to Dynamics 365 Business Central as an ODBC data source in PyCharm using the CData Software ODBC Driver for Dynamics 365 Business Central.
-
Operational Reporting on Power BI XMLA from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Power BI XMLA.
-
Operational Reporting on Dropbox from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Dropbox.
-
DataBind Controls to SAP Fieldglass in C++Builder
DataBind to SAP Fieldglass in C++Builder with standard components and controls.
-
Process & Analyze Reckon Accounts Hosted in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Reckon Accounts Hosted .
-
Bidirectional Access to Klaviyo from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Klaviyo in Filemaker Pro for Mac or Windows.
-
Creating Snowflake-Connected Applications in Unqork
You can use CData Connect AI to feed Snowflake to Unqork and build custom business apps.
-
Manage Bing Ads in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Bing Ads.
-
Choosing the Best Method to Connect Avalara AvaTax to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Avalara AvaTax from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Enable the PingOne JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with PingOne.
-
Replicate Multiple Azure DevOps Accounts via the CData Sync CLI
Replicate multiple Azure DevOps accounts to one or many databases.
-
How to Connect Google Campaign Manager 360 to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Google Campaign Manager 360 data in real time using natural language.
-
Build Trello Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Trello and build visualizations in Tableau Cloud.
-
Extend Google Sheets with SharePoint Excel Services
Make calls to the API Server from Google Apps Script.
-
DataBind Controls to Jira Assets in Delphi
DataBind to Jira Assets in Delphi with standard data access components and controls.
-
Analyze Google Analytics in Looker
Use CData Connect AI to connect to Google Analytics from Looker and build custom apps using live Google Analytics.
-
Create SAP ByDesign-Connected Dashboards in Grafana
Connect to SAP ByDesign via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP Business ByDesign.
-
Xero Reporting in OBIEE with the Xero JDBC Driver
Deploy the Xero JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to eBay from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for eBay to connect to eBay and execute queries in PowerBuilder.
-
Natively Connect to Salesforce Marketing in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Salesforce Marketing Cloud. Leverage the native support for ODBC in PHP.
-
Access Klipfolio from MySQL in PHP
Connect to Klipfolio through the standard MySQL libraries in PHP.
-
Use Microsoft Copilot Studio to talk to your Epicor Kinetic via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Epicor Kinetic for you.
-
Build a Simple VCL Application for Unbounce
How to build a simple VCL Application to view Unbounce in RAD Studio using the CData ODBC Driver for Unbounce.
-
Use Biml to Build SSIS Tasks to Replicate Neo4J to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Neo4J to SQL Server.
-
How to connect SharePoint with Drip through external lists
Provide Drip to SharePoint users as an external list.
-
Connect to Instagram in NetBeans
Connect to Instagram in NetBeans with the data source configuration wizard.
-
Extend Google Sheets with Acumatica
Make calls to the API Server from Google Apps Script.
-
Box Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Box facts in real time.
-
Enable the CockroachDB JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with CockroachDB.
-
How to connect to Access in DBVisualizer
Integrate Microsoft Access with visual data analysis tools and data connection wizards in DBVisualizer
-
Query GitHub in ColdFusion
Write standard ColdFusion data access code to connect to GitHub.
-
Import Real-Time Excel Online via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Excel Online in ColdFusion.
-
Excel Spreadsheet Automation on Todoist with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Build Zoho Creator-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Zoho Creator.
-
Integrate HubDB in the Pentaho Report Designer
Publish reports based on HubDB in the Pentaho BI tool.
-
Use the CData Software ODBC Driver for SingleStore in MicroStrategy Desktop
Connect to SingleStore in MicroStrategy Desktop using the CData Software ODBC Driver for SingleStore.
-
How to Connect to Live Tableau CRM Analytics 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 Tableau CRM Analytics through natural language.
-
Connect and Query Live Sage 200 Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Sage 200 into Databricks
-
Connect to Sage Cloud Accounting as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Sage Business Cloud Accounting.
-
Automated Continuous eBay Analytics Replication to IBM DB2
Use CData Sync for automated, continuous, customizable eBay Analytics replication to IBM DB2.
-
Feed Microsoft Teams into FineReport
How to set Microsoft Teams as a JDBC data source in FineReport.
-
How to connect to JotForm from Spring Boot
Connect to JotForm in a Spring Boot Application using CData JDBC JotForm Driver
-
Stream Authorize.Net into Apache Kafka Topics
Access and stream Authorize.Net in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Analyze Oracle SCM with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Oracle SCM from Power Pivot. You will use the Table Import Wizard to load Oracle SCM. You can visually build the import query or use any SQL supported by the driver.
-
Manage ClickUp in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ClickUp.
-
How to Connect the Power BI Service to AlloyDB: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Build Dashboards with Invoiced in Dundas BI
Create dynamic dashboards and perform analytics based on Invoiced in Dundas BI.
-
A PostgreSQL Interface for Spark using the CData ODBC Driver
Use the SQL Gateway and Spark ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Redis Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Redis securely in real time.
-
Integrate QuickBooks Time with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate QuickBooks Time with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to QuickBooks Time.
-
Edit and Search Neo4J External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Neo4J to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Neo4J objects that you can access from apps and the dashboard.
-
How to Query Live Azure Data Catalog in Perplexity MacOS Desktop
Connect to and query live Azure Data Catalog in Perplexity Desktop using CData Code Assist MCP.
-
Query Live eBay 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 eBay directly from the development environment.
-
Automate Splunk Replication to Azure Synapse
Use CData Sync to customize and automate Splunk replication to Azure Synapse.
-
Access Live Zoho CRM Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Zoho CRM data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use the CData Software ODBC Driver for Microsoft Exchange in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft Exchange in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Microsoft Exchange.
-
Getting Started with the CData ODBC Driver for HubSpot
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for HubSpot.
-
How to Access Live Couchbase in Visual Studio Code via Cline
-