CData Software - Knowledge Base
Recent Articles
-
Connecting Moonlit Workflow with HCL Domino 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 HCL Domino in real time.
-
Publish Crystal Reports on Google Campaign Manager 360 Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Campaign Manager 360.
-
How to Access Live Elasticsearch Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Elasticsearch enables you to integrate Elasticsearch into workflows built using Microsoft Power Automate Desktop.
-
Load Splunk Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Splunk to a database.
-
Connect to Klipfolio Data from a Connection Pool in JBoss
Integrate Klipfolio into Java servlets: Use the Management Console in JBoss to install the Klipfolio JDBC Driver.
-
Automated Continuous FreshBooks Replication to AlloyDB
Use CData Sync for automated, continuous, customizable FreshBooks replication to AlloyDB.
-
Visualize Live Tickspot Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Tickspot using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Model, Search, and Visualize Live Greenhouse Data in ThoughtSpot
Use CData Connect AI to connect to live Greenhouse for modeling, searching, and visualizing.
-
Connect to and Visualize Live Zoho Inventory Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Zoho Inventory.
-
Operational Reporting on MongoDB Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote MongoDB.
-
Use Dash to Build to Web Apps on Notion Data
Create Python applications that use pandas and Dash to build Notion-connected web apps.
-
Build SAP Hybris C4C-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for SAP Hybris C4C to explore live SAP Hybris C4C Data in Cursor to assist with building SAP Hybris C4C-powered applications.
-
Connect to MailerLite Data from PowerBuilder via ADO.NET
This article demonstrates how to access MailerLite from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to connect to Procore Data in DBVisualizer
Integrate Procore with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Visualize Salesforce Marketing Data in Python with pandas
Use pandas and other modules to analyze and visualize live Salesforce Marketing Cloud in Python.
-
Analyze ZohoPeople Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ZohoPeople with the CData JDBC Driver for ZohoPeople.
-
Seamlessly Bring Impala Data into Retool Using CData Connect AI
Integrate Impala data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to import Gumroad Data into Apache Solr
Use the CData Software JDBC Driver for Gumroad in Data Import Handler and create an automated import of Gumroad to Apache Solr Enterprise Search platform.
-
View Reports on Real-Time LionDesk Data in Power BI Report Server
Use the CData ODBC Driver for LionDesk to visualize LionDesk in Power BI Desktop and then publish them to Power BI Report Server.
-
Working with MariaDB Data in LINQPad
Execute LINQ queries to MariaDB in LINQPad.
-
How to Connect to Live Amazon S3 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 Amazon S3 for you.
-
ETL CloudConvert in Oracle Data Integrator
This article shows how to transfer CloudConvert into a data warehouse using Oracle Data Integrator.
-
View Reports on Real-Time CockroachDB Data in Power BI Report Server
Use the CData ODBC Driver for CockroachDB to visualize CockroachDB in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to and Visualize Live Blackbaud FE NXT Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Blackbaud FE NXT.
-
Bidirectional Access to SparkPost Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SparkPost in Filemaker Pro for Mac or Windows.
-
Connect Zendesk Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zendesk using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
A PostgreSQL Interface for Stripe Data (MySQL Remoting via JDBC)
Use the Remoting features of the Stripe JDBC Driver to create a PostgreSQL entry-point for data access.
-
Choosing the Best Method to Connect SendGrid to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SendGrid from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to publish and share Snowflake Data dashboards with Tableau Server
The CData ODBC driver for Snowflake enables you integrate Snowflake into Tableau dashboards.
-
Create SSAS Tabular Models from Twitter Ads Data
How to build a SQL Server Analysis Service Tabular Model from Twitter Ads using CData drivers.
-
Build Salesforce Marketing-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Salesforce Marketing to explore live Salesforce Marketing Data in Cursor to assist with building Salesforce Marketing-powered applications.
-
Create Informatica Mappings From/To a JDBC Data Source for Calendly
Create Calendly data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect to PDFMonkey Data from Spring Boot
Connect to PDFMonkey in a Spring Boot Application using the CData API Driver for JDBC
-
Query Amazon DynamoDB Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Amazon DynamoDB entities in PHP by modeling them as objects.
-
Migrating data from Instagram to Google BigQuery using CData SSIS Components.
Easily push Instagram to Google BigQuery using the CData SSIS Tasks for Instagram and Google BigQuery.
-
Use JayDeBeApi to access Webex Data in Python
Use standard Python scripting and the development environment of your choice to access live Webex.
-
How to publish and share Trello Data dashboards with Tableau Server
The CData ODBC driver for Trello enables you integrate Trello into Tableau dashboards.
-
Use Grok to Talk to Your Dynamics 365 Business Central 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 Dynamics 365 Business Central for you.
-
Build AI Agents with Sybase IQ 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 Sybase IQ through CData Connect AI.
-
Build Demio-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Demio and build web apps with connectivity to live Demio.
-
How to Easily Query Dynamics 365 Business Central Data in OpenOffice Base
Connect to Dynamics 365 Business Central data in OpenOffice Base using the CData ODBC Driver for Dynamics 365 Business Central and generate reports with live data insights.
-
How to Easily Query Quaderno Data in OpenOffice Base
Connect to Quaderno data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to connect Amazon QuickSight to Zoho Books Data
Create a connection to Zoho Books in CData Connect AI and insert Zoho Books into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Informatica Mappings From/To a JDBC Data Source for Elasticsearch
Create Elasticsearch data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
View Reports on Real-Time Spark Data in Power BI Report Server
Use the CData ODBC Driver for Spark to visualize Apache Spark SQL in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Google Sheets Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous Drift Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Drift replication to PostgreSQL.
-
Visualize Clockify Data in Tableau
The CData ODBC driver for Clockify enables you integrate Clockify into Tableau dashboards.
-
Validate Workday Data with QuerySurge
Access and validate Workday in QuerySurge using the CData JDBC Driver.
-
Access JobNimbus Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live JobNimbus from HeidiSQL.
-
Add Demio Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Demio with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Azure Analysis Services Data in CloverDX (formerly CloverETL)
Transfer Azure Analysis Services using the visual workflow in the CloverDX data integration tool.
-
Connect to Cohere Data in HULFT Integrate
Connect to Cohere as a JDBC data source in HULFT Integrate
-
Build a Simple VCL Application for BenchmarkEmail Data
How to build a simple VCL Application to view BenchmarkEmail in RAD Studio using the CData ODBC Driver for BenchmarkEmail.
-
Connect to Act-On Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Act-On.
-
Integrate LibreChat with Live BigQuery Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google BigQuery from within the chat interface.
-
Import SAP Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAP ERP/NetWeaver. In this article, you will use the OData format to import SAP ERP/NetWeaver into Microsoft Power Query.
-
Import Real-Time ScrapingBee Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ScrapingBee in ColdFusion.
-
LINQ to Microsoft Exchange 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 Microsoft Exchange Data Provider.
-
Seamlessly Bring CockroachDB Data into Retool Using CData Connect AI
Integrate CockroachDB data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to connect to Sendwithus Data in DBVisualizer
Integrate Sendwithus with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect to Cohere Data in DBVisualizer
Integrate Cohere with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live Reckon Accounts Hosted Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Reckon Accounts Hosted into the statistical analysis tools available in SAS JMP. This article shows how to use Reckon Accounts Hosted in the Graph Builder and Query Builder.
-
Connect to Live Xero Data in MicroStrategy through CData Connect AI
Create a live connection to Xero Data in CData Connect AI and connect to your Xero Accounting from MicroStrategy.
-
Use Agno to Talk to Your SAP Ariba Procurement Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your SAP Ariba Procurement for you.
-
A PostgreSQL Interface for Vimeo Data using the CData ODBC Driver
Use the SQL Gateway and Vimeo ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to and Visualize Live SAS Data Sets Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAS Data Sets.
-
Build Greenhouse-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Greenhouse Data and create custom apps in Mendix.
-
Access Live eBay Analytics Data in AWS Lambda
Connect to live eBay Analytics in AWS Lambda using the CData JDBC Driver.
-
Query, Visualize, and Share live Monday.com Data in Redash
Use CData Connect AI to connect to live Monday.com in Redash for querying, visualizing, and sharing.
-
Import Real-Time HelloSign Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use HelloSign in ColdFusion.
-
Migrating data from Aha! to Snowflake using CData SSIS Components.
Easily push Aha! to Snowflake using the CData SSIS Tasks for Aha! and Snowflake.
-
How to Connect Elasticsearch 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 Elasticsearch data in real time using natural language.
-
Build Data Flows from Bitly to SQL Server using SSIS
Easily back up Bitly to SQL Server using the SSIS components for Bitly.
-
How to load MYOB AccountRight data into Elasticsearch via Logstash
Introducing a simple method to load MYOB AccountRight data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Deploy the ADO.NET Provider for Outreach.io on an SSRS Report Server
Connect to Outreach.io 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.
-
Build a Simple VCL Application for Oracle HCM Cloud Data
How to build a simple VCL Application to view Oracle HCM Cloud in RAD Studio using the CData ODBC Driver for Oracle HCM Cloud.
-
Integrating LlamaIndex with Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Xero Accounting in real time.
-
Moving Data from Onfleet to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Onfleet data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for MariaDB
Provide connectivity to MariaDB through an SAP BusinessObjects universe.
-
Getting Started with the CData Tableau Connector for HDFS
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for HDFS.
-
Extract, Transform, and Load Instantly Data in Informatica PowerCenter
Create a simple Workflow for Instantly in Informatica PowerCenter.
-
Connect to Facebook Data from HeidiSQL
Use CData Connect AI to connect to and query live Facebook from HeidiSQL.
-
Publish Crystal Reports on SageHR Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SageHR.
-
Working with Outreach.io Data in LINQPad
Execute LINQ queries to Outreach.io in LINQPad.
-
Build Data Flows from PostgreSQL to SQL Server using SSIS
Easily back up PostgreSQL to SQL Server using the SSIS components for PostgreSQL.
-
Publish Klipfolio-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Klipfolio.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP Hybris C4C
Create an ODBC connection to SAP Hybris C4C in Informatica and browse and transfer SAP Hybris C4C.
-
Integrating Boomi Agentstudio with Avalara AvaTax Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Avalara AvaTax, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use Grok to Talk to Your Kintone 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 Kintone for you.
-
Connect Salesforce Data 360 to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Salesforce Data 360 using the CData Python MCP Server.
-
Connect to Dynamics CRM Data from Crystal Reports
Use CData Connect AI to connect to and report on live Microsoft Dynamics CRM from Crystal Reports.
-
Automated Continuous Tickspot Replication to SQLite
Use CData Sync for automated, continuous, customizable Tickspot replication to SQLite.
-
Analyze Figshare Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Figshare in Microsoft R Open.
-
Bidirectional Access to Yelp Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Yelp in Filemaker Pro for Mac or Windows.
-
Getting Started with the CData Tableau Connector for Salesforce Data 360
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Salesforce Data 360.
-
Connect Shopify to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Shopify with IBM WebSphere for seamless data integration and connectivity.
-
Natively Connect to Google Cloud Storage Data in PHP
The CData ODBC driver for Google Cloud Storage enables you to create PHP applications with connectivity to Google Cloud Storage. Leverage the native support for ODBC in PHP.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Procore within intelligent workflows.
-
Integrate Goose with Live Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Atlassian Confluence from within the local AI agent.