CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData ODBC Driver for LinkedIn
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for LinkedIn.
-
DataBind Controls to Invoiced in C++Builder
DataBind to Invoiced in C++Builder with standard components and controls.
-
Connect to Kintone in RazorSQL
Connect to Kintone from wizards and query Kintone from the GUI in the RazorSQL database management tool.
-
How to Connect the Power BI Service to HBase: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Automated Continuous Azure Data Lake Storage Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Microsoft Access.
-
Visualize QuickBooks Time in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load QuickBooks Time into TIBCO Spotfire.
-
Load Adobe Commerce to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Adobe Commerce to a database.
-
Build Pipelines with Live SAP HANA in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP HANA from Google Cloud Data Fusion, enabling the integration of live SAP HANA into the building and management of effective data pipelines.
-
Access Live Excel Online in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Excel Online from your Excel spreadsheets.
-
DataBind Adobe Commerce to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Adobe Commerce with the DevExpress Windows Forms and Web controls to provide Adobe Commerce to a chart.
-
Use the CData Software ODBC Driver for Microsoft Project in MicroStrategy Web
Connect to Microsoft Project in MicroStrategy Web using the CData Software ODBC Driver for Microsoft Project.
-
Access Typeform from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Typeform from HeidiSQL.
-
Connect to HDFS in Google Apps Script via SQL Gateway
Use the ODBC Driver for HDFS and the SQL Gateway to access Apache HDFS from Google Apps Script.
-
How to Connect to Live Cosmos DB 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 Azure Cosmos DB for you.
-
Automated Continuous Confluence Replication to Vertica
Use CData Sync for automated, continuous, customizable Confluence replication to Vertica.
-
Connecting Mastra with Azure DevOps 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.
-
Natively Connect to PingOne in PHP
The CData ODBC driver for PingOne enables you to create PHP applications with connectivity to PingOne. Leverage the native support for ODBC in PHP.
-
DataBind Charts to Salesforce Data Cloud
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Salesforce Data Cloud 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.
-
Use the CData Software ODBC Driver for Azure Analysis Services in MicroStrategy Web
Connect to Azure Analysis Services in MicroStrategy Web using the CData Software ODBC Driver for Azure Analysis Services.
-
Object-Relational Mapping (ORM) with CockroachDB Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to CockroachDB into a Java-based ORM framework, Hibernate.
-
How to publish and share Amazon DynamoDB dashboards with Tableau Server
The CData ODBC driver for Amazon DynamoDB enables you integrate Amazon DynamoDB into Tableau dashboards.
-
Connect to IBM Informix from a Connection Pool in Jetty
The IBM Informix JDBC Driver supports connection pooling: This article shows how to connect faster to IBM Informix from Web apps in Jetty.
-
Visualize Tableau CRM Analytics in Tableau
The CData ODBC driver for Tableau CRM Analytics enables you integrate Tableau CRM Analytics into Tableau dashboards.
-
Back Up SQL Analysis Services to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SQL Analysis Services. In this article, we will employ an SSIS workflow to populate a database with SQL Analysis Services data.
-
Query SurveyMonkey as a SQL Server Database in Node.js
Execute SQL Server queries against SurveyMonkey from Node.js.
-
A PostgreSQL Interface for Zoho Books (MySQL Remoting via JDBC)
Use the Remoting features of the Zoho Books JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Basecamp in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Basecamp into the statistical analysis tools available in SAS JMP. This article shows how to use Basecamp in the Graph Builder and Query Builder.
-
Connecting Mastra with Zoho Books 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.
-
Use the CData API Server to Access Slack in Microsoft PowerPivot
Use the CData API Server to connect to live Slack in the Power Pivot business intelligence tool.
-
Migrating data from SAP HANA to Databricks using CData SSIS Components.
Easily push SAP HANA to Databricks using the CData SSIS Tasks for SAP HANA and Databricks.
-
Automated Continuous Office 365 Replication to MongoDB
Use CData Sync for automated, continuous, customizable Office 365 replication to MongoDB.
-
Integrating Claude Code with PostgreSQL via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on PostgreSQL within assisted coding and automated development workflows.
-
Connect Oracle Sales to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Oracle Sales using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Power BI Reports on Real-Time Zoho CRM
Use the CData ODBC Driver for Zoho CRM to visualize Zoho CRM in Power BI Desktop.
-
Create Reports with Google Drive in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Drive.
-
Connect to and Query Google Data Catalog in QlikView over ODBC
Create data visualizations with Google Data Catalog in QlikView.
-
Building Dynamic Web Pages with Sage 50 UK Using AngularJS
Create single-page applications with live connectivity to Sage 50 UK using the CData API Server.
-
Integrate with Monday.com in JReport Designer
Create charts and reports based on Monday.com in JReport Designer.
-
Create Invoiced Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Invoiced data access from reports, embedded analytics, and more.
-
Build a PostgreSQL Interface for SAS Data Sets using the CData JDBC Driver
Use the Remoting features of the SAS Data Sets JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import Act-On into the Power BI Service for Visualizations
Use CData Connect AI to connect to Act-On and provide access to live Act-On for custom reports in the Power BI Service.
-
Access Live ActiveCampaign in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ActiveCampaign from your Google Sheets.
-
Create Reports from ADP in Looker Studio
Use CData Connect AI to gain access to live ADP and create custom reports in Looker Studio.
-
Create a Data Access Object for Email using JDBI
A brief overview of creating a SQL Object API for Email in JDBI.
-
Extract, Transform, and Load Neo4J in Informatica PowerCenter
Create a simple Workflow for Neo4J in Informatica PowerCenter.
-
Analyze Shopify in Looker
Use CData Connect AI to connect to Shopify from Looker and build custom apps using live Shopify.
-
Getting Started with the CData SSIS Components for Google Ads
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Ads.
-
Analyze JSON Services in R via JDBC
Use standard R functions and the development environment of your choice to analyze JSON with the CData JDBC Driver for JSON.
-
Back Up Apache Phoenix to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Phoenix. In this article, we will employ an SSIS workflow to populate a database with Apache Phoenix data.
-
Automated Continuous Printify Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Printify replication to AlloyDB.
-
Access Live Microsoft Exchange in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Microsoft Exchange from your Excel spreadsheets.
-
Automated Continuous Amazon Athena Replication to SQLite
Use CData Sync for automated, continuous, customizable Amazon Athena replication to SQLite.
-
How to connect PolyBase to SAP Hybris C4C
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP Hybris C4C.
-
Replicate SAP Fieldglass from PowerShell
Write a quick PowerShell script to query SAP Fieldglass. Use connectivity to the live data to replicate SAP Fieldglass to SQL Server.
-
Getting Started with the CData PowerShell Cmdlets for Microsoft OneDrive
-