CData Software - Knowledge Base
Recent Articles
-
Connect to Microsoft Planner from Asprova with CData Software ODBC Driver for Microsoft Planner
This article shows how to connect faster to Microsoft Planner data from Asprova.
-
Build Data Flows from Amazon Marketplace to SQL Server using SSIS
Easily back up Amazon Marketplace to SQL Server using the SSIS components for Amazon Marketplace.
-
Connect and Query Live Reckon Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Reckon into Databricks
-
How to Connect DBeaver to Clio via a JDBC Driver
Manage Clio with visual tools in DBeaver like the query browser.
-
Access Bitbucket 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 Bitbucket.
-
Publish Crystal Reports on Snowflake
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Snowflake.
-
Access Procore from MySQL in PHP
Connect to Procore through the standard MySQL libraries in PHP.
-
Automated Continuous LinkedIn Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable LinkedIn replication to Apache Cassandra.
-
Google Spanner Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Spanner facts in real time.
-
Connecting Mastra with Oracle HCM Cloud 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 data across 300+ enterprise sources no replication required.
-
Replicate Sage 300 in Heroku for Use in Salesforce Connect
Replicate Sage 300 to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Query Klaviyo through ODBC in Node.js
Use node-odbc to execute SQL queries against Klaviyo from Node.js.
-
Replicate Vault CRM to Multiple Databases
Replicate Veeva Vault & Vault CRM to disparate databases with a point-and-click configuration.
-
Connect to Klipfolio in Google Apps Script via SQL Gateway
Use the ODBC Driver for Klipfolio and the SQL Gateway to access Klipfolio from Google Apps Script.
-
CData Connect AI Quickstart
Everything you need to get started with data connectivity as a service.
-
How to Query Live Splunk Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Splunk data in natural language using Python.
-
Use the CData ODBC Driver for Dynamics 365 Business Central in Microsoft Power Query
You can use the CData Dynamics 365 Business Central ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Dynamics 365 Business Central into Microsoft Power Query.
-
Using the CData Software ODBC Driver for Gmail in PyCharm
Connect to Gmail as an ODBC data source in PyCharm using the CData Software ODBC Driver for Gmail.
-
Publish Crystal Reports on MarkLogic
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MarkLogic.
-
Connect to CockroachDB in JRuby
Create a simple JRuby app with access to live CockroachDB.
-
Extract, Transform, and Load TaxJar in Informatica PowerCenter
Create a simple Workflow for TaxJar in Informatica PowerCenter.
-
Getting Started with the CData ODBC Driver for SAP Ariba Source
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP Ariba Source.
-
Connect to SAP HANA XS Advanced in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use the CData Software JDBC Driver for Office 365 in MicroStrategy Web
Connect to Microsoft Office 365 in MicroStrategy Web using the CData Software JDBC Driver for Office 365.
-
Migrating data from Oracle SCM to Databricks using CData SSIS Components.
Easily push Oracle SCM to Databricks using the CData SSIS Tasks for Oracle SCM and Databricks.
-
Access Live Azure Active Directory in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Azure Active Directory from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Query Live TaxJar in Perplexity MacOS Desktop
Connect to and query live TaxJar in Perplexity Desktop using the CData MCP Server.
-
How to Access Live Oracle Service Cloud in Visual Studio Code via Cline
Run the CData MCP Server for Oracle Service Cloud on Windows Subsytem for Linux (WSL) and connect to live Oracle Service Cloud from the Cline extension in Visual Studio Code.
-
How to Connect the Power BI Service to Slack: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Automated Continuous SharePoint Excel Services Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Amazon Redshift.
-
Import Real-Time SAP via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP ERP/NetWeaver in ColdFusion.
-
Build Dashboards with FTP in Dundas BI
Create dynamic dashboards and perform analytics based on FTP Servers in Dundas BI.
-
Connect to WooCommerce from a Connection Pool in WebLogic
Use the CData JDBC Driver for WooCommerce to connect to WooCommerce from Web applications running on WebLogic.
-
How to connect and process Microsoft Dynamics NAV from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Dynamics NAV.
-
Stream Jira Service Management into Apache Kafka Topics
Access and stream Atlassian Jira Service Management in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Visualize SingleStore Data in Python with pandas
Use pandas and other modules to analyze and visualize live SingleStore in Python.
-
Write a Simple Go Application to work with Azure Data Lake Storage on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Azure Data Lake Storage.
-
Integrating LangGraph with Oracle Sales via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Oracle Sales within automated workflows.
-
How to Connect Flowise AI Agents to Live MongoDB via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
Visualize ActiveCampaign in Tableau
The CData ODBC driver for ActiveCampaign enables you integrate ActiveCampaign into Tableau dashboards.
-
Build a PostgreSQL Interface for QuickBooks Online using the CData JDBC Driver
Use the Remoting features of the QuickBooks Online JDBC Driver to create a PostgreSQL entry-point for data access.
-
Feed Kafka into FineReport
How to set Apache Kafka as a JDBC data source in FineReport.
-
Build Azure Analysis Services Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Azure Analysis Services and build visualizations in Tableau.
-
Connect to PostgreSQL from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time PostgreSQL using standard SQL.
-
Connect to Oracle SCM in DBArtisan
Use wizards in DBArtisan to configure Oracle SCM as a data source.
-
Create GraphQL-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to GraphQL from OutSystems and build custom enterprise apps using live GraphQL.
-
Edit and Search Clio External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Clio to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Clio objects that you can access from apps and the dashboard.
-
Bridge SuiteCRM Connectivity with Apache NiFi
Access and process SuiteCRM in Apache NiFi using the CData JDBC Driver.
-
Integrate Cursor with Live Odoo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Odoo ERP from within the editor.
-
Use the CData Software ODBC Driver for Google Campaign Manager 360 in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Campaign Manager 360 in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Campaign Manager 360.
-
Create Reports with Zoho Creator in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoho Creator.
-
Connect to Live Adobe Commerce in PostGresSQL Interface through CData Connect AI
Create a live connection to Adobe Commerce in CData Connect AI and connect to your Adobe Commerce from PostgreSQL.
-
Connect to Printify in Google Apps Script via SQL Gateway
Use the ODBC Driver for Printify and the SQL Gateway to access Printify from Google Apps Script.
-
Use the CData Software JDBC Driver for Act CRM in MicroStrategy Web
Connect to Act CRM in MicroStrategy Web using the CData Software JDBC Driver for Act CRM.
-
Publish HarperDB-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live HarperDB.
-
Create Informatica Mappings From/To an ODBC Data Source for Slack
Create an ODBC connection to Slack in Informatica and browse and transfer Slack.
-
Natively Connect to Act-On 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.
-
How to create an RPA flow for Vault CRM in UiPath Studio
Use the Vault CRM ODBC Driver to create workflows that access real-time Veeva Vault & Vault CRM without any coding.
-
Connect to Oracle Eloqua Reporting in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use Biml to Build SSIS Tasks to Replicate Clio to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Clio to SQL Server.
-
Migrating data from Cosmos DB to Snowflake using CData SSIS Components.
Easily push Azure Cosmos DB to Snowflake using the CData SSIS Tasks for Cosmos DB and Snowflake.
-
Connect to Zoho Projects in Aqua Data Studio
Access Zoho Projects from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Calendly-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Calendly.
-
Connect SFTP to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SFTP using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect and process Drip from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Drip.
-
How to Create Power BI Visual Reports with Real-Time QuickBooks Online
Use CData Power BI Connectors to visualize QuickBooks Online in Power BI.
-
Use the CData ODBC Driver for Salesforce Pardot from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Salesforce Pardot to connect to Salesforce Pardot from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Salesforce Pardot in Excel.
-
Build Apps with Live Gmail in Adalo using CData Connect AI
Use CData Connect AI to integrate live Gmail into the Adalo platform and build custom mobile and web applications with real-time Gmail.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Azure DevOps using the Model Context Protocol.
-
Use Claude to Talk to Your Microsoft Exchange via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Microsoft Exchange for you.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Authorize.Net
Provide connectivity to Authorize.Net through an SAP BusinessObjects universe.
-
How to load Oracle Financials Cloud data into Elasticsearch via Logstash
Introducing a simple method to load Oracle Financials Cloud data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Microsoft Dataverse from MySQL in Amazon QuickSight
Connect to Microsoft Dataverse and build visualizations of Microsoft Dataverse (CDS) using a MySQL Connection in Amazon QuickSight.
-
Automate Avro Replication to Azure Data Lake
Use CData Sync to customize and automate Apache Avro replication to Azure Data Lake.
-
Connect to Real-Time Outreach.io Data in Power Apps Using Dataflows to Build Custom Applications
-