CData Software - Knowledge Base
Recent Articles
-
Prepare, Blend, and Analyze Presto Data in Alteryx Designer (ODBC)
Build workflows to access live Presto for self-service data analytics.
-
Build Apps with Live Azure Data Lake Storage in Adalo using CData Connect AI
Use CData Connect AI to integrate live Azure Data Lake Storage into the Adalo platform and build custom mobile and web applications with real-time Azure Data Lake Storage.
-
Migrating data from Sendwithus to Databricks using CData SSIS Components.
Easily push Sendwithus to Databricks using the CData SSIS Tasks for Sendwithus and Databricks.
-
Natively Connect to SAS Data Sets Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAS Data Sets. Leverage the native support for ODBC in PHP.
-
How to connect Amazon QuickSight to BambooHR Data
Create a connection to BambooHR in CData Connect AI and insert BambooHR into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Dynamic PabblySubscriptions Grids Using the Infragistics XamDataGrid
Learn how you can connect PabblySubscriptions to Infragistics XamDataGrid to build dynamic grids.
-
Import Real-Time Bannerbear Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Bannerbear in ColdFusion.
-
Build Dashboards with Excel Data in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft Excel in Dundas BI.
-
How to load Mixpanel data into Elasticsearch via Logstash
Introducing a simple method to load Mixpanel data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Edit and Search Oracle Financials Cloud External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Oracle Financials Cloud to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Oracle Financials Cloud objects that you can access from apps and the dashboard.
-
Establish a Live Connection with DB2 Data using Tableau Bridge
The CData ODBC Driver for DB2 enables you to integrate live IBM DB2 into Tableau Cloud dashboards using the Tableau Bridge.
-
DataBind Controls to Opsgenie Data in C++Builder
DataBind to Opsgenie in C++Builder with standard components and controls.
-
Automated Continuous Datadog Replication to Vertica
Use CData Sync for automated, continuous, customizable Datadog replication to Vertica.
-
Access Live Aircall Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Aircall into the statistical analysis tools available in SAS JMP. This article shows how to use Aircall in the Graph Builder and Query Builder.
-
Getting Started with the CData Tableau Connector for Chargebee
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build Apps with Live Opsgenie Data Using the Low-Code Development Platform of Mendix
Connect Opsgenie with Mendix to build apps using the CData API Driver for JDBC.
-
Connect ZarMoney Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ZarMoney using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
View Reports on Real-Time Suadeo Data in Power BI Report Server
Use the CData ODBC Driver for Suadeo to visualize Suadeo in Power BI Desktop and then publish them to Power BI Report Server.
-
Build ZendeskSell-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ZendeskSell and build web apps with connectivity to live ZendeskSell.
-
LINQ to Acumatica 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 Acumatica Data Provider.
-
Connect to Live Act-On Data in MicroStrategy through CData Connect AI
Create a live connection to Act-On Data in CData Connect AI and connect to your Act-On from MicroStrategy.
-
Build Microsoft Dataverse-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Dataverse (CDS).
-
Connect to Harvest Data from PowerBuilder via ADO.NET
This article demonstrates how to access Harvest from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to and Visualize Live Sage 300 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sage 300.
-
Integrate SAP SuccessFactors LMS Data into Power Automate Desktop using CData Connect
CData Connect for SAP SuccessFactors LMS Data enables you to integrate SAP SuccessFactors LMS into workflows built using Microsoft Power Automate Desktop.
-
Integrate Gong Data into Power Automate Desktop using CData Connect
CData Connect for Gong Data enables you to integrate Gong into workflows built using Microsoft Power Automate Desktop.
-
Back Up HCL Domino to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for HCL Domino. In this article, we will employ an SSIS workflow to populate a database with HCL Domino data.
-
Build MVC Applications with Connectivity to Templated Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Templated from an ASP.NET MVC application.
-
How to Access Live RSS Feeds in Visual Studio Code via Cline
Run CData MCP Server for RSS on Windows Subsytem for Linux (WSL) and connect to live RSS Feeds from the Cline extension in Visual Studio Code.
-
Build Voice Agents in ElevenLabs with access to Live Amazon S3 Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Amazon S3.
-
Connect to Teradata Data in HULFT Integrate
Connect to Teradata as a JDBC data source in HULFT Integrate
-
A PostgreSQL Interface for Calendly Data (MySQL Remoting via JDBC)
Use the Remoting features of the Calendly JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Live Outreach.io Data in Perplexity MacOS Desktop
Connect to and query live Outreach.io Data in Perplexity Desktop using CData MCP Server.
-
Integrating Freshdesk Data in Talend Cloud Data Management Platform
Connect Freshdesk Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Freshdesk.
-
A PostgreSQL Interface for Twilio Data using the CData ODBC Driver
Use the SQL Gateway and Twilio ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Onfleet-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Onfleet.
-
Bridge Factorial Connectivity with Apache NiFi
Access and process Factorial in Apache NiFi using the CData JDBC Driver.
-
Build Act CRM-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Act CRM and build web apps with connectivity to live Act CRM.
-
Automated Continuous Mouseflow Replication to Oracle
Use CData Sync for automated, continuous, customizable Mouseflow replication to Oracle.
-
Access SAP HANA Data from MySQL in Amazon QuickSight
Connect to SAP HANA and build visualizations of SAP HANA using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous ZendeskSell Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ZendeskSell replication to delimited files (CSV/TSV).
-
Operational Reporting on CouchDB Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Apache CouchDB.
-
Visualize Redis 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 Redis into TIBCO Spotfire.
-
Connect to Close Data in DBeaver
Use the CData ODBC Driver to connect to Close in DBeaver.
-
Replicate Multiple Mailgun Accounts via the CData Sync CLI
Replicate multiple Mailgun accounts to one or many databases.
-
Replicate Multiple Highrise Accounts
Replicate multiple Highrise accounts to one or many databases.
-
How to Easily Query Bannerbear Data in OpenOffice Base
Connect to Bannerbear data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous Oracle SCM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Oracle SCM replication to Google BigQuery.
-
DataBind Charts to Dotmailer Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Dotmailer 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.
-
Access Live DocuSign Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live DocuSign through MCP integration.
-
Automated Continuous FreshBooks Replication to IBM DB2
Use CData Sync for automated, continuous, customizable FreshBooks replication to IBM DB2.
-
Prepare, Blend, and Analyze Reckon Accounts Hosted Data in Alteryx Designer (Connect AI)
Build workflows to access live Reckon Accounts Hosted for self-service data analytics.
-
How to connect and process Mailgun from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Mailgun.
-
Connect to ShipStation Data from PowerBuilder via ADO.NET
This article demonstrates how to access ShipStation from Appeon PowerBuilder using the CData ADO.NET Provider for ShipStation.
-
Visualize Active Directory Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Active Directory.
-
How to Work with DB2 Data in AWS Glue Jobs Using JDBC
Connect to DB2 from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Reckon Accounts Hosted Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Reckon Accounts Hosted using standard SQL.
-
How to Seamlessly Import NASA Data into IBM SPSS Modeler
Integrate NASA data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Analyze Presto Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Presto from Power Pivot. You will use the Table Import Wizard to load Presto. You can visually build the import query or use any SQL supported by the driver.
-
DataBind SAP BusinessObjects BI Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAP BusinessObjects BI with the DevExpress Windows Forms and Web controls to provide SAP BusinessObjects BI to a chart.
-
How to load Blackbaud FE NXT data into Elasticsearch via Logstash
Introducing a simple method to load Blackbaud FE NXT data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Import Data from SAP HANA XS Advanced into Google Sheets
Import SAP HANA XS Advanced into a Google spreadsheet that is automatically refreshed.
-
Connect to Avro Data from AWS Glue
Use CData Connect AI to gain access to live Apache Avro from your AWS Glue jobs.
-
Deploy the ADO.NET Provider for Sage Intacct on an SSRS Report Server
Connect to Sage Intacct 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.
-
Analyze Live Freshdesk Data in SAS Viya
Use CData Connect AI to connect to Freshdesk from SAS Viya and deploy self-service analytics using live Freshdesk.
-
Add ElevenLabs Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ElevenLabs with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Pipedrive
Provide connectivity to Pipedrive through an SAP BusinessObjects universe.
-
Connect Lakebase to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Lakebase using the CData Python MCP Server.
-
Visualize MailerSend Data in Tableau
The CData ODBC driver for MailerSend enables you integrate MailerSend into Tableau dashboards.
-
How to create CloudConvert federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for CloudConvert in MySQL .
-
Access Live Gmail 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 Gmail through MCP integration.
-
Enable the Shortcut JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Shortcut.
-
How to Create Power BI Visual Reports with Real-Time Redis Data
Use CData Power BI Connectors to visualize Redis in Power BI.
-
DataBind Controls to Wistia Data in Delphi
DataBind to Wistia in Delphi with standard data access components and controls.
-
Connect to Oracle SCM Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Oracle SCM to connect to Oracle SCM and execute queries in PowerBuilder.
-
Query Google Directory Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Directory entities in PHP by modeling them as objects.
-
Use Claude to Talk to Your Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Outreach.io for you.
-
Creating SurveyMonkey-Connected Applications in Unqork
You can use CData Connect AI to feed SurveyMonkey to Unqork and build custom business apps.
-
Model Google Calendar Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Calendar, enabling the direct import of real-time Google Calendar.
-
Bind Live Zuora Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Zuora data
-
Create QuickBooks Time Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time QuickBooks Time data access from reports, embedded analytics, and more.
-
Create MongoDB-Connected Nintex Workflows
Use CData Connect AI to connect to MongoDB Data from Nintex Workflow Cloud and build custom workflows using live MongoDB.
-
Access Live Azure Data Lake Storage Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Azure Data Lake Storage data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to TaxJar Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time TaxJar using standard SQL.
-
Connect to Dynamics NAV Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Dynamics NAV in DBeaver.
-
How to connect SharePoint with SAP Ariba Procurement Data through external lists
Provide SAP Ariba Procurement to SharePoint users as an external list.
-
Connect to Pipeline CRM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Pipeline CRM and the SQL Gateway to access Pipeline CRM from Google Apps Script.
-
How to Easily Query Short.io Data in OpenOffice Base
Connect to Short.io data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Hubstaff from a Connection Pool in WebLogic
Use the CData JDBC Driver for Hubstaff to connect to Hubstaff from Web applications running on WebLogic.
-
How to Connect Presto 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 Presto data in real time using natural language.
-
How to create an RPA flow for xBase Data in UiPath Studio
Use the xBase ODBC Driver to create workflows that access real-time xBase without any coding.
-
Integrating LangGraph with Microsoft Dataverse Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft Dataverse (CDS) within automated workflows.
-
Configure the CData JDBC Driver for Google Calendar in a Connection Pool in Tomcat
Connect to Google Calendar from a connection pool in Tomcat.
-
Replicate Multiple Calendly Accounts
Replicate multiple Calendly accounts to one or many databases.
-
How to Work with Dropbox Data in AWS Glue Jobs Using JDBC
Connect to Dropbox from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Extract, Transform, and Load Billsby Data in Informatica PowerCenter
Create a simple Workflow for Billsby in Informatica PowerCenter.
-
Access Live ScrapingBee Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ScrapingBee into the statistical analysis tools available in SAS JMP. This article shows how to use ScrapingBee in the Graph Builder and Query Builder.
-
Import Power BI XMLA Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Power BI XMLA. In this article, you will use the OData format to import Power BI XMLA into Microsoft Power Query.
-
Getting Started with the CData Python Connector for Cosmos DB
Learn to install and license the CData Python Connector
-
Connect to Basecamp Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Basecamp using standard SQL.