CData Software - Knowledge Base
Recent Articles
-
Connect to Excel Online in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft Excel Online in the Denodo Virtual DataPort Administrator.
-
Integrate with Live Acumatica in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Acumatica from the MuleSoft Anypoint Platform to integrate live Acumatica ERP into custom reports and dashboards.
-
Analyze CockroachDB in Infragistics Reveal
Use CData Connect AI to create on OData API on top of CockroachDB and visualize live CockroachDB in Infragistics Reveal.
-
How to connect SharePoint with Raisers Edge NXT through external lists
Provide Raisers Edge NXT to SharePoint users as an external list.
-
Access Live Databricks in AWS Lambda
Connect to live Databricks in AWS Lambda using the CData JDBC Driver.
-
How to Connect Flowise AI Agents to Live AlloyDB via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
Analyze Oracle Financials Cloud in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Oracle Financials Cloud and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrating Gumloop with Trello via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Trello within automated workflows.
-
Connect to Greenplum in Ruby
Connect to Pivotal GreenPlum in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Migrating data from Klaviyo to Databricks using CData SSIS Components.
Easily push Klaviyo to Databricks using the CData SSIS Tasks for Klaviyo and Databricks.
-
Build SharePoint-Connected Apps in Choreo
Use CData Connect AI to connect to SharePoint from Choreo and build custom apps using live Microsoft SharePoint.
-
Replicate Multiple Raisers Edge NXT Accounts via the CData Sync CLI
Replicate multiple Raisers Edge NXT accounts to one or many databases.
-
Use the CData ODBC Driver for Bullhorn CRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Bullhorn CRM to connect to Bullhorn CRM from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Bullhorn CRM in Excel.
-
Use the CData Software ODBC Driver for PayPal in MicroStrategy Desktop
Connect to PayPal in MicroStrategy Desktop using the CData Software ODBC Driver for PayPal.
-
A PostgreSQL Interface for Freshdesk (MySQL Remoting via JDBC)
Use the Remoting features of the Freshdesk JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Redshift in MicroStrategy Desktop
Connect to Amazon Redshift in MicroStrategy Desktop using the CData Software JDBC Driver for Redshift.
-
Import Real-Time SQL Analysis Services via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SQL Analysis Services in ColdFusion.
-
How to Design Access Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
PowerShell Scripting to Replicate Coinbase to MySQL
Write a simple PowerShell script to replicate Coinbase to a MySQL database.
-
Connecting Mastra with ServiceNow 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 data across 300+ enterprise sources no replication required.
-
How to Connect the Power BI Service to SharePoint Excel Services: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Visualize Google Cloud Storage in TIBCO Spotfire through ADO.NET
Integrate Google Cloud Storage into dashboards in TIBCO Spotfire.
-
How to Connect the Power BI Service to Coinbase: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Create Monday.com-Connected Dashboards in Grafana
Connect to Monday.com via CData Connect AI in Grafana and create custom business dashboards with real-time access to Monday.com.
-
Create Data Visualizations Based On Salesforce Marketing in Mode
Use CData Connect AI to connect to Salesforce Marketing from Mode and build visualizations using live
-
Query Dynamics 365 Business Central in ColdFusion
Write standard ColdFusion data access code to connect to Dynamics 365 Business Central.
-
Automate CockroachDB Replication to Azure Synapse
Use CData Sync to customize and automate CockroachDB replication to Azure Synapse.
-
How to Connect to Live Zuora from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Zuora through natural language.
-
DataBind MYOB AccountRight to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for MYOB AccountRight with the DevExpress Windows Forms and Web controls to provide MYOB AccountRight to a chart.
-
Create Power BI Reports on Real-Time Elasticsearch
Use the CData ODBC Driver for Elasticsearch to visualize Elasticsearch in Power BI Desktop.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live NetSuite CRM & ERP using the Model Context Protocol.
-
How to Connect the Power BI Service to Google Data Catalog: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
How to pipe Google Cloud Storage to CSV in PowerShell
Use standard PowerShell cmdlets to access Google Cloud Storage tables.
-
Extend Google Sheets with SendGrid
Make calls to the API Server from Google Apps Script.
-
Integrate Amazon Athena in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Amazon Athena from Informatica Cloud.
-
Connect to Elasticsearch in the Denodo Platform
Use CData driver technologies to create a virtual data source for Elasticsearch in the Denodo Virtual DataPort Administrator.
-
Access Stripe from MySQL in Amazon QuickSight
Connect to Stripe and build visualizations of Stripe using a MySQL Connection in Amazon QuickSight.
-
Import Real-Time Zoho Creator via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zoho Creator in ColdFusion.
-
Import Real-Time Bing Ads via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Bing Ads in ColdFusion.
-
Connect and Query Live WordPress Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live WordPress into Databricks
-
Visualize Greenhouse in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Greenhouse into TIBCO Spotfire.
-
Create Informatica Mappings From/To a JDBC Data Source for Confluence
Create Confluence data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Publish Reports with Amazon DynamoDB in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Amazon DynamoDB.
-
Replicate CSV from PowerShell
Write a quick PowerShell script to query CSV/TSV Files. Use connectivity to the live data to replicate CSV/TSV Files to SQL Server.
-
Natively Connect to Sage 200 in PHP
The CData ODBC driver for Sage 200 enables you to create PHP applications with connectivity to Sage 200. Leverage the native support for ODBC in PHP.
-
Creating Power BI XMLA-Connected Applications in Unqork
You can use CData Connect AI to feed Power BI XMLA to Unqork and build custom business apps.
-
Visualize Drift in Sisense
Create an ElastiCube in Sisense app with access to Drift.
-
Connect to Stripe in SpagoBI
Create reports featuring live Stripe in SpagoBI Studio. Host Stripe reports on SpagoBI Server.
-
Automated Continuous Raisers Edge NXT Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Amazon S3.
-
Query Cosmos DB in DataGrip
Create a Data Source for Cosmos DB in DataGrip and use SQL to query live Azure Cosmos DB.
-
Build Dashboards with YouTube Analytics in Dundas BI
Create dynamic dashboards and perform analytics based on YouTube Analytics in Dundas BI.
-
Create Dashboards and Visualize Live Sugar CRM in Geckoboard
Use CData Connect AI to connect to live Sugar CRM and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build a Simple VCL Application for Dropbox
How to build a simple VCL Application to view Dropbox in RAD Studio using the CData ODBC Driver for Dropbox.
-
Connecting Moonlit Workflow with SurveyMonkey via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SurveyMonkey in real time.
-
How to integrate MySQL with Apache Airflow
Access and process MySQL in Apache Airflow using the CData JDBC Driver.
-
Publish SAP Business One-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP Business One.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for BambooHR
Provide connectivity to BambooHR through an SAP BusinessObjects universe.
-
Add SendGrid to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SendGrid with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating LangGraph with Microsoft Dataverse via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft Dataverse (CDS) within automated workflows.
-
Create Oracle Service Cloud-Connected Business Apps in AppSheet
Connect to Oracle Service Cloud via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Oracle Service Cloud.
-
Connect to and Query MySQL in QlikView over ODBC
Create data visualizations with MySQL in QlikView.
-
Integrate Office 365 into Automated Tasks with Power Automate
Use CData Connect AI to connect to Microsoft Office 365 and integrate live Microsoft Office 365 into your Power Automate tasks.
-
How to Work with SAS Data Sets in ETL Validator JDBC
Connect to SAS Data Sets from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Monday.com from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Monday.com using standard SQL.
-
How to Connect to Live Amazon Athena 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 Amazon Athena without replication.
-
Automate Bullhorn CRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Bullhorn CRM from PowerShell? This article demonstrates how to utilize the Bullhorn CRM Cmdlets for tasks like connecting to Bullhorn CRM, automating operations, downloading data, and more.
-
Connect to Zoho CRM as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Zoho CRM.
-
How to Easily Query Google Cloud Storage in OpenOffice Base
-