CData Software - Knowledge Base
Recent Articles
-
Manage Printful Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Printful.
-
Connect to Odoo Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Odoo and the SQL Gateway to access Odoo ERP from Google Apps Script.
-
Build Dashboards with Jodoo Data in Dundas BI
Create dynamic dashboards and perform analytics based on Jodoo in Dundas BI.
-
Integrate Live YouTube Analytics Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live YouTube Analytics to Blue Prism using the CData ODBC Driver for YouTube Analytics to create automated workflows for repetitive business tasks.
-
Connect to Drift Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Drift using standard SQL.
-
Integrate Live Microsoft Planner Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft Planner to Blue Prism using the CData ODBC Driver for Microsoft Planner to create automated workflows for repetitive business tasks.
-
Analyze Live Salesforce Marketing Data in SAS Viya
Use CData Connect AI to connect to Salesforce Marketing Cloud from SAS Viya and deploy self-service analytics using live Salesforce Marketing Cloud.
-
Create Reports with Elasticsearch Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Elasticsearch.
-
Access Live Amazon Athena Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Amazon Athena from your Excel spreadsheets.
-
How to connect to MYOB AccountRight Data from Spring Boot
Connect to MYOB AccountRight in a Spring Boot Application using the CData JDBC Driver for MYOB AccountRight
-
Excel Spreadsheet Automation on Helpscout Data with the QUERY Formula
Pull data from Helpscout, automate spreadsheets, and more with the QUERY formula.
-
Build Freshdesk Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Freshdesk and build visualizations in Tableau Cloud.
-
Replicate Amazon Athena Data to Multiple Databases via the CData Sync CLI
Replicate Amazon Athena to disparate databases with a single configuration.
-
Connect to Exact Online Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Exact Online.
-
DataBind Charts to Mouseflow Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Mouseflow 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.
-
Connecting Agentforce with Azure Table Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Azure Table Storage for you.
-
Connect to Stack Exchange Data from a Connection Pool in JBoss
Integrate Stack Exchange into Java servlets: Use the Management Console in JBoss to install the Stack Exchange JDBC Driver.
-
Access Live Everhour Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Everhour in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP Fieldglass
Provide connectivity to SAP Fieldglass through an SAP BusinessObjects universe.
-
Connecting Pipedream with PostgreSQL Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on PostgreSQL data in real time.
-
Work with Live Klaviyo Data in Power Query
Use CData Connect AI to connect to Klaviyo and work with live Klaviyo in Microsoft Power Query.
-
Use the CData Software JDBC Driver for Optimizely in MicroStrategy Desktop
Connect to Optimizely in MicroStrategy Desktop using the CData Software JDBC Driver for Optimizely.
-
Visualize Live Google Ads Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Ads using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect Stack Exchange Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Stack Exchange using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate with Live Google Ads Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Google Ads from the MuleSoft Anypoint Platform to integrate live Google Ads into custom reports and dashboards.
-
Prepare, Blend, and Analyze Teamwork Data in Alteryx Designer (ODBC)
Build workflows to access live Teamwork for self-service data analytics.
-
Integrating Dataiku with MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live MongoDB.
-
Connect to LionDesk Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for LionDesk in the Denodo Virtual DataPort Administrator.
-
Build Paddle-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Paddle and build web apps with connectivity to live Paddle.
-
Build Semantic Layer Views for SAP Business Warehouse Data in APOS Live Data Gateway
Use the CData Connector for SAP Business Warehouse in APOS Live Data Gateway to build Semantic Layer Views for SAP Business Warehouse.
-
How to Query Live Everhour Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Everhour data in natural language using Python.
-
Migrating data from JotForm to Google BigQuery using CData SSIS Components.
Easily push JotForm to Google BigQuery using the CData SSIS Tasks for JotForm and Google BigQuery.
-
Build a PostgreSQL Interface for Jodoo Data using the CData JDBC Driver
Use the Remoting features of the Jodoo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Mailjet in MicroStrategy Desktop
Connect to Mailjet in MicroStrategy Desktop using the CData Software JDBC Driver for Mailjet.
-
How to Query Live Nethunt Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Nethunt data in natural language using Python.
-
How to connect to SQL Server Data in DBVisualizer
Integrate Microsoft SQL Server with visual data analysis tools and data connection wizards in DBVisualizer
-
Visualize BenchmarkEmail Data in TIBCO Spotfire through ADO.NET
Integrate BenchmarkEmail into dashboards in TIBCO Spotfire.
-
Query PDFMonkey Data through ODBC in Node.js
Use node-odbc to execute SQL queries against PDFMonkey from Node.js.
-
Connect Demio Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Demio using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Bidirectional Access to Pipeliner CRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Pipeliner CRM in Filemaker Pro for Mac or Windows.
-
Automated Continuous ZohoInvoice Replication to SQL Server
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to SQL Server.
-
Feed Jodoo Data into FineReport
How to set Jodoo as a JDBC data source in FineReport.
-
Integrate with Pipeline CRM Data in JReport Designer
Create charts and reports based on Pipeline CRM in JReport Designer.
-
Visualize Live Invoiced Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Invoiced using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Kafka Data in TIBCO Spotfire through ADO.NET
Integrate Apache Kafka into dashboards in TIBCO Spotfire.
-
Integrate Close with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Close with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Close.
-
Integrating Boomi Agentstudio with SAP Ariba Source Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SAP Ariba Source, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Optimizely Data in RazorSQL
Connect to Optimizely from wizards and query Optimizely from the GUI in the RazorSQL database management tool.
-
Create Apps from Phoenix Data in Qlik Sense Cloud
Use CData Connect AI to connect to Phoenix Data and build apps from live Apache Phoenix in Qlik Sense Cloud.
-
Integrate Excel Online with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Excel Online with External Services.
-
Use the CData ODBC Driver for Bitbucket from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Bitbucket to connect to Bitbucket from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Bitbucket in Excel.
-
Visualize GraphQL Data in Sisense
Create an ElastiCube in Sisense app with access to GraphQL.
-
Connect to Google Sheets 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 Google Sheets.
-
Build a PostgreSQL Interface for Close Data using the CData JDBC Driver
Use the Remoting features of the Close JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous HBase Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable HBase replication to Apache Kafka.
-
How to connect to SendInBlue Data from Spring Boot
Connect to SendInBlue in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous Keap Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Keap replication to Google Cloud SQL.
-
Connect to Bugsnag Data in Aqua Data Studio
Access Bugsnag from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Easily Query LionDesk Data in OpenOffice Base
Connect to LionDesk data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Work with Live CockroachDB Data in Power Query
Use CData Connect AI to connect to CockroachDB and work with live CockroachDB in Microsoft Power Query.
-
Build SAP HANA-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP HANA Data and create custom apps in Mendix.
-
How to Connect to Live Splunk 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 Splunk for you.
-
Connect to HBase from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Apache HBase, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Visualize Basecamp 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 Basecamp into TIBCO Spotfire.
-
Connect to Reckon Accounts Hosted Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Reckon Accounts Hosted Data and connect to Reckon Accounts Hosted in Akorbi Digital RunMyProcess.
-
Building Dynamic Web Pages with Dynamics NAV Data Using AngularJS
Create single-page applications with live connectivity to Dynamics NAV using the CData API Server.
-
Integrate Live Active Directory Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Active Directory to Blue Prism using the CData ODBC Driver for Active Directory to create automated workflows for repetitive business tasks.
-
Connect to NASA Data in RazorSQL
Connect to NASA from wizards and query NASA from the GUI in the RazorSQL database management tool.
-
Connect to Azure Synapse Data in RapidMiner
Integrate Azure Synapse with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData Python Connector for Amazon Marketplace
Learn to install and license the CData Python Connector
-
Write a Simple Go Application to work with Apollo Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Apollo.
-
Import and Visualize Greenhouse Data in Power View
Create data visualizations based on Greenhouse in Excel.
-
Use the CData ODBC Driver for Pinterest from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Pinterest to connect to Pinterest from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Pinterest in Excel.
-
Connect to Facebook Data in HULFT Integrate
Connect to Facebook as a JDBC data source in HULFT Integrate
-
Access Live Azure Analysis Services Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Azure Analysis Services into the statistical analysis tools available in SAS JMP. This article shows how to use Azure Analysis Services in the Graph Builder and Query Builder.
-
Replicate FHIR Data from PowerShell
Write a quick PowerShell script to query FHIR. Use connectivity to the live data to replicate FHIR to SQL Server.
-
Connect to Postmark Data from PowerBuilder via ADO.NET
This article demonstrates how to access Postmark from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connecting Agentforce with CSV Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your CSV/TSV Files for you.
-
Create Databricks-Connected Applications in Appsmith
Connect to Databricks Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Databricks.
-
Write a Simple Go Application to work with SharePoint Excel Services Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SharePoint Excel Services.
-
How to Query Live REST Data in Claude Desktop
Connect to and query live REST Data in Claude Desktop using CData MCP Server.
-
DataBind Controls to Paylocity Data in Delphi
DataBind to Paylocity in Delphi with standard data access components and controls.
-
Replicate SAP Ariba Source Data to Multiple Databases via the CData Sync CLI
Replicate SAP Ariba Source to disparate databases with a single configuration.
-
Automated Continuous Google Search Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Search replication to delimited files (CSV/TSV).
-
Getting Started with the CData Power BI Connector for QuickBooks Time
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for QuickBooks Time.
-
Build Semantic Layer Views for SAP BusinessObjects BI Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP BusinessObjects BI.
-
How to work with Mistral AI Data in Apache Spark using SQL
Access and process Mistral AI Data in Apache Spark using the CData Software JDBC Driver.
-
How to integrate Attio with Apache Airflow
Access and process Attio in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Timely Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Timely replication to PostgreSQL.
-
Connect to Webflow Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Webflow and work with Webflow in your FileMaker applications.
-
Create Power BI Reports on Real-Time ConvertKit Data
Use the CData ODBC Driver for ConvertKit to visualize ConvertKit in Power BI Desktop.
-
ETL OnePageCrm in Oracle Data Integrator
This article shows how to transfer OnePageCrm into a data warehouse using Oracle Data Integrator.
-
Connect to Clockify Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Clockify and work with Clockify in your FileMaker application.
-
Connect to Typeform Data from PowerBuilder via ADO.NET
This article demonstrates how to access Typeform from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build an OLAP Cube in SSAS from Testmonitor Data
Establish a connection to Testmonitor data from SQL Server Analysis Services, and use the Testmonitor Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Dynamics 365 Business Central Data into Power Automate Desktop using CData Connect
CData Connect for Dynamics 365 Business Central Data enables you to integrate Dynamics 365 Business Central into workflows built using Microsoft Power Automate Desktop.
-
Integrate Live SAP ByDesign Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP ByDesign from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Business ByDesign.
-
Analyze Tally Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Tally ERP and visualize Tally ERP in SAP Analytics Cloud.
-
Integrating LlamaIndex with Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Authorize.Net in real time.
-
Replicate Multiple SuiteCRM Accounts
Replicate multiple SuiteCRM accounts to one or many databases.