CData Software - Knowledge Base
Recent Articles
-
Connect to and Visualize Live Discord Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Discord data.
-
Connect to Real-Time MySQL Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for MySQL and Dataflow to import and use MySQL data in Power Apps.
-
Connect to Auth0 Data in DBeaver
Use the CData ODBC Driver to connect to Auth0 data in DBeaver.
-
How to Connect Google Calendar Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Google Calendar data in real time using natural language.
-
Establish a Live Connection with Access Data using Tableau Bridge
The CData ODBC Driver for Access enables you to integrate live Access data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating Kiro with Amazon S3 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.
-
How to Create Power BI Visual Reports with Real-Time Excel Data
Use CData Power BI Connectors to visualize Excel data in Power BI.
-
Integrating Kiro with ServiceNow 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.
-
LINQ to Coda 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 Coda Data Provider.
-
Enable the Avaza JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Avaza data.
-
Access Billsby Data from MySQL in Amazon QuickSight
Connect to Billsby and build visualizations of Billsby data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Azure Synapse Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Apache Kafka.
-
Connect to QuickBooks Data in Ruby
Connect to QuickBooks data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Natively Connect to SAP ByDesign Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAP ByDesign data. Leverage the native support for ODBC in PHP.
-
Automate Klaviyo Data Replication to SAP HANA
Use CData Sync to customize and automate Klaviyo data replication to SAP HANA.
-
Import Real-Time CampaignMonitor Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use CampaignMonitor data in ColdFusion.
-
Easily Integrate Monday.com Data in Lazarus Pascal IDE
Learn how to easily integrate live Monday.com data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous LinkedIn Ads Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to Azure SQL Database.
-
Extract, Transform, and Load SAP Ariba Procurement Data in Informatica PowerCenter
Create a simple Workflow for SAP Ariba Procurement data in Informatica PowerCenter.
-
Automated Continuous HubDB Replication to Oracle
Use CData Sync for automated, continuous, customizable HubDB replication to Oracle.
-
Visualize Live Tavily Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Tavily data into custom reports in Power BI.
-
Visualize MariaDB Data in TIBCO Spotfire through OData
Integrate MariaDB data into dashboards in TIBCO Spotfire.
-
Automated Continuous Freshsales Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Freshsales replication to Amazon Redshift.
-
Extract, Transform, and Load Scrapfly Data in Informatica PowerCenter
Create a simple Workflow for Scrapfly data in Informatica PowerCenter.
-
Use the CData Software ODBC Driver for Parquet in MicroStrategy Desktop
Connect to Parquet data in MicroStrategy Desktop using the CData Software ODBC Driver for Parquet.
-
How to use SQLAlchemy ORM to access CircleCI Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of CircleCI data.
-
Excel Spreadsheet Automation on Close Data with the QUERY Formula
Pull data from Close, automate spreadsheets, and more with the QUERY formula.
-
Automate Eventbrite Data Replication to Azure Data Lake
Use CData Sync to customize and automate Eventbrite data replication to Azure Data Lake.
-
Connect to Salesforce CRM Analytics Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Salesforce CRM Analytics Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Oracle Sales Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Oracle Sales from PowerBI.com to create Power BI Dataflows with real-time data.
-
LINQ to Gumroad 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 Gumroad Data Provider.
-
Connect to Presto Data from PowerBuilder via JDBC
This article demonstrates how to access Presto data from PowerBuilder using the Presto JDBC Driver.
-
Migrating data from Simplesat to Databricks using CData SSIS Components.
Easily push Simplesat data to Databricks using the CData SSIS Tasks for Simplesat and Databricks.
-
Automated Continuous Printify Replication to Oracle
Use CData Sync for automated, continuous, customizable Printify replication to Oracle.
-
Trello Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Trello facts in real time.
-
Connect to Oracle in SpagoBI
Create reports featuring live Oracle data in SpagoBI Studio. Host Oracle reports on SpagoBI Server.
-
Build an OLAP Cube in SSAS from PolarTeamPro Data
Establish a connection to PolarTeamPro data data from SQL Server Analysis Services, and use the PolarTeamPro Data Provider to build OLAP cubes for use in analytics and reporting.
-
Load Slack Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Slack data to a database.
-
How to connect and process Oracle Eloqua data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle Eloqua data.
-
Operational Reporting on JSON Services from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote JSON services.
-
Asana Reporting in OBIEE with the Asana JDBC Driver
Deploy the Asana JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Wave Financial Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Wave Financial to connect to Wave Financial data and execute queries in PowerBuilder.
-
Connect to Office 365 Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Office 365 data in Airbyte.
-
Automated Continuous Clari Replication to SingleStore
Use CData Sync for automated, continuous, customizable Clari replication to SingleStore.
-
How to Create Power BI Visual Reports with Real-Time TigerGraph Data
Use CData Power BI Connectors to visualize TigerGraph data in Power BI.
-
Publish Crystal Reports on ServiceNow Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ServiceNow data.
-
How to work with SAP Business One Data in Apache Spark using SQL
Access and process SAP Business One Data in Apache Spark using the CData Software JDBC Driver.
-
Create Timely-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Timely Data from OutSystems and build custom enterprise apps using live Timely data.
-
How to connect to Mode Data in DBVisualizer
Integrate Mode data with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live SageHR Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live SageHR data through MCP integration.
-
Connect to Blackbaud FE NXT Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Blackbaud FE NXT data from Filemaker Pro on Mac.
-
Automated Continuous Reply.io Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Reply.io replication to Google BigQuery.
-
Build Zoho Books Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Zoho Books data and build visualizations in Tableau Cloud.
-
Integrate Cosmos DB with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Cosmos DB with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Cosmos DB data.
-
Replicate Sybase IQ Data to Multiple Databases via the CData Sync CLI
Replicate Sybase IQ data to disparate databases with a single configuration.
-
Connect to Snowflake Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Snowflake data.
-
Create Reports with PhantomBuster Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PhantomBuster data.
-
Integrating Claude Code CLI with SAP SuccessFactors LMS 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.
-
Query Moosend Data in DataGrip
Create a Data Source for Moosend in DataGrip and use SQL to query live Moosend data.
-
Excel Spreadsheet Automation on Box Data with the QUERY Formula
Pull data from Box, automate spreadsheets, and more with the QUERY formula.
-
Build AI Agents with Grafana Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Grafana data through CData Connect AI.
-
Migrating data from Rebilly to Snowflake using CData SSIS Components.
Easily push Rebilly data to Snowflake using the CData SSIS Tasks for Rebilly and Snowflake.
-
Create Reports from ZohoPeople Data in Looker Studio
Use CData Connect AI to gain access to live ZohoPeople data and create custom reports in Looker Studio.
-
Choosing the Best Method to Connect SAP Netweaver Gateway to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP Netweaver Gateway data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use JayDeBeApi to access NASA Data in Python
Use standard Python scripting and the development environment of your choice to access live NASA data.
-
Edit and Search External SendGrid Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SendGrid data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SendGrid Data objects that you can access from apps and the dashboard.
-
Automated Continuous SuiteCRM Replication to Snowflake
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Snowflake.
-
Access Typeform Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Typeform data.
-
How to Connect to Live SharePoint Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your SharePoint data for you.
-
Getting Started with the CData Power BI Connector for CouchDB
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for CouchDB.
-
How to connect to SAP Business Warehouse Data in DBVisualizer
Integrate SAP Business Warehouse data with visual data analysis tools and data connection wizards in DBVisualizer
-
Query Live Apollo 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 Apollo data directly from the development environment.
-
Build CouchDB-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live CouchDB data.
-
Create SSAS Tabular Models from PabblySubscriptions Data
How to build a SQL Server Analysis Service Tabular Model from PabblySubscriptions data using CData drivers.
-
Automate Jumpseller Data Replication to Azure Data Lake
Use CData Sync to customize and automate Jumpseller data replication to Azure Data Lake.
-
Consume Twilio OData Feeds in PowerBuilder
This article demonstrates how to consume Twilio data as OData feeds from PowerBuilder using the API Server.
-
How to create an RPA flow for SQL Analysis Services Data in UiPath Studio
Use the SQL Analysis Services ODBC Driver to create workflows that access real-time SQL Analysis Services data without any coding.
-
How to Query Stack Exchange Data in MySQL Workbench
Execute MySQL queries against live Stack Exchange data from MySQL Workbench.
-
Create SSAS Tabular Models from Gong Data
How to build a SQL Server Analysis Service Tabular Model from Gong data using CData drivers.
-
Import FHIR Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to FHIR Data and provide access to live FHIR data for custom reports in the Power BI Service.
-
How to Visualize Workable Data in Python with pandas
Use pandas and other modules to analyze and visualize live Workable data in Python.
-
Integrating Cassandra Data in Talend Cloud Data Management Platform
Connect Cassandra Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Cassandra.
-
Automate Stack Exchange Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Stack Exchange data from PowerShell? This article demonstrates how to utilize the Stack Exchange Cmdlets for tasks like connecting to Stack Exchange data, automating operations, downloading data, and more.
-
Connect to Tanda Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Tanda data.
-
Import and Visualize Oracle Eloqua Reporting Data in Power View
Create data visualizations based on Oracle Eloqua Reporting data in Excel.
-
Automate SAP Data Replication to SAP HANA
Use CData Sync to customize and automate SAP data replication to SAP HANA.
-
Bridge Reply.io Connectivity with Apache NiFi
Access and process Reply.io data in Apache NiFi using the CData JDBC Driver.
-
Create Reports with Accelo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Accelo data.
-
Visualize Live LaunchDarkly Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live LaunchDarkly data.
-
Visualize ZohoInvoice 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 ZohoInvoice data into TIBCO Spotfire.
-
Integrate with SendInBlue Data in JReport Designer
Create charts and reports based on SendInBlue data in JReport Designer.
-
Create Informatica Mappings From/To a JDBC Data Source for ClickUp
Create ClickUp data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Load Accelo Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Accelo data to a database.
-
Enable the Drip JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Drip data.
-
Integrate Oracle Sales Data into Power Automate Desktop using CData Connect
CData Connect for Oracle Sales Data enables you to integrate Oracle Sales data into workflows built using Microsoft Power Automate Desktop.
-
Build a PostgreSQL Interface for Ontraport Data using the CData JDBC Driver
Use the Remoting features of the Ontraport JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live Mouseflow Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Mouseflow data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize GitHub Data in Tableau
The CData ODBC driver for GitHub enables you integrate GitHub data into Tableau dashboards.
-
Connect to Dynamics NAV Data in Google Apps Script via Connect AI
Use CData Connect AI to access Dynamics NAV data in Google Apps Script.
-
Integrating Impala Data in Talend Cloud Data Management Platform
Connect Impala Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Impala.