CData Software - Knowledge Base
Recent Articles
-
NASA Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on NASA facts in real time.
-
Build Dashboards with OnePageCrm Data in Dundas BI
Create dynamic dashboards and perform analytics based on OnePageCrm data in Dundas BI.
-
Build Visualizations of Sybase IQ Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Sybase IQ data in Birst.
-
Automated Continuous Email Replication to MongoDB
Use CData Sync for automated, continuous, customizable Email replication to MongoDB.
-
Automated Continuous Databricks Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Databricks replication to delimited files (CSV/TSV).
-
Use Databricks Agent Bricks to Talk to Your Amazon DynamoDB Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Amazon DynamoDB data for you.
-
Connect to Amazon S3 Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Amazon S3 Data and connect to Amazon S3 data in Akorbi Digital RunMyProcess.
-
Automate Dropbox Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Dropbox data from PowerShell? This article demonstrates how to utilize the Dropbox Cmdlets for tasks like connecting to Dropbox data, automating operations, downloading data, and more.
-
Connect to HCL Domino Data from HeidiSQL
Use CData Connect AI to connect to and query live HCL Domino data from HeidiSQL.
-
Use Manus AI to Talk to Your Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Sage 200 data.
-
Integrate Theia IDE with Live ServiceDesk Plus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live ServiceDesk Plus data from within the development environment.
-
Connect to Stripe from Asprova with CData Software ODBC Driver for Stripe
This article shows how to connect faster to Stripe data from Asprova.
-
Connect ZohoSubscriptions to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ZohoSubscriptions with IBM WebSphere for seamless data integration and connectivity.
-
CampaignMonitor Reporting in OBIEE with the CampaignMonitor JDBC Driver
Deploy the CampaignMonitor JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Flowlu Replication to Vertica
Use CData Sync for automated, continuous, customizable Flowlu replication to Vertica.
-
How to connect Amazon QuickSight to Oracle Sales Data
Create a connection to Oracle Sales data in CData Connect AI and insert Oracle Sales data into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate Jira Assets Data into Power Automate Desktop using CData Connect
CData Connect for Jira Assets Data enables you to integrate Jira Assets data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Microsoft Dataverse from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Dataverse data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Work with Sugar CRM Data in AWS Glue Jobs Using JDBC
Connect to Sugar CRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Getting Started with the CData Tableau Connector for Cassandra
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Cassandra.
-
Query Rootly Data as a MySQL Database in Node.js
Execute MySQL queries against Rootly data from Node.js.
-
Process & Analyze Databricks Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Databricks Data.
-
Build Dashboards with Act-On Data in Dundas BI
Create dynamic dashboards and perform analytics based on Act-On data in Dundas BI.
-
Enable the JotForm JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with JotForm data.
-
Connect to Bitbucket Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Bitbucket as an External Source in Dremio.
-
Getting Started with the CData SSIS Components for Mocean
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Mocean.
-
Explore Geographical Relationships in Workable Data with Power Map
Create data visualizations with Workable data in Power Map.
-
Automated Continuous Marketo Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Marketo replication to Azure SQL Database.
-
Connect to PayPal Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for PayPal and the Script function in FileMaker Pro to connect to PayPal and work with PayPal data in your FileMaker application.
-
Query Simplesat Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Simplesat data from Node.js.
-
Create Power BI Reports on Real-Time Instantly Data
Use the CData ODBC Driver for Instantly to visualize Instantly data in Power BI Desktop.
-
Analyze BenchmarkEmail Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of BenchmarkEmail data and visualize BenchmarkEmail data in SAP Analytics Cloud.
-
Connect to ClickTime Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to ClickTime.
-
Working with ScrapingBee Data in LINQPad
Execute LINQ queries to ScrapingBee data in LINQPad.
-
Replicate Multiple Quickbase Accounts
Replicate multiple Quickbase accounts to one or many databases.
-
Create a Data Access Object for Invoiced Data using JDBI
A brief overview of creating a SQL Object API for Invoiced data in JDBI.
-
Access Live Square Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Square data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to MariaDB Data in NetBeans
Connect to MariaDB data in NetBeans with the data source configuration wizard.
-
Getting Started with the CData ODBC Driver for Jodoo
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Jodoo.
-
Connect to Paymo Data in Jaspersoft Studio
Execute SQL to remote Paymo data in Jaspersoft Studio.
-
How to use SQLAlchemy ORM to access TaxJar Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of TaxJar data.
-
Create Reports from Microsoft Planner Data in Looker Studio
Use CData Connect AI to gain access to live Microsoft Planner data and create custom reports in Looker Studio.
-
Create Informatica Mappings From/To a JDBC Data Source for Attio
Create Attio data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Informatica Mappings From/To an ODBC Data Source for Box
Create an ODBC connection to Box in Informatica and browse and transfer Box data.
-
How to Use a Microsoft Access Database to Update Google Drive Data in Real Time
Update Google Drive data by creating a linked table in Microsoft Access with the CData Google Drive ODBC Driver.
-
Analyze HubDB Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for HubDB from Power Pivot. You will use the Table Import Wizard to load HubDB data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Workday Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Workday data using standard SQL.
-
Bind Live Facebook Ads Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Facebook Ads data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Replicate Mistral AI Data to Multiple Databases
Replicate Mistral AI data to disparate databases with a point-and-click configuration.
-
Build Couchbase-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Couchbase data.
-
Automated Continuous Teamwork Replication to Oracle
Use CData Sync for automated, continuous, customizable Teamwork replication to Oracle.
-
DataBind Charts to Databricks Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Databricks 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.
-
Search External Power BI XMLA Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Power BI XMLA data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Power BI XMLA Data objects that you can access from apps and the dashboard.
-
Connect to Monday.com Data from a Connection Pool in JBoss
Integrate Monday.com data into Java servlets: Use the Management Console in JBoss to install the Monday.com JDBC Driver.
-
Enable the Hugging Face JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Hugging Face data.
-
Integrating Antigravity CLI with Neo4J data via CData CLI
Connect Neo4J data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
DataBind Controls to Missive Data in C++Builder
DataBind to Missive data in C++Builder with standard components and controls.
-
Create Power BI Reports on Real-Time AgileCRM Data
Use the CData ODBC Driver for AgileCRM to visualize AgileCRM data in Power BI Desktop.
-
Access ServiceDesk Plus Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ServiceDesk Plus data from HeidiSQL.
-
How to integrate Metabase with Pipedrive Data
Use CData Connect AI to connect to live Pipedrive data and create an interactive dashboard in Metabase from Pipedrive data.
-
Automated Continuous Paylocity Replication to Vertica
Use CData Sync for automated, continuous, customizable Paylocity replication to Vertica.
-
How to Build an ETL App for Google Analytics Data in Python with CData
Create ETL applications and real-time data pipelines for Google Analytics data in Python with petl.
-
Visualize Optimizely Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Optimizely data into TIBCO Spotfire.
-
Stream Pushbullet Data into Apache Kafka Topics
Access and stream Pushbullet data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Prepare, Blend, and Analyze Google Calendar Data in Alteryx Designer (ODBC)
Build workflows to access live Google Calendar data for self-service data analytics.
-
How to use SQLAlchemy ORM to access BigQuery Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of BigQuery data.
-
Access Live Qualaroo Data in AWS Lambda
Connect to live Qualaroo data in AWS Lambda using the CData JDBC Driver.
-
Access Live Trello Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Trello data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating Claude Code CLI with Humanity 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.
-
Connect to IBM Informix Data from Crystal Reports
Use CData Connect AI to connect to and report on live IBM Informix data from Crystal Reports.
-
Build Voice Agents in ElevenLabs with access to Live FHIR Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live FHIR data.
-
Create NetSuite-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to NetSuite Data from OutSystems and build custom enterprise apps using live NetSuite data.
-
Connect to MYOB AccountRight Data in HULFT Integrate
Connect to MYOB AccountRight as a JDBC data source in HULFT Integrate
-
Analyze Microsoft Exchange Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft Exchange data and visualize Microsoft Exchange data in SAP Analytics Cloud.
-
Create Dropbox-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Dropbox Data from Klipfolio and build custom visualizations using live Dropbox data.
-
Create SAS Data Sets-Connected Dashboards in Grafana
Connect to SAS Data Sets Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAS Data Sets data.
-
Connect to Active Directory 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 Active Directory data.
-
Import EnterpriseDB Data Using Azure Data Factory
Use CData Connect AI to connect to EnterpriseDB Data from Azure Data Factory and import live EnterpriseDB data.
-
Connect to Elorus from Asprova with CData Software ODBC Driver for Elorus
This article shows how to connect faster to Elorus data from Asprova.
-
Access Live Deel Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Deel data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to CSV Data in CloverDX (formerly CloverETL)
Transfer CSV data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Jumpseller Replication to SingleStore
Use CData Sync for automated, continuous, customizable Jumpseller replication to SingleStore.
-
Integrating Codex with Redis 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.
-
Connect CockroachDB Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your CockroachDB data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create HBase-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to HBase Data from OutSystems and build custom enterprise apps using live HBase data.
-
Design BIRT Reports on Email Data
Provide current Email data to your embedded analytics.
-
Access Live Azure Data Lake Storage Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure Data Lake Storage data from your Excel spreadsheets.
-
Connect Elorus to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Elorus data using the CData Python MCP Server.
-
Build Supabase-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Supabase data and build Supabase-connected web apps with Axios.
-
Use CData Connect AI to Access Azure DevOps Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Azure DevOps data in the Power Pivot business intelligence tool.
-
Migrating data from Harvest to Databricks using CData SSIS Components.
Easily push Harvest data to Databricks using the CData SSIS Tasks for Harvest and Databricks.
-
Integrate MailerSend with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate MailerSend with External Services.
-
Visualize Strava Data in TIBCO Spotfire through ADO.NET
Integrate Strava data into dashboards in TIBCO Spotfire.
-
How to connect Amazon QuickSight to Workday Data
Create a connection to Workday data in CData Connect AI and insert Workday data into Amazon QuickSight SPICE to build interactive dashboards.
-
DataBind Controls to Paymo Data in C++Builder
DataBind to Paymo data in C++Builder with standard components and controls.
-
Integrate with ZohoSubscriptions Data in SnapLogic
Use CData Connect AI to connect to and integrate with live ZohoSubscriptions data in SnapLogic.
-
Access SendInBlue Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SendInBlue data from your Oracle system.
-
How to Query MailerLite Data in MySQL Workbench
Execute MySQL queries against live MailerLite data from MySQL Workbench.
-
Working with Oracle Eloqua Reporting Data in LINQPad
Execute LINQ queries to Oracle Eloqua Reporting data in LINQPad.
-
Automated Instantly Data Replication to Teradata
Use CData Sync to Customize and automate Instantly data replication to Teradata.