CData Software - Knowledge Base
Recent Articles
-
Integrating Claude Code with Amazon Athena via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Amazon Athena within assisted coding and automated development workflows.
-
Getting Started with the CData Excel Add-In for Dropbox
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Dropbox.
-
Work with Reckon Accounts Hosted in FoxPro
Load Reckon Accounts Hosted into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Printify-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Printify and build web apps with connectivity to live Printify.
-
Build a PostgreSQL Interface for SAP Fieldglass using the CData JDBC Driver
Use the Remoting features of the SAP Fieldglass JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Active Directory in Jaspersoft Studio
Execute SQL to remote Active Directory in Jaspersoft Studio.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Shopify using the Model Context Protocol.
-
Create Dynamic Bing Ads Grids Using the Infragistics XamDataGrid
Learn how you can connect Bing Ads to Infragistics XamDataGrid to build dynamic grids.
-
DataBind Controls to Unbounce in C++Builder
DataBind to Unbounce in C++Builder with standard components and controls.
-
Build a PostgreSQL Interface for SAP using the CData JDBC Driver
Use the Remoting features of the SAP JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous SAP Business One Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable SAP Business One replication to Microsoft Access.
-
Replicate Multiple DB2 Accounts
Replicate multiple DB2 accounts to one or many databases.
-
Automated Continuous Shopify Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Shopify replication to AlloyDB.
-
Create Informatica Mappings From/To a JDBC Data Source for HubSpot
Create HubSpot data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to HCL Domino from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for HCL Domino to connect to HCL Domino and execute queries in PowerBuilder.
-
How to Use a Microsoft Access Database to Update SendGrid in Real Time
Update SendGrid data by creating a linked table in Microsoft Access with the CData SendGrid ODBC Driver.
-
Replicate Paylocity in Heroku for Use in Salesforce Connect
Replicate Paylocity to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Migrating data from QuickBooks Online to Snowflake using CData SSIS Components.
Easily push QuickBooks Online to Snowflake using the CData SSIS Tasks for QuickBooks Online and Snowflake.
-
Create Reports from Oracle Service Cloud in Looker Studio
Use CData Connect AI to gain access to live Oracle Service Cloud and create custom reports in Looker Studio.
-
Access SAP Ariba Procurement from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP Ariba Procurement from HeidiSQL.
-
How to Query Live Greenhouse in Claude Desktop
Connect to and query live Greenhouse in Claude Desktop using CData Code Assist MCP.
-
How to update SharePoint from Excel
This article explains how to transfer data from Excel to SharePoint using the Excel Add-In for SharePoint.
-
How to Connect to Live MariaDB 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 MariaDB without replication.
-
How to connect to Oracle SCM from IntelliJ
Integrate connectivity to Oracle SCM with wizards in IntelliJ.
-
Connect to Avalara AvaTax as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Avalara AvaTax.
-
Write a Simple Go Application to work with EnterpriseDB on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to EnterpriseDB.
-
Connect and Query Live API Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live API into Databricks
-
Integrating Gumloop with MailChimp via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on MailChimp within automated workflows.
-
Automated Continuous Facebook Ads Replication to SQL Server
Use CData Sync for automated, continuous, customizable Facebook Ads replication to SQL Server.
-
Process & Analyze Zoho Books in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Zoho Books .
-
Use the CData API Server to Access MySQL in Microsoft PowerPivot
Use the CData API Server to connect to live MySQL in the Power Pivot business intelligence tool.
-
How to Connect to Live Microsoft Exchange from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Microsoft Exchange for you.
-
Access QuickBooks Online from MySQL in PHP
Connect to QuickBooks Online through the standard MySQL libraries in PHP.
-
Automate Redshift Replication to Azure Synapse
Use CData Sync to customize and automate Amazon Redshift replication to Azure Synapse.
-
Automated Continuous SAS xpt Replication to Databricks
Use CData Sync for automated, continuous, customizable SAS xpt replication to Databricks.
-
Design BIRT Reports on Square
Provide current Square to your embedded analytics.
-
How to publish and share Reckon dashboards with Tableau Server
The CData ODBC driver for Reckon enables you integrate Reckon into Tableau dashboards.
-
Create ActiveCampaign-Connected Business Apps in AppSheet
Connect to ActiveCampaign via CData Connect AI in Google AppSheet and create custom business applications with real-time access to ActiveCampaign.
-
Integrate Live Shopify into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Shopify and integrate live Shopify into apps built in Microsoft Power Apps.
-
Analyze Shopify in Looker
Use CData Connect AI to connect to Shopify from Looker and build custom apps using live Shopify.
-
Automate Microsoft Planner Replication to SAP HANA
Use CData Sync to customize and automate Microsoft Planner replication to SAP HANA.
-
Enable the RSS JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with RSS Feeds.
-
Import PostgreSQL into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access PostgreSQL. In this article, you will use the OData format to import PostgreSQL into Microsoft Power Query.
-
Access Live BigQuery in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google BigQuery from your Excel spreadsheets.
-
Connect to Sage 200 in NetBeans
Connect to Sage 200 in NetBeans with the data source configuration wizard.
-
Automate Zoom Replication to SAP HANA
Use CData Sync to customize and automate Zoom replication to SAP HANA.
-
Visualize OData Services in Sisense
Create an ElastiCube in Sisense app with access to OData.
-
How to integrate Oracle Financials Cloud with Apache Airflow
Access and process Oracle Financials Cloud in Apache Airflow using the CData JDBC Driver.
-
Connect Adobe Commerce to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Adobe Commerce using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Data Flows from Amazon S3 to SQL Server using SSIS
Easily back up Amazon S3 to SQL Server using the SSIS components for Amazon S3.
-
Automate SAP HANA XS Advanced Replication to Couchbase
Use CData Sync to Customize and automate SAP HANA XS Advanced replication to Couchbase.
-
Connect to Salesforce Pardot from a Connection Pool in Jetty
The Salesforce Pardot JDBC Driver supports connection pooling: This article shows how to connect faster to Salesforce Pardot from Web apps in Jetty.
-
Integrate with Reckon Accounts Hosted using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Reckon Accounts Hosted to a JSON file on disk.
-
Back Up Klaviyo to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Klaviyo. In this article, we will employ an SSIS workflow to populate a database with Klaviyo data.
-
Connect SFTP to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SFTP using the CData Python MCP Server.
-
Feed DB2 into FineReport
How to set IBM DB2 as a JDBC data source in FineReport.
-
How to Access PingOne Using Entity Framework
This article shows how to access PingOne using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Import Data from Google Drive into Google Sheets
Import Google Drive into a Google spreadsheet that is automatically refreshed.
-
Use Agno to Talk to Your Oracle HCM Cloud 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 Oracle HCM Cloud for you.
-
Visualize Live CockroachDB of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live CockroachDB using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Google Campaign Manager 360 Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Oracle.
-
Rapidly Develop Coinbase-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
How to connect to SAP Business One from IntelliJ
Integrate connectivity to SAP Business One with wizards in IntelliJ.
-
Build Apps with Live Twilio in Adalo using CData Connect AI
Use CData Connect AI to integrate live Twilio into the Adalo platform and build custom mobile and web applications with real-time Twilio.
-
Edit and Search Azure Active Directory External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Azure Active Directory to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Azure Active Directory objects that you can access from apps and the dashboard.
-
Getting Started with the CData ADO.NET Provider for Oracle SCM
-