CData Software - Knowledge Base
Recent Articles
-
How to connect SharePoint with Oracle Sales Data through external lists
Provide Oracle Sales data to SharePoint users as an external list.
-
Automated Continuous Amplitude Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Amplitude replication to Amazon S3.
-
Integrating Codex with Qualaroo 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.
-
Connect to Dynamics NAV from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Dynamics NAV data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Live Xero Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Xero data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous HubDB Replication to Snowflake
Use CData Sync for automated, continuous, customizable HubDB replication to Snowflake.
-
Integrate Aha! Data in the Pentaho Report Designer
Publish reports based on Aha! data in the Pentaho BI tool.
-
Connect to Strava Data in Ruby
Connect to Strava data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Acumatica Replication to Databricks
Use CData Sync for automated, continuous, customizable Acumatica replication to Databricks.
-
How to connect SharePoint with Active Directory Data through external lists
Provide Active Directory data to SharePoint users as an external list.
-
Connect to Greenplum Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Greenplum to connect to Greenplum data and execute queries in PowerBuilder.
-
Access Cloudflare 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 Cloudflare data.
-
Import Reckon Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Reckon Data and provide access to live Reckon data for custom reports in the Power BI Service.
-
Analyze Printify Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Printify data with the CData JDBC Driver for Printify.
-
Model, Search, and Visualize Live Google Cloud Storage Data in ThoughtSpot
Use CData Connect AI to connect to live Google Cloud Storage data for modeling, searching, and visualizing.
-
Build a PostgreSQL Interface for Reckon Accounts Hosted Data using the CData JDBC Driver
Use the Remoting features of the Reckon Accounts Hosted JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to ConvertAPI Data in RapidMiner
Integrate ConvertAPI data with standard components and data source configuration wizards in RapidMiner Studio.
-
A PostgreSQL Interface for Microsoft Teams Data (MySQL Remoting via JDBC)
Use the Remoting features of the Microsoft Teams JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Dynamics CRM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Dynamics CRM from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query Spark Data in ColdFusion
Write standard ColdFusion data access code to connect to Spark data.
-
Connect Amazon Athena to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Amazon Athena with IBM WebSphere for seamless data integration and connectivity.
-
Easily Integrate Front Data in Lazarus Pascal IDE
Learn how to easily integrate live Front data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Google Translate Data in DBArtisan
Use wizards in DBArtisan to configure Google Translate data as a data source.
-
Deploy the ADO.NET Provider for SuiteCRM on an SSRS Report Server
Connect to SuiteCRM data 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.
-
Getting Started with the CData Power BI Connector for SendGrid
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SendGrid.
-
Build Semantic Layer Views for Monday.com Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Monday.com data.
-
Access Live Freshsales Data in Coginiti Pro
Connect to and query live Freshsales data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Telegram Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Telegram data using standard SQL.
-
Establish a Live Connection with Templated Data using Tableau Bridge
The CData ODBC Driver for Templated enables you to integrate live Templated data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate with Zuora Data in JReport Designer
Create charts and reports based on Zuora data in JReport Designer.
-
Integrate Zoho Books Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Zoho Books data and integrate live Zoho Books data into your Power Automate tasks.
-
Easily Integrate SuiteCRM Data in Lazarus Pascal IDE
Learn how to easily integrate live SuiteCRM data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Migrating data from ZohoSubscriptions to Google BigQuery using CData SSIS Components.
Easily push ZohoSubscriptions data to Google BigQuery using the CData SSIS Tasks for ZohoSubscriptions and Google BigQuery.
-
Working with Epicor Kinetic Data in LINQPad
Execute LINQ queries to Epicor Kinetic data in LINQPad.
-
Automated Continuous AlloyDB Replication to Oracle
Use CData Sync for automated, continuous, customizable AlloyDB replication to Oracle.
-
Automated Continuous Dotmailer Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Dotmailer replication to delimited files (CSV/TSV).
-
Use the CData Software ODBC Driver for SAP Fieldglass in MicroStrategy
Connect to SAP Fieldglass data in MicroStrategy Developer using the CData Software ODBC Driver for SAP Fieldglass.
-
Build Data Flows from SQL Server to Square through SSIS
Easily push SQL Server data to Square using the CData SSIS Tasks for Square.
-
Visualize Billsby Data in TIBCO Spotfire through ADO.NET
Integrate Billsby data into dashboards in TIBCO Spotfire.
-
Access Live CapsuleCRM Data in AWS Lambda
Connect to live CapsuleCRM data in AWS Lambda using the CData JDBC Driver.
-
Integrate Live Dynamics 365 Business Central Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Dynamics 365 Business Central from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Dynamics 365 Business Central data.
-
Connect to and Visualize Live SAP HANA XS Advanced Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP HANA XS Advanced data.
-
Connect to Onfleet Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Onfleet to connect to Onfleet data and execute queries in PowerBuilder.
-
Create MailerLite-Connected Business Apps in AppSheet
Connect to MailerLite Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to MailerLite data.
-
Build Visualizations of SingleStore Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SingleStore data in Birst.
-
Connect to ElevenLabs from a Connection Pool in WebLogic
Use the CData JDBC Driver for ElevenLabs to connect to ElevenLabs data from Web applications running on WebLogic.
-
Getting Started with the CData Excel Add-In for Marketo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Marketo.
-
Build Pipedrive-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Pipedrive Data and create custom apps in Bubble.
-
Connect to Splunk Data in RapidMiner
Integrate Splunk data with standard components and data source configuration wizards in RapidMiner Studio.
-
View Reports on Real-Time BambooHR Data in Power BI Report Server
Use the CData ODBC Driver for BambooHR to visualize BambooHR data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to publish and share SAP Hybris C4C Data dashboards with Tableau Server
The CData ODBC driver for SAP Hybris C4C enables you integrate SAP Hybris C4C data into Tableau dashboards.
-
Connect to Excel Online Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Excel Online Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Easily Integrate ZohoExpense Data in Lazarus Pascal IDE
Learn how to easily integrate live ZohoExpense data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connecting Pipedream with Zoom Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Zoom data in real time.
-
Analyze MarkLogic Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of MarkLogic data and visualize live MarkLogic data in Infragistics Reveal.
-
Viewing Contentful Data in RAD Studio Data Explorer
How to view Contentful data in RAD Studio Data Explorer using the CData ODBC Driver for Contentful.
-
Prepare, Blend, and Analyze HDFS Data in Alteryx Designer (ODBC)
Build workflows to access live HDFS data for self-service data analytics.
-
Creating Cosmos DB-Connected Applications in Unqork
You can use CData Connect AI to feed Cosmos DB data to Unqork and build custom business apps.
-
Build Automated Workflows with Live Sage 200 Data in Workato
Use CData Connect AI to connect to live Sage 200 data and build automated workflows in Workato.
-
Provide OData Services of Outreach.io Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Outreach.io data by developing a WCF Service Application.
-
Integrate PingOne with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PingOne with External Services.
-
How to work with QuickBooks Online Data in Apache Spark using SQL
Access and process QuickBooks Online Data in Apache Spark using the CData Software JDBC Driver.
-
Import GetResponse Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to GetResponse Data and provide access to live GetResponse data for custom reports in the Power BI Service.
-
Getting Started with the CData ODBC Driver for SQL Analysis Services
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SQL Analysis Services.
-
Automated Continuous Xero Replication to Databricks
Use CData Sync for automated, continuous, customizable Xero replication to Databricks.
-
Replicate ShipEngine Data to Multiple Databases
Replicate ShipEngine data to disparate databases with a point-and-click configuration.
-
Create Pinterest-Connected Nintex Workflows
Use CData Connect AI to connect to Pinterest Data from Nintex Workflow Cloud and build custom workflows using live Pinterest data.
-
Create Zendesk-Connected Applications in Appsmith
Connect to Zendesk Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Zendesk data.
-
Connect to Dynamics 365 Business Central Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Dynamics 365 Business Central to connect to Dynamics 365 Business Central data and execute queries in PowerBuilder.
-
Use the CData Software ODBC Driver for HCL Domino in MicroStrategy
Connect to HCL Domino data in MicroStrategy Developer using the CData Software ODBC Driver for HCL Domino.
-
Use the CData ODBC Driver for Sage Cloud Accounting in Microsoft Power Query
You can use the CData Sage Cloud Accounting ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sage Cloud Accounting data into Microsoft Power Query.
-
Access Live Optimizely Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Optimizely data from your Google Sheets.
-
Create Confluence Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Confluence from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData Software ODBC Driver for SAP SuccessFactors LMS in MicroStrategy Web
Connect to SAP SuccessFactors LMS data in MicroStrategy Web using the CData Software ODBC Driver for SAP SuccessFactors LMS.
-
Integrating Gumloop with Suadeo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Suadeo data within automated workflows.
-
How to Build an ETL App for Jumpseller Data in Python with CData Connect AI
Extract and transform live Jumpseller data in Python with petl and the CData Connect AI Python SDK.
-
Integrate Live Vertica Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Vertica from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Vertica data.
-
Connect to Neo4J Data in ACL Analytics
Connect to Neo4J data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Neo4J data.
-
Use Azure AI Foundry to Talk to Your ZohoExpense Data 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 ZohoExpense data for you.
-
Integrating OpenCode with ZohoExpense 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.
-
Automated Continuous LinkedIn Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to Amazon S3.
-
Interact with Live Zoom Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Zoom data.
-
Create Informatica Mappings From/To a JDBC Data Source for Splunk
Create Splunk data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Real-Time Okta Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Okta and Dataflow to import and use Okta data in Power Apps.
-
Access Box Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Box data from HeidiSQL.
-
Integrate AgileCRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate AgileCRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to AgileCRM data.
-
Create a Data Access Object for Okta Data using JDBI
A brief overview of creating a SQL Object API for Okta data in JDBI.
-
How to Connect Guru Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Guru data in real time using natural language.
-
Automated Continuous Teamwork Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Teamwork replication to Amazon Redshift.
-
How to connect to PhantomBuster Data from Spring Boot
Connect to PhantomBuster in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Ontraport Data from PowerBuilder via ADO.NET
This article demonstrates how to access Ontraport data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrating LangGraph with Freshservice Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Freshservice data within automated workflows.
-
Access Live GitHub Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate GitHub data into the statistical analysis tools available in SAS JMP. This article shows how to use GitHub data in the Graph Builder and Query Builder.
-
Integrate Google's Antigravity Agent with Live HDFS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live HDFS data using the Model Context Protocol.
-
Back Up Google Cloud Storage data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Cloud Storage. In this article, we will employ an SSIS workflow to populate a database with Google Cloud Storage data data.
-
Analyze ElevenLabs Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ElevenLabs from Power Pivot. You will use the Table Import Wizard to load ElevenLabs data. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Microsoft Entra ID Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Entra ID data.
-
Integrate Cline with Live SparkPost Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SparkPost data from within your IDE.
-
Visualize Live Typeform Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Typeform data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Explore Geographical Relationships in ClickUp Data with Power Map
Create data visualizations with ClickUp data in Power Map.