CData Software - Knowledge Base
Recent Articles
-
Integrate Live Sentry Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Sentry data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to connect and process REST data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live REST data.
-
Integrate Vercel with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Vercel with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Vercel data.
-
Use the CData Software ODBC Driver for Azure Data Lake Storage in SAS for Real-Time Reporting and Analytics
Connect to real-time Azure Data Lake Storage data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Azure Data Lake Storage.
-
Build Amazon Athena Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Amazon Athena data and build visualizations in Tableau.
-
Build CapsuleCRM-Connected Apps in Choreo
Use CData Connect AI to connect to CapsuleCRM Data from Choreo and build custom apps using live CapsuleCRM data.
-
Automated Continuous Billsby Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Billsby replication to Google Cloud SQL.
-
Build an OLAP Cube in SSAS from Brex Data
Establish a connection to Brex data data from SQL Server Analysis Services, and use the Brex Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Query Live MarkLogic Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live MarkLogic data data in natural language using Python.
-
Visualize Live SAP HANA Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP HANA data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Google Drive Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Drive data and integrate live Google Drive data into your Power Automate tasks.
-
Import Real-Time Twitter Ads Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Twitter Ads data in ColdFusion.
-
Create Informatica Mappings From/To an ODBC Data Source for FreeAgent
Create an ODBC connection to FreeAgent in Informatica and browse and transfer FreeAgent data.
-
Connecting Moonlit Workflow with Cloudant Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Cloudant data in real time.
-
Visualize Zoho Recruit 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 Zoho Recruit data into TIBCO Spotfire.
-
Access Live HBase Data in Coginiti Pro
Connect to and query live HBase data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Excel Spreadsheet Automation on Templated Data with the QUERY Formula
Pull data from Templated, automate spreadsheets, and more with the QUERY formula.
-
Build a Simple VCL Application for Gong Data
How to build a simple VCL Application to view Gong data in RAD Studio using the CData ODBC Driver for Gong.
-
Connect to Real-Time Salesforce CRM Analytics Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Salesforce CRM Analytics and Dataflow to import and use Salesforce CRM Analytics data in Power Apps.
-
Integrate Trae with Live MYOB AccountRight Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live MYOB AccountRight data from within the AI-powered IDE.
-
Connect to Microsoft Entra ID Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Microsoft Entra ID Data and connect to Microsoft Entra ID data in Akorbi Digital RunMyProcess.
-
Build Semantic Layer Views for Reply.io Data in APOS Live Data Gateway
Use the CData Connector for Reply.io in APOS Live Data Gateway to build Semantic Layer Views for Reply.io data.
-
Integrate with Act CRM Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Act CRM data to a JSON file on disk.
-
Create Dynamic ConvertAPI Grids Using the Infragistics XamDataGrid
Learn how you can connect ConvertAPI to Infragistics XamDataGrid to build dynamic grids.
-
Build Microsoft Dataverse Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft Dataverse data and build visualizations in Tableau.
-
Use the CData Software JDBC Driver for Vimeo in MicroStrategy Web
Connect to Vimeo data in MicroStrategy Web using the CData Software JDBC Driver for Vimeo.
-
Create Reports from Epicor Kinetic Data in Looker Studio
Use CData Connect AI to gain access to live Epicor Kinetic data and create custom reports in Looker Studio.
-
How to Easily Query Freshteam Data in OpenOffice Base
Connect to Freshteam data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Work with Salesforce Data 360 Data in ETL Validator JDBC
Connect to Salesforce Data 360 from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Elasticsearch Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Elasticsearch data from HeidiSQL.
-
Connect to Zoho Books Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zoho Books and the SQL Gateway to access Zoho Books data from Google Apps Script.
-
How to Connect to & Open Amazon DynamoDB Data in Microsoft Excel
This article uses the CData ODBC driver for Amazon DynamoDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Live WordPress Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live WordPress data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Data Flows from VWO to SQL Server using SSIS
Easily back up VWO data to SQL Server using the SSIS components for VWO.
-
Connect to SharePoint Data from a Connection Pool in Jetty
The SharePoint JDBC Driver supports connection pooling: This article shows how to connect faster to SharePoint data from Web apps in Jetty.
-
Build a PostgreSQL Interface for Azure Data Catalog Data using the CData JDBC Driver
Use the Remoting features of the Azure Data Catalog JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Bitbucket Data from Crystal Reports
Use CData Connect AI to connect to and report on live Bitbucket data from Crystal Reports.
-
Connect to Facebook Ads Data from HeidiSQL
Use CData Connect AI to connect to and query live Facebook Ads data from HeidiSQL.
-
Import Real-Time SAP Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP data in ColdFusion.
-
Connect to Testmonitor Data in Aqua Data Studio
Access Testmonitor data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Hacker News Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Hacker News.
-
Automated Continuous SurveyMonkey Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to delimited files (CSV/TSV).
-
Replicate Snowflake Data from PowerShell
Write a quick PowerShell script to query Snowflake data. Use connectivity to the live data to replicate Snowflake data to SQL Server.
-
Building Dynamic Web Pages with Sage Intacct Data Using AngularJS
Create single-page applications with live connectivity to Sage Intacct using the CData API Server.
-
Connect to Elasticsearch Data from a Connection Pool in Jetty
The Elasticsearch JDBC Driver supports connection pooling: This article shows how to connect faster to Elasticsearch data from Web apps in Jetty.
-
Automated Continuous Microsoft Planner Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Amazon S3.
-
Automated Continuous Phoenix Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Phoenix replication to IBM DB2.
-
Build Dashboards with PagerDuty Data in DBxtra
Create dynamic dashboards and perform analytics based on PagerDuty data in DBxtra.
-
Use Dash to Build to Web Apps on Eventbrite Data
Create Python applications that use pandas and Dash to build Eventbrite-connected web apps.
-
Create Informatica Mappings From/To a JDBC Data Source for Slack
Create Slack data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to SFTP Data from Crystal Reports
Use CData Connect AI to connect to and report on live SFTP data from Crystal Reports.
-
Use the CData Software JDBC Driver for Hubstaff in MicroStrategy Web
Connect to Hubstaff data in MicroStrategy Web using the CData Software JDBC Driver for Hubstaff.
-
Connect to Workday Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Workday Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Visualize Live Productboard Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Productboard data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Natively Connect to Microsoft Teams Data in PHP
The CData ODBC driver for Microsoft Teams enables you to create PHP applications with connectivity to Microsoft Teams data. Leverage the native support for ODBC in PHP.
-
LINQ to Google Spanner 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 Google Spanner Data Provider.
-
Consume Elasticsearch OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Elasticsearch feeds that reflect any changes in SAP Lumira.
-
Build Bitly Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Bitly data and build visualizations in Tableau Cloud.
-
How to connect to Shippo Data from IntelliJ
Integrate connectivity to Shippo data with wizards in IntelliJ.
-
Connect to Tanda Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Tanda to connect to Tanda data and execute queries in PowerBuilder.
-
Create Power BI Reports on Real-Time Cosmos DB Data
Use the CData ODBC Driver for Cosmos DB to visualize Cosmos DB data in Power BI Desktop.
-
Stream SAP Concur Data into Apache Kafka Topics
Access and stream SAP Concur data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Choosing the Best Method to Connect Epicor Kinetic to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Epicor Kinetic data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Blackbaud FE NXT Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Blackbaud FE NXT.
-
Connecting Agentforce with Aweber Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Aweber data for you.
-
Build Typeform-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Typeform Data from Zoho Analytics and import live Typeform data.
-
Use the CData ODBC Driver for Parallel in Microsoft Power Query
You can use the CData Parallel ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Parallel data into Microsoft Power Query.
-
Automated Continuous Presto Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Presto replication to delimited files (CSV/TSV).
-
Publish Reports with Guru Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Guru data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Elorus
Provide connectivity to Elorus data through an SAP BusinessObjects universe.
-
Integrate with Acumatica Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Acumatica data to a JSON file on disk.
-
Prepare, Blend, and Analyze Google Spanner Data in Alteryx Designer (Connect AI)
Build workflows to access live Google Spanner data for self-service data analytics.
-
Use Azure AI Foundry to Talk to Your OData Services 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 OData services for you.
-
How to Connect the Power BI Service to Shippo: Complete Guide
Connect to the CData Software Power BI Connector for Shippo from PowerBI.com to provide real-time Shippo data across the organization.
-
Build Dashboards with SharePoint Data in Dundas BI
Create dynamic dashboards and perform analytics based on SharePoint data in Dundas BI.
-
Build Agents in Relevance AI with Access to Live Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Reckon Accounts Hosted data within intelligent agent workflows.
-
Create Informatica Mappings From/To an ODBC Data Source for Apollo
Create an ODBC connection to Apollo in Informatica and browse and transfer Apollo data.
-
Use the CData Software JDBC Driver for Short.io in MicroStrategy Desktop
Connect to Short.io data in MicroStrategy Desktop using the CData Software JDBC Driver for Short.io.
-
Connect and Query Live Neo4J Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Neo4J data into Databricks and enable direct, live querying and analysis without replication.
-
Access Live Azure DevOps Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Azure DevOps data from your Excel spreadsheets.
-
Natively Connect to Mocean Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Mocean data. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData Power BI Connector for OpenWeatherMap
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to import Reckon Data into Apache Solr
Use the CData Software JDBC Driver for Reckon in Data Import Handler and create an automated import of Reckon data to Apache Solr Enterprise Search platform.
-
How to create SAP BusinessObjects BI federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP BusinessObjects BI data in MySQL .
-
Automated Continuous Auth0 Replication to MySQL
Use CData Sync for automated, continuous, customizable Auth0 replication to MySQL.
-
Build Apps with Live Pingdom Data Using the Low-Code Development Platform of Mendix
Connect Pingdom data with Mendix to build apps using the CData API Driver for JDBC.
-
Access Amazon Athena Data 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 Amazon Athena data.
-
Integrate Cursor with Live SAP Business Warehouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP Business Warehouse data from within the editor.
-
Connect to Freshsales Data in Aqua Data Studio
Access Freshsales data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to QuickBooks Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for QuickBooks data in the Denodo Virtual DataPort Administrator.
-
Access ChartMogul Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ChartMogul data from HeidiSQL.
-
Replicate Spark Data in Heroku for Use in Salesforce Connect
Replicate Spark data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use Manus AI to Talk to Your Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Email data.
-
Integrating Dataiku with Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Avalara AvaTax data.
-
Build MVC Applications with Connectivity to SageHR Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SageHR from an ASP.NET MVC application.
-
Create Google Directory-Connected Business Apps in AppSheet
Connect to Google Directory Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google Directory data.
-
Integrating Kiro with VWO Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Getting Started with the CData Power BI Connector for Google Sheets
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Sheets.
-
Work with ConstantContact Data in FoxPro
Load ConstantContact data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Multiple ShipEngine Accounts via the CData Sync CLI
Replicate multiple ShipEngine accounts to one or many databases.