CData Software - Knowledge Base
Recent Articles
-
Automated Continuous NASA Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable NASA replication to Google Cloud SQL.
-
Getting Started with the CData SSIS Components for Samanage
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Samanage.
-
How to Easily Query Cloudant Data in OpenOffice Base
Connect to Cloudant data in OpenOffice Base using the CData ODBC Driver for Cloudant and generate reports with live data insights.
-
Connect to Snapchat Ads Data in DBArtisan
Use wizards in DBArtisan to configure Snapchat Ads data as a data source.
-
Use Dash to Build to Web Apps on Scrapfly Data
Create Python applications that use pandas and Dash to build Scrapfly-connected web apps.
-
Build Data Flows from Productboard to SQL Server using SSIS
Easily back up Productboard data to SQL Server using the SSIS components for Productboard.
-
Automated Azure Blob Storage Data Replication to Teradata
Use CData Sync to Customize and automate Azure Blob Storage data replication to Teradata.
-
Access Live Todoist Data in AWS Lambda
Connect to live Todoist data in AWS Lambda using the CData JDBC Driver.
-
Integrate Google's Vertex AI Agent with Live Raisers Edge NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Raisers Edge NXT data within intelligent workflows.
-
Use the CData ODBC Driver for ADP from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ADP to connect to ADP data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ADP data in Excel.
-
Publish Mouseflow-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Mouseflow data.
-
Automated Continuous Discourse Replication to Oracle
Use CData Sync for automated, continuous, customizable Discourse replication to Oracle.
-
Connect to Microsoft Planner Data from a Connection Pool in JBoss
Integrate Microsoft Planner data into Java servlets: Use the Management Console in JBoss to install the Microsoft Planner JDBC Driver.
-
DataBind Controls to Azure Data Catalog Data in C++Builder
DataBind to Azure Data Catalog data in C++Builder with standard components and controls.
-
View Reports on Real-Time Zoom Data in Power BI Report Server
Use the CData ODBC Driver for Zoom to visualize Zoom data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Live Instagram Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Instagram data to Blue Prism using the CData ODBC Driver for Instagram to create automated workflows for repetitive business tasks.
-
Automated Continuous Microsoft Exchange Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to IBM DB2.
-
Working with LinkedIn Data in LINQPad
Execute LINQ queries to LinkedIn data in LINQPad.
-
Replicate Outreach.io Data to Multiple Databases via the CData Sync CLI
Replicate Outreach.io data to disparate databases with a single configuration.
-
Integrating LangGraph with Salesloft Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Salesloft data within automated workflows.
-
Getting Started with the CData JDBC Driver for Invoiced
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Invoiced.
-
How to connect and process Outlook data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Outlook data.
-
Automated Continuous CockroachDB Replication to MongoDB
Use CData Sync for automated, continuous, customizable CockroachDB replication to MongoDB.
-
Analyze Pipedrive Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Pipedrive data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build RSS-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for RSS Feeds and create custom apps in Mendix.
-
Automated Continuous Workable Replication to Oracle
Use CData Sync for automated, continuous, customizable Workable replication to Oracle.
-
Design BIRT Reports on Couchbase Data
Provide current Couchbase data to your embedded analytics.
-
Connect to Asana Data in ACL Analytics
Connect to Asana data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Asana data.
-
Model, Search, and Visualize Live Amazon DynamoDB Data in ThoughtSpot
Use CData Connect AI to connect to live Amazon DynamoDB data for modeling, searching, and visualizing.
-
Access Live iContact Data 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 iContact data through MCP integration.
-
Integrate Goose with Live Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Sybase IQ data from within the local AI agent.
-
How to connect to Toggl Data from Spring Boot
Connect to Toggl in a Spring Boot Application using the CData API Driver for JDBC
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for PolarTeamPro
Provide connectivity to PolarTeamPro data through an SAP BusinessObjects universe.
-
Connect to Zoho Projects Data in NetBeans
Connect to Zoho Projects data in NetBeans with the data source configuration wizard.
-
Automated Continuous Teamgate Replication to SQL Server
Use CData Sync for automated, continuous, customizable Teamgate replication to SQL Server.
-
Integrate Active Directory with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Active Directory with External Services.
-
Prepare, Blend, and Analyze Printful Data in Alteryx Designer (ODBC)
Build workflows to access live Printful data for self-service data analytics.
-
Connect to BigQuery Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live BigQuery data.
-
Analyze Amazon DynamoDB Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Amazon DynamoDB data in Microsoft R Open.
-
Integrate Azure Data Lake Storage Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Azure Data Lake Storage data from Informatica Cloud.
-
Automated Continuous Teamgate Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Teamgate replication to Google BigQuery.
-
Automated Continuous PDFMonkey Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable PDFMonkey replication to Google Cloud SQL.
-
How to Visualize Greenhouse Data in Python with pandas
Use pandas and other modules to analyze and visualize live Greenhouse data in Python.
-
Build an OLAP Cube in SSAS from Kintone Data
Establish a connection to Kintone data data from SQL Server Analysis Services, and use the Kintone Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect Greenhouse to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Greenhouse data using the CData Python MCP Server.
-
Automated HelloSign Data Replication to Teradata
Use CData Sync to Customize and automate HelloSign data replication to Teradata.
-
Connect to Salesloft Data from Crystal Reports
Use CData Connect AI to connect to and report on live Salesloft data from Crystal Reports.
-
Build Semantic Layer Views for Shopify Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Shopify data.
-
Design BIRT Reports on Placid Data
Provide current Placid data to your embedded analytics.
-
How to Build an ETL App for TaxJar Data in Python with CData Connect AI
Build ETL pipelines that read and write live TaxJar data in Python with petl and the CData Connect AI Python SDK.
-
Connect GitHub to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live GitHub data using the CData Python MCP Server.
-
Build Dashboards with Recurly Data in DBxtra
Create dynamic dashboards and perform analytics based on Recurly data in DBxtra.
-
Query YouTube Analytics Data as a SQL Server Database in Node.js
Execute SQL Server queries against YouTube Analytics data from Node.js.
-
Automated Continuous SAS xpt Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAS xpt data replication to OneLake in Microsoft Fabric.
-
Work with Omnisend Data in FoxPro
Load Omnisend data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to PingOne from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from PingOne data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData SSIS Components for Google Cloud Storage
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Cloud Storage.
-
Automated Continuous Amazon Marketplace Replication to SQL Server
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to SQL Server.
-
Replicate Amazon S3 Data to Multiple Databases
Replicate Amazon S3 data to disparate databases with a point-and-click configuration.
-
Seamlessly Bring NetSuite SuiteAnalytics Data into Retool Using CData Connect AI
Integrate NetSuite SuiteAnalytics data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Connect the Power BI Service to Box: Complete Guide
Connect to the CData Software Power BI Connector for Box from PowerBI.com to provide real-time Box data across the organization.
-
Use Agno to Talk to Your Reckon Accounts Hosted Data 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 Reckon Accounts Hosted data for you.
-
Build Visualizations of Google Drive Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Drive data in Birst.
-
Integrate Azure Analysis Services Data in Pentaho Data Integration
Build ETL pipelines based on Azure Analysis Services data in the Pentaho Data Integration tool.
-
Automated Continuous PabblySubscriptions Replication to Amazon S3
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Amazon S3.
-
Automated Continuous Splunk Replication to Vertica
Use CData Sync for automated, continuous, customizable Splunk replication to Vertica.
-
Automated Continuous FreeAgent Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable FreeAgent replication to Amazon Redshift.
-
Build MVC Applications with Connectivity to ZohoInvoice Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ZohoInvoice from an ASP.NET MVC application.
-
Build Semantic Layer Views for Excel Online Data in APOS Live Data Gateway
Use the CData Connector for Excel Online in APOS Live Data Gateway to build Semantic Layer Views for Excel Online data.
-
Access Live JSON 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 JSON services through MCP integration.
-
Create FormSite Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time FormSite data access from reports, embedded analytics, and more.
-
Connect to FreshBooks from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from FreshBooks data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Live Google Forms Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Forms data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Google's Antigravity Agent with Live iContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live iContact data using the Model Context Protocol.
-
Build Shopify-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Shopify data.
-
Connect to Printify Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Printify data using standard SQL.
-
Connect ZohoExpense Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ZohoExpense data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData ODBC Driver for SAP Hybris C4C in Microsoft Power Query
You can use the CData SAP Hybris C4C ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP Hybris C4C data into Microsoft Power Query.
-
How to Access Live Cloudant Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Cloudant enables you to integrate Cloudant data into workflows built using Microsoft Power Automate Desktop.
-
Integrate with Nethunt Data in JReport Designer
Create charts and reports based on Nethunt data in JReport Designer.
-
Connect to Procore Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Procore data.
-
How to connect SharePoint with Sage 200 Data through external lists
Provide Sage 200 data to SharePoint users as an external list.
-
Getting Started with the CData ADO.NET Provider for Azure Data Catalog
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Azure Data Catalog.
-
Build Visualizations of Brex Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Brex data in Birst.
-
Query Oracle SCM Data as a MySQL Database in Node.js
Execute MySQL queries against Oracle SCM data from Node.js.
-
Create Dynamics CRM-Connected Dashboards in Grafana
Connect to Dynamics CRM Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Dynamics CRM data.
-
Publish Pushbullet-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Pushbullet data.
-
Build a Singer.io Tap for Redshift With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Redshift data using the CData Python Connector.
-
Connect to Close Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Close and work with Close data in your FileMaker application.
-
Connect to SFTP Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SFTP Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Analyze Live HCL Domino Data in SAS Viya
Use CData Connect AI to connect to HCL Domino data from SAS Viya and deploy self-service analytics using live HCL Domino data.
-
Create Salesforce Marketing Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Salesforce Marketing from PowerBI.com to create Power BI Dataflows with real-time data.
-
Replicate Oracle Eloqua Data to Multiple Databases via the CData Sync CLI
Replicate Oracle Eloqua data to disparate databases with a single configuration.
-
How to Connect to & Open AfterShip Data in Microsoft Excel
This article uses the CData ODBC driver for AfterShip to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to load Eventbrite data into Elasticsearch via Logstash
Introducing a simple method to load Eventbrite data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
DataBind Charts to Simplesat Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Simplesat data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Build AI/ML Models with Live Google Campaign Manager 360 Data using Dataiku
Connect Google Campaign Manager 360 Data with Dataiku using the CData JDBC Driver for Google Campaign Manager 360.
-
How to Connect to Live Slack Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Slack data without replication.
-
Integrating GitHub Copilot with Zoho Books 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 Apollo Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Apollo data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.