CData Software - Knowledge Base
Recent Articles
-
How to connect PolyBase to Snowflake
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Snowflake data.
-
Integrating Gumloop with SingleStore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SingleStore data within automated workflows.
-
Operational Reporting on Bannerbear Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Bannerbear data.
-
Back Up Samanage 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 Samanage data data.
-
Back Up Asana data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Asana. In this article, we will employ an SSIS workflow to populate a database with Asana data data.
-
Integrate Goose with Live Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Google Directory data from within the local AI agent.
-
Connect to API from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from API data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrating Claude Code CLI with Vimeo 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.
-
Integrating Factorial Data in Talend Cloud Data Management Platform
Connect Factorial Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build Semantic Layer Views for Epicor Kinetic Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Epicor Kinetic data.
-
Automated Continuous Neo4J Replication to Oracle
Use CData Sync for automated, continuous, customizable Neo4J replication to Oracle.
-
Connect to ConstantContact Data in JRuby
Create a simple JRuby app with access to live ConstantContact data.
-
Integrate Discord Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Discord data from Informatica Cloud.
-
Integrate Airtable Data into Power Automate Desktop using CData Connect
CData Connect for Airtable Data enables you to integrate Airtable data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Cline with Live Perplexity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Perplexity data from within your IDE.
-
Build an OLAP Cube in SSAS from Instantly Data
Establish a connection to Instantly data data from SQL Server Analysis Services, and use the Instantly Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Live Oracle SCM Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Oracle SCM from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Oracle SCM data.
-
Analyze Opsgenie Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Opsgenie from Power Pivot. You will use the Table Import Wizard to load Opsgenie data. You can visually build the import query or use any SQL supported by the driver.
-
Build Visualizations of Redis Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Redis data in Birst.
-
Model, Search, and Visualize Live SAP SuccessFactors Data in ThoughtSpot
Use CData Connect AI to connect to live SAP SuccessFactors data for modeling, searching, and visualizing.
-
Integrating OneNote Data in Talend Cloud Data Management Platform
Connect OneNote Data with Talend Cloud Data Management Platform using the CData JDBC Driver for OneNote.
-
Access Live Blackbaud FE NXT Data in AWS Lambda
Connect to live Blackbaud FE NXT data in AWS Lambda using the CData JDBC Driver.
-
How to connect to CouchDB Data from Spring Boot
Connect to CouchDB in a Spring Boot Application using the CData JDBC Driver for CouchDB
-
Connect to Greenhouse Data from a Connection Pool in JBoss
Integrate Greenhouse data into Java servlets: Use the Management Console in JBoss to install the Greenhouse JDBC Driver.
-
Getting Started with the CData ODBC Driver for LaunchDarkly
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for LaunchDarkly.
-
Build Yelp-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Yelp Data and create custom apps in Mendix.
-
Build Data Flows from SQL Server to MongoDB through SSIS
Easily push SQL Server data to MongoDB using the CData SSIS Tasks for MongoDB.
-
Integrate XML Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live XML data from Informatica Cloud.
-
Import JSON Services Using Azure Data Factory
Use CData Connect AI to connect to JSON Services from Azure Data Factory and import live JSON services.
-
Publish Crystal Reports on SingleStore Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SingleStore data.
-
Build a Singer.io Tap for PingOne With the CData Python Connector
Learn how to easily build a Singer.io Tap for live PingOne data using the CData Python Connector.
-
Integrate Dify with Live Splunk 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 Splunk data.
-
Build Salesloft-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Salesloft Data from Zoho Analytics and import live Salesloft data.
-
Access Live Testmonitor Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Testmonitor data from your Excel spreadsheets.
-
Validate NASA Data with QuerySurge
Access and validate NASA data in QuerySurge using the CData JDBC Driver.
-
Connect to Adobe Analytics Data in NetBeans
Connect to Adobe Analytics data in NetBeans with the data source configuration wizard.
-
Process & Analyze Raisers Edge NXT Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Raisers Edge NXT Data.
-
Extract, Transform, and Load Hugging Face Data in Informatica PowerCenter
Create a simple Workflow for Hugging Face data in Informatica PowerCenter.
-
Integrate with JotForm Data in JReport Designer
Create charts and reports based on JotForm data in JReport Designer.
-
Automated Continuous MessageBird Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable MessageBird replication to PostgreSQL.
-
Connect to Twilio Data in DBArtisan
Use wizards in DBArtisan to configure Twilio data as a data source.
-
Connect to Salesforce Data 360 Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Salesforce Data 360 Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use ChatGPT to Talk to Your Zoho Inventory 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 Zoho Inventory data for you.
-
Query, Visualize, and Share live Omnisend Data in Redash
Use CData Connect AI to connect to live Omnisend data in Redash for querying, visualizing, and sharing.
-
Integrate Live ZohoPeople Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to ZohoPeople from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live ZohoPeople data.
-
Integrate SQL Analysis Services Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SQL Analysis Services data from Informatica Cloud.
-
Connect to Bright Data from a Connection Pool in WebLogic
Use the CData JDBC Driver for Bright Data to connect to Bright Data data from Web applications running on WebLogic.
-
Automate Google Directory Data Replication to Azure Synapse
Use CData Sync to customize and automate Google Directory data replication to Azure Synapse.
-
Integrate with SendPulse Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SendPulse data to a JSON file on disk.
-
Connect to Browserless Data in RapidMiner
Integrate Browserless data with standard components and data source configuration wizards in RapidMiner Studio.
-
Apify Reporting in OBIEE with the Apify JDBC Driver
Deploy the Apify JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Publish Crystal Reports on Printify Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Printify data.
-
How to Connect the Power BI Service to SFTP: Complete Guide
Connect to the CData Software Power BI Connector for SFTP from PowerBI.com to provide real-time SFTP data across the organization.
-
How to connect to OnePageCrm Data in DBVisualizer
Integrate OnePageCrm data with visual data analysis tools and data connection wizards in DBVisualizer
-
Work with Xero Data in FoxPro
Load Xero data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query Jira Data as a SQL Server Database in Node.js
Execute SQL Server queries against Jira data from Node.js.
-
Publish Google Forms-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Forms data.
-
Build an OLAP Cube in SSAS from Contentful Data
Establish a connection to Contentful data data from SQL Server Analysis Services, and use the Contentful Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize Marketo Data in TIBCO Spotfire through OData
Integrate Marketo data into dashboards in TIBCO Spotfire.
-
Connect to BigCommerce Data in Google Apps Script via Connect AI
Use CData Connect AI to access BigCommerce data in Google Apps Script.
-
Replicate Multiple Acumatica Accounts
Replicate multiple Acumatica accounts to one or many databases.
-
Integrate with Twilio Data in JReport Designer
Create charts and reports based on Twilio data in JReport Designer.
-
Model, Search, and Visualize Live Quickbase Data in ThoughtSpot
Use CData Connect AI to connect to live Quickbase data for modeling, searching, and visualizing.
-
Connect to Discourse Data in CloverDX (formerly CloverETL)
Transfer Discourse data using the visual workflow in the CloverDX data integration tool.
-
Create GitHub-Connected Business Apps in AppSheet
Connect to GitHub Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to GitHub data.
-
Access CircleCI Data from MySQL in PHP
Connect to CircleCI through the standard MySQL libraries in PHP.
-
Integrate Google Campaign Manager 360 Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Campaign Manager 360 data from Informatica Cloud.
-
Automated Continuous YouTube Analytics Replication to IBM DB2
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to IBM DB2.
-
Natively Connect to PabblySubscriptions Data in PHP
The CData ODBC driver for PabblySubscriptions enables you to create PHP applications with connectivity to PabblySubscriptions data. Leverage the native support for ODBC in PHP.
-
Automate OnePageCrm Data Replication to Azure Data Lake
Use CData Sync to customize and automate OnePageCrm data replication to Azure Data Lake.
-
Build a Singer.io Tap for Teradata With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Teradata data using the CData Python Connector.
-
Integrate ZeroBounce Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ZeroBounce data from Informatica Cloud.
-
Integrate with Live BenchmarkEmail Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to BenchmarkEmail from the MuleSoft Anypoint Platform to integrate live BenchmarkEmail data into custom reports and dashboards.
-
Use the CData Software JDBC Driver for Everhour in MicroStrategy
Connect to Everhour data in MicroStrategy Developer using the CData Software JDBC Driver for Everhour.
-
Getting Started with the CData Power BI Connector for SAP BusinessObjects BI
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP BusinessObjects BI.
-
Publish Tickspot-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Tickspot data.
-
Integrate Theia IDE with Live SingleStore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live SingleStore data from within the development environment.
-
Getting Started with the CData Python Connector for Teradata
Learn to install and license the CData Python Connector and configure a connection to live Teradata data.
-
Working with Contentful Data in LINQPad
Execute LINQ queries to Contentful data in LINQPad.
-
Getting Started with the CData Python Connector for Dynamics 365 Business Central
Learn to install and license the CData Python Connector and configure a connection to live Dynamics 365 Business Central data.
-
Query MariaDB Data in DataGrip
Create a Data Source for MariaDB in DataGrip and use SQL to query live MariaDB data.
-
Access Parallel 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 Parallel data.
-
How to Easily Query ZendeskSell Data in OpenOffice Base
Connect to ZendeskSell data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Connect to & Open Perplexity Data in Microsoft Excel
This article uses the CData ODBC driver for Perplexity to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Google Drive Data in Talend Cloud Data Management Platform
Connect Google Drive Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Google Drive.
-
Integrate Open WebUI with Live Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Reckon Accounts Hosted data from within the chat interface.
-
Connect to DocuSign Data from a Connection Pool in JBoss
Integrate DocuSign data into Java servlets: Use the Management Console in JBoss to install the DocuSign JDBC Driver.
-
Build a Simple VCL Application for Templated Data
How to build a simple VCL Application to view Templated data in RAD Studio using the CData ODBC Driver for Templated.
-
Connect and Query Live Pipedrive Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Pipedrive data into Databricks and enable direct, live querying and analysis without replication.
-
Create SAP SuccessFactors-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP SuccessFactors Data from OutSystems and build custom enterprise apps using live SAP SuccessFactors data.
-
DataBind Controls to SAP SuccessFactors LMS Data in C++Builder
DataBind to SAP SuccessFactors LMS data in C++Builder with standard components and controls.
-
Create Datasets from ZeroBounce in Domo Workbench and Build Visualizations of ZeroBounce Data in Domo
Use the CData Software ODBC Driver for ZeroBounce to create datasets from ZeroBounce data in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Goose with Live Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Reckon Accounts Hosted data from within the local AI agent.
-
Access Live Oracle Sales Data in AWS Lambda
Connect to live Oracle Sales data in AWS Lambda using the CData JDBC Driver.
-
How to Visualize Okta Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Okta data in Python.
-
Create Dynamic Salesforce Pardot Grids Using the Infragistics XamDataGrid
Learn how you can connect Salesforce Pardot to Infragistics XamDataGrid to build dynamic grids.
-
Visualize Live Azure Table Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Azure Table data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
A PostgreSQL Interface for PayPal Data using the CData ODBC Driver
Use the SQL Gateway and PayPal ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Codex with Clari 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.
-
Use the CData ODBC Driver for Sage 300 in Microsoft Power Query
You can use the CData Sage 300 ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sage 300 data into Microsoft Power Query.