CData Software - Knowledge Base
Recent Articles
-
Query Omnisend Data in DataGrip
Create a Data Source for Omnisend in DataGrip and use SQL to query live Omnisend data.
-
Build Dashboards with SAP Hybris C4C Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Hybris C4C data in Dundas BI.
-
Automated Continuous Mode Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Mode replication to Amazon S3.
-
Model, Search, and Visualize Live MongoDB Data in ThoughtSpot
Use CData Connect AI to connect to live MongoDB data for modeling, searching, and visualizing.
-
Connect to Pipedrive Data in DBeaver
Use the CData ODBC Driver to connect to Pipedrive data in DBeaver.
-
Connect to Zoho Creator Data in CloverDX (formerly CloverETL)
Transfer Zoho Creator data using the visual workflow in the CloverDX data integration tool.
-
Deploy the ADO.NET Provider for Amplitude on an SSRS Report Server
Connect to Amplitude data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect to MailChimp Data from AWS Glue
Use CData Connect AI to gain access to live MailChimp data from your AWS Glue jobs.
-
Access Live Oracle Sales 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 Oracle Sales data through MCP integration.
-
MariaDB Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to MariaDB data through CData Connect AI using different applications and tools.
-
Object-Relational Mapping (ORM) with RabbitMQ Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to RabbitMQ data into a Java-based ORM framework, Hibernate.
-
Getting Started with the CData JDBC Driver for Office 365
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Office 365.
-
How to Visualize LDAP Objects in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live LDAP objects in Python.
-
Use the CData Software JDBC Driver for Coinbase in MicroStrategy
Connect to Coinbase data in MicroStrategy Developer using the CData Software JDBC Driver for Coinbase.
-
Visualize Oracle Service Cloud Data in TIBCO Spotfire through ADO.NET
Integrate Oracle Service Cloud data into dashboards in TIBCO Spotfire.
-
Create Reports from MariaDB Data in Looker Studio
Use CData Connect AI to gain access to live MariaDB data and create custom reports in Looker Studio.
-
Connect to ConstantContact Data from AWS Glue
Use CData Connect AI to gain access to live ConstantContact data from your AWS Glue jobs.
-
How to connect PolyBase to MailerSend
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live MailerSend data.
-
Connect to Real-Time Tavily Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Tavily data in Power Apps.
-
Integrating Kiro with Bullhorn CRM 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.
-
Visualize ZohoExpense Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ZohoExpense data.
-
How to publish and share Zoho Books Data dashboards with Tableau Server
The CData ODBC driver for Zoho Books enables you integrate Zoho Books data into Tableau dashboards.
-
How to Connect the Power BI Service to Facebook: Complete Guide
Connect to the CData Software Power BI Connector for Facebook from PowerBI.com to provide real-time Facebook data across the organization.
-
Integrate Cursor with Live Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Oracle Sales data from within the editor.
-
Integrate Google Analytics with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Analytics with External Services.
-
Access Oracle Data from MySQL in PHP
Connect to Oracle through the standard MySQL libraries in PHP.
-
Connect to Amazon DynamoDB from Asprova with CData Software ODBC Driver for Amazon DynamoDB
This article shows how to connect faster to Amazon DynamoDB data from Asprova.
-
Build Dashboards with SAP Ariba Procurement Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Ariba Procurement data in Dundas BI.
-
Build AI Agents with SAP Ariba Source 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 SAP Ariba Source data through CData Connect AI.
-
Build AI/ML Models with Live PhantomBuster Data using Dataiku
Connect PhantomBuster Data with Dataiku using the CData API Driver for JDBC.
-
How to integrate Amazon DynamoDB with Apache Airflow
Access and process Amazon DynamoDB data in Apache Airflow using the CData JDBC Driver.
-
How to Access Live Epicor Kinetic Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Epicor Kinetic enables you to integrate Epicor Kinetic data into workflows built using Microsoft Power Automate Desktop.
-
Create Datasets from Redshift in Domo Workbench and Build Visualizations of Redshift Data in Domo
Use the CData Software ODBC Driver for Redshift to create datasets from Redshift data in Domo Workbench and then build visualizations in the Domo service.
-
Natively Connect to Insightly Data in PHP
The CData ODBC driver for Insightly enables you to create PHP applications with connectivity to Insightly data. Leverage the native support for ODBC in PHP.
-
Analyze Live WooCommerce Data in SAS Viya
Use CData Connect AI to connect to WooCommerce data from SAS Viya and deploy self-service analytics using live WooCommerce data.
-
Integrate Dify with Live Google Cloud Storage Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Google Cloud Storage data.
-
Automated Continuous ElevenLabs Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ElevenLabs replication to Google BigQuery.
-
Query AdRoll Data as a MySQL Database in Node.js
Execute MySQL queries against AdRoll data from Node.js.
-
Connect to SAP ByDesign from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP ByDesign to connect to SAP ByDesign data from Web applications running on WebLogic.
-
Publish Reports with Adobe Analytics Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Adobe Analytics data.
-
Automated Continuous Factorial Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Factorial replication to delimited files (CSV/TSV).
-
Query Azure Table Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Azure Table data from Node.js.
-
How to Visualize Okta Data in Python with pandas
Use pandas and other modules to analyze and visualize live Okta data in Python.
-
Integrating LangChain with Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Microsoft Dataverse data within automated workflows.
-
How to work with Google Ad Manager Data in Apache Spark using SQL
Access and process Google Ad Manager Data in Apache Spark using the CData Software JDBC Driver.
-
How to connect and process AgileCRM data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live AgileCRM data.
-
Getting Started with the CData Python Connector for Odoo
Learn to install and license the CData Python Connector and configure a connection to live Odoo data.
-
Analyze LDAP Objects in Looker
Use CData Connect AI to connect to LDAP Objects from Looker and build custom apps using live LDAP objects.
-
Automated Continuous SharePoint Replication to Snowflake
Use CData Sync for automated, continuous, customizable SharePoint replication to Snowflake.
-
Automate Freshsales Data Replication to SAP HANA
Use CData Sync to customize and automate Freshsales data replication to SAP HANA.
-
Connecting Mastra with Basecamp 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 Basecamp data, no replication required.
-
Operational Reporting on HubSpot Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote HubSpot data.
-
How to work with Adobe Target Data in Apache Spark using SQL
Access and process Adobe Target Data in Apache Spark using the CData Software JDBC Driver.
-
Automate ZohoDesk Data Replication to SAP HANA
Use CData Sync to customize and automate ZohoDesk data replication to SAP HANA.
-
Automated Continuous Oracle Eloqua Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Azure SQL Database.
-
How to work with Smartsheet Data in Apache Spark using SQL
Access and process Smartsheet Data in Apache Spark using the CData Software JDBC Driver.
-
Build an OLAP Cube in SSAS from LinkedIn Ads Data
Establish a connection to LinkedIn Ads data data from SQL Server Analysis Services, and use the LinkedIn Ads Data Provider to build OLAP cubes for use in analytics and reporting.
-
Replicate Multiple LightSpeedRetail Accounts
Replicate multiple LightSpeedRetail accounts to one or many databases.
-
Integrate with Confluence Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Confluence data in SnapLogic.
-
Connect to Apollo Data in Ruby
Connect to Apollo data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automate CockroachDB Data Replication to Couchbase
Use CData Sync to Customize and automate CockroachDB data replication to Couchbase.
-
Use the CData Software ODBC Driver for Figshare in MicroStrategy Web
Connect to Figshare data in MicroStrategy Web using the CData Software ODBC Driver for Figshare.
-
Getting Started with the CData Tableau Connector for Anaplan
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Anaplan.
-
Query PostgreSQL Data as a SQL Server Database in Node.js
Execute SQL Server queries against PostgreSQL data from Node.js.
-
Connect to and Visualize Live Zoho Projects Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Zoho Projects data.
-
Automate Microsoft OneLake Data Replication to SAP HANA
Use CData Sync to customize and automate Microsoft OneLake data replication to SAP HANA.
-
Connect to ConvertAPI Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ConvertAPI data.
-
Connect to Azure Data Catalog from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Azure Data Catalog data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Replicate YouTube Analytics Data from PowerShell
Write a quick PowerShell script to query YouTube Analytics data. Use connectivity to the live data to replicate YouTube Analytics data to SQL Server.
-
ZarMoney Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ZarMoney facts in real time.
-
Access Live Hubstaff Data in Coginiti Pro
Connect to and query live Hubstaff data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Zoom Data from a Connection Pool in JBoss
Integrate Zoom data into Java servlets: Use the Management Console in JBoss to install the Zoom JDBC Driver.
-
Using the CData Software ODBC Driver for OnePageCrm in PyCharm
Connect to OnePageCrm as an ODBC data source in PyCharm using the CData Software ODBC Driver for OnePageCrm.
-
Work with Postmark Data in FoxPro
Load Postmark data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live Stripe Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Stripe data from your Google Sheets.
-
Connect to Office 365 Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Office 365 data from Filemaker Pro on Mac.
-
Query Avalara AvaTax Data as a SQL Server Database in Node.js
Execute SQL Server queries against Avalara AvaTax data from Node.js.
-
Use Grok to Talk to Your Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Sugar CRM data for you.
-
How to connect to Gorgias Data from IntelliJ
Integrate connectivity to Gorgias data with wizards in IntelliJ.
-
Use Dash to Build to Web Apps on CSV Data
Create Python applications that use pandas and Dash to build CSV-connected web apps.
-
How to publish and share Facebook Ads Data dashboards with Tableau Server
The CData ODBC driver for Facebook Ads enables you integrate Facebook Ads data into Tableau dashboards.
-
DataBind Charts to Jira Assets Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Jira Assets 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.
-
LINQ to Cloudflare 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 Cloudflare Data Provider.
-
How to integrate Metabase with Apollo Data
Use CData Connect AI to connect to live Apollo data and create an interactive dashboard in Metabase from Apollo data.
-
Build QuickBooks Time-Connected Apps in Choreo
Use CData Connect AI to connect to QuickBooks Time Data from Choreo and build custom apps using live QuickBooks Time data.
-
Automated Continuous Avalara AvaTax Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Azure SQL Database.
-
Natively Connect to Adobe Target Data in PHP
The CData ODBC driver for Adobe Target enables you to create PHP applications with connectivity to Adobe Target data. Leverage the native support for ODBC in PHP.
-
Automate ZarMoney Data Replication to Couchbase
Use CData Sync to Customize and automate ZarMoney data replication to Couchbase.
-
Replicate Amazon DynamoDB Data to Multiple Databases via the CData Sync CLI
Replicate Amazon DynamoDB data to disparate databases with a single configuration.
-
Integrating Boomi Agentstudio with Freshdesk Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Freshdesk data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use the CData Software JDBC Driver for Helpscout in MicroStrategy Web
Connect to Helpscout data in MicroStrategy Web using the CData Software JDBC Driver for Helpscout.
-
Connect to and Query iContact Data in QlikView over ODBC
Create data visualizations with iContact data in QlikView.
-
Add Missive Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Missive with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create Salesforce Data 360-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Salesforce Data 360 Data from OutSystems and build custom enterprise apps using live Salesforce Data 360 data.
-
Automated Continuous Landbot Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Landbot replication to Apache Kafka.
-
DataBind NetSuite Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for NetSuite with the DevExpress Windows Forms and Web controls to provide NetSuite data to a chart.
-
Replicate Mode Data from PowerShell
Write a quick PowerShell script to query Mode data. Use connectivity to the live data to replicate Mode data to SQL Server.
-
Use Biml to Build SSIS Tasks to Replicate CampaignMonitor Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate CampaignMonitor data to SQL Server.
-
Access Jumpseller 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 Jumpseller data.
-
Create Informatica Mappings From/To an ODBC Data Source for Nethunt
Create an ODBC connection to Nethunt in Informatica and browse and transfer Nethunt data.