CData Software - Knowledge Base
Recent Articles
-
Access Live Jira Assets in Coginiti Pro
Connect to and query live Jira Assets from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Excel Online-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft Excel Online and build Excel Online-connected web apps with Axios.
-
Use JayDeBeApi to access IBM Cloud Object Storage in Python
Use standard Python scripting and the development environment of your choice to access live IBM Cloud Object Storage.
-
Integrate Authorize.Net in the Pentaho Report Designer
Publish reports based on Authorize.Net in the Pentaho BI tool.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Exact Online using the Model Context Protocol.
-
Use Microsoft Copilot Studio to talk to your Outreach.io 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 Outreach.io for you.
-
Analyze Live GraphQL in SAS Viya
Use CData Connect AI to connect to GraphQL from SAS Viya and deploy self-service analytics using live GraphQL.
-
Visualize Live Oracle HCM Cloud in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Oracle HCM Cloud.
-
View Reports on Real-Time Pinterest in Power BI Report Server
Use the CData ODBC Driver for Pinterest to visualize Pinterest in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Printify in Aqua Data Studio
Access Printify from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to connect PolyBase to SAP Fieldglass
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP Fieldglass.
-
Replicate QuickBooks to Multiple Databases
Replicate QuickBooks Desktop to disparate databases with a point-and-click configuration.
-
Connect to Act-On in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Act-On and connect to Act-On in Akorbi Digital RunMyProcess.
-
How to Connect to Live Airtable from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Airtable for you.
-
Automated Continuous Basecamp Replication to SingleStore
Use CData Sync for automated, continuous, customizable Basecamp replication to SingleStore.
-
Use Biml to Build SSIS Tasks to Replicate Oracle SCM to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle SCM to SQL Server.
-
Access Cosmos DB 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 Azure Cosmos DB.
-
Validate Dynamics NAV with QuerySurge
Access and validate Microsoft Dynamics NAV in QuerySurge using the CData JDBC Driver.
-
Create Informatica Mappings From/To a JDBC Data Source for Parquet
Create Parquet data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Google Campaign Manager 360 Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Azure SQL Database.
-
Build an OLAP Cube in SSAS from MongoDB
Establish a connection to MongoDB data from SQL Server Analysis Services, and use the MongoDB Data Provider to build OLAP cubes for use in analytics and reporting.
-
PowerShell Scripting to Replicate ADP to MySQL
Write a simple PowerShell script to replicate ADP to a MySQL database.
-
Use Dash to Build to Web Apps on JSON Services
Create Python applications that use pandas and Dash to build JSON-connected web apps.
-
Create Adobe Commerce-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Adobe Commerce from OutSystems and build custom enterprise apps using live Adobe Commerce.
-
Automated Continuous Redis Replication to Databricks
Use CData Sync for automated, continuous, customizable Redis replication to Databricks.
-
A PostgreSQL Interface for Access using the CData ODBC Driver
Use the SQL Gateway and Access ODBC Driver to create a PostgreSQL entry-point for data access.
-
Excel Spreadsheet Automation on BambooHR with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
How to create Visio diagrams from Oracle Eloqua
Automatically update Oracle Eloqua with the changes you make to Visio master shapes.
-
Write a Simple Go Application to work with Dynamics CRM on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Dynamics CRM.
-
How to Work with SAP Concur in AWS Glue Jobs Using JDBC
Connect to SAP Concur from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live Microsoft Teams in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft Teams into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Teams in the Graph Builder and Query Builder.
-
Getting Started with the CData SSIS Components for SAP
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP.
-
Import Real-Time Salesforce Data Cloud via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Salesforce Data Cloud in ColdFusion.
-
Creating AlloyDB-Connected Applications in Unqork
You can use CData Connect AI to feed Google AlloyDB to Unqork and build custom business apps.
-
A PostgreSQL Interface for Oracle Eloqua using the CData ODBC Driver
Use the SQL Gateway and Oracle Eloqua ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Google Calendar-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Calendar.
-
How to Build an ETL App for Dynamics NAV in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Dynamics NAV in Python with petl.
-
How to connect and process Sage Business Cloud Accounting from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Sage Business Cloud Accounting.
-
Import Real-Time Email via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Email in ColdFusion.
-
Build SAP Ariba Source-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SAP Ariba Source and build SAP Ariba Source-connected web apps with Axios.
-
Extend Google Sheets with Unbounce
Make calls to the API Server from Google Apps Script.
-
Work with Klipfolio in FoxPro
Load Klipfolio into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect and Visualize Live Adobe Analytics Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Adobe Analytics into the Databricks platform and create visualization dashboards with real-time Adobe Analytics.
-
Access QuickBooks from RazorSQL
Connect to QuickBooks company file data through the RazorSQL database query tool.
-
Connect to Google Spanner from a Connection Pool in Jetty
The Google Spanner JDBC Driver supports connection pooling: This article shows how to connect faster to Google Spanner from Web apps in Jetty.
-
Integrating Claude Code with Zuora via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Zuora within assisted coding and automated development workflows.
-
Viewing Dynamics CRM in RAD Studio Data Explorer
How to view Microsoft Dynamics CRM in RAD Studio Data Explorer using the CData ODBC Driver for Dynamics CRM.
-
How to Access Live Google Ads in Visual Studio Code via Cline
-