CData Software - Knowledge Base
Recent Articles
-
How to Work with MYOB AccountRight Data in AWS Glue Jobs Using JDBC
Connect to MYOB AccountRight from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automate Slack Data Replication to SAP HANA
Use CData Sync to customize and automate Slack data replication to SAP HANA.
-
How to connect to Facebook Ads Data from IntelliJ
Integrate connectivity to Facebook Ads data with wizards in IntelliJ.
-
How to create QuickBooks Time federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for QuickBooks Time data in MySQL .
-
Create Neo4J-Connected Applications in Appsmith
Connect to Neo4J Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Neo4J data.
-
Create a Private/Public Key Pair with Certificate Generator
Information on how to use the Certificate Generator application to create public and private keypairs.
-
Connect to Stripe Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Stripe and the SQL Gateway to access Stripe data from Google Apps Script.
-
Getting Started with the CData ODBC Driver for Strava
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Strava.
-
Build Sendwithus Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Sendwithus data and build visualizations in Tableau.
-
Getting Started with the CData SSIS Components for HubSpot
Complete guide to installing, licensing, and connecting with the CData SSIS Components for HubSpot.
-
Access Live ShipEngine Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to ShipEngine data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate Open WebUI with Live MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live MYOB AccountRight data from within the chat interface.
-
Query Live SAP Fieldglass Data 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 SAP Fieldglass data directly from the development environment.
-
Creating Basecamp-Connected Applications in Unqork
You can use CData Connect AI to feed Basecamp data to Unqork and build custom business apps.
-
Integrate Dify with Live Oracle Service Cloud Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Oracle Service Cloud data.
-
Integrate Guru Data into Power Automate Desktop using CData Connect
CData Connect for Guru Data enables you to integrate Guru data into workflows built using Microsoft Power Automate Desktop.
-
Feed SAP SuccessFactors Data into FineReport
How to set SAP SuccessFactors data as a JDBC data source in FineReport.
-
Automated Continuous Onfleet Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Onfleet replication to AlloyDB.
-
Build MailerSend-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to MailerSend data and build web apps with connectivity to live MailerSend data.
-
Analyze Azure Data Lake Storage Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Azure Data Lake Storage data and visualize live Azure Data Lake Storage data in Infragistics Reveal.
-
Replicate Multiple BenchmarkEmail Accounts
Replicate multiple BenchmarkEmail accounts to one or many databases.
-
How to Connect to Live Oracle Sales Data 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 Oracle Sales data for you.
-
Use Biml to Build SSIS Tasks to Replicate SAP HANA Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP HANA data to SQL Server.
-
Use Azure AI Foundry to Talk to Your Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Trello data for you.
-
Getting Started with the CData Tableau Connector for Google Ad Manager
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Ad Manager.
-
Connect Perigon Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Perigon data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use Biml to Build SSIS Tasks to Replicate Rebilly Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Rebilly data to SQL Server.
-
Explore Geographical Relationships in Zoho Creator Data with Power Map
Create data visualizations with Zoho Creator data in Power Map.
-
Write a Simple Go Application to work with GitLab Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to GitLab data.
-
Connecting Mastra with Smartsheet Data 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 Smartsheet data, no replication required.
-
Connect to SAP Concur Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to SAP Concur.
-
How to Build an ETL App for Microsoft Exchange Data in Python with CData Connect AI
Build ETL pipelines that read and write live Microsoft Exchange data in Python with petl and the CData Connect AI Python SDK.
-
Integrate Amazon Marketplace Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Amazon Marketplace data from Informatica Cloud.
-
Create Power BI Reports on Real-Time FreshBooks Data
Use the CData ODBC Driver for FreshBooks to visualize FreshBooks data in Power BI Desktop.
-
How to create an RPA flow for CouchDB Data in UiPath Studio
Use the CouchDB ODBC Driver to create workflows that access real-time CouchDB data without any coding.
-
Analyze Mixpanel Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Mixpanel from Power Pivot. You will use the Table Import Wizard to load Mixpanel data. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Real-Time Access to Facebook in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Facebook data in real time.
-
Working with Discord Data in LINQPad
Execute LINQ queries to Discord data in LINQPad.
-
Access Live Stripe Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Stripe data from your Excel spreadsheets.
-
Integrate Live Elasticsearch Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Elasticsearch from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Elasticsearch data.
-
Use JayDeBeApi to access Act-On Data in Python
Use standard Python scripting and the development environment of your choice to access live Act-On data.
-
Replicate Drip Data from PowerShell
Write a quick PowerShell script to query Drip data. Use connectivity to the live data to replicate Drip data to SQL Server.
-
Use Biml to Build SSIS Tasks to Replicate ZeroBounce Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ZeroBounce data to SQL Server.
-
TaxJar Reporting in OBIEE with the TaxJar JDBC Driver
Deploy the TaxJar JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to update Odoo from Excel
This article explains how to transfer data from Excel to Odoo using the Excel Add-In for Odoo.
-
Build AfterShip Visualizations in Tableau Desktop
Use CData Connect AI to connect to live AfterShip data and build visualizations in Tableau.
-
Connecting Mastra with Amazon Athena Data 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 Amazon Athena data, no replication required.
-
Automated Continuous Oracle Financials Cloud Replication to Oracle
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Oracle.
-
How to Seamlessly Import Oracle Eloqua Reporting Data into IBM SPSS Modeler
Integrate Oracle Eloqua Reporting data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create Dynamic Productboard Grids Using the Infragistics XamDataGrid
Learn how you can connect Productboard to Infragistics XamDataGrid to build dynamic grids.
-
How to Connect to & Open Sage 300 Data in Microsoft Excel
This article uses the CData ODBC driver for Sage 300 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use Azure AI Foundry to Talk to Your QuickBooks Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your QuickBooks Online data for you.
-
Automated Continuous Stripe Replication to SQL Server
Use CData Sync for automated, continuous, customizable Stripe replication to SQL Server.
-
A PostgreSQL Interface for Freshteam Data (MySQL Remoting via JDBC)
Use the Remoting features of the Freshteam JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect DBeaver to PostgreSQL via a JDBC Driver
Manage PostgreSQL data with visual tools in DBeaver like the query browser.
-
Create a Data Access Object for MariaDB Data using JDBI
A brief overview of creating a SQL Object API for MariaDB data in JDBI.
-
Explore Geographical Relationships in Adobe Target Data with Power Map
Create data visualizations with Adobe Target data in Power Map.
-
Use the CData Software ODBC Driver for SingleStore in MicroStrategy Web
Connect to SingleStore data in MicroStrategy Web using the CData Software ODBC Driver for SingleStore.
-
Build Front-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Front data.
-
Automated Continuous SageHR Replication to SQLite
Use CData Sync for automated, continuous, customizable SageHR replication to SQLite.
-
Use the CData Software ODBC Driver for ActiveCampaign in MicroStrategy Web
Connect to ActiveCampaign data in MicroStrategy Web using the CData Software ODBC Driver for ActiveCampaign.
-
Bind Live SAP ByDesign Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP ByDesign data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Create Data Visualizations Based On Microsoft Planner Data in Mode
Use CData Connect AI to connect to Microsoft Planner Data from Mode and build visualizations using live Microsoft Planner data.
-
Connect to Box Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Box data from Filemaker Pro on Mac.
-
Use the CData SSIS Components to Insert New or Update Existing Google Spanner Records from SQL Server
Easily push SQL Server data to Google Spanner using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Spanner or update existing records with data from a SQL Server database.
-
Access Live Aircall Data in Coginiti Pro
Connect to and query live Aircall data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Live Shortcut Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Shortcut data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Visualize Google Tasks Data in TIBCO Spotfire through ADO.NET
Integrate Google Tasks data into dashboards in TIBCO Spotfire.
-
View Reports on Real-Time HubDB Data in Power BI Report Server
Use the CData ODBC Driver for HubDB to visualize HubDB data in Power BI Desktop and then publish them to Power BI Report Server.
-
Migrating data from PayPal to Databricks using CData SSIS Components.
Easily push PayPal data to Databricks using the CData SSIS Tasks for PayPal and Databricks.
-
Build Dashboards with Sage Intacct Data in Dundas BI
Create dynamic dashboards and perform analytics based on Sage Intacct data in Dundas BI.
-
How to Access Apollo Data Using Entity Framework
This article shows how to access Apollo data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Semantic Layer Views for AgileCRM Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for AgileCRM data.
-
Everhour Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Everhour facts in real time.
-
Connect to Oracle Eloqua Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle Eloqua and the Script function in FileMaker Pro to connect to Oracle Eloqua and work with Oracle Eloqua data in your FileMaker application.
-
Automated Continuous Telegram Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Telegram replication to AlloyDB.
-
Integrating Claude Code with ServiceNow Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on ServiceNow data within assisted coding and automated development workflows.
-
Build HubSpot-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live HubSpot data and build HubSpot-connected web apps with Axios.
-
Bridge MessageBird Connectivity with Apache NiFi
Access and process MessageBird data in Apache NiFi using the CData JDBC Driver.
-
Visualize Live Microsoft Dataverse Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft Dataverse data into custom reports in Power BI.
-
Connect to SAP Hybris C4C Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP Hybris C4C data from HeidiSQL.
-
Validate Oracle Sales Data with QuerySurge
Access and validate Oracle Sales data in QuerySurge using the CData JDBC Driver.
-
Publish Crystal Reports on HubSpot Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date HubSpot data.
-
Create Oracle SCM Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Oracle SCM data access from reports, embedded analytics, and more.
-
Integrate with live Optimizely Data in Jitterbit
Use CData Connect AI to connect to and integrate live Optimizely data in Jitterbit.
-
Automate Codat Data Replication to Couchbase
Use CData Sync to Customize and automate Codat data replication to Couchbase.
-
Enable the Stripe JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Stripe data.
-
Create Reports with Instagram Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Instagram data.
-
Natively Connect to Twitter Ads Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Twitter Ads data. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData JDBC Driver for Reply.io
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Reply.io.
-
Build MVC Applications with Connectivity to Outlook Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Outlook from an ASP.NET MVC application.
-
Create Cloudflare-Connected Business Apps in AppSheet
Connect to Cloudflare Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Cloudflare data.
-
Integrating Dataiku with Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Azure Data Lake Storage data.
-
Use the CData ODBC Driver for Campaigner from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Campaigner to connect to Campaigner data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Campaigner data in Excel.
-
How to Connect the Power BI Service to BenchmarkEmail: Complete Guide
Connect to the CData Software Power BI Connector for BenchmarkEmail from PowerBI.com to provide real-time BenchmarkEmail data across the organization.
-
Publish Reports with Pingdom Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pingdom data.
-
Integrate SAP Concur Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAP Concur data and integrate live SAP Concur data into your Power Automate tasks.
-
Connect to Google Drive Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Drive data in Google Apps Script.
-
Build Pipelines with Live Snowflake Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Snowflake from Google Cloud Data Fusion, enabling the integration of live Snowflake data into the building and management of effective data pipelines.
-
Working with Cohere Data in LINQPad
Execute LINQ queries to Cohere data in LINQPad.