CData Software - Knowledge Base
Recent Articles
-
Connect to Access in SpagoBI
Create reports featuring live Microsoft Access in SpagoBI Studio. Host Access reports on SpagoBI Server.
-
DataBind Cloudant to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Cloudant with the DevExpress Windows Forms and Web controls to provide IBM Cloudant to a chart.
-
Create Data Visualizations in Cognos BI with Phoenix
Access Apache Phoenix as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software ODBC Driver for Salesloft in MicroStrategy
Connect to Salesloft in MicroStrategy Developer using the CData Software ODBC Driver for Salesloft.
-
Automate Google Drive Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Drive from PowerShell? This article demonstrates how to utilize the Google Drive Cmdlets for tasks like connecting to Google Drive, automating operations, downloading data, and more.
-
Build MVC Applications with Connectivity to Adobe Experience Manager
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Adobe Experience Manager from an ASP.NET MVC application.
-
Edit and Search External Azure Active Directory Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Azure Active Directory to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Azure Active Directory objects that you can access from apps and the dashboard.
-
How to import MySQL into Apache Solr
Use the CData Software JDBC Driver for MySQL in Data Import Handler and create an automated import of MySQL to Apache Solr Enterprise Search platform.
-
Create Blackbaud FE NXT-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Blackbaud FE NXT from OutSystems and build custom enterprise apps using live Blackbaud FE NXT.
-
Create Apps from SingleStore in Qlik Sense Cloud
Use CData Connect AI to connect to SingleStore and build apps from live SingleStore in Qlik Sense Cloud.
-
Migrating data from Phoenix to Snowflake using CData SSIS Components.
Easily push Apache Phoenix to Snowflake using the CData SSIS Tasks for Phoenix and Snowflake.
-
Create SSAS Tabular Models from Slack
How to build a SQL Server Analysis Service Tabular Model from Slack using CData drivers.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Sage Business Cloud Accounting to Power BI dashboards. Simply drag and drop Sage Business Cloud Accounting into data visuals on the Power BI canvas.
-
Edit and Search External QuickBooks Time Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of QuickBooks Time to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create QuickBooks Time objects that you can access from apps and the dashboard.
-
Automated Continuous Bullhorn CRM Replication to SQLite
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to SQLite.
-
Use the CData Software ODBC Driver for Oracle HCM Cloud in MicroStrategy
Connect to Oracle HCM Cloud in MicroStrategy Developer using the CData Software ODBC Driver for Oracle HCM Cloud.
-
Automated Continuous Outreach.io Replication to Databricks
Use CData Sync for automated, continuous, customizable Outreach.io replication to Databricks.
-
Access HCL Domino as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access HCL Domino from your Oracle system.
-
Connect to and Visualize Live Microsoft Dataverse in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Dataverse (CDS).
-
How to integrate Metabase with Amazon Marketplace
Use CData Connect AI to connect to live Amazon Marketplace and create an interactive dashboard in Metabase from Amazon Marketplace.
-
Analyze QuickBooks Online in Cognos Analytics
Use CData Connect AI to connect to QuickBooks Online from Cognos Analytics and analyze live QuickBooks Online.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for BigCommerce
Provide connectivity to BigCommerce through an SAP BusinessObjects universe.
-
How to Connect DBeaver to Dynamics NAV via a JDBC Driver
Manage Microsoft Dynamics NAV with visual tools in DBeaver like the query browser.
-
Use Claude to Talk to Your Google Drive via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Google Drive for you.
-
How to connect and process HubDB from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live HubDB.
-
Access Hive as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Apache Hive from your Oracle system.
-
Connecting GenSpark with Sage 200 via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across hundreds of systems without any replication or custom integration required.
-
Splunk Reporting in OBIEE with the Splunk JDBC Driver
Deploy the Splunk JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use ChatGPT to Talk to Your Microsoft Exchange via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Microsoft Exchange for you.
-
Bridge Phoenix Connectivity with Apache NiFi
Access and process Apache Phoenix in Apache NiFi using the CData JDBC Driver.
-
Access Live PostgreSQL in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to PostgreSQL from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate with CockroachDB in JReport Designer
Create charts and reports based on CockroachDB in JReport Designer.
-
Connect to Impala in DBeaver
Use the CData ODBC Driver to connect to Apache Impala in DBeaver.
-
Use ChatGPT to Talk to Your YouTube Analytics via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your YouTube Analytics for you.
-
Integrate Theia IDE with Live Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Perform Batch Operations with Zoho Creator in Apache NiFi
Connect to Zoho Creator and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Visualize Azure Table in Sisense
Create an ElastiCube in Sisense app with access to Azure Table Storage.
-
Excel Spreadsheet Automation on Okta with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Extend Google Sheets with Oracle
Make calls to the API Server from Google Apps Script.
-
Integrate ConstantContact in the Pentaho Report Designer
Publish reports based on ConstantContact in the Pentaho BI tool.
-
Work with Salesloft in FoxPro
Load Salesloft into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Visualize Oracle HCM Cloud Data in Python with pandas
Use pandas and other modules to analyze and visualize live Oracle HCM Cloud in Python.
-
Use Microsoft Copilot Studio to talk to your Jira Service Management via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Atlassian Jira Service Management for you.
-
Create Data Visualizations in Cognos BI with AlloyDB
Access Google AlloyDB as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Connect to Live Google Contacts from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Google Contacts for you.
-
Automated Continuous Coinbase Replication to MySQL
Use CData Sync for automated, continuous, customizable Coinbase replication to MySQL.
-
How to Import Data from Vault CRM into Google Sheets
Import Veeva Vault & Vault CRM into a Google spreadsheet that is automatically refreshed.
-
Import Real-Time SAP Netweaver Gateway via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP Netweaver Gateway in ColdFusion.
-
Create Freshdesk-Connected Dashboards in Grafana
Connect to Freshdesk via CData Connect AI in Grafana and create custom business dashboards with real-time access to Freshdesk.
-
Create Zoho CRM-Connected Nintex Workflows
Use CData Connect AI to connect to Zoho CRM from Nintex Workflow Cloud and build custom workflows using live Zoho CRM.
-
Access Asana as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Asana from your Oracle system.
-
Visualize Oracle HCM Cloud in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Oracle HCM Cloud into TIBCO Spotfire.
-
SQL Access to Redis Data
An article highlighting the available features and functionality of CData Software Drivers for Redis.
-
Create LinkedIn Ads Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData ODBC Driver for DocuSign from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for DocuSign to connect to DocuSign from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring DocuSign in Excel.
-
How to Connect to Live Square in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Square without replication.
-
Connect to JotForm as an External Source in Dremio
Use the CData JDBC Driver to connect to JotForm as an External Source in Dremio.
-
Create Data Visualizations in Cognos BI with Sage Cloud Accounting
Access Sage Business Cloud Accounting as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Excel Spreadsheet Automation on Google Spanner with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
How to Create Power BI Visual Reports with Real-Time Salesforce Data Cloud
Use CData Power BI Connectors to visualize Salesforce Data Cloud in Power BI.
-
How to connect and process Google Ads from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Ads.
-
Migrating data from Eventbrite to Databricks using CData SSIS Components.
Easily push Eventbrite to Databricks using the CData SSIS Tasks for Eventbrite and Databricks.
-
Access Live Dynamics 365 Business Central in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Dynamics 365 Business Central into the statistical analysis tools available in SAS JMP. This article shows how to use Dynamics 365 Business Central in the Graph Builder and Query Builder.
-
How to Connect to Live Google Spanner in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Google Spanner for you.
-
Connect to Real-Time Dropbox Data in Power Apps Using Dataflows to Build Custom Applications
-