CData Software - Knowledge Base
Recent Articles
-
Integrate Live Box Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Box from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Box.
-
How to use SQLAlchemy ORM to access Nethunt Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Nethunt.
-
Manage SAP Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP.
-
Query Oracle Data in DataGrip
Create a Data Source for Oracle in DataGrip and use SQL to query live Oracle Database.
-
Seamlessly Bring Adobe Commerce Data into Retool Using CData Connect AI
Integrate Adobe Commerce data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Building Dynamic Web Pages with DB2 Data Using AngularJS
Create single-page applications with live connectivity to DB2 using the CData API Server.
-
Connect to LDAP in SpagoBI
Create reports featuring live LDAP in SpagoBI Studio. Host LDAP reports on SpagoBI Server.
-
Automate eBay Data Replication to Azure Data Lake
Use CData Sync to customize and automate eBay replication to Azure Data Lake.
-
Build Bitbucket-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Bitbucket to explore live Bitbucket Data in Cursor to assist with building Bitbucket-powered applications.
-
Configure the CData JDBC Driver for Discourse in a Connection Pool in Tomcat
Connect to Discourse from a connection pool in Tomcat.
-
Integrating LlamaIndex with SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAS XPORT in real time.
-
Enable the Amazon Marketplace JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Amazon Marketplace.
-
Stream Odoo Data into Apache Kafka Topics
Access and stream Odoo ERP in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create SurveyMonkey-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SurveyMonkey Data from OutSystems and build custom enterprise apps using live SurveyMonkey.
-
Bridge Google Analytics Connectivity with Apache NiFi
Access and process Google Analytics in Apache NiFi using the CData JDBC Driver.
-
Replicate Freshsales Data to Multiple Databases
Replicate Freshsales to disparate databases with a point-and-click configuration.
-
How to Import Data from SQL Server into Google Sheets
Import Microsoft SQL Server into a Google spreadsheet that is automatically refreshed.
-
Integrating Antigravity CLI with Snowflake via CData CLI
Connect Snowflake to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Apps with Live Square Data Using the Low-Code Development Platform of Mendix
Connect Square with Mendix to build apps using the CData JDBC Driver for Square.
-
How to use SQLAlchemy ORM to access GitLab Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of GitLab.
-
Use CData Connect AI to Access SAP Concur Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP Concur in the Power Pivot business intelligence tool.
-
Integrate Productboard Data in Pentaho Data Integration
Build ETL pipelines based on Productboard in the Pentaho Data Integration tool.
-
Connect to and Query Ontraport Data in QlikView over ODBC
Create data visualizations with Ontraport in QlikView.
-
Integrate with live OneNote Data in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft OneNote in Jitterbit.
-
Connect to JSON Services in Google Apps Script via SQL Gateway
Use the ODBC Driver for JSON and the SQL Gateway to access JSON from Google Apps Script.
-
Visualize Live Google Sheets Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Sheets using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous PayPal Replication to Vertica
Use CData Sync for automated, continuous, customizable PayPal replication to Vertica.
-
Connect Exact Online to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Exact Online using the CData Python MCP Server.
-
Choosing the Best Method to Connect eBay to SQL Server: 5 Options Explained
Discover multiple ways to connect and use eBay from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
A PostgreSQL Interface for Azure Analysis Services Data using the CData ODBC Driver
Use the SQL Gateway and Azure Analysis Services ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous ActiveCampaign Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to PostgreSQL.
-
Use the CData Software JDBC Driver for OnePageCrm in MicroStrategy
Connect to OnePageCrm in MicroStrategy Developer using the CData Software JDBC Driver for OnePageCrm.
-
How to Work with Google Translate Data in ETL Validator JDBC
Connect to Google Translate from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData ADO.NET Provider for Paddle
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Tavily from Asprova with CData Software ODBC Driver for Tavily
This article shows how to connect faster to Tavily data from Asprova.
-
Access SingleStore Data from MySQL in PHP
Connect to SingleStore through the standard MySQL libraries in PHP.
-
Getting Started with the CData Power BI Connector for Foursquare
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to load SAP Hybris C4C data into Elasticsearch via Logstash
Introducing a simple method to load SAP Hybris C4C data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Seamlessly Bring Oracle Service Cloud Data into Retool Using CData Connect AI
Integrate Oracle Service Cloud data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Visualize MongoDB Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MongoDB.
-
How to Visualize SAP HANA XS Advanced Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP HANA XS Advanced in Python.
-
LINQ to Azure Table 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 Azure Table Data Provider.
-
Integrating Codex CLI with Insightly 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.
-
Visualize Scrapfly Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Scrapfly.
-
Automated Continuous Zoho Projects Replication to Snowflake
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Snowflake.
-
Integrate CampaignMonitor Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live CampaignMonitor from Informatica Cloud.
-
Build Zoom Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Zoom and build visualizations in Tableau Cloud.
-
How to Access Supabase Data Using Entity Framework
This article shows how to access Supabase using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Visualize Planio Data in Sisense
Create an ElastiCube in Sisense app with access to Planio.
-
Create Informatica Mappings From/To a JDBC Data Source for Sage 200
Create Sage 200 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Google Forms Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Forms replication to MySQL.
-
Process & Analyze ZohoPeople Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ZohoPeople Data.
-
Create Informatica Mappings From/To an ODBC Data Source for NASA
Create an ODBC connection to NASA in Informatica and browse and transfer NASA.
-
Connect to FHIR Data from Crystal Reports
Use CData Connect AI to connect to and report on live FHIR from Crystal Reports.
-
How to connect PolyBase to PabblySubscriptions
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PabblySubscriptions.
-
Automated Continuous ZohoInvoice Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to Google BigQuery.
-
Edit and Search External MySQL Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of MySQL to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create MySQL Data objects that you can access from apps and the dashboard.
-
Integrate Presto Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Presto from Informatica Cloud.
-
Access Live Avro Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Avro data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Viewing ChargeOver Data in RAD Studio Data Explorer
How to view ChargeOver in RAD Studio Data Explorer using the CData ODBC Driver for ChargeOver.
-
Connect to Real-Time LaunchDarkly Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use LaunchDarkly in Power Apps.
-
How to connect to Printify Data in DBVisualizer
Integrate Printify with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Data Flows from Eventbrite to SQL Server using SSIS
Easily back up Eventbrite to SQL Server using the SSIS components for Eventbrite.
-
Create GraphQL-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to GraphQL Data from Klipfolio and build custom visualizations using live GraphQL.
-
Getting Started with the CData Tableau Connector for xBase
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for xBase.
-
Use the CData ODBC Driver for Excel Online in Microsoft Power Query
You can use the CData Excel Online ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft Excel Online into Microsoft Power Query.
-
Integrate with Spotify Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Spotify to a JSON file on disk.
-
DataBind Controls to GitHub Data in C++Builder
DataBind to GitHub in C++Builder with standard components and controls.
-
How to Visualize CapsuleCRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live CapsuleCRM in Python.
-
Access Live Klipfolio Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Klipfolio into the statistical analysis tools available in SAS JMP. This article shows how to use Klipfolio in the Graph Builder and Query Builder.
-
Integrating Kiro CLI with Egnyte 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.
-
Connect to Adobe Target Data in CloverDX (formerly CloverETL)
Transfer Adobe Target using the visual workflow in the CloverDX data integration tool.
-
Connect to and Visualize Live Salesforce Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Salesforce & Force.com.
-
Build an OLAP Cube in SSAS from Perplexity Data
Establish a connection to Perplexity data from SQL Server Analysis Services, and use the Perplexity Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Amazon Athena Data in ACL Analytics
Connect to Amazon Athena via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Amazon Athena.
-
Building Dynamic Web Pages with SurveyMonkey Data Using AngularJS
Create single-page applications with live connectivity to SurveyMonkey using the CData API Server.
-
Connect to Telegram Data in DBeaver
Use the CData ODBC Driver to connect to Telegram in DBeaver.
-
Integrate with Live Office 365 Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Office 365 from the MuleSoft Anypoint Platform to integrate live Microsoft Office 365 into custom reports and dashboards.
-
Getting Started with the CData ODBC Driver for OpenWeatherMap
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for OpenWeatherMap.
-
Create Power BI Reports on Real-Time Zoho Inventory Data
Use the CData ODBC Driver for Zoho Inventory to visualize Zoho Inventory in Power BI Desktop.
-
How to Easily Query Postmark Data in OpenOffice Base
Connect to Postmark data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to ActiveCampaign Data from Crystal Reports
Use CData Connect AI to connect to and report on live ActiveCampaign from Crystal Reports.
-
Connect to Auth0 Data from a Connection Pool in JBoss
Integrate Auth0 into Java servlets: Use the Management Console in JBoss to install the Auth0 JDBC Driver.
-
How to Connect to Live IBM Cloud Object Storage 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 IBM Cloud Object Storage without replication.
-
Create Amazon Athena-Connected Dashboards in Grafana
Connect to Amazon Athena Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Amazon Athena.
-
Getting Started with the CData SSIS Components for SAP ByDesign
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP ByDesign.
-
Use the CData Software JDBC Driver for Redis in MicroStrategy Web
Connect to Redis in MicroStrategy Web using the CData Software JDBC Driver for Redis.
-
Connect to Google Analytics Data in CloverDX (formerly CloverETL)
Transfer Google Analytics using the visual workflow in the CloverDX data integration tool.
-
How to connect to Adobe Target Data from IntelliJ
Integrate connectivity to Adobe Target with wizards in IntelliJ.
-
Build YouTube Analytics-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for YouTube Analytics to explore live YouTube Analytics Data in GitHub Copilot to assist with building YouTube Analytics-powered applications.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Procore using the Model Context Protocol.
-
Automated Continuous Jira Assets Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Jira Assets replication to IBM DB2.
-
Access MarkLogic Data from MySQL in PHP
Connect to MarkLogic through the standard MySQL libraries in PHP.
-
Connect to Live Adobe Commerce Data in MicroStrategy through CData Connect AI
Create a live connection to Adobe Commerce Data in CData Connect AI and connect to your Adobe Commerce from MicroStrategy.
-
Integrating LlamaIndex with Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google Ads in real time.
-
Getting Started with the CData JDBC Driver for Dynamics NAV
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Dynamics NAV.
-
Use the CData SSIS Components to Insert New or Update Existing Exact Online Records from SQL Server
Easily push SQL Server data to Exact Online using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Exact Online or update existing records with data from a SQL Server database.
-
Connect Excel Online to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Excel Online with IBM WebSphere for seamless data integration and connectivity.
-
Build Dashboards with EnterpriseDB Data in DBxtra
Create dynamic dashboards and perform analytics based on EnterpriseDB in DBxtra.
-
Build MVC Applications with Connectivity to Accelo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Accelo from an ASP.NET MVC application.