CData Software - Knowledge Base
Recent Articles
-
Create Power BI Reports on Real-Time SAP Ariba Procurement Data
Use the CData ODBC Driver for SAP Ariba Procurement to visualize SAP Ariba Procurement data in Power BI Desktop.
-
A PostgreSQL Interface for Mocean Data (MySQL Remoting via JDBC)
Use the Remoting features of the Mocean JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Adobe Target Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Adobe Target to connect to Adobe Target data and execute queries in PowerBuilder.
-
Use the CData Software JDBC Driver for Wrike in MicroStrategy
Connect to Wrike data in MicroStrategy Developer using the CData Software JDBC Driver for Wrike.
-
Build a PostgreSQL Interface for Templated Data using the CData JDBC Driver
Use the Remoting features of the Templated JDBC Driver to create a PostgreSQL entry-point for data access.
-
Model, Search, and Visualize Live Yelp Data in ThoughtSpot
Use CData Connect AI to connect to live Yelp data for modeling, searching, and visualizing.
-
Use the CData Software ODBC Driver for Lakebase in MicroStrategy
Connect to Lakebase data in MicroStrategy Developer using the CData Software ODBC Driver for Lakebase.
-
A PostgreSQL Interface for LDAP Objects using the CData ODBC Driver
Use the SQL Gateway and LDAP ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect PolyBase to Unbounce
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Unbounce data.
-
How to connect PolyBase to Intercom
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Intercom data.
-
Visualize Live Templated Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Templated data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use ChatGPT to Talk to Your LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your LinkedIn Ads data for you.
-
Query Live MySQL Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live MySQL data through a conversational interface.
-
Getting Started with the CData ADO.NET Provider for Ontraport
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrate Real-Time Access to Cloudant in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Cloudant data in real time.
-
Use the CData Software ODBC Driver for Mistral AI in MicroStrategy
Connect to Mistral AI data in MicroStrategy Developer using the CData Software ODBC Driver for Mistral AI.
-
Getting Started with the CData SSIS Components for Contentful
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Contentful.
-
Connect to Telegram from Asprova with CData Software ODBC Driver for Telegram
This article shows how to connect faster to Telegram data from Asprova.
-
Replicate Multiple MessageBird Accounts via the CData Sync CLI
Replicate multiple MessageBird accounts to one or many databases.
-
Build Stripe-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Stripe Data and create custom apps in Mendix.
-
Migrating data from CSV to Snowflake using CData SSIS Components.
Easily push CSV data to Snowflake using the CData SSIS Tasks for CSV and Snowflake.
-
Getting Started with the CData Power BI Connector for Sentry
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Use the CData Software ODBC Driver for Cassandra in SAS for Real-Time Reporting and Analytics
Connect to real-time Cassandra data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Cassandra.
-
Getting Started with the CData JDBC Driver for Anaplan
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Anaplan.
-
Build Dashboards with ChartMogul Data in DBxtra
Create dynamic dashboards and perform analytics based on ChartMogul data in DBxtra.
-
How to Connect to Live Freshdesk Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Freshdesk data without replication.
-
How to connect SharePoint with Oracle Eloqua Data through external lists
Provide Oracle Eloqua data to SharePoint users as an external list.
-
Integrate SQL Analysis Services Data in the Pentaho Report Designer
Publish reports based on SQL Analysis Services data in the Pentaho BI tool.
-
Moving Data from Zoho CRM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Zoho CRM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use the CData SSIS Components to Insert New or Update Existing Bitbucket Records from SQL Server
Easily push SQL Server data to Bitbucket using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Bitbucket or update existing records with data from a SQL Server database.
-
Build SharePoint-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SharePoint data and build SharePoint-connected web apps with Axios.
-
Use Agno to Talk to Your Google Spanner 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 Google Spanner data for you.
-
Integrating Dataiku with ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live ActiveCampaign data.
-
Replicate DocuSign Data to Multiple Databases
Replicate DocuSign data to disparate databases with a point-and-click configuration.
-
How to load YouTube Analytics data into Elasticsearch via Logstash
Introducing a simple method to load YouTube Analytics data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query CSV Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume CSV entities in PHP by modeling them as objects.
-
Visualize Stripe Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Stripe data into TIBCO Spotfire.
-
Connect to Shopify Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Shopify data in the Denodo Virtual DataPort Administrator.
-
Provide OData Services of SendPulse Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SendPulse data by developing a WCF Service Application.
-
Build Data Flows from Epicor Kinetic to SQL Server using SSIS
Easily back up Epicor Kinetic data to SQL Server using the SSIS components for Epicor Kinetic.
-
Create Tally-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Tally Data from Klipfolio and build custom visualizations using live Tally data.
-
Add Google Analytics Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Analytics with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build MVC Applications with Connectivity to Simplesat Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Simplesat from an ASP.NET MVC application.
-
Connect to Supabase Data in NetBeans
Connect to Supabase data in NetBeans with the data source configuration wizard.
-
Connect to and Query Mode Data in QlikView over ODBC
Create data visualizations with Mode data in QlikView.
-
Use CData Connect AI to Access Google Analytics Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Analytics data in the Power Pivot business intelligence tool.
-
Use Grok to Talk to Your Phoenix 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 Phoenix data for you.
-
Connect to IBM Informix Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time IBM Informix data using standard SQL.
-
Connecting Pipedream with QuickBooks 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 QuickBooks data in real time.
-
Connect to Quickbase Data from a Connection Pool in Jetty
The Quickbase JDBC Driver supports connection pooling: This article shows how to connect faster to Quickbase data from Web apps in Jetty.
-
Integrate Acumatica Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Acumatica data and integrate live Acumatica data into your Power Automate tasks.
-
DataBind Controls to SAP HANA Data in Delphi
DataBind to SAP HANA data in Delphi with standard data access components and controls.
-
Replicate Multiple Jira Accounts via the CData Sync CLI
Replicate multiple Jira accounts to one or many databases.
-
Connect to Smartsheet Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Smartsheet data.
-
Connect ZohoExpense to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ZohoExpense with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Google Cloud Storage Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Google Cloud Storage data.
-
How to connect and process GetResponse data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live GetResponse data.
-
Use the CData Software ODBC Driver for ChargeOver in MicroStrategy Desktop
Connect to ChargeOver data in MicroStrategy Desktop using the CData Software ODBC Driver for ChargeOver.
-
Automated Continuous Quaderno Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Quaderno replication to IBM DB2.
-
Query XML Data as a SQL Server Database in Node.js
Execute SQL Server queries against XML data from Node.js.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Wistia
Provide connectivity to Wistia data through an SAP BusinessObjects universe.
-
Connect to Campaigner Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Campaigner and the SQL Gateway to access Campaigner data from Google Apps Script.
-
Connect to SQL Server Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to SQL Server.
-
Automated Continuous Vertica Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Vertica replication to Google BigQuery.
-
Connect to GraphQL Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time GraphQL data using standard SQL.
-
Automated Continuous Clari Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Clari replication to IBM DB2.
-
How to Query Splunk Data in MySQL Workbench
Execute MySQL queries against live Splunk data from MySQL Workbench.
-
Integrate OpenCode with Live CSV Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live CSV data from within your AI coding agent.
-
Query Pingdom Data in DataGrip
Create a Data Source for Pingdom in DataGrip and use SQL to query live Pingdom data.
-
Connect to ZohoMarketingHub 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 ZohoMarketingHub and work with ZohoMarketingHub data in your FileMaker application.
-
Build Semantic Layer Views for Oracle Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Oracle data.
-
Access Notion 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 Notion data.
-
Automated Continuous Invoiced Replication to Snowflake
Use CData Sync for automated, continuous, customizable Invoiced replication to Snowflake.
-
Create SSAS Tabular Models from Flowlu Data
How to build a SQL Server Analysis Service Tabular Model from Flowlu data using CData drivers.
-
Connect to Quickbase from Asprova with CData Software ODBC Driver for Quickbase
This article shows how to connect faster to Quickbase data from Asprova.
-
Connect to Google Contacts Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Google Contacts.
-
How to Build an ETL App for Zoho Inventory Data in Python with CData
Create ETL applications and real-time data pipelines for Zoho Inventory data in Python with petl.
-
Use the CData Software JDBC Driver for LightSpeedRetail in MicroStrategy Web
Connect to LightSpeedRetail data in MicroStrategy Web using the CData Software JDBC Driver for LightSpeedRetail.
-
Create Informatica Mappings From/To an ODBC Data Source for Optimizely
Create an ODBC connection to Optimizely in Informatica and browse and transfer Optimizely data.
-
Configure the CData JDBC Driver for Ontraport in a Connection Pool in Tomcat
Connect to Ontraport data from a connection pool in Tomcat.
-
Integrate with Optimizely Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Optimizely data in SnapLogic.
-
Connect to Factorial Data from a Connection Pool in JBoss
Integrate Factorial data into Java servlets: Use the Management Console in JBoss to install the Factorial JDBC Driver.
-
Connect to Microsoft Entra ID Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Microsoft Entra ID as an External Source in Dremio.
-
Query HubSpot Data as a MySQL Database in Node.js
Execute MySQL queries against HubSpot data from Node.js.
-
Operational Reporting on Clockify Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Clockify data.
-
Design BIRT Reports on Demio Data
Provide current Demio data to your embedded analytics.
-
Create Facebook Ads-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Facebook Ads Data from Klipfolio and build custom visualizations using live Facebook Ads data.
-
Import Avalara AvaTax Data Using Azure Data Factory
Use CData Connect AI to connect to Avalara AvaTax Data from Azure Data Factory and import live Avalara AvaTax data.
-
Integrate Quaderno with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Quaderno with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Quaderno data.
-
Getting Started with the CData Excel Add-In for GitHub
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for GitHub.
-
Connect to ZohoSubscriptions Data in NetBeans
Connect to ZohoSubscriptions data in NetBeans with the data source configuration wizard.
-
Access Live Shippo Data in AWS Lambda
Connect to live Shippo data in AWS Lambda using the CData JDBC Driver.
-
A PostgreSQL Interface for ShipStation Data (MySQL Remoting via JDBC)
Use the Remoting features of the ShipStation JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live SharePoint Data in the Power BI Service
Use CData Connect AI to connect to live SharePoint data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Jira Assets Data in DataGrip
Create a Data Source for Jira Assets in DataGrip and use SQL to query live Jira Assets data.
-
Analyze Live Avro Data in SAS Viya
Use CData Connect AI to connect to Avro data from SAS Viya and deploy self-service analytics using live Avro data.
-
Connect to Printful Data from a Connection Pool in JBoss
Integrate Printful data into Java servlets: Use the Management Console in JBoss to install the Printful JDBC Driver.
-
Interact with Live Twilio Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Twilio data.
-
Replicate SAP SuccessFactors Data to Multiple Databases via the CData Sync CLI
Replicate SAP SuccessFactors data to disparate databases with a single configuration.
-
How to create an RPA flow for Landbot Data in UiPath Studio
Use the Landbot ODBC Driver to create workflows that access real-time Landbot data without any coding.