CData Software - Knowledge Base
Recent Articles
-
Replicate Cloudant Data from PowerShell
Write a quick PowerShell script to query IBM Cloudant. Use connectivity to the live data to replicate IBM Cloudant to SQL Server.
-
Use ChatGPT to Talk to Your HBase 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 Apache HBase for you.
-
Integrate with CockroachDB Data in SnapLogic
Use CData Connect AI to connect to and integrate with live CockroachDB in SnapLogic.
-
Access PayPal Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live PayPal from HeidiSQL.
-
How to Use a Microsoft Access Database to Update Greenplum Data in Real Time
Update Greenplum data by creating a linked table in Microsoft Access with the CData Greenplum ODBC Driver.
-
Integrate LibreChat with Live Klaviyo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Klaviyo from within the chat interface.
-
Manage Simplesat Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Simplesat.
-
Build an OLAP Cube in SSAS from Discord Data
Establish a connection to Discord data from SQL Server Analysis Services, and use the Discord Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query, Visualize, and Share live Raisers Edge NXT Data in Redash
Use CData Connect AI to connect to live Raisers Edge NXT in Redash for querying, visualizing, and sharing.
-
Connect to and Query Google Analytics Data in QlikView over ODBC
Create data visualizations with Google Analytics in QlikView.
-
Integrating Epicor Kinetic Data in Talend Cloud Data Management Platform
Connect Epicor Kinetic Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Epicor Kinetic.
-
How to connect PolyBase to Google Translate
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Translate.
-
Analyze eBay Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of eBay and visualize live eBay in Infragistics Reveal.
-
Natively Connect to Microsoft Ads Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Ads. Leverage the native support for ODBC in PHP.
-
Rapidly Develop Bitly-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 Bitly.
-
How to integrate Reckon with Apache Airflow
Access and process Reckon in Apache Airflow using the CData JDBC Driver.
-
Access Live SAP Fieldglass Data in Excel 365 Online (Excel for the web)
Connect to SAP Fieldglass from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Semantic Layer Views for Outreach.io Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Outreach.io.
-
Publish PayPal-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live PayPal.
-
Replicate Multiple Bullhorn CRM Accounts
Replicate multiple Bullhorn CRM accounts to one or many databases.
-
Back Up Google Contacts to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Contacts. In this article, we will employ an SSIS workflow to populate a database with Google Contacts data.
-
Query Oracle Data as a MySQL Database in Node.js
Execute MySQL queries against Oracle Database from Node.js.
-
Connecting Moonlit Workflow with Oracle Service Cloud Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Oracle Service Cloud in real time.
-
Build Visualizations of ShipStation Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ShipStation in Birst.
-
Query SQL Server Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Microsoft SQL Server and perform CRUD operations on SQL Server from Node.js.
-
Rapidly Develop Yelp-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 Yelp.
-
Replicate Multiple Adobe Commerce Accounts
Replicate multiple Adobe Commerce accounts to one or many databases.
-
Build NASA-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live NASA Data in Claude Code to assist with building NASA-powered applications.
-
Work with Deel Data in FoxPro
Load Deel into a FoxPro database. This article includes full code and a walk-through of the process.
-
Publish Templated-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Templated.
-
Connect to Toggl Data in HULFT Integrate
Connect to Toggl as a JDBC data source in HULFT Integrate
-
How to Connect Gong Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Gong data in real time using natural language.
-
Access Live CSV Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live CSV/TSV Files through MCP integration.
-
Visualize AfterShip Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to AfterShip.
-
Natively Connect to Recurly Data in PHP
The CData ODBC driver for Recurly enables you to create PHP applications with connectivity to Recurly. Leverage the native support for ODBC in PHP.
-
Integrate with live Kintone Data in Jitterbit
Use CData Connect AI to connect to and integrate live Kintone in Jitterbit.
-
Object-Relational Mapping (ORM) with Avalara AvaTax Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Avalara AvaTax into a Java-based ORM framework, Hibernate.
-
Use the CData Software ODBC Driver for Amazon DynamoDB in MicroStrategy Desktop
Connect to Amazon DynamoDB in MicroStrategy Desktop using the CData Software ODBC Driver for Amazon DynamoDB.
-
Analyze Oracle Eloqua Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Oracle Eloqua and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Paymo with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Paymo with External Services.
-
Access Live Pinecone Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Pinecone data source in TIBCO Data Virtualization Studio and gain access to live Pinecone from your TDV Server.
-
Integrate Marketo Data into Power Automate Desktop using CData Connect
CData Connect for Marketo Data enables you to integrate Marketo into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software ODBC Driver for Rootly in MicroStrategy
Connect to Rootly in MicroStrategy Developer using the CData Software ODBC Driver for Rootly.
-
Connect Neo4J to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Neo4J using the CData Python MCP Server.
-
Getting Started with the CData ADO.NET Provider for Front
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Access Live LinkedIn Data in Excel 365 Online (Excel for the web)
Connect to LinkedIn from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Write a Simple Go Application to work with Mailjet Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Mailjet.
-
Visualize Live FreshBooks Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live FreshBooks into custom reports in Power BI.
-
Use the CData Software ODBC Driver for CapsuleCRM in MicroStrategy Web
Connect to CapsuleCRM in MicroStrategy Web using the CData Software ODBC Driver for CapsuleCRM.
-
How to load Access data into Elasticsearch via Logstash
Introducing a simple method to load Access data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to MongoDB Data in HULFT Integrate
Connect to MongoDB as a JDBC data source in HULFT Integrate
-
Getting Started with the CData ODBC Driver for Act-On
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Act-On.
-
Analyze Live YouTube Analytics Data in SAS Viya
Use CData Connect AI to connect to YouTube Analytics from SAS Viya and deploy self-service analytics using live YouTube Analytics.
-
A PostgreSQL Interface for Contentful Data (MySQL Remoting via JDBC)
Use the Remoting features of the Contentful JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Optimizely-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Optimizely.
-
Query Egnyte Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Egnyte and perform CRUD operations on Egnyte from Node.js.
-
Using the CData Software ODBC Driver for Sage Cloud Accounting in PyCharm
Connect to Sage Cloud Accounting as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sage Cloud Accounting.
-
Integrate Real-Time Access to Freshdesk in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Freshdesk in real time.
-
Connect to Sugar CRM Data in DBeaver
Use the CData ODBC Driver to connect to Sugar CRM in DBeaver.
-
Access Oracle Sales 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 Oracle Sales.
-
Replicate Multiple WordPress Accounts
Replicate multiple WordPress accounts to one or many databases.
-
How to use SQLAlchemy ORM to access Aweber Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Aweber.
-
How to Work with JobNimbus Data in AWS Glue Jobs Using JDBC
Connect to JobNimbus from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Short.io Data in the Pentaho Report Designer
Publish reports based on Short.io in the Pentaho BI tool.
-
Automate PabblySubscriptions Data Replication to SAP HANA
Use CData Sync to customize and automate PabblySubscriptions replication to SAP HANA.
-
Write a Simple Go Application to work with Unbounce Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Unbounce.
-
Build Charts with Flowlu Data in Clear Analytics
Create dynamic charts and perform analytics based on Flowlu in Clear Analytics.
-
Use Grok to Talk to Your Pipedrive 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 Pipedrive for you.
-
Create Power BI Reports on Real-Time Asana Data
Use the CData ODBC Driver for Asana to visualize Asana in Power BI Desktop.
-
Viewing Amazon Marketplace Data in RAD Studio Data Explorer
How to view Amazon Marketplace in RAD Studio Data Explorer using the CData ODBC Driver for Amazon Marketplace.
-
Automate SingleStore Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SingleStore from PowerShell? This article demonstrates how to utilize the SingleStore Cmdlets for tasks like connecting to SingleStore, automating operations, downloading data, and more.
-
How to connect to Access Data with Squirrel SQL client
Connect to Microsoft Access and execute queries in the Squirrel SQL Client.
-
How to connect to AfterShip Data with Squirrel SQL client
Connect to AfterShip and execute queries in the Squirrel SQL Client.
-
Create Informatica Mappings From/To an ODBC Data Source for Okta
Create an ODBC connection to Okta in Informatica and browse and transfer Okta.
-
How to Easily Query CSV Data in OpenOffice Base
Connect to CSV data in OpenOffice Base using the CData ODBC Driver for CSV and generate reports with live data insights.
-
How to Work with Google Forms Data in AWS Glue Jobs Using JDBC
Connect to Google Forms from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate VWO with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate VWO with External Services.
-
Connect to Sage Cloud Accounting Data from AWS Glue
Use CData Connect AI to gain access to live Sage Business Cloud Accounting from your AWS Glue jobs.
-
Connect to Hubstaff Data in HULFT Integrate
Connect to Hubstaff as a JDBC data source in HULFT Integrate
-
Use Azure AI Foundry to Talk to Your Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Apache Hive for you.
-
Using the CData Software ODBC Driver for IBM Informix in PyCharm
Connect to IBM Informix as an ODBC data source in PyCharm using the CData Software ODBC Driver for IBM Informix.
-
Query Vercel Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Vercel and perform CRUD operations on Vercel from Node.js.
-
Create Reports from Azure DevOps Data in Looker Studio
Use CData Connect AI to gain access to live Azure DevOps and create custom reports in Looker Studio.
-
Connect Opsgenie to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Opsgenie using the CData Python MCP Server.
-
Explore Geographical Relationships in Acumatica Data with Power Map
Create data visualizations with Acumatica ERP in Power Map.
-
Connecting GenSpark with Freshservice Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Freshservice without any replication or custom integration required.
-
Build SAP HANA Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP HANA and build visualizations in Tableau.
-
Automated Continuous Apify Replication to SingleStore
Use CData Sync for automated, continuous, customizable Apify replication to SingleStore.
-
Automated Continuous AgileCRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable AgileCRM replication to Apache Cassandra.
-
Getting Started with the CData SSIS Components for Azure DevOps
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Azure DevOps.
-
Visualize PingOne Data in Tableau
The CData ODBC driver for PingOne enables you integrate PingOne into Tableau dashboards.
-
Automated Continuous PivotalTracker Replication to MySQL
Use CData Sync for automated, continuous, customizable PivotalTracker replication to MySQL.
-
Visualize Teamgate Data in Sisense
Create an ElastiCube in Sisense app with access to Teamgate.
-
Automated Continuous Confluence Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Confluence replication to Apache Cassandra.
-
Connect to Mocean Data in NetBeans
Connect to Mocean in NetBeans with the data source configuration wizard.
-
Automated Continuous Procore Replication to SQL Server
Use CData Sync for automated, continuous, customizable Procore replication to SQL Server.
-
How to Query Hugging Face Data in MySQL Workbench
Execute MySQL queries against live Hugging Face from MySQL Workbench.
-
Extract, Transform, and Load Figshare Data in Informatica PowerCenter
Create a simple Workflow for Figshare in Informatica PowerCenter.
-
Integrating Claude Code with Shopify Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Shopify within assisted coding and automated development workflows.
-
How to Query Live Zoho Creator Data in Claude Desktop
Connect to and query live Zoho Creator Data in Claude Desktop using CData MCP Server.