CData Software - Knowledge Base
Recent Articles
-
Connecting Agentforce with Acumatica Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Acumatica data for you.
-
Automated Continuous ADP Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ADP data replication to OneLake in Microsoft Fabric.
-
Replicate Vault CRM Data to Multiple Databases via the CData Sync CLI
Replicate Vault CRM data to disparate databases with a single configuration.
-
Integrate Telegram Data in the Pentaho Report Designer
Publish reports based on Telegram data in the Pentaho BI tool.
-
DataBind MailChimp Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for MailChimp with the DevExpress Windows Forms and Web controls to provide MailChimp data to a chart.
-
Access Google Ad Manager Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Ad Manager data from your Oracle system.
-
Build Gmail-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Gmail data without replication.
-
Access Live ClickTime Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ClickTime data into the statistical analysis tools available in SAS JMP. This article shows how to use ClickTime data in the Graph Builder and Query Builder.
-
Connect to Gorgias from a Connection Pool in WebLogic
Use the CData JDBC Driver for Gorgias to connect to Gorgias data from Web applications running on WebLogic.
-
Visualize Sybase IQ Data in Sisense
Create an ElastiCube in Sisense app with access to Sybase IQ data.
-
Integrating GitHub Copilot with Procore data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Enable the ServiceNow JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ServiceNow data.
-
Automated Continuous Microsoft Ads Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to AlloyDB.
-
Connect to Mixpanel Data in RapidMiner
Integrate Mixpanel data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Odoo Replication to SQL Server
Use CData Sync for automated, continuous, customizable Odoo replication to SQL Server.
-
Use Microsoft Copilot Studio to talk to your OData Services 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 OData services for you.
-
Use the CData ODBC Driver for Outlook from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Outlook to connect to Outlook data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Outlook data in Excel.
-
Integrate Campaigner with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Campaigner with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Campaigner data.
-
Access Live Salesforce Pardot Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Salesforce Pardot data from your Google Sheets.
-
Publish Reports with ZohoMarketingHub Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZohoMarketingHub data.
-
Create Data Visualizations Based On Salesforce Pardot Data in Mode
Use CData Connect AI to connect to Salesforce Pardot Data from Mode and build visualizations using live Salesforce Pardot data.
-
Automated Continuous MySQL Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable MySQL replication to Apache Cassandra.
-
Create Data Visualizations in Cognos BI with Google Forms Data
Access Google Forms data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Visualize Superchat Data in TIBCO Spotfire through ADO.NET
Integrate Superchat data into dashboards in TIBCO Spotfire.
-
Extract, Transform, and Load SuiteCRM Data in Informatica PowerCenter
Create a simple Workflow for SuiteCRM data in Informatica PowerCenter.
-
Access Live Samanage Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Samanage data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Import and Visualize TigerGraph Data in Power View
Create data visualizations based on TigerGraph data in Excel.
-
Migrating data from Hacker News to Google BigQuery using CData SSIS Components.
Easily push Hacker News data to Google BigQuery using the CData SSIS Tasks for Hacker News and Google BigQuery.
-
Stream Discourse Data into Apache Kafka Topics
Access and stream Discourse data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Figshare Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Figshare replication to Apache Kafka.
-
Access Live Oracle SCM Data in Excel 365 Online (Excel for the web)
Connect to Oracle SCM data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
DataBind Controls to Miro Data in Delphi
DataBind to Miro data in Delphi with standard data access components and controls.
-
How to Access Live Clari Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Clari enables you to integrate Clari data into workflows built using Microsoft Power Automate Desktop.
-
How to Connect to & Open ShipStation Data in Microsoft Excel
This article uses the CData ODBC driver for ShipStation to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Apps with Live Zuora data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Zuora data into the Adalo platform and build custom mobile and web applications with real-time Zuora data.
-
Access Live OData Services in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live OData services through MCP integration.
-
Build MVC Applications with Connectivity to Avro Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Avro from an ASP.NET MVC application.
-
Integrate Mocean Data in the Pentaho Report Designer
Publish reports based on Mocean data in the Pentaho BI tool.
-
How to Connect to Live Zoho Inventory Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Zoho Inventory data securely in real time.
-
Import and Visualize MYOB AccountRight Data in Power View
Create data visualizations based on MYOB AccountRight data in Excel.
-
Connecting Pipedream with Microsoft Teams Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Microsoft Teams data in real time.
-
Build a Simple VCL Application for Avaza Data
How to build a simple VCL Application to view Avaza data in RAD Studio using the CData ODBC Driver for Avaza.
-
Use the CData ODBC Driver for AlloyDB from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for AlloyDB to connect to AlloyDB data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring AlloyDB data in Excel.
-
Automated Continuous Sage Intacct Replication to MongoDB
Use CData Sync for automated, continuous, customizable Sage Intacct replication to MongoDB.
-
Connect to SAS xpt Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to SAS xpt.
-
Feed Missive Data into FineReport
How to set Missive data as a JDBC data source in FineReport.
-
Build ZohoMarketingHub-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ZohoMarketingHub data.
-
How to Create Power BI Visual Reports with Real-Time JobNimbus Data
Use CData Power BI Connectors to visualize JobNimbus data in Power BI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Salesforce Data 360
Provide connectivity to Salesforce Data 360 data through an SAP BusinessObjects universe.
-
How to Seamlessly Import Postmark Data into IBM SPSS Modeler
Integrate Postmark data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Epicor Kinetic-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Epicor Kinetic data without replication.
-
Back Up Strava data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Strava data data.
-
Connecting Moonlit Workflow with Zoom Data 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 Zoom data in real time.
-
Model Campaigner Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Campaigner, enabling the direct import of real-time Campaigner data.
-
Build Automated Microsoft Dataverse-Connected Workflows in Zapier
Use CData Connect AI to connect to live Microsoft Dataverse data and build automated workflows in Zapier.
-
Connect ZeroBounce to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ZeroBounce with IBM WebSphere for seamless data integration and connectivity.
-
Connect to SQL Server from Asprova with CData Software ODBC Driver for SQL Server
This article shows how to connect faster to SQL Server data from Asprova.
-
Replicate Multiple Google Campaign Manager 360 Accounts
Replicate multiple Google Campaign Manager 360 accounts to one or many databases.
-
Getting Started with the CData Excel Add-In for Nethunt
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Nethunt.
-
Easily Integrate Sugar CRM Data in Lazarus Pascal IDE
Learn how to easily integrate live Sugar CRM data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Oracle Financials Cloud Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Oracle Financials Cloud data from Filemaker Pro on Mac.
-
How to Access Procore Data Using Entity Framework
This article shows how to access Procore data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live Blackbaud FE NXT Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Blackbaud FE NXT data into the statistical analysis tools available in SAS JMP. This article shows how to use Blackbaud FE NXT data in the Graph Builder and Query Builder.
-
Excel Spreadsheet Automation on Mocean Data with the QUERY Formula
Pull data from Mocean, automate spreadsheets, and more with the QUERY formula.
-
Connecting Mastra with Salesforce Data 360 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 Salesforce Data 360 data, no replication required.
-
Connect to Procore Data in Aqua Data Studio
Access Procore data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to and Visualize Live Marketo Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Marketo data.
-
Write a Simple Go Application to work with Microsoft Entra ID Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Entra ID data.
-
How to Access Salesforce Data Using Entity Framework
This article shows how to access Salesforce data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Analyze Square Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Square data and visualize Square data in SAP Analytics Cloud.
-
Import Real-Time MYOB AccountRight Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use MYOB AccountRight data in ColdFusion.
-
Build Semantic Layer Views for Databricks Data in APOS Live Data Gateway
Use the CData Connector for Databricks in APOS Live Data Gateway to build Semantic Layer Views for Databricks data.
-
How to Connect to Paymo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Paymo data. Leverage the pyodbc module for ODBC in Python.
-
Access Live Typeform Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Typeform data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Replicate Multiple Xero Accounts via the CData Sync CLI
Replicate multiple Xero accounts to one or many databases.
-
Integrate Egnyte Data in the Pentaho Report Designer
Publish reports based on Egnyte data in the Pentaho BI tool.
-
Connect to SAP ByDesign Data from AWS Glue
Use CData Connect AI to gain access to live SAP ByDesign data from your AWS Glue jobs.
-
Getting Started with the CData Excel Add-In for ActiveCampaign
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ActiveCampaign.
-
How to integrate Gong with Apache Airflow
Access and process Gong data in Apache Airflow using the CData JDBC Driver.
-
Replicate SAP Concur Data in Heroku for Use in Salesforce Connect
Replicate SAP Concur data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Miro Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Miro to connect to Miro data and execute queries in PowerBuilder.
-
Manage SAP Ariba Source Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP Ariba Source.
-
Connect to Freshsales Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Freshsales to connect to Freshsales data and execute queries in PowerBuilder.
-
Access Live Presto Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Presto data from your Google Sheets.
-
Create Data Visualizations Based On BigQuery Data in Mode
Use CData Connect AI to connect to BigQuery Data from Mode and build visualizations using live BigQuery data.
-
Integrating GitHub Copilot with Workable data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Access Live Google Ad Manager Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Ad Manager data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Replicate Multiple MariaDB Accounts
Replicate multiple MariaDB accounts to one or many databases.
-
Connect to Reckon Accounts Hosted from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Reckon Accounts Hosted data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use CData Connect AI to Access Avalara AvaTax Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Avalara AvaTax data in the Power Pivot business intelligence tool.
-
Visualize Live Oracle Eloqua Reporting Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Oracle Eloqua Reporting data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Coda Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Coda data from Node.js.
-
Automated Continuous SparkPost Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SparkPost replication to Amazon S3.
-
Integrate TigerGraph with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate TigerGraph with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to TigerGraph data.
-
How to Connect to Cvent Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Cvent data. Leverage the pyodbc module for ODBC in Python.
-
Connect Xero to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Xero with IBM WebSphere for seamless data integration and connectivity.
-
Replicate SageHR Data in Heroku for Use in Salesforce Connect
Replicate SageHR data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Data Flows from Asana to SQL Server using SSIS
Easily back up Asana data to SQL Server using the SSIS components for Asana.
-
Automated Continuous Notion Replication to Snowflake
Use CData Sync for automated, continuous, customizable Notion replication to Snowflake.
-
Automated Continuous SAP Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP replication to Oracle.