CData Software - Knowledge Base
Recent Articles
-
Publish Wave Financial-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Wave Financial.
-
Build Charts with Exact Online in Clear Analytics
Create dynamic charts and perform analytics based on Exact Online in Clear Analytics.
-
Connect to Google Calendar from PowerBuilder via JDBC
This article demonstrates how to access Google Calendar from PowerBuilder using the Google Calendar JDBC Driver.
-
Create a Data Access Object for Salesloft using JDBI
A brief overview of creating a SQL Object API for Salesloft in JDBI.
-
Visualize Box in TIBCO Spotfire through ADO.NET
Integrate Box into dashboards in TIBCO Spotfire.
-
Visualize Databricks from Tableau
Use the Tableau Desktop business intelligence tool to connect to Databricks.
-
Build an OLAP Cube in SSAS from Sugar CRM
Establish a connection to Sugar CRM data from SQL Server Analysis Services, and use the Sugar CRM Data Provider to build OLAP cubes for use in analytics and reporting.
-
Configure the CData JDBC Driver for Outreach.io in a Connection Pool in Tomcat
Connect to Outreach.io from a connection pool in Tomcat.
-
DataBind Controls to Trello in Delphi
DataBind to Trello in Delphi with standard data access components and controls.
-
Integrate Twilio in Pentaho Data Integration
Build ETL pipelines based on Twilio in the Pentaho Data Integration tool.
-
How to Design SAS Data Sets Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Create Power BI Reports on Real-Time Asana
Use the CData ODBC Driver for Asana to visualize Asana in Power BI Desktop.
-
Operational Reporting on FTP from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote FTP Servers.
-
Automated Continuous Freshdesk Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Freshdesk replication to IBM DB2.
-
Stream Zoho Books into Apache Kafka Topics
Access and stream Zoho Books in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Analyze YouTube Analytics in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze YouTube Analytics in Microsoft R Open.
-
How to connect to Azure Active Directory with Squirrel SQL client
Connect to Azure Active Directory and execute queries in the Squirrel SQL Client.
-
Build Agents in Relevance AI with Access to Live Azure Table via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Azure Table Storage within intelligent agent workflows.
-
Connect to Amazon Marketplace in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Amazon Marketplace and connect to Amazon Marketplace in Akorbi Digital RunMyProcess.
-
How to load JDBC-ODBC Bridge data into Elasticsearch via Logstash
Introducing a simple method to load JDBC-ODBC Bridge data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect SharePoint with Blackbaud FE NXT through external lists
Provide Blackbaud FE NXT to SharePoint users as an external list.
-
Access Zoho CRM 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 Zoho CRM.
-
Rapidly Develop Act-On-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Connecting Mastra with Asana 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.
-
Connect to SAS Data Sets from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAS Data Sets using standard SQL.
-
Build AI Agents with Zuora Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Automated Continuous Confluence Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Atlassian Confluence replication to OneLake in Microsoft Fabric.
-
Create Power BI Reports on Real-Time Highrise
Use the CData ODBC Driver for Highrise to visualize Highrise CRM in Power BI Desktop.
-
How to Connect to Live PayPal 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 PayPal for you.
-
LINQ to Adobe Analytics
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 Adobe Analytics Data Provider.
-
Connect to Google Calendar in JRuby
Create a simple JRuby app with access to live Google Calendar.
-
Integrate Cassandra with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Cassandra with External Services.
-
How to integrate SAP ByDesign with Apache Airflow
Access and process SAP Business ByDesign in Apache Airflow using the CData JDBC Driver.
-
Explore Geographical Relationships in Zoho CRM with Power Map
Create data visualizations with Zoho CRM in Power Map.
-
Connect to QuickBooks Time from PowerBuilder via JDBC
This article demonstrates how to access QuickBooks Time from PowerBuilder using the QuickBooks Time JDBC Driver.
-
Import Vault CRM into the Power BI Service for Visualizations
Use CData Connect AI to connect to Vault CRM and provide access to live Veeva Vault & Vault CRM for custom reports in the Power BI Service.
-
Access HubDB from MySQL in Amazon QuickSight
Connect to HubDB and build visualizations of HubDB using a MySQL Connection in Amazon QuickSight.
-
DataBind Charts to Google Analytics
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Analytics 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.
-
Automated Continuous Marketo Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Marketo replication to PostgreSQL.
-
Publish Crystal Reports on OneNote
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft OneNote.
-
Consume QuickBooks Online OData Feeds in PowerBuilder
This article demonstrates how to consume QuickBooks Online as OData feeds from PowerBuilder using the API Server.
-
Connect to SFTP in Aqua Data Studio
Access SFTP from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Stream Parquet into Apache Kafka Topics
Access and stream Apache Parquet in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Back Up SAP Ariba Source to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Ariba Source. In this article, we will employ an SSIS workflow to populate a database with SAP Ariba Source data.
-
Access GitHub 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 GitHub.
-
Feed Azure Synapse into FineReport
How to set Azure Synapse as a JDBC data source in FineReport.
-
Query YouTube Analytics through ODBC in Node.js
Use node-odbc to execute SQL queries against YouTube Analytics from Node.js.
-
Use the CData Software JDBC Driver for Zoom in MicroStrategy
Connect to Zoom in MicroStrategy Developer using the CData Software JDBC Driver for Zoom.
-
Access Live Marketo in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Marketo from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create Dynamic WooCommerce Grids Using the Infragistics XamDataGrid
Learn how you can connect WooCommerce to Infragistics XamDataGrid to build dynamic grids.
-
DataBind Controls to Klipfolio in Delphi
DataBind to Klipfolio in Delphi with standard data access components and controls.
-
Getting Started with the CData Python Connector for Snapchat Ads
Learn to install and license the CData Python Connector
-
How to Work with CockroachDB in ETL Validator JDBC
Connect to CockroachDB from ETL Validator jobs using the CData Software JDBC Driver.
-
How to work with Adobe Analytics in Apache Spark using SQL
Access and process Adobe Analytics in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to & Open xBase in Microsoft Excel
This article uses the CData ODBC driver for xBase to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Publish Crystal Reports on Vault CRM
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Veeva Vault & Vault CRM.
-
How to Connect to Live Azure DevOps Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Azure DevOps securely in real time.
-
Connect PayPal to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live PayPal using the CData Python MCP Server.
-
Access SharePoint Excel Services 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 SharePoint Excel Services.
-
Connect to Cassandra in Ruby
Connect to Apache Cassandra in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData ODBC Driver for Access from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Access to connect to Microsoft Access from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Access in Excel.
-
Build Certinia-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Certinia.
-
Automated Continuous Office 365 Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Office 365 replication to Amazon Redshift.
-
Create Power BI Reports on Real-Time XML
Use the CData ODBC Driver for XML to visualize XML Files in Power BI Desktop.
-
Integrate QuickBooks in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live QuickBooks Desktop from Informatica Cloud.
-
Connect to Harvest in JRuby
Create a simple JRuby app with access to live Harvest.
-
Build OneNote-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft OneNote.
-
Import and Visualize EnterpriseDB in Power View
Create data visualizations based on EnterpriseDB in Excel.
-
Consume SharePoint OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft SharePoint as OData feeds from PowerBuilder using the API Server.
-
How to Query Live FTP in Perplexity MacOS Desktop
Connect to and query live FTP in Perplexity Desktop using CData Code Assist MCP.
-
Automated Continuous Drip Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Drip replication to AlloyDB.
-
SAP SuccessFactors LMS Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP SuccessFactors LMS facts in real time.
-
Create Informatica Mappings From/To a JDBC Data Source for Instagram
Create Instagram data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to HarperDB in the Denodo Platform
Use CData driver technologies to create a virtual data source for HarperDB in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Amazon Athena Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Google Cloud SQL.
-
How to Visualize Oracle Eloqua Reporting Data in Python with pandas
Use pandas and other modules to analyze and visualize live Oracle Eloqua Reporting in Python.
-
Connect ADP to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ADP using the CData Python MCP Server.
-
Connect to MongoDB from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from MongoDB, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData Python Connector for Facebook
Learn to install and license the CData Python Connector
-
Access CockroachDB from MySQL in PHP
Connect to CockroachDB through the standard MySQL libraries in PHP.
-
Visualize Amazon Marketplace in Sisense
Create an ElastiCube in Sisense app with access to Amazon Marketplace.
-
Connect to Airtable as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Airtable.
-
Getting Started with the CData SSIS Components for Oracle Eloqua Reporting
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Oracle Eloqua Reporting.
-
Easily Integrate Drip in Lazarus Pascal IDE
Learn how to easily integrate live Drip in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to create Amazon Marketplace federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Amazon Marketplace in MySQL .
-
Manage Shopify in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Shopify.
-
Access Live ConstantContact in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ConstantContact into the statistical analysis tools available in SAS JMP. This article shows how to use ConstantContact in the Graph Builder and Query Builder.
-
Analyze Todoist in Infragistics Reveal
Use the CData API Server to create an OData API on top of Todoist and visualize live Todoist in Infragistics Reveal.
-
Getting Started with the CData Power BI Connector for Workday
-