CData Software - Knowledge Base
Recent Articles
-
How to load Procore data into Elasticsearch via Logstash
Introducing a simple method to load Procore data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Microsoft Entra ID Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft Entra ID data and build visualizations in Tableau.
-
Build Apps with Live GitHub Data Using the Low-Code Development Platform of Mendix
Connect GitHub data with Mendix to build apps using the CData JDBC Driver for GitHub.
-
Access Live ADP Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ADP data from your Google Sheets.
-
Create Dynamic Odoo Grids Using the Infragistics XamDataGrid
Learn how you can connect Odoo to Infragistics XamDataGrid to build dynamic grids.
-
Create a Data Access Object for Onfleet Data using JDBI
A brief overview of creating a SQL Object API for Onfleet data in JDBI.
-
Connect to Sendwithus Data in HULFT Integrate
Connect to Sendwithus as a JDBC data source in HULFT Integrate
-
Connect to MailChimp Data in Ruby
Connect to MailChimp data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Eventbrite Data in Aqua Data Studio
Access Eventbrite data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Webflow Data in DBArtisan
Use wizards in DBArtisan to configure Webflow data as a data source.
-
Automated Continuous Amazon Marketplace Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to IBM DB2.
-
Creating Okta-Connected Applications in Unqork
You can use CData Connect AI to feed Okta data to Unqork and build custom business apps.
-
Connect to Real-Time ScrapingBee Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ScrapingBee data in Power Apps.
-
Automated Continuous MongoDB Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable MongoDB replication to Amazon Redshift.
-
Use Biml to Build SSIS Tasks to Replicate Microsoft Teams Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Teams data to SQL Server.
-
Automate Google Campaign Manager 360 Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Campaign Manager 360 data from PowerShell? This article demonstrates how to utilize the Google Campaign Manager 360 Cmdlets for tasks like connecting to Google Campaign Manager 360 data, automating operations, downloading data, and more.
-
Import XML Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to XML Data and provide access to live XML data for custom reports in the Power BI Service.
-
Build Charts with ConvertAPI Data in Clear Analytics
Create dynamic charts and perform analytics based on ConvertAPI data in Clear Analytics.
-
Automated Continuous NASA Replication to Amazon S3
Use CData Sync for automated, continuous, customizable NASA replication to Amazon S3.
-
Getting Started with the CData Connect AI Python SDK for Dynamics NAV
Install the CData Connect AI Python SDK to read and write live Dynamics NAV data with standard DB-API 2.0 Python code.
-
Getting Started with the CData Excel Add-In for Google Campaign Manager 360
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Campaign Manager 360.
-
Write a Simple Go Application to work with Pipeline CRM Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Pipeline CRM data.
-
Automate Oracle Financials Cloud Data Replication to Couchbase
Use CData Sync to Customize and automate Oracle Financials Cloud data replication to Couchbase.
-
Analyze Google Ads Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Ads data in Microsoft R Open.
-
Process & Analyze Unbounce Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Unbounce Data.
-
Build a Simple VCL Application for Bright Data Data
How to build a simple VCL Application to view Bright Data data in RAD Studio using the CData ODBC Driver for Bright Data.
-
Connect to Helpscout Data in JRuby
Create a simple JRuby app with access to live Helpscout data.
-
Process & Analyze SQL Server Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SQL Server Data.
-
Replicate ZohoMarketingHub Data to Multiple Databases
Replicate ZohoMarketingHub data to disparate databases with a point-and-click configuration.
-
Build Zoho Creator-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Zoho Creator Data and create custom apps in Bubble.
-
Create SharePoint-Connected Dashboards in Grafana
Connect to SharePoint Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SharePoint data.
-
DataBind Controls to Quickbase Data in C++Builder
DataBind to Quickbase data in C++Builder with standard components and controls.
-
Automated Continuous Elorus Replication to SingleStore
Use CData Sync for automated, continuous, customizable Elorus replication to SingleStore.
-
Operational Reporting on ZohoDesk Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ZohoDesk data.
-
How to create an RPA flow for DB2 Data in UiPath Studio
Use the DB2 ODBC Driver to create workflows that access real-time DB2 data without any coding.
-
Integrate Theia IDE with Live Perplexity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Perplexity data from within the development environment.
-
Automated Continuous Autopilot Replication to MySQL
Use CData Sync for automated, continuous, customizable Autopilot replication to MySQL.
-
Access Couchbase Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Couchbase data from HeidiSQL.
-
Feed Freshdesk Data into FineReport
How to set Freshdesk data as a JDBC data source in FineReport.
-
How to Connect to Live AgileCRM Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your AgileCRM data for you.
-
Publish eBay Analytics-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live eBay Analytics data.
-
Build Google Campaign Manager 360-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Campaign Manager 360 data and build web apps with connectivity to live Google Campaign Manager 360 data.
-
Back Up Paylocity data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Paylocity. In this article, we will employ an SSIS workflow to populate a database with Paylocity data data.
-
Use the CData SSIS Components to Insert New or Update Existing Bullhorn CRM Records from SQL Server
Easily push SQL Server data to Bullhorn CRM using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Bullhorn CRM or update existing records with data from a SQL Server database.
-
Build Cloudflare-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Cloudflare Data and create custom apps in Mendix.
-
Natively Connect to MySQL Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MySQL data. Leverage the native support for ODBC in PHP.
-
Create Data Visualizations in Cognos BI with Placid Data
Access Placid data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Connect to Live Power BI XMLA Data 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 Power BI XMLA data for you.
-
Getting Started with the CData ADO.NET Provider for Productboard
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
A PostgreSQL Interface for NASA Data using the CData ODBC Driver
Use the SQL Gateway and NASA ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Presto from Asprova with CData Software ODBC Driver for Presto
This article shows how to connect faster to Presto data from Asprova.
-
Query Zoho Recruit Data in DataGrip
Create a Data Source for Zoho Recruit in DataGrip and use SQL to query live Zoho Recruit data.
-
Access Live Attio Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Attio data from your Excel spreadsheets.
-
Build MVC Applications with Connectivity to Bannerbear Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Bannerbear from an ASP.NET MVC application.
-
Use Dash to Build Web Apps on Smartsheet Data via CData Connect AI
Build interactive Dash web apps on live Smartsheet data using pandas and the CData Connect AI Python SDK.
-
Automated Continuous ClickUp Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ClickUp replication to Apache Cassandra.
-
Connecting Agentforce with Oracle SCM 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 Oracle SCM data for you.
-
Build Data Flows from Contentful to SQL Server using SSIS
Easily back up Contentful data to SQL Server using the SSIS components for Contentful.
-
Use the CData Software JDBC Driver for Microsoft Teams in MicroStrategy Desktop
Connect to Microsoft Teams data in MicroStrategy Desktop using the CData Software JDBC Driver for Microsoft Teams.
-
Connect to Airtable Data from AWS Glue
Use CData Connect AI to gain access to live Airtable data from your AWS Glue jobs.
-
Analyze Shopify Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Shopify data with the CData JDBC Driver for Shopify.
-
Validate SharePoint Excel Services Data with QuerySurge
Access and validate SharePoint Excel Services data in QuerySurge using the CData JDBC Driver.
-
Configure the CData JDBC Driver for Google Contacts in a Connection Pool in Tomcat
Connect to Google Contacts data from a connection pool in Tomcat.
-
Connect to Timely Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Timely Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Connect to Azure Synapse Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Azure Synapse data. Leverage the pyodbc module for ODBC in Python.
-
Analyze Oracle SCM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Oracle SCM data in Microsoft R Open.
-
Use Microsoft Copilot Studio to talk to your Bannerbear Data 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 Bannerbear data for you.
-
Use Microsoft Copilot Studio to talk to your Marketo Data 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 Marketo data for you.
-
Design BIRT Reports on SAP HANA Data
Provide current SAP HANA data to your embedded analytics.
-
How to connect PolyBase to Trello
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Trello data.
-
Connect to Sage Cloud Accounting Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Sage Cloud Accounting data.
-
Automated Continuous FreeAgent Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable FreeAgent replication to Google BigQuery.
-
How to Connect to FormSite Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to FormSite data. Leverage the pyodbc module for ODBC in Python.
-
Validate GitHub Data with QuerySurge
Access and validate GitHub data in QuerySurge using the CData JDBC Driver.
-
Replicate Autopilot Data in Heroku for Use in Salesforce Connect
Replicate Autopilot data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Trae with Live Zoho Creator Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Zoho Creator data from within the AI-powered IDE.
-
Create Dashboards and Visualize Live FTP Data in Geckoboard
Use CData Connect AI to connect to live FTP data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Work with Pingdom Data in AWS Glue Jobs Using JDBC
Connect to Pingdom from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Qualaroo Data in RapidMiner
Integrate Qualaroo data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating LlamaIndex with Omnisend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Omnisend data in real time.
-
Connect to TigerGraph Data in HULFT Integrate
Connect to TigerGraph as a JDBC data source in HULFT Integrate
-
Link SQL Analysis Services with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SQL Analysis Services data in Filemaker Pro for Mac or Windows.
-
Write a Simple Go Application to work with SAP BusinessObjects BI Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP BusinessObjects BI data.
-
Establish a Live Connection with SAP Ariba Source Data using Tableau Bridge
The CData ODBC Driver for SAP Ariba Source enables you to integrate live SAP Ariba Source data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating Kiro with Azure Table 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.
-
Access Live Grafana Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Grafana data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Visualize Reckon Accounts Hosted Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Reckon Accounts Hosted data.
-
Query Bright Data Data as a MySQL Database in Node.js
Execute MySQL queries against Bright Data data from Node.js.
-
Create Dashboards and Visualize Live Okta Data in Geckoboard
Use CData Connect AI to connect to live Okta data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access Live Stack Exchange Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Stack Exchange data into the statistical analysis tools available in SAS JMP. This article shows how to use Stack Exchange data in the Graph Builder and Query Builder.
-
Automate LDAP Objects Replication to Azure Synapse
Use CData Sync to customize and automate LDAP objects replication to Azure Synapse.
-
How to Connect Freshdesk 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 Freshdesk data in real time using natural language.
-
Publish Amazon Marketplace-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Amazon Marketplace data.
-
Connect Paymo Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Paymo data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create SSAS Tabular Models from JSON Services
How to build a SQL Server Analysis Service Tabular Model from JSON services using CData drivers.
-
Automate Jira Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Jira data from PowerShell? This article demonstrates how to utilize the Jira Cmdlets for tasks like connecting to Jira data, automating operations, downloading data, and more.
-
How to import JDBC-ODBC Bridge Data into Apache Solr
Use the CData Software JDBC Driver for JDBC-ODBC Bridge in Data Import Handler and create an automated import of JDBC-ODBC Bridge data to Apache Solr Enterprise Search platform.
-
Connecting Mastra with Google Search Results 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 Google Search results, no replication required.
-
How to import Pushbullet Data into Apache Solr
Use the CData Software JDBC Driver for Pushbullet in Data Import Handler and create an automated import of Pushbullet data to Apache Solr Enterprise Search platform.
-
Query IBM Informix Data in DataGrip
Create a Data Source for IBM Informix in DataGrip and use SQL to query live IBM Informix data.