CData Software - Knowledge Base
Recent Articles
-
Integrate Open WebUI with Live Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Email data from within the chat interface.
-
Connecting Moonlit Workflow with Paymo 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 Paymo data in real time.
-
How to create an RPA flow for Paymo Data in UiPath Studio
Use the Paymo ODBC Driver to create workflows that access real-time Paymo data without any coding.
-
Prepare, Blend, and Analyze Perplexity Data in Alteryx Designer (ODBC)
Build workflows to access live Perplexity data for self-service data analytics.
-
Query ShipStation Data in ColdFusion
Write standard ColdFusion data access code to connect to ShipStation data.
-
Integrate PayPal Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to PayPal data and integrate live PayPal data into your Power Automate tasks.
-
Use CData Connect AI to Access ShipStation Data in Microsoft Power Pivot
Use CData Connect AI to connect to live ShipStation data in the Power Pivot business intelligence tool.
-
How to Connect DBeaver to Databricks via a JDBC Driver
Manage Databricks data with visual tools in DBeaver like the query browser.
-
Connecting Pipedream with Gong 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 Gong data in real time.
-
Connect to CapsuleCRM Data in NetBeans
Connect to CapsuleCRM data in NetBeans with the data source configuration wizard.
-
Build Semantic Layer Views for ServiceDesk Plus Data in APOS Live Data Gateway
Use the CData Connector for ServiceDesk Plus in APOS Live Data Gateway to build Semantic Layer Views for ServiceDesk Plus data.
-
Build Semantic Layer Views for AgileCRM Data in APOS Live Data Gateway
Use the CData Connector for AgileCRM in APOS Live Data Gateway to build Semantic Layer Views for AgileCRM data.
-
How to Work with BambooHR Data in ETL Validator JDBC
Connect to BambooHR from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Live Dynamics 365 Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Dynamics 365 data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Configure the CData JDBC Driver for Google Translate in a Connection Pool in Tomcat
Connect to Google Translate data from a connection pool in Tomcat.
-
Replicate Multiple Sendwithus Accounts
Replicate multiple Sendwithus accounts to one or many databases.
-
Connect to Salesforce Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Salesforce data in Airbyte.
-
Integrate LibreChat with Live Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google Directory data from within the chat interface.
-
Bridge Hubstaff Connectivity with Apache NiFi
Access and process Hubstaff data in Apache NiFi using the CData JDBC Driver.
-
Connect to Jumpseller Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Jumpseller data.
-
Access Live Couchbase Data in TIBCO Data Virtualization
Use the Couchbase Tibco DV Adapter to create a Couchbase data data source in TIBCO Data Virtualization Studio and gain access to live Couchbase data from your TDV Server.
-
Integrate Microsoft Entra ID with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Microsoft Entra ID with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Microsoft Entra ID data.
-
Visualize Live REST Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live REST data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create a Data Access Object for Nuclia Data using JDBI
A brief overview of creating a SQL Object API for Nuclia data in JDBI.
-
How to Work with Salesforce Data 360 Data in AWS Glue Jobs Using JDBC
Connect to Salesforce Data 360 from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Supabase Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Supabase and work with Supabase data in your FileMaker application.
-
Use Microsoft Copilot Studio to talk to your SAS Data Sets 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 SAS Data Sets data for you.
-
Connect to Codat Data in HULFT Integrate
Connect to Codat as a JDBC data source in HULFT Integrate
-
Automated Continuous Paddle Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Paddle replication to Google Cloud SQL.
-
Working with Omnisend Data in LINQPad
Execute LINQ queries to Omnisend data in LINQPad.
-
Integrating LangChain with DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on DocuSign data within automated workflows.
-
Use Biml to Build SSIS Tasks to Replicate Beeminder Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Beeminder data to SQL Server.
-
Connect to Grafana Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Grafana data from Filemaker Pro on Mac.
-
Integrate Typeform Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Typeform data from Informatica Cloud.
-
Build AI Agents with HubDB Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live HubDB data through CData Connect AI.
-
Connect to Xero Data in Google Apps Script via Connect AI
Use CData Connect AI to access Xero data in Google Apps Script.
-
Automated Continuous Pushbullet Replication to Vertica
Use CData Sync for automated, continuous, customizable Pushbullet replication to Vertica.
-
Connect to Hive Data from HeidiSQL
Use CData Connect AI to connect to and query live Hive data from HeidiSQL.
-
Automate Chargebee Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Chargebee data from PowerShell? This article demonstrates how to utilize the Chargebee Cmdlets for tasks like connecting to Chargebee data, automating operations, downloading data, and more.
-
View Reports on Real-Time Discord Data in Power BI Report Server
Use the CData ODBC Driver for Discord to visualize Discord data in Power BI Desktop and then publish them to Power BI Report Server.
-
Model Okta Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Okta, enabling the direct import of real-time Okta data.
-
Integrate Live FreshBooks Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live FreshBooks data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Object-Relational Mapping (ORM) with Beeminder Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Beeminder data into a Java-based ORM framework, Hibernate.
-
Create Data Visualizations in Cognos BI with SuiteCRM Data
Access SuiteCRM data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build a Singer.io Tap for Office 365 With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Office 365 data using the CData Python Connector.
-
Automated Continuous Apollo Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Apollo replication to AlloyDB.
-
How to Connect to & Open Tally Data in Microsoft Excel
This article uses the CData ODBC driver for Tally to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
SAP HANA Reporting in OBIEE with the SAP HANA JDBC Driver
Deploy the SAP HANA JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Replicate Multiple Oracle HCM Cloud Accounts via the CData Sync CLI
Replicate multiple Oracle HCM Cloud accounts to one or many databases.
-
Publish Reports with SAS Data Sets Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAS Data Sets data.
-
Provide OData Services of Mailjet Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Mailjet data by developing a WCF Service Application.
-
Getting Started with the CData ADO.NET Provider for Jira Assets
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Jira Assets.
-
Natively Connect to RabbitMQ Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to RabbitMQ data. Leverage the native support for ODBC in PHP.
-
Prepare, Blend, and Analyze ActiveCampaign Data in Alteryx Designer (ODBC)
Build workflows to access live ActiveCampaign data for self-service data analytics.
-
Access Live SparkPost Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SparkPost data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Configure the CData JDBC Driver for CircleCI in a Connection Pool in Tomcat
Connect to CircleCI data from a connection pool in Tomcat.
-
Integrating Cursor with Accelo 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.
-
Design BIRT Reports on MailChimp Data
Provide current MailChimp data to your embedded analytics.
-
Work with Salesforce CRM Analytics Data in FoxPro
Load Salesforce CRM Analytics data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automate PagerDuty Data Replication to Couchbase
Use CData Sync to Customize and automate PagerDuty data replication to Couchbase.
-
Query Excel Online Data in ColdFusion
Write standard ColdFusion data access code to connect to Excel Online data.
-
Analyze Live Amazon Marketplace Data in SAS Viya
Use CData Connect AI to connect to Amazon Marketplace data from SAS Viya and deploy self-service analytics using live Amazon Marketplace data.
-
Analyze Gmail Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Gmail data and visualize live Gmail data in Infragistics Reveal.
-
Connect to Microsoft Entra ID Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Microsoft Entra ID and the SQL Gateway to access Microsoft Entra ID data from Google Apps Script.
-
Use the CData Software ODBC Driver for Simplesat in MicroStrategy
Connect to Simplesat data in MicroStrategy Developer using the CData Software ODBC Driver for Simplesat.
-
Bridge Outlook Connectivity with Apache NiFi
Access and process Outlook data in Apache NiFi using the CData JDBC Driver.
-
Use Grok to Talk to Your Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Quickbase data for you.
-
Replicate Cohere Data to Multiple Databases
Replicate Cohere data to disparate databases with a point-and-click configuration.
-
Prepare, Blend, and Analyze SAP Ariba Source Data in Alteryx Designer (ODBC)
Build workflows to access live SAP Ariba Source data for self-service data analytics.
-
Automated Continuous Microsoft OneLake Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to Amazon S3.
-
How to Connect to SAP ByDesign Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP ByDesign data. Leverage the pyodbc module for ODBC in Python.
-
Visualize LightSpeedRetail Data in Sisense
Create an ElastiCube in Sisense app with access to LightSpeedRetail data.
-
Publish Unbounce-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Unbounce data.
-
Connect to Power BI XMLA from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Power BI XMLA data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create Wave Financial-Connected Applications in Appsmith
Connect to Wave Financial Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Wave Financial data.
-
Visualize Aha! Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Aha! data.
-
DataBind SharePoint Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SharePoint with the DevExpress Windows Forms and Web controls to provide SharePoint data to a chart.
-
Getting Started with the CData ADO.NET Provider for Cassandra
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Cassandra.
-
Integrate Zoho Creator Data in the Pentaho Report Designer
Publish reports based on Zoho Creator data in the Pentaho BI tool.
-
Integrate Trae with Live Highrise Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Highrise data from within the AI-powered IDE.
-
How to Connect to Live Typeform 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 Typeform data through natural language.
-
Integrate Live ZohoExpense Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to ZohoExpense from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live ZohoExpense data.
-
Automated Continuous Chargebee Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Chargebee replication to Google BigQuery.
-
Automated Continuous Microsoft Dataverse Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Apache Kafka.
-
Access SuiteCRM Data from MySQL in Amazon QuickSight
Connect to SuiteCRM and build visualizations of SuiteCRM data using a MySQL Connection in Amazon QuickSight.
-
Use the CData Software JDBC Driver for SAP Fieldglass in MicroStrategy Desktop
Connect to SAP Fieldglass data in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Fieldglass.
-
Getting Started with the CData Power BI Connector for SparkPost
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automated Continuous Salesforce Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Salesforce replication to IBM DB2.
-
Integrate Cline with Live ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live ADP data from within your IDE.
-
Getting Started with the CData ODBC Driver for FHIR
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for FHIR.
-
Automate Dynamics 365 Business Central Data Replication to SAP HANA
Use CData Sync to customize and automate Dynamics 365 Business Central data replication to SAP HANA.
-
Analyze Microsoft Ads Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft Ads data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Back Up Moosend data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Moosend data data.
-
Query Coinbase Data in DataGrip
Create a Data Source for Coinbase in DataGrip and use SQL to query live Coinbase data.
-
How to Easily Query Printful Data in OpenOffice Base
Connect to Printful data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous Act CRM Replication to Oracle
Use CData Sync for automated, continuous, customizable Act CRM replication to Oracle.
-
Create Data Visualizations Based On Gong Data in Mode
Use CData Connect AI to connect to Gong Data from Mode and build visualizations using live Gong data.
-
Rapidly Develop JSON-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by JSON.
-
Integrating Codex with Landbot 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.
-
Build Microsoft OneDrive-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Microsoft OneDrive Data and create custom apps in Bubble.