CData Software - Knowledge Base
Recent Articles
-
Build Dashboards with MYOB AccountRight Data in Dundas BI
Create dynamic dashboards and perform analytics based on MYOB AccountRight data in Dundas BI.
-
Connect to Pipeline CRM Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Pipeline CRM.
-
Access Live Impala Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Impala data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect to & Open Azure Data Catalog Data in Microsoft Excel
This article uses the CData ODBC driver for Azure Data Catalog to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Getting Started with the CData ODBC Driver for Postmark
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Postmark.
-
Build Dashboards with Azure DevOps Data in DBxtra
Create dynamic dashboards and perform analytics based on Azure DevOps data in DBxtra.
-
Build Automated Workflows with Live EnterpriseDB Data in Workato
Use CData Connect AI to connect to live EnterpriseDB data and build automated workflows in Workato.
-
Automated Continuous Outreach.io Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Outreach.io replication to IBM DB2.
-
How to Connect the Power BI Service to ClickUp: Complete Guide
Connect to the CData Software Power BI Connector for ClickUp from PowerBI.com to provide real-time ClickUp data across the organization.
-
Build Act CRM-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 Act CRM data without replication.
-
Automated Continuous ConvertKit Replication to SQLite
Use CData Sync for automated, continuous, customizable ConvertKit replication to SQLite.
-
Create Power BI Reports on Real-Time JotForm Data
Use the CData ODBC Driver for JotForm to visualize JotForm data in Power BI Desktop.
-
Use the CData Software JDBC Driver for Workday in MicroStrategy
Connect to Workday data in MicroStrategy Developer using the CData Software JDBC Driver for Workday.
-
Integrate Live XML Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live XML data to Blue Prism using the CData ODBC Driver for XML to create automated workflows for repetitive business tasks.
-
Integrate Open WebUI with Live FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live FreshBooks data from within the chat interface.
-
LINQ to Amazon DynamoDB Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Amazon DynamoDB Data Provider.
-
Build Charts with ShipStation Data in Clear Analytics
Create dynamic charts and perform analytics based on ShipStation data in Clear Analytics.
-
Integrate LDAP with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate LDAP with External Services.
-
How to connect Amazon QuickSight to BenchmarkEmail Data
Create a connection to BenchmarkEmail data in CData Connect AI and insert BenchmarkEmail data into Amazon QuickSight SPICE to build interactive dashboards.
-
Load XML Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load XML data to a database.
-
Connect to Asana Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Asana data.
-
How to work with Coda Data in Apache Spark using SQL
Access and process Coda Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous ZarMoney Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ZarMoney replication to Google BigQuery.
-
Operational Reporting on Paddle Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Paddle data.
-
Access Live Lakebase Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Lakebase data from your Excel spreadsheets.
-
Feed Teradata Data into FineReport
How to set Teradata data as a JDBC data source in FineReport.
-
Integrating OpenCode with PabblySubscriptions 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.
-
Integrate OpenCode with Live Dynamics 365 Business Central Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Dynamics 365 Business Central data from within your AI coding agent.
-
Analyze Azure Table Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Azure Table data and visualize Azure Table data in SAP Analytics Cloud.
-
Back Up SAP Fieldglass data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Fieldglass. In this article, we will employ an SSIS workflow to populate a database with SAP Fieldglass data data.
-
Build Dashboards with QuickBooks Online Data in Dundas BI
Create dynamic dashboards and perform analytics based on QuickBooks Online data in Dundas BI.
-
Automated Continuous OnePageCrm Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable OnePageCrm replication to Apache Cassandra.
-
Integrating LlamaIndex with LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on LinkedIn data in real time.
-
Replicate Couchbase Data to Multiple Databases
Replicate Couchbase data to disparate databases with a point-and-click configuration.
-
Connect to Opsgenie from Asprova with CData Software ODBC Driver for Opsgenie
This article shows how to connect faster to Opsgenie data from Asprova.
-
Design BIRT Reports on ZohoSubscriptions Data
Provide current ZohoSubscriptions data to your embedded analytics.
-
Getting Started with the CData Python Connector for Nuclia
Learn to install and license the CData Python Connector and configure a connection to live Nuclia data.
-
Use Dash to Build to Web Apps on Discord Data
Create Python applications that use pandas and Dash to build Discord-connected web apps.
-
Stream Drip Data into Apache Kafka Topics
Access and stream Drip data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Live Postmark Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Postmark data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Connect to Live Sage 300 Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Sage 300 data securely in real time.
-
Automated Continuous ZohoDesk Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ZohoDesk replication to Apache Kafka.
-
Automated Continuous AdRoll Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable AdRoll replication to Apache Kafka.
-
How to Access Live eBay Analytics Data in Power Automate Desktop via ODBC
The CData ODBC Driver for eBay Analytics enables you to integrate eBay Analytics data into workflows built using Microsoft Power Automate Desktop.
-
Integrate with Azure Table Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Azure Table data to a JSON file on disk.
-
Integrating Antigravity CLI with LightSpeedRetail data via CData CLI
Connect LightSpeedRetail data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to load Twitter Ads data into Elasticsearch via Logstash
Introducing a simple method to load Twitter Ads data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect DBeaver to Cosmos DB via a JDBC Driver
Manage Cosmos DB data with visual tools in DBeaver like the query browser.
-
Build Rootly-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Rootly data.
-
Getting Started with the CData Tableau Connector for Apollo
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrating Antigravity CLI with Microsoft Entra ID data via CData CLI
Connect Microsoft Entra ID data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect Active Directory to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Active Directory data using the CData Python MCP Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Egnyte
Provide connectivity to Egnyte data through an SAP BusinessObjects universe.
-
Build Dashboards with Google Ad Manager Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Ad Manager data in Dundas BI.
-
Use the CData Software JDBC Driver for Jira in MicroStrategy Desktop
Connect to Jira data in MicroStrategy Desktop using the CData Software JDBC Driver for Jira.
-
Create a Data Access Object for PostgreSQL Data using JDBI
A brief overview of creating a SQL Object API for PostgreSQL data in JDBI.
-
Explore Geographical Relationships in JSON Services with Power Map
Create data visualizations with JSON services in Power Map.
-
Use the CData Software ODBC Driver for MariaDB in SAS for Real-Time Reporting and Analytics
Connect to real-time MariaDB data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MariaDB.
-
Connect to ShipEngine Data in CloverDX (formerly CloverETL)
Transfer ShipEngine data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Apify Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Apify replication to IBM DB2.
-
DataBind Controls to Grafana Data in Delphi
DataBind to Grafana data in Delphi with standard data access components and controls.
-
Build Data Flows from Unbounce to SQL Server using SSIS
Easily back up Unbounce data to SQL Server using the SSIS components for Unbounce.
-
Configure the CData JDBC Driver for Hugging Face in a Connection Pool in Tomcat
Connect to Hugging Face data from a connection pool in Tomcat.
-
Getting Started with the CData Power BI Connector for SAP Ariba Procurement
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP Ariba Procurement.
-
Analyze SurveyMonkey Data in Cognos Analytics
Use CData Connect AI to connect to SurveyMonkey Data from Cognos Analytics and analyze live SurveyMonkey data.
-
Build a PostgreSQL Interface for Scrapfly Data using the CData JDBC Driver
Use the Remoting features of the Scrapfly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Amazon Athena from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Amazon Athena data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrating Kiro with ZohoDesk 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.
-
Automate Clockify Data Replication to SAP HANA
Use CData Sync to customize and automate Clockify data replication to SAP HANA.
-
Design BIRT Reports on ConvertKit Data
Provide current ConvertKit data to your embedded analytics.
-
Connect to Browserless from a Connection Pool in WebLogic
Use the CData JDBC Driver for Browserless to connect to Browserless data from Web applications running on WebLogic.
-
Analyze Campaigner Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Campaigner data and visualize Campaigner data in SAP Analytics Cloud.
-
Connect to Oracle Data in RapidMiner
Integrate Oracle data with standard components and data source configuration wizards in RapidMiner Studio.
-
DataBind Charts to SAS Data Sets Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAS Data Sets 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.
-
DataBind Charts to Epicor Kinetic Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Epicor Kinetic 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.
-
Jira Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Jira facts in real time.
-
Back Up Odoo data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Odoo. In this article, we will employ an SSIS workflow to populate a database with Odoo data data.
-
Use Biml to Build SSIS Tasks to Replicate Zoho Projects Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoho Projects data to SQL Server.
-
How to connect to Exact Online Data from IntelliJ
Integrate connectivity to Exact Online data with wizards in IntelliJ.
-
Automated Continuous CapsuleCRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Apache Kafka.
-
How to use SQLAlchemy ORM to access Vault CRM Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Vault CRM data.
-
Access Live Strava Data in Coginiti Pro
Connect to and query live Strava data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Access Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Access data from your Oracle system.
-
Create SSAS Tabular Models from Sage 200 Data
How to build a SQL Server Analysis Service Tabular Model from Sage 200 data using CData drivers.
-
Create Browserless Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Browserless from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Reports with ServiceNow Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ServiceNow data.
-
Integrate Live Epicor Kinetic Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Epicor Kinetic data to Blue Prism using the CData ODBC Driver for Epicor Kinetic to create automated workflows for repetitive business tasks.
-
Easily Integrate Workable Data in Lazarus Pascal IDE
Learn how to easily integrate live Workable data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Excel Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Excel data from your Oracle system.
-
Search External Avro Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Avro data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Avro Data objects that you can access from apps and the dashboard.
-
Prepare, Blend, and Analyze OneNote Data in Alteryx Designer (Connect AI)
Build workflows to access live OneNote data for self-service data analytics.
-
How to Connect to Marketo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Marketo data. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Dynamics NAV Replication to SQLite
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to SQLite.
-
Create Reports with WooCommerce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date WooCommerce data.
-
Use the CData Software ODBC Driver for Acumatica in MicroStrategy Desktop
Connect to Acumatica data in MicroStrategy Desktop using the CData Software ODBC Driver for Acumatica.
-
Build a Singer.io Tap for Guru With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Guru data using the CData Python Connector.
-
Use the CData Software JDBC Driver for Azure DevOps in MicroStrategy
Connect to Azure DevOps data in MicroStrategy Developer using the CData Software JDBC Driver for Azure DevOps.
-
Create Informatica Mappings From/To a JDBC Data Source for SpaceX
Create SpaceX data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Snapchat Ads from a Connection Pool in WebLogic
Use the CData JDBC Driver for Snapchat Ads to connect to Snapchat Ads data from Web applications running on WebLogic.
-
Connect to Simplesat from Asprova with CData Software ODBC Driver for Simplesat
This article shows how to connect faster to Simplesat data from Asprova.