CData Software - Knowledge Base
Recent Articles
-
Connect to SAP BusinessObjects BI from HeidiSQL
Use CData Connect AI to connect to and query live SAP BusinessObjects BI from HeidiSQL.
-
Integrate with Xero using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Xero Accounting to a JSON file on disk.
-
How to Import Data from Azure Analysis Services into Google Sheets
Import Azure Analysis Services into a Google spreadsheet that is automatically refreshed.
-
Publish Reports with Twitter in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Twitter.
-
Easily Integrate Zoho CRM in Lazarus Pascal IDE
Learn how to easily integrate live Zoho CRM in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
LINQ to Hive
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 Hive Data Provider.
-
Build Agents in Relevance AI with Access to Live Azure Active Directory via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Azure Active Directory within intelligent agent workflows.
-
Connect to EventBrite from PowerBuilder via ADO.NET
This article demonstrates how to access Eventbrite from Appeon PowerBuilder using the CData ADO.NET Provider for EventBrite.
-
Access Slack as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Slack from your Oracle system.
-
Build MVC Applications with Connectivity to Aha
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Aha from an ASP.NET MVC application.
-
Working with Lakebase in LINQPad
Execute LINQ queries to Lakebase in LINQPad.
-
Connect to Amazon DynamoDB in CloverDX (formerly CloverETL)
Transfer Amazon DynamoDB using the visual workflow in the CloverDX data integration tool.
-
A Comparison of Drivers for Amazon DynamoDB
An article comparing the read performance, client-side resource usage, and read capacity consumption of different JDBC drivers for Amazon DynamoDB.
-
Automated Continuous Sybase IQ Replication to SingleStore
Use CData Sync for automated, continuous, customizable Sybase IQ replication to SingleStore.
-
How to update Redshift from Excel
This article explains how to transfer data from Excel to Redshift using the Excel Add-In for Redshift.
-
Import Real-Time QuickBooks Time via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use QuickBooks Time in ColdFusion.
-
How to Use a Microsoft Access Database to Update Pipedrive in Real Time
Update Pipedrive data by creating a linked table in Microsoft Access with the CData Pipedrive ODBC Driver.
-
Query Confluence in DataGrip
Create a Data Source for Confluence in DataGrip and use SQL to query live Atlassian Confluence.
-
How to Query Live PostgreSQL in Claude Desktop
Connect to and query live PostgreSQL in Claude Desktop using CData Code Assist MCP.
-
Feed Databricks into FineReport
How to set Databricks as a JDBC data source in FineReport.
-
Validate PingOne with QuerySurge
Access and validate PingOne in QuerySurge using the CData JDBC Driver.
-
Connect to Authorize.Net as an External Source in Dremio
Use the CData JDBC Driver to connect to Authorize.Net as an External Source in Dremio.
-
Visualize Live HCL Domino in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live HCL Domino.
-
Automated Continuous Act-On Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Act-On replication to Google BigQuery.
-
How to Create Power BI Visual Reports with Real-Time Shopify
Use CData Power BI Connectors to visualize Shopify in Power BI.
-
Connect to Marketo in NetBeans
Connect to Marketo in NetBeans with the data source configuration wizard.
-
How to Connect to Live OneNote from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Microsoft OneNote for you.
-
Connect to Live ServiceNow in PostGresSQL Interface through CData Connect AI
Create a live connection to ServiceNow in CData Connect AI and connect to your ServiceNow from PostgreSQL.
-
Automate Salesforce Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Salesforce & Force.com and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Prepare, Blend, and Analyze Dynamics NAV in Alteryx Designer (ODBC)
Build workflows to access live Microsoft Dynamics NAV for self-service data analytics.
-
Access Live Google Drive in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Drive in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Prepare, Blend, and Analyze SuiteCRM in Alteryx Designer (ODBC)
Build workflows to access live SuiteCRM for self-service data analytics.
-
Analyze Redshift in R via JDBC
Use standard R functions and the development environment of your choice to analyze Amazon Redshift with the CData JDBC Driver for Redshift.
-
Viewing SAP BusinessObjects BI in RAD Studio Data Explorer
How to view SAP BusinessObjects BI in RAD Studio Data Explorer using the CData ODBC Driver for SAP BusinessObjects BI.
-
Build Google Ads-Connected Apps in Choreo
Use CData Connect AI to connect to Google Ads from Choreo and build custom apps using live Google Ads.
-
Build Data Flows from SQL Server to Google Calendar through SSIS
Easily push SQL Server data to Google Calendar using the CData SSIS Tasks for Google Calendar.
-
Create Power BI Reports on Real-Time Basecamp
Use the CData ODBC Driver for Basecamp to visualize Basecamp in Power BI Desktop.
-
Use Microsoft Copilot Studio to talk to your Elasticsearch via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Elasticsearch for you.
-
Create Facebook Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Facebook data access from reports, embedded analytics, and more.
-
Query SAP Fieldglass from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP Fieldglass and perform CRUD operations on SAP Fieldglass from Node.js.
-
Automated Continuous Redis Replication to Snowflake
Use CData Sync for automated, continuous, customizable Redis replication to Snowflake.
-
Use ChatGPT to Talk to Your SingleStore via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SingleStore for you.
-
Analyze SAP Business One with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP Business One from Power Pivot. You will use the Table Import Wizard to load SAP Business One. You can visually build the import query or use any SQL supported by the driver.
-
Access Live Databricks in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Databricks from your Excel spreadsheets.
-
Analyze Trello in R via JDBC
Use standard R functions and the development environment of your choice to analyze Trello with the CData JDBC Driver for Trello.
-
Build a Singer.io Tap for Gmail With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Gmail data using
-
Connect to Email in RapidMiner
Integrate Email with standard components and data source configuration wizards in RapidMiner Studio.
-
Replicate SAS xpt to Multiple Databases via the CData Sync CLI
Replicate SAS XPORT to disparate databases with a single configuration.
-
Integrate Live Google Campaign Manager 360 into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Google Campaign Manager 360 from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Campaign Manager 360.
-
Natively Connect to ClickUp in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ClickUp. Leverage the native support for ODBC in PHP.
-
Use the CData Software ODBC Driver for SAP Ariba Procurement in MicroStrategy
Connect to SAP Ariba Procurement in MicroStrategy Developer using the CData Software ODBC Driver for SAP Ariba Procurement.
-
Connect to Oracle Financials Cloud from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Oracle Financials Cloud, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use CData Connect AI to Access SingleStore in Microsoft Power Pivot
Use CData Connect AI to connect to live SingleStore in the Power Pivot business intelligence tool.
-
Use the CData API Server to Access Tally in Microsoft PowerPivot
Use the CData API Server to connect to live Tally ERP in the Power Pivot business intelligence tool.
-
Connect to Xero in Ruby
Connect to Xero Accounting in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate Google Spanner in Heroku for Use in Salesforce Connect
Replicate Google Spanner to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
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 Data Visualizations in Cognos BI with Exact Online
Access Exact Online as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Enable the SAP Ariba Source JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP Ariba Source.
-
Automated Continuous Reckon Replication to Vertica
Use CData Sync for automated, continuous, customizable Reckon replication to Vertica.
-
Getting Started with the CData PowerShell Cmdlets for Zoho Books
-