CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Invoiced Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Invoiced replication to Google Cloud SQL.
-
Integrate Live MySQL into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to MySQL and integrate live MySQL into apps built in Microsoft Power Apps.
-
Access Exact Online as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Exact Online from your Oracle system.
-
Connect to Oracle in RazorSQL
Connect to Oracle from wizards and query Oracle Database from the GUI in the RazorSQL database management tool.
-
Use the CData Software ODBC Driver for SAP Concur in MicroStrategy
Connect to SAP Concur in MicroStrategy Developer using the CData Software ODBC Driver for SAP Concur.
-
Connect to GraphQL in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for GraphQL in Airbyte.
-
Import Real-Time SAP ByDesign via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP Business ByDesign in ColdFusion.
-
Connecting Moonlit Workflow with Excel Online via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Microsoft Excel Online in real time.
-
How to Connect to Live Amazon Marketplace 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 Amazon Marketplace for you.
-
How to work with Zoom in Apache Spark using SQL
Access and process Zoom in Apache Spark using the CData Software JDBC Driver.
-
Dynamically Retrieve Data Based on Cell Values with the CData Excel Add-in: CData Excel Formulas
Learn how to use the CData Excel Add-in and CData Excel Formulas to dynamically retrieve and refresh live cloud data in Excel using SQL queries.
-
Connect to OData Services in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for OData in Airbyte.
-
How to Connect to Live Active Directory in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Active Directory without replication.
-
DataBind Controls to GitHub in Delphi
DataBind to GitHub in Delphi with standard data access components and controls.
-
Build Visualizations of Redshift in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Amazon Redshift in Birst.
-
Connect to HDFS as an External Source in Dremio
Use the CData JDBC Driver to connect to HDFS as an External Source in Dremio.
-
Replicate Multiple JSON Accounts
Replicate multiple JSON accounts to one or many databases.
-
Migrating data from SAP Business One to Google BigQuery using CData SSIS Components.
Easily push SAP Business One to Google BigQuery using the CData SSIS Tasks for SAP Business One and Google BigQuery.
-
Import Cassandra into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Apache Cassandra. In this article, you will use the OData format to import Apache Cassandra into Microsoft Power Query.
-
How to Connect to Live Splunk 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 Splunk for you.
-
Connect to Sugar CRM in NetBeans
Connect to Sugar CRM in NetBeans with the data source configuration wizard.
-
Connect to Phoenix in Ruby
Connect to Apache Phoenix in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData ODBC Driver for Blackbaud FE NXT from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Blackbaud FE NXT to connect to Blackbaud FE NXT from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Blackbaud FE NXT in Excel.
-
Access Live Vault CRM in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Veeva Vault & Vault CRM from your Excel spreadsheets.
-
Configure the CData JDBC Driver for Coinbase in a Connection Pool in Tomcat
Connect to Coinbase from a connection pool in Tomcat.
-
How to Query Odoo in MySQL Workbench
Execute MySQL queries against live Odoo ERP from MySQL Workbench.
-
Integrate MarkLogic in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MarkLogic from Informatica Cloud.
-
Replicate Google Ad Manager to Multiple Databases
Replicate Google Ad Manager to disparate databases with a point-and-click configuration.
-
How to Access Live BigCommerce in Power Automate Desktop via ODBC
The CData ODBC Driver for BigCommerce enables you to integrate BigCommerce into workflows built using Microsoft Power Automate Desktop.
-
Connect to WooCommerce in NetBeans
Connect to WooCommerce in NetBeans with the data source configuration wizard.
-
Use the CData Software ODBC Driver for Quickbase in MicroStrategy
Connect to Quickbase in MicroStrategy Developer using the CData Software ODBC Driver for Quickbase.
-
Connect to HubSpot in DBeaver
Use the CData ODBC Driver to connect to HubSpot in DBeaver.
-
PowerShell Scripting to Replicate Sage 300 to MySQL
Write a simple PowerShell script to replicate Sage 300 to a MySQL database.
-
Operational Reporting on ServiceNow from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ServiceNow.
-
How to Connect to Power BI XMLA in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Power BI XMLA. Leverage the pyodbc module for ODBC in Python.
-
Use the CData Software JDBC Driver for Pinterest in MicroStrategy Desktop
Connect to Pinterest in MicroStrategy Desktop using the CData Software JDBC Driver for Pinterest.
-
Automated Continuous Couchbase Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Couchbase replication to Azure SQL Database.
-
Connect to ADP in Jaspersoft Studio
Execute SQL to remote ADP in Jaspersoft Studio.
-
How to connect SharePoint with Jira Service Management through external lists
Provide Atlassian Jira Service Management to SharePoint users as an external list.
-
Integrate Shippo with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Shippo with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Shippo.
-
Automated Continuous Bullhorn CRM Replication to SQLite
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to SQLite.
-
Connect to Oracle SCM from a Connection Pool in JBoss
Integrate Oracle SCM into Java servlets: Use the Management Console in JBoss to install the Oracle SCM JDBC Driver.
-
Automated Continuous Zoho Books Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Zoho Books replication to Azure SQL Database.
-
Automated Continuous ADP Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ADP replication to Google BigQuery.
-
Bridge Hive Connectivity with Apache NiFi
Access and process Apache Hive in Apache NiFi using the CData JDBC Driver.
-
Connect to SAP Business One in DBArtisan
Use wizards in DBArtisan to configure SAP Business One as a data source.
-
Process & Analyze Bitbucket in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Bitbucket .
-
Viewing JotForm in RAD Studio Data Explorer
How to view JotForm in RAD Studio Data Explorer using the CData ODBC Driver for JotForm.
-
Automated Continuous Shippo Replication to SingleStore
Use CData Sync for automated, continuous, customizable Shippo replication to SingleStore.
-
Explore Geographical Relationships in Reckon Accounts Hosted with Power Map
Create data visualizations with Reckon Accounts Hosted in Power Map.
-
Use the CData Software JDBC Driver for Marketo in MicroStrategy Desktop
Connect to Marketo in MicroStrategy Desktop using the CData Software JDBC Driver for Marketo.
-
View Reports on Real-Time Salesforce Data Cloud in Power BI Report Server
Use the CData ODBC Driver for Salesforce Data Cloud to visualize Salesforce Data Cloud in Power BI Desktop and then publish them to Power BI Report Server.
-
Edit and Search Salesforce Pardot External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Salesforce Pardot to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Salesforce Pardot objects that you can access from apps and the dashboard.
-
Build Data Flows from SAP Concur to SQL Server using SSIS
Easily back up SAP Concur to SQL Server using the SSIS components for SAP Concur.
-
Prepare, Blend, and Analyze Okta in Alteryx Designer (ODBC)
Build workflows to access live Okta for self-service data analytics.
-
Connect to Odoo in Aqua Data Studio
Access Odoo ERP from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect to Live Redshift from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Amazon Redshift for you.
-
Integrate PingOne in the Pentaho Report Designer
Publish reports based on PingOne in the Pentaho BI tool.
-
Feed Act-On into FineReport
How to set Act-On as a JDBC data source in FineReport.
-
Connect to Databricks through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Databricks using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrating Boomi Agentstudio with Oracle HCM Cloud via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Oracle HCM Cloud, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrating LangChain with Outreach.io via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Outreach.io within automated workflows.
-
Automated Continuous Act-On Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Act-On replication to Azure SQL Database.
-
Access Drip from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Drip from HeidiSQL.
-
How to Connect to Live Power BI XMLA from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Power BI XMLA for you.
-
View Reports on Real-Time XML in Power BI Report Server
Use the CData ODBC Driver for XML to visualize XML Files in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData Software ODBC Driver for Cvent in SAS for Real-Time Reporting and Analytics
Connect to real-time Cvent in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Cvent.
-
How to connect to Facebook Ads in DBVisualizer
Integrate Facebook Ads with visual data analysis tools and data connection wizards in DBVisualizer
-
Write a Simple Go Application to work with HCL Domino on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to HCL Domino.
-
Seamlessly Bring Reckon into Retool Using CData Connect AI
Integrate Reckon data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Semantic Layer Views for Zoho CRM in APOS Live Data Gateway
Use the CData Connector for Zoho CRM in APOS Live Data Gateway to build Semantic Layer Views for Zoho CRM.
-
Automated Continuous Highrise Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Highrise replication to Google Cloud SQL.
-
Integrate with ShipStation in JReport Designer
Create charts and reports based on ShipStation in JReport Designer.
-
Automated Salesforce Marketing Replication to Teradata
Use CData Sync to Customize and automate Salesforce Marketing Cloud replication to Teradata.
-
Working with Azure Active Directory in LINQPad
Execute LINQ queries to Azure Active Directory in LINQPad.
-
Automated Continuous Greenplum Replication to Databricks
Use CData Sync for automated, continuous, customizable Greenplum replication to Databricks.
-
How to Connect to Live Oracle HCM Cloud 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 Oracle HCM Cloud for you.
-
Automate SAS xpt Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAS XPORT from PowerShell? This article demonstrates how to utilize the SAS xpt Cmdlets for tasks like connecting to SAS XPORT, automating operations, downloading data, and more.
-
Integrate Sage 200 with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Sage 200 with External Services.
-
Design BIRT Reports on eBay Analytics
Provide current eBay Analytics to your embedded analytics.
-
Automated Continuous IBM Informix Replication to Oracle
Use CData Sync for automated, continuous, customizable IBM Informix replication to Oracle.
-
Integrate Real-Time Access to Redshift in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Amazon Redshift in real time.
-
Connecting GenSpark with Raisers Edge NXT via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
Connect to Real-Time Unbounce Data in Power Apps Using Dataflows to Build Custom Applications
-