CData Software - Knowledge Base
Recent Articles
-
Query Elasticsearch using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Elasticsearch entities in PHP by modeling them as objects.
-
How to Import Data from HarperDB into Google Sheets
Import HarperDB into a Google spreadsheet that is automatically refreshed.
-
Access Slack from MySQL in Amazon QuickSight
Connect to Slack and build visualizations of Slack using a MySQL Connection in Amazon QuickSight.
-
Manage Reckon Accounts Hosted in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Reckon Accounts Hosted.
-
Publish Crystal Reports on PayPal
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date PayPal.
-
How to update Amazon DynamoDB from Excel
This article explains how to transfer data from Excel to Amazon DynamoDB using the Excel Add-In for Amazon DynamoDB.
-
Build a Simple VCL Application for Power BI XMLA
How to build a simple VCL Application to view Power BI XMLA in RAD Studio using the CData ODBC Driver for Power BI XMLA.
-
How to import SendGrid into Apache Solr
Use the CData Software JDBC Driver for SendGrid in Data Import Handler and create an automated import of SendGrid to Apache Solr Enterprise Search platform.
-
Connect SAP ByDesign to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP ByDesign with IBM WebSphere for seamless data integration and connectivity.
-
How to Access LinkedIn Using Entity Framework
This article shows how to access LinkedIn using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Query DocuSign as a SQL Server Database in Node.js
Execute SQL Server queries against DocuSign from Node.js.
-
Query Zoho Projects as a SQL Server Database in Node.js
Execute SQL Server queries against Zoho Projects from Node.js.
-
Connect to MariaDB in the Denodo Platform
Use CData driver technologies to create a virtual data source for MariaDB in the Denodo Virtual DataPort Administrator.
-
DataBind Exact Online to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Exact Online with the DevExpress Windows Forms and Web controls to provide Exact Online to a chart.
-
Extract, Transform, and Load SharePoint in Informatica PowerCenter
Create a simple Workflow for Microsoft SharePoint in Informatica PowerCenter.
-
Visualize Pinterest in Sisense
Create an ElastiCube in Sisense app with access to Pinterest.
-
How to Use a Microsoft Access Database to Update Square in Real Time
Update Square data by creating a linked table in Microsoft Access with the CData Square ODBC Driver.
-
Connect to MailChimp in Ruby
Connect to MailChimp in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to HarperDB from Asprova with CData Software ODBC Driver for HarperDB
This article shows how to connect faster to HarperDB data from Asprova.
-
JSON Drivers: Parsing Hierarchical Data
Configure our JSON drivers to parse the entirety of a JSON data set as a single table or as separate, relational tables.
-
Use the CData Software JDBC Driver for Kintone in MicroStrategy
Connect to Kintone in MicroStrategy Developer using the CData Software JDBC Driver for Kintone.
-
Access Live Stripe in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Stripe from your Excel spreadsheets.
-
Import ServiceNow into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access ServiceNow. In this article, you will use the OData format to import ServiceNow into Microsoft Power Query.
-
Create Reports from QuickBooks Online in Looker Studio
Use CData Connect AI to gain access to live QuickBooks Online and create custom reports in Looker Studio.
-
Use the CData ODBC Driver for Blackbaud FE NXT in Microsoft Power Query
You can use the CData Blackbaud FE NXT ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Blackbaud FE NXT into Microsoft Power Query.
-
Automated Continuous ClickUp Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ClickUp replication to IBM DB2.
-
Analyze Impala in Looker
Use CData Connect AI to connect to Impala from Looker and build custom apps using live Apache Impala.
-
Deploy the ADO.NET Provider for SAP ByDesign on an SSRS Report Server
Connect to SAP Business ByDesign 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.
-
Create Reports with Facebook in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Facebook.
-
ETL Azure Analysis Services in Oracle Data Integrator
This article shows how to transfer Azure Analysis Services into a data warehouse using Oracle Data Integrator.
-
Viewing Microsoft OneDrive in RAD Studio Data Explorer
How to view Microsoft OneDrive in RAD Studio Data Explorer using the CData ODBC Driver for Microsoft OneDrive.
-
DataBind Controls to Google Analytics in C++Builder
DataBind to Google Analytics in C++Builder with standard components and controls.
-
Feed Impala into FineReport
How to set Apache Impala as a JDBC data source in FineReport.
-
Publish Reports with CouchDB in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache CouchDB.
-
LINQ to Cloudant
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 Cloudant Data Provider.
-
Build a Simple VCL Application for Google Contacts
How to build a simple VCL Application to view Google Contacts in RAD Studio using the CData ODBC Driver for Google Contacts.
-
Create NetSuite-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to NetSuite from OutSystems and build custom enterprise apps using live NetSuite CRM & ERP.
-
How to create Microsoft OneDrive federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft OneDrive in MySQL .
-
Operational Reporting on SharePoint Excel Services from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SharePoint Excel Services.
-
Create Google Directory-Connected Applications in Appsmith
Connect to Google Directory via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Directory.
-
Create SSAS Tabular Models from Microsoft Planner
How to build a SQL Server Analysis Service Tabular Model from Microsoft Planner using CData drivers.
-
How to Connect to Live Redis 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 Redis for you.
-
Connect to Microsoft Project from a Connection Pool in WebLogic
Use the CData JDBC Driver for Microsoft Project to connect to Microsoft Project from Web applications running on WebLogic.
-
Automated Continuous Cloudant Replication to SQL Server
Use CData Sync for automated, continuous, customizable Cloudant replication to SQL Server.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP Hybris C4C
Create an ODBC connection to SAP Hybris C4C in Informatica and browse and transfer SAP Hybris C4C.
-
How to Connect DBeaver to Wave Financial via a JDBC Driver
Manage Wave Financial with visual tools in DBeaver like the query browser.
-
How to Design Salesforce Marketing Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Create SSAS Tabular Models from Excel
How to build a SQL Server Analysis Service Tabular Model from Microsoft Excel using CData drivers.
-
Build Semantic Layer Views for ADP in APOS Live Data Gateway
Use the CData Connector for ADP in APOS Live Data Gateway to build Semantic Layer Views for ADP.
-
Bind Live Xero Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Xero data
-
Use Azure AI Foundry to Talk to Your Google Contacts via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Google Contacts for you.
-
Build Semantic Layer Views for LinkedIn Ads in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for LinkedIn Ads.
-
Integrate Cursor with Live WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live WooCommerce from within the editor.
-
Use the CData Software ODBC Driver for LinkedIn in SAS for Real-Time Reporting and Analytics
Connect to real-time LinkedIn in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for LinkedIn.
-
How to use SQLAlchemy ORM to access Cvent in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Cvent.
-
Analyze Tally with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Tally from Power Pivot. You will use the Table Import Wizard to load Tally ERP. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect to Live Quickbase Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Quickbase securely in real time.
-
Connect to SendGrid in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SendGrid in Airbyte.
-
Access DocuSign from MySQL in Amazon QuickSight
Connect to DocuSign and build visualizations of DocuSign using a MySQL Connection in Amazon QuickSight.
-
Create Twilio-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Twilio from OutSystems and build custom enterprise apps using live Twilio.
-
How to Work with Azure Table in ETL Validator JDBC
Connect to Azure Table from ETL Validator jobs using the CData Software JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Azure Synapse
Provide connectivity to Azure Synapse through an SAP BusinessObjects universe.
-
Getting Started with the CData ODBC Driver for Zoho Books
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Zoho Books.
-
Connect Twitter Ads to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Twitter Ads using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Sage 200 Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Sage 200 replication to PostgreSQL.
-
Build SAP BusinessObjects BI-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP BusinessObjects BI.
-
How to Work with ConstantContact in ETL Validator JDBC
Connect to ConstantContact from ETL Validator jobs using the CData Software JDBC Driver.
-
Build a Singer.io Tap for Jira With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Jira data using
-
How to create an RPA flow for EnterpriseDB in UiPath Studio
Use the EnterpriseDB ODBC Driver to create workflows that access real-time EnterpriseDB without any coding.
-
Automated Continuous XML Replication to Amazon S3
Use CData Sync for automated, continuous, customizable XML replication to Amazon S3.
-
Connect Aha! to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Aha! using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Sage Cloud Accounting from Asprova with CData Software ODBC Driver for Sage Cloud Accounting
This article shows how to connect faster to Sage Cloud Accounting data from Asprova.
-
Connect to Adobe Analytics from a Connection Pool in Jetty
The Adobe Analytics JDBC Driver supports connection pooling: This article shows how to connect faster to Adobe Analytics from Web apps in Jetty.
-
Create Zoho Projects-Connected Dashboards in Grafana
Connect to Zoho Projects via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zoho Projects.
-
Use Claude to Talk to Your Office 365 via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Microsoft Office 365 for you.
-
Connect to and Query Greenhouse in QlikView over ODBC
Create data visualizations with Greenhouse in QlikView.
-
Build a PostgreSQL Interface for MySQL using the CData JDBC Driver
Use the Remoting features of the MySQL JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous WooCommerce Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable WooCommerce replication to Apache Cassandra.
-
Build a Singer.io Tap for Workday With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Workday data using
-
Visualize Zendesk in TIBCO Spotfire through ADO.NET
Integrate Zendesk into dashboards in TIBCO Spotfire.
-
View Reports on Real-Time SAP HANA in Power BI Report Server
Use the CData ODBC Driver for SAP HANA to visualize SAP HANA in Power BI Desktop and then publish them to Power BI Report Server.
-
Build SingleStore-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SingleStore and create custom apps in Mendix.
-
A PostgreSQL Interface for Azure Data Lake Storage using the CData ODBC Driver
Use the SQL Gateway and Azure Data Lake Storage ODBC Driver to create a PostgreSQL entry-point for data access.
-
Extract, Transform, and Load GraphQL in Informatica PowerCenter
Create a simple Workflow for GraphQL in Informatica PowerCenter.
-
Replicate Multiple Microsoft Dataverse Accounts via the CData Sync CLI
Replicate multiple Microsoft Dataverse accounts to one or many databases.
-
Bridge Printify Connectivity with Apache NiFi
Access and process Printify in Apache NiFi using the CData JDBC Driver.
-
Publish Crystal Reports on Adobe Analytics
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Adobe Analytics.
-
Automated Continuous Salesforce Pardot Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Amazon S3.
-
Analyze Live YouTube Analytics in SAS Viya
Use CData Connect AI to connect to YouTube Analytics from SAS Viya and deploy self-service analytics using live YouTube Analytics.
-
Automated Continuous Reckon Accounts Hosted Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Google Cloud SQL.
-
How to Work with SingleStore in AWS Glue Jobs Using JDBC
Connect to SingleStore from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Amazon Redshift to Power BI dashboards. Simply drag and drop Amazon Redshift into data visuals on the Power BI canvas.
-
Use ChatGPT to Talk to Your MYOB AccountRight via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your MYOB AccountRight for you.
-
Automated Continuous Unbounce Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Unbounce replication to Amazon Redshift.
-
Extract, Transform, and Load Amazon Marketplace in Informatica PowerCenter
Create a simple Workflow for Amazon Marketplace in Informatica PowerCenter.
-
Getting Started with the CData Power BI Connector for HDFS
-