CData Software - Knowledge Base
Recent Articles
-
How to Connect DBeaver to Parallel via a JDBC Driver
Manage Parallel with visual tools in DBeaver like the query browser.
-
Connect to SingleStore Data from Crystal Reports
Use CData Connect AI to connect to and report on live SingleStore from Crystal Reports.
-
Explore Geographical Relationships in Anaplan Data with Power Map
Create data visualizations with Anaplan in Power Map.
-
Gumroad Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Gumroad facts in real time.
-
Back Up SendPulse 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 SendPulse data.
-
Consume FTP OData Feeds in PowerBuilder
This article demonstrates how to consume FTP Servers as OData feeds from PowerBuilder using the API Server.
-
Use Claude to Talk to Your Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Basecamp for you.
-
Using the CData Software ODBC Driver for Google Campaign Manager 360 in PyCharm
Connect to Google Campaign Manager 360 as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Campaign Manager 360.
-
Automate Oracle HCM Cloud Data Replication to Azure Synapse
Use CData Sync to customize and automate Oracle HCM Cloud replication to Azure Synapse.
-
Create Dashboards and Visualize Live Oracle Sales Data in Geckoboard
Use CData Connect AI to connect to live Oracle Sales and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed MYOB AccountRight to Power BI dashboards. Simply drag and drop MYOB AccountRight into data visuals on the Power BI canvas.
-
How to publish and share HelloSign Data dashboards with Tableau Server
The CData ODBC driver for HelloSign enables you integrate HelloSign into Tableau dashboards.
-
Getting Started with the CData Power BI Connector for SAP Ariba Source
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP Ariba Source.
-
Automated Continuous Billsby Replication to MongoDB
Use CData Sync for automated, continuous, customizable Billsby replication to MongoDB.
-
Integrating OpenCode Terminal with ConvertKit 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.
-
Integrate Theia IDE with Live SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to CSV Data in Ruby
Connect to CSV/TSV Files in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Databricks: Option to Disable SELECT version() Execution
Learn how to disable the execution of SELECT version() in Databricks to improve performance and avoid unnecessary queries.
-
How to Connect the Power BI Service to Azure Data Catalog: Complete Guide
Connect to the CData Software Power BI Connector for Azure Data Catalog from PowerBI.com to provide real-time Azure Data Catalog across the organization.
-
Integrate Pinecone with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Pinecone with External Services.
-
Integrating GitHub Copilot CLI with Sendwithus 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.
-
How to Access Live Square Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Square enables you to integrate Square into workflows built using Microsoft Power Automate Desktop.
-
Access Basecamp 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 Basecamp.
-
ETL Egnyte in Oracle Data Integrator
This article shows how to transfer Egnyte into a data warehouse using Oracle Data Integrator.
-
Build a Singer.io Tap for Salesforce CRM Analytics With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Salesforce CRM Analytics data using
-
Use the CData API Server to Access Cloudflare Data in Microsoft PowerPivot
Use the CData API Server to connect to live Cloudflare in the Power Pivot business intelligence tool.
-
How to use SQLAlchemy ORM to access Avaza Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Avaza.
-
Build MVC Applications with Connectivity to Epicor Kinetic Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Epicor Kinetic from an ASP.NET MVC application.
-
Build Semantic Layer Views for MongoDB Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for MongoDB.
-
Create Dynamic Sage 200 Grids Using the Infragistics XamDataGrid
Learn how you can connect Sage 200 to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Oracle HCM Cloud Data from HeidiSQL
Use CData Connect AI to connect to and query live Oracle HCM Cloud from HeidiSQL.
-
Use the CData Software JDBC Driver for Postmark in MicroStrategy
Connect to Postmark in MicroStrategy Developer using the CData Software JDBC Driver for Postmark.
-
Use Databricks Agent Bricks to Talk to Your NetSuite SuiteAnalytics Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your NetSuite SuiteAnalytics for you.
-
Automate Confluence Data Replication to SAP HANA
Use CData Sync to customize and automate Atlassian Confluence replication to SAP HANA.
-
Connect to Adobe Experience Manager Data in NetBeans
Connect to Adobe Experience Manager in NetBeans with the data source configuration wizard.
-
Visualize SAP Ariba Procurement Data in TIBCO Spotfire through ADO.NET
Integrate SAP Ariba Procurement into dashboards in TIBCO Spotfire.
-
How to Query Live LightSpeedRetail Data in Claude Desktop
Connect to and query live LightSpeedRetail Data in Claude Desktop using CData MCP Server.
-
Use the CData Software JDBC Driver for Impala in MicroStrategy Desktop
Connect to Apache Impala in MicroStrategy Desktop using the CData Software JDBC Driver for Impala.
-
Visualize MYOB AccountRight Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MYOB AccountRight.
-
Getting Started with the CData Python Connector for Missive
Learn to install and license the CData Python Connector
-
Query Box Data as a SQL Server Database in Node.js
Execute SQL Server queries against Box from Node.js.
-
Use Databricks Agent Bricks to Talk to Your Raisers Edge NXT Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Raisers Edge NXT for you.
-
Access Live Dropbox Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Dropbox in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Natively Connect to WordPress Data in PHP
The CData ODBC driver for WordPress enables you to create PHP applications with connectivity to WordPress. Leverage the native support for ODBC in PHP.
-
Connect Bright Data Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Bright Data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to PostgreSQL from Asprova with CData Software ODBC Driver for PostgreSQL
This article shows how to connect faster to PostgreSQL data from Asprova.
-
Connect to Adobe Target Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Adobe Target as an External Source in Dremio.
-
Configure the CData JDBC Driver for Samanage in a Connection Pool in Tomcat
Connect to Samanage from a connection pool in Tomcat.
-
Import SAP SuccessFactors Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAP SuccessFactors. In this article, you will use the OData format to import SAP SuccessFactors into Microsoft Power Query.
-
Viewing Cohere Data in RAD Studio Data Explorer
How to view Cohere in RAD Studio Data Explorer using the CData ODBC Driver for Cohere.
-
How to integrate Instagram with Apache Airflow
Access and process Instagram in Apache Airflow using the CData JDBC Driver.
-
A PostgreSQL Interface for Spark Data (MySQL Remoting via JDBC)
Use the Remoting features of the Spark JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to integrate Metabase with Azure Analysis Services Data
Use CData Connect AI to connect to live Azure Analysis Services and create an interactive dashboard in Metabase from Azure Analysis Services.
-
LINQ to Phoenix 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 Phoenix Data Provider.
-
Integrate ZohoMarketingHub Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ZohoMarketingHub from Informatica Cloud.
-
Getting Started with the CData Python Connector for Customer.io
Learn to install and license the CData Python Connector
-
A PostgreSQL Interface for Jumpseller Data (MySQL Remoting via JDBC)
Use the Remoting features of the Jumpseller JDBC Driver to create a PostgreSQL entry-point for data access.
-
Enable the ZohoDesk JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ZohoDesk.
-
Getting Started with the CData Tableau Connector for Wave Financial
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Wave Financial.
-
Create Datasets from REST in Domo Workbench and Build Visualizations of REST Data in Domo
Use the CData Software ODBC Driver for REST to create datasets from REST in Domo Workbench and then build visualizations in the Domo service.
-
Provide OData Services of Oracle Financials Cloud Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Oracle Financials Cloud by developing a WCF Service Application.
-
Access Live Gong Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Gong from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use the CData Software ODBC Driver for IBM Cloud Object Storage in MicroStrategy
Connect to IBM Cloud Object Storage in MicroStrategy Developer using the CData Software ODBC Driver for IBM Cloud Object Storage.
-
Replicate Oracle Data to Multiple Databases
Replicate Oracle Database to disparate databases with a point-and-click configuration.
-
How to Design SAP Hybris C4C Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to SAP Hybris C4C from mobile and tablet Power Apps.
-
Connect to Salesforce CRM Analytics Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Salesforce CRM Analytics as an External Source in Dremio.
-
Prepare, Blend, and Analyze Postmark Data in Alteryx Designer (ODBC)
Build workflows to access live Postmark for self-service data analytics.
-
How to connect to Twilio Data in DBVisualizer
Integrate Twilio with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Avalara AvaTax Data from MySQL in PHP
Connect to Avalara AvaTax through the standard MySQL libraries in PHP.
-
Build Dashboards with Azure Analysis Services Data in DBxtra
Create dynamic dashboards and perform analytics based on Azure Analysis Services in DBxtra.
-
Hive Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Hive facts in real time.
-
How to Query Live LaunchDarkly Data in Perplexity MacOS Desktop
Connect to and query live LaunchDarkly Data in Perplexity Desktop using CData MCP Server.
-
Create Kintone-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Kintone Data from Klipfolio and build custom visualizations using live Kintone.
-
Create Informatica Mappings From/To a JDBC Data Source for Mailjet
Create Mailjet data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize Campaigner Data in TIBCO Spotfire through ADO.NET
Integrate Campaigner into dashboards in TIBCO Spotfire.
-
Build AI Agents with Shopify 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 Shopify through CData Connect AI.
-
Write a Simple Go Application to work with Webflow Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Webflow.
-
Automate Couchbase Data Replication to Azure Data Lake
Use CData Sync to customize and automate Couchbase replication to Azure Data Lake.
-
How to Design Cloudant Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Cloudant from mobile and tablet Power Apps.
-
Use the CData ODBC Driver for Anaplan in Microsoft Power Query
You can use the CData Anaplan ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Anaplan into Microsoft Power Query.
-
Connect to MYOB AccountRight Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with MYOB AccountRight Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build an OLAP Cube in SSAS from SparkPost Data
Establish a connection to SparkPost data from SQL Server Analysis Services, and use the SparkPost Data Provider to build OLAP cubes for use in analytics and reporting.
-
Viewing Jodoo Data in RAD Studio Data Explorer
How to view Jodoo in RAD Studio Data Explorer using the CData ODBC Driver for Jodoo.
-
Rapidly Develop QuickBooks-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 QuickBooks.
-
Build Google Directory-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Directory Data and create custom apps in Mendix.
-
Use Claude to Talk to Your eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your eBay for you.
-
How to connect and process Google AlloyDB from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google AlloyDB.
-
Integrating Cursor CLI with eBay 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.
-
ETL BenchmarkEmail in Oracle Data Integrator
This article shows how to transfer BenchmarkEmail into a data warehouse using Oracle Data Integrator.
-
Access Live FreshBooks Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate FreshBooks into the statistical analysis tools available in SAS JMP. This article shows how to use FreshBooks in the Graph Builder and Query Builder.
-
How to connect to Qualaroo Data with Squirrel SQL client
Connect to Qualaroo and execute queries in the Squirrel SQL Client.
-
Analyze Productboard Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Productboard and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Tickspot Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Tickspot.
-
Add Microsoft Exchange Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Microsoft Exchange with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate with Live Airtable Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Airtable from the MuleSoft Anypoint Platform to integrate live Airtable into custom reports and dashboards.
-
How to Query Live ZohoInvoice Data in Perplexity MacOS Desktop
Connect to and query live ZohoInvoice Data in Perplexity Desktop using CData MCP Server.
-
How to Import Data from Google Search into Google Sheets
Import Google Search into a Google spreadsheet that is automatically refreshed.
-
How to Connect to Live Klaviyo 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 Klaviyo through natural language.
-
Integrate Real-Time Access to Sendwithus in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Sendwithus in real time.
-
Build AI/ML Models with Live ZohoExpense Data using Dataiku
Connect ZohoExpense Data with Dataiku using the CData API Driver for JDBC.