CData Software - Knowledge Base
Recent Articles
-
Integrate Mode Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Mode from Informatica Cloud.
-
Build Voice Agents in ElevenLabs with access to Live SurveyMonkey Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SurveyMonkey.
-
Back Up Bugsnag 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 Bugsnag data.
-
Integrate Theia IDE with Live LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to create Visio diagrams from Wave Financial Data
Automatically update Wave Financial with the changes you make to Visio master shapes.
-
Easily Integrate SageHR Data in Lazarus Pascal IDE
Learn how to easily integrate live SageHR in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Dynamic Amazon DynamoDB Grids Using the Infragistics XamDataGrid
Learn how you can connect Amazon DynamoDB to Infragistics XamDataGrid to build dynamic grids.
-
Integrating LlamaIndex with FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on FHIR in real time.
-
Visualize JSON Services in TIBCO Spotfire through OData
Integrate JSON into dashboards in TIBCO Spotfire.
-
Visualize SAP HANA Data in TIBCO Spotfire through OData
Integrate SAP HANA into dashboards in TIBCO Spotfire.
-
Integrate Miro Data in Pentaho Data Integration
Build ETL pipelines based on Miro in the Pentaho Data Integration tool.
-
Connect to FreshBooks Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for FreshBooks in the Denodo Virtual DataPort Administrator.
-
Use the CData Software ODBC Driver for Zoho Recruit in SAS for Real-Time Reporting and Analytics
Connect to real-time Zoho Recruit in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Zoho Recruit.
-
Replicate Egnyte Data to Multiple Databases via the CData Sync CLI
Replicate Egnyte to disparate databases with a single configuration.
-
How to update Klaviyo from Excel
This article explains how to transfer data from Excel to Klaviyo using the Excel Add-In for Klaviyo.
-
Access Live Phoenix Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache Phoenix from your Excel spreadsheets.
-
Automate PolarTeamPro Integration Tasks from PowerShell
Are you in search of a quick and easy way to access PolarTeamPro from PowerShell? This article demonstrates how to utilize the PolarTeamPro Cmdlets for tasks like connecting to PolarTeamPro, automating operations, downloading data, and more.
-
Use the CData Software ODBC Driver for Printful in SAS for Real-Time Reporting and Analytics
Connect to real-time Printful in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Printful.
-
Build Gmail-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Gmail to explore live Gmail Data in Gemini Code Assist to assist with building Gmail-powered applications.
-
Build Dashboards with Marketo Data in DBxtra
Create dynamic dashboards and perform analytics based on Marketo in DBxtra.
-
Use the CData Software JDBC Driver for HelloSign in MicroStrategy Web
Connect to HelloSign in MicroStrategy Web using the CData Software JDBC Driver for HelloSign.
-
Integrate LibreChat with Live Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Trello from within the chat interface.
-
Publish SAP Netweaver Gateway-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP Netweaver Gateway.
-
Azure Synapse Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Azure Synapse through CData Connect AI using different applications and tools.
-
How to Create Power BI Visual Reports with Real-Time Datadog Data
Use CData Power BI Connectors to visualize Datadog in Power BI.
-
Getting Started with the CData ODBC Driver for Cosmos DB
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Cosmos DB.
-
Connect to MariaDB Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for MariaDB Data and connect to MariaDB in Akorbi Digital RunMyProcess.
-
Migrating data from Pinterest to Google BigQuery using CData SSIS Components.
Easily push Pinterest to Google BigQuery using the CData SSIS Tasks for Pinterest and Google BigQuery.
-
Automated Continuous Sendwithus Replication to Databricks
Use CData Sync for automated, continuous, customizable Sendwithus replication to Databricks.
-
Connect to Aweber Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Aweber and work with Aweber in your FileMaker applications.
-
Connect to Bitly Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Bitly as an External Source in Dremio.
-
Integrating LlamaIndex with SQL Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SQL Analysis Services in real time.
-
Integrate Invoiced Data in Pentaho Data Integration
Build ETL pipelines based on Invoiced in the Pentaho Data Integration tool.
-
How to Connect DBeaver to EnterpriseDB via a JDBC Driver
Manage EnterpriseDB with visual tools in DBeaver like the query browser.
-
Build Voice Agents in ElevenLabs with access to Live Spark Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Apache Spark SQL.
-
Access Live Amazon Marketplace Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Amazon Marketplace from your Google Sheets.
-
Automated Continuous Sage 200 Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Sage 200 replication to OneLake in Microsoft Fabric.
-
Build Dashboards with Sage 300 Data in DBxtra
Create dynamic dashboards and perform analytics based on Sage 300 in DBxtra.
-
Access Live SAP BusinessObjects BI Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP BusinessObjects BI from your Excel spreadsheets.
-
Build Apps with Live ChartMogul Data Using the Low-Code Development Platform of Mendix
Connect ChartMogul with Mendix to build apps using the CData API Driver for JDBC.
-
Access Live JSON Services in TIBCO Data Virtualization
Use the JSON Tibco DV Adapter to create a JSON data source in TIBCO Data Virtualization Studio and gain access to live JSON from your TDV Server.
-
Create SSAS Tabular Models from EmailOctopus Data
How to build a SQL Server Analysis Service Tabular Model from EmailOctopus using CData drivers.
-
Build Automated Google Campaign Manager 360-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Campaign Manager 360 and build automated workflows in Zapier.
-
Migrating data from Auth0 to Snowflake using CData SSIS Components.
Easily push Auth0 to Snowflake using the CData SSIS Tasks for Auth0 and Snowflake.
-
Analyze Google Cloud Storage Data in Looker
Use CData Connect AI to connect to Google Cloud Storage Data from Looker and build custom apps using live Google Cloud Storage.
-
Build Data Flows from ClickUp to SQL Server using SSIS
Easily back up ClickUp to SQL Server using the SSIS components for ClickUp.
-
Integrating OpenCode Terminal with HDFS 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.
-
Automated Continuous LeadDesk Replication to MySQL
Use CData Sync for automated, continuous, customizable LeadDesk replication to MySQL.
-
Import and Visualize Google Spanner Data in Power View
Create data visualizations based on Google Spanner in Excel.
-
Build EnterpriseDB-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for EnterpriseDB to explore live EnterpriseDB Data in Cursor to assist with building EnterpriseDB-powered applications.
-
Connect to Exact Online Data in Ruby
Connect to Exact Online in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Establish a Live Connection with ClickTime Data using Tableau Bridge
The CData ODBC Driver for ClickTime enables you to integrate live ClickTime into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Lakebase Replication to Snowflake
Use CData Sync for automated, continuous, customizable Lakebase replication to Snowflake.
-
Connect to Salesforce Pardot Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Salesforce Pardot Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
LINQ to Gorgias 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 Gorgias Data Provider.
-
Build an OLAP Cube in SSAS from Postmark Data
Establish a connection to Postmark data from SQL Server Analysis Services, and use the Postmark Data Provider to build OLAP cubes for use in analytics and reporting.
-
Feed Anaplan Data into FineReport
How to set Anaplan as a JDBC data source in FineReport.
-
Excel Spreadsheet Automation on Datadog Data with the QUERY Formula
Pull data from Datadog, automate spreadsheets, and more with the QUERY formula.
-
Analyze Azure Synapse Data in Looker
Use CData Connect AI to connect to Azure Synapse Data from Looker and build custom apps using live Azure Synapse.
-
Query Workable Data as a MySQL Database in Node.js
Execute MySQL queries against Workable from Node.js.
-
Connect Oracle Eloqua Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Oracle Eloqua using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Rebilly Data in DBeaver
Use the CData ODBC Driver to connect to Rebilly in DBeaver.
-
Automated Continuous Retently Replication to Snowflake
Use CData Sync for automated, continuous, customizable Retently replication to Snowflake.
-
Integrating Claude Code CLI with Nuclia 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.
-
Analyze Zoho Creator Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Zoho Creator and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Google Tasks Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Tasks facts in real time.
-
Add LinkedIn Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for LinkedIn with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Live Google Campaign Manager 360 Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Campaigner Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Campaigner facts in real time.
-
How to connect to Mailjet Data in DBVisualizer
Integrate Mailjet with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Datasets from Freshsales in Domo Workbench and Build Visualizations of Freshsales Data in Domo
Use the CData Software ODBC Driver for Freshsales to create datasets from Freshsales in Domo Workbench and then build visualizations in the Domo service.
-
Visualize ShipEngine Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ShipEngine.
-
Getting Started with the CData JDBC Driver for Twilio
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Twilio.
-
A PostgreSQL Interface for Gorgias Data using the CData ODBC Driver
Use the SQL Gateway and Gorgias ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect and Visualize Live Sage Intacct Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Sage Intacct into the Databricks platform and create visualization dashboards with real-time Sage Intacct.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Office 365
Provide connectivity to Microsoft Office 365 through an SAP BusinessObjects universe.
-
Integrate with Dropbox Data in JReport Designer
Create charts and reports based on Dropbox in JReport Designer.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SingleStore to Power BI dashboards. Simply drag and drop SingleStore into data visuals on the Power BI canvas.
-
Moving Data from Asana to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Asana data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build AlloyDB-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for AlloyDB to explore live AlloyDB Data in GitHub Copilot to assist with building AlloyDB-powered applications.
-
Visualize Live Shopify Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Shopify using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Claude Code CLI with Avaza 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.
-
Working with CloudConvert Data in LINQPad
Execute LINQ queries to CloudConvert in LINQPad.
-
How to Connect to Live Trello Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Trello without replication.
-
Manage Salesloft Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Salesloft.
-
Integrate Email Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Email from Informatica Cloud.
-
Integrate Telegram Data in Pentaho Data Integration
Build ETL pipelines based on Telegram in the Pentaho Data Integration tool.
-
Working with Azure Data Lake Storage Data in LINQPad
Execute LINQ queries to Azure Data Lake Storage in LINQPad.
-
Connect to Egnyte Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Egnyte to connect to Egnyte and execute queries in PowerBuilder.
-
Work with Live Jira Data in Power Query
Use CData Connect AI to connect to Atlassian Jira and work with live Atlassian Jira in Microsoft Power Query.
-
Getting Started with the CData ODBC Driver for Power BI XMLA
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Power BI XMLA.
-
Use the CData ODBC Driver for Omnisend from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Omnisend to connect to Omnisend from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Omnisend in Excel.
-
Connect to Landbot Data in HULFT Integrate
Connect to Landbot as a JDBC data source in HULFT Integrate
-
Access Moosend Data from MySQL in PHP
Connect to Moosend through the standard MySQL libraries in PHP.
-
Connect to SageHR Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SageHR to connect to SageHR and execute queries in PowerBuilder.
-
Integrating GitHub Copilot CLI with Microsoft Teams 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.
-
Create Informatica Mappings From/To an ODBC Data Source for MongoDB
Create an ODBC connection to MongoDB in Informatica and browse and transfer MongoDB.
-
Connect to Greenhouse Data from AWS Glue
Use CData Connect AI to gain access to live Greenhouse from your AWS Glue jobs.
-
Automated Continuous Google Ad Manager Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Snowflake.
-
Getting Started with the CData JDBC Driver for HDFS
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for HDFS.