CData Software - Knowledge Base
Recent Articles
-
Connect to Live BambooHR Data in MicroStrategy through CData Connect AI
Create a live connection to BambooHR Data in CData Connect AI and connect to your BambooHR data from MicroStrategy.
-
Connecting GenSpark with ShipEngine Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to ShipEngine data without any replication or custom integration required.
-
Build Confluence-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Confluence data.
-
How to create an RPA flow for Contentful Data in UiPath Studio
Use the Contentful ODBC Driver to create workflows that access real-time Contentful data without any coding.
-
Build Automated Workflows with Live SingleStore Data in Workato
Use CData Connect AI to connect to live SingleStore data and build automated workflows in Workato.
-
Build Semantic Layer Views for eBay Data in APOS Live Data Gateway
Use the CData Connector for eBay in APOS Live Data Gateway to build Semantic Layer Views for eBay data.
-
How to Create Power BI Visual Reports with Real-Time CampaignMonitor Data
Use CData Power BI Connectors to visualize CampaignMonitor data in Power BI.
-
Automated Continuous Reckon Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Reckon replication to Amazon Redshift.
-
Connect to Customer.io Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Customer.io and the SQL Gateway to access Customer.io data from Google Apps Script.
-
Getting Started with the CData ADO.NET Provider for Gmail
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Gmail.
-
Connect to Nethunt Data in Ruby
Connect to Nethunt data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData Power BI Connector for Wistia
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Work with Cvent Data in AWS Glue Jobs Using JDBC
Connect to Cvent from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate eBay Analytics Data in Pentaho Data Integration
Build ETL pipelines based on eBay Analytics data in the Pentaho Data Integration tool.
-
Validate Mocean Data with QuerySurge
Access and validate Mocean data in QuerySurge using the CData JDBC Driver.
-
Connect to Dynamics 365 Data from PowerBuilder via JDBC
This article demonstrates how to access Dynamics 365 data from PowerBuilder using the Dynamics 365 JDBC Driver.
-
Connecting Moonlit Workflow with SQL Analysis Services 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 SQL Analysis Services data in real time.
-
Use Databricks Agent Bricks to Talk to Your Monday.com Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Monday.com data for you.
-
Access Live SAP SuccessFactors LMS Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live SAP SuccessFactors LMS data through MCP integration.
-
Work with SAP Netweaver Gateway Data in FoxPro
Load SAP Netweaver Gateway data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to AgileCRM Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for AgileCRM data in the Denodo Virtual DataPort Administrator.
-
How to work with Redis Data in Apache Spark using SQL
Access and process Redis Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to JDBC-ODBC Bridge Data in RapidMiner
Integrate JDBC-ODBC Bridge data with standard components and data source configuration wizards in RapidMiner Studio.
-
Publish Attio-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Attio data.
-
Connecting Moonlit Workflow with Microsoft Teams 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 Microsoft Teams data in real time.
-
DataBind Controls to QuickBooks Data in C++Builder
DataBind to QuickBooks data in C++Builder with standard components and controls.
-
How to Work with GitLab Data in AWS Glue Jobs Using JDBC
Connect to GitLab from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Freshdesk Data in Sisense
Create an ElastiCube in Sisense app with access to Freshdesk data.
-
Automated Continuous Zoho Books Replication to SQL Server
Use CData Sync for automated, continuous, customizable Zoho Books replication to SQL Server.
-
Connect MarkLogic to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect MarkLogic with IBM WebSphere for seamless data integration and connectivity.
-
Automate Microsoft Dataverse Data Replication to SAP HANA
Use CData Sync to customize and automate Microsoft Dataverse data replication to SAP HANA.
-
Create Dynamic SingleStore Grids Using the Infragistics XamDataGrid
Learn how you can connect SingleStore to Infragistics XamDataGrid to build dynamic grids.
-
How to Work with Snowflake Data in ETL Validator JDBC
Connect to Snowflake from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Campaigner Data from a Connection Pool in Jetty
The Campaigner JDBC Driver supports connection pooling: This article shows how to connect faster to Campaigner data from Web apps in Jetty.
-
Integrate RabbitMQ with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate RabbitMQ with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to RabbitMQ data.
-
Integrate Goose with Live Azure Data Catalog Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Azure Data Catalog data from within the local AI agent.
-
Viewing Customer.io Data in RAD Studio Data Explorer
How to view Customer.io data in RAD Studio Data Explorer using the CData ODBC Driver for Customer.io.
-
Access Live Coda Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Coda data from your Excel spreadsheets.
-
Use CData Connect AI to Access Monday.com Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Monday.com data in the Power Pivot business intelligence tool.
-
Integrate Live Act-On Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Act-On from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Act-On data.
-
Connect to Live Google Ads Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Ads in CData Connect AI and connect to your Google Ads data from PostgreSQL.
-
Build Visualizations of SAS Data Sets Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAS Data Sets data in Birst.
-
Use the CData ODBC Driver for Oracle HCM Cloud from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Oracle HCM Cloud to connect to Oracle HCM Cloud data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Oracle HCM Cloud data in Excel.
-
Analyze FormSite Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze FormSite data in Microsoft R Open.
-
Write a Simple Go Application to work with Salesforce Marketing Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Salesforce Marketing data.
-
Build an OLAP Cube in SSAS from MySQL Data
Establish a connection to MySQL data data from SQL Server Analysis Services, and use the MySQL Data Provider to build OLAP cubes for use in analytics and reporting.
-
Publish Reports with SAP Netweaver Gateway Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Netweaver Gateway data.
-
Access Live Clari Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Clari data into the statistical analysis tools available in SAS JMP. This article shows how to use Clari data in the Graph Builder and Query Builder.
-
How to Seamlessly Import Close Data into IBM SPSS Modeler
Integrate Close data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to use SQLAlchemy ORM to access Google Cloud Storage Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Cloud Storage data.
-
Use Dash to Build to Web Apps on ActiveCampaign Data
Create Python applications that use pandas and Dash to build ActiveCampaign-connected web apps.
-
Connect to Greenhouse from a Connection Pool in WebLogic
Use the CData JDBC Driver for Greenhouse to connect to Greenhouse data from Web applications running on WebLogic.
-
Build Visualizations of Nethunt Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Nethunt data in Birst.
-
Automated Continuous Google Forms Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Forms replication to Snowflake.
-
Connect to Acumatica Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Acumatica data.
-
Query Impala Data as a SQL Server Database in Node.js
Execute SQL Server queries against Impala data from Node.js.
-
Integrate Live Authorize.Net Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Authorize.Net data and integrate live Authorize.Net data into apps built in Microsoft Power Apps.
-
Create Reports from Certinia Data in Looker Studio
Use CData Connect AI to gain access to live Certinia data and create custom reports in Looker Studio.
-
Automated Continuous Trello Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Trello replication to Azure SQL Database.
-
How to connect and process Sage Intacct data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Sage Intacct data.
-
Use the CData ODBC Driver for Cohere in Microsoft Power Query
You can use the CData Cohere ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Cohere data into Microsoft Power Query.
-
Bridge Nuclia Connectivity with Apache NiFi
Access and process Nuclia data in Apache NiFi using the CData JDBC Driver.
-
Connect to ShipEngine Data from PowerBuilder via ADO.NET
This article demonstrates how to access ShipEngine data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create Informatica Mappings From/To a JDBC Data Source for Kafka
Create Kafka data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous HBase Replication to MongoDB
Use CData Sync for automated, continuous, customizable HBase replication to MongoDB.
-
Integrate PDFMonkey Data in the Pentaho Report Designer
Publish reports based on PDFMonkey data in the Pentaho BI tool.
-
Create Instagram-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Instagram Data from Klipfolio and build custom visualizations using live Instagram data.
-
Explore Geographical Relationships in Clio Data with Power Map
Create data visualizations with Clio data in Power Map.
-
View Reports on Real-Time CouchDB Data in Power BI Report Server
Use the CData ODBC Driver for CouchDB to visualize CouchDB data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use CData Connect AI to Access Bitly Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Bitly data in the Power Pivot business intelligence tool.
-
Connect and Visualize Live QuickBooks Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live QuickBooks data into the Databricks platform and create visualization dashboards with real-time QuickBooks data.
-
Automated Continuous Lakebase Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Lakebase replication to IBM DB2.
-
Create Calendly Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Calendly data access from reports, embedded analytics, and more.
-
Access Figshare Data from MySQL in Amazon QuickSight
Connect to Figshare and build visualizations of Figshare data using a MySQL Connection in Amazon QuickSight.
-
Visualize Live Odoo Data in the Power BI Service
Use CData Connect AI to connect to live Odoo data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to Live Paylocity Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Paylocity data through natural language.
-
Automated Continuous Marketo Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Marketo replication to PostgreSQL.
-
Build Visualizations of Confluence Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Confluence data in Birst.
-
Analyze Zuora Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Zuora data and visualize Zuora data in SAP Analytics Cloud.
-
Link Mouseflow with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Mouseflow data in Filemaker Pro for Mac or Windows.
-
Connect Billsby to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Billsby data using the CData Python MCP Server.
-
How to Work with SpaceX Data in ETL Validator JDBC
Connect to SpaceX from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Real-Time Access to CouchDB in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to CouchDB data in real time.
-
Provide OData Services of Freshteam Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Freshteam data by developing a WCF Service Application.
-
How to create Salesloft federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Salesloft data in MySQL .
-
Build Data Flows from Autopilot to SQL Server using SSIS
Easily back up Autopilot data to SQL Server using the SSIS components for Autopilot.
-
Integrate OpenCode with Live Google Ads Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Google Ads data from within your AI coding agent.
-
Analyze Superchat Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Superchat data in Microsoft R Open.
-
Write a Simple Go Application to work with SAP ByDesign Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP ByDesign data.
-
Consume FHIR OData Feeds in PowerBuilder
This article demonstrates how to consume FHIR data as OData feeds from PowerBuilder using the API Server.
-
Integrate SQL Server with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SQL Server with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SQL Server data.
-
How to Connect EnterpriseDB 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 EnterpriseDB data in real time using natural language.
-
Automate Procore Data Replication to Azure Data Lake
Use CData Sync to customize and automate Procore data replication to Azure Data Lake.
-
Access Live Discord Data in Excel 365 Online (Excel for the web)
Connect to Discord data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to load AgileCRM data into Elasticsearch via Logstash
Introducing a simple method to load AgileCRM data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Dify with Live BigQuery Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live BigQuery data.
-
Easily Integrate Factorial Data in Lazarus Pascal IDE
Learn how to easily integrate live Factorial data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Goose with Live Tally Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Tally data from within the local AI agent.
-
Build MVC Applications with Connectivity to Salesloft Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Salesloft from an ASP.NET MVC application.
-
Integrate Cline with Live Paymo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Paymo data from within your IDE.