CData Software - Knowledge Base
Recent Articles
-
How to Visualize Epicor Kinetic Data in Python with pandas
Use pandas and other modules to analyze and visualize live Epicor Kinetic in Python.
-
Migrating data from Square to Databricks using CData SSIS Components.
Easily push Square to Databricks using the CData SSIS Tasks for Square and Databricks.
-
Visualize ScrapingBee Data in Tableau
The CData ODBC driver for ScrapingBee enables you integrate ScrapingBee into Tableau dashboards.
-
Prepare, Blend, and Analyze Gumroad Data in Alteryx Designer (ODBC)
Build workflows to access live Gumroad for self-service data analytics.
-
Connect ConvertKit Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ConvertKit using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Visualizations of CockroachDB Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of CockroachDB in Birst.
-
Query Perigon Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Perigon and perform CRUD operations on Perigon from Node.js.
-
Deploy the ADO.NET Provider for Customer.io on an SSRS Report Server
Connect to Customer.io from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Build Autopilot-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Autopilot.
-
Access Bannerbear Data from MySQL in Amazon QuickSight
Connect to Bannerbear and build visualizations of Bannerbear using a MySQL Connection in Amazon QuickSight.
-
Extract, Transform, and Load eBay Data in Informatica PowerCenter
Create a simple Workflow for eBay in Informatica PowerCenter.
-
Access Live Reckon Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Reckon data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build Pipelines with Live CockroachDB Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to CockroachDB from Google Cloud Data Fusion, enabling the integration of live CockroachDB into the building and management of effective data pipelines.
-
Build Semantic Layer Views for GitHub Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for GitHub.
-
A PostgreSQL Interface for Facebook Ads Data (MySQL Remoting via JDBC)
Use the Remoting features of the Facebook Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating GitHub Copilot CLI with Elorus 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 Freshdesk Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Freshdesk data access from reports, embedded analytics, and more.
-
Integrating Gong Data in Talend Cloud Data Management Platform
Connect Gong Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Enable the Paylocity JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Paylocity.
-
Connect to YouTube Analytics Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for YouTube Analytics and the SQL Gateway to access YouTube Analytics from Google Apps Script.
-
Use the CData Software JDBC Driver for Factorial in MicroStrategy Desktop
Connect to Factorial in MicroStrategy Desktop using the CData Software JDBC Driver for Factorial.
-
How to connect PolyBase to Humanity
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Humanity.
-
DataBind Charts to Asana Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Asana from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
How to create an RPA flow for Egnyte Data in UiPath Studio
Use the Egnyte ODBC Driver to create workflows that access real-time Egnyte without any coding.
-
Working with Front Data in LINQPad
Execute LINQ queries to Front in LINQPad.
-
Create Data Visualizations Based On SAP Hybris C4C Data in Mode
Use CData Connect AI to connect to SAP Hybris C4C Data from Mode and build visualizations using live
-
Integrating Cursor CLI with Paylocity 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.
-
How to Connect to & Open Cloudflare Data in Microsoft Excel
This article uses the CData ODBC driver for Cloudflare to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to HCL Domino Data in RapidMiner
Integrate HCL Domino with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Box Replication to Snowflake
Use CData Sync for automated, continuous, customizable Box replication to Snowflake.
-
How to Access Live Simplesat Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Simplesat enables you to integrate Simplesat into workflows built using Microsoft Power Automate Desktop.
-
Integrating GitHub Copilot CLI with Salesforce & Force.com 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 Stack Exchange Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Apache Cassandra.
-
Connecting GenSpark with Google Analytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Google Analytics without any replication or custom integration required.
-
Automate BambooHR Data Replication to Azure Data Lake
Use CData Sync to customize and automate BambooHR replication to Azure Data Lake.
-
How to connect to Toggl Data in DBVisualizer
Integrate Toggl with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Import Data from JobNimbus into Google Sheets
Import JobNimbus into a Google spreadsheet that is automatically refreshed.
-
Replicate BambooHR Data to Multiple Databases
Replicate BambooHR to disparate databases with a point-and-click configuration.
-
Connect to Salesforce Marketing Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Salesforce Marketing Cloud in Airbyte.
-
Build Salesforce Pardot Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Salesforce Pardot and build visualizations in Tableau Cloud.
-
Connect to Marketo Data in ACL Analytics
Connect to Marketo via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Marketo.
-
How to Access GraphQL Data Using Entity Framework
This article shows how to access GraphQL using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrating GitHub Copilot CLI with Authorize.Net 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 LDAP to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live LDAP using the CData Python MCP Server.
-
How to connect to Oracle HCM Cloud Data in DBVisualizer
Integrate Oracle HCM Cloud with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze SFTP Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SFTP and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrating LangChain with SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SAP BusinessObjects BI within automated workflows.
-
Connect to SAP Business One Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP Business One from Crystal Reports.
-
Connect to Chargebee Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Chargebee.
-
Connect to Active Directory Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Active Directory in the Denodo Virtual DataPort Administrator.
-
Connect to MailChimp Data in RazorSQL
Connect to MailChimp from wizards and query MailChimp from the GUI in the RazorSQL database management tool.
-
Connect to Salesloft Data in RapidMiner
Integrate Salesloft with standard components and data source configuration wizards in RapidMiner Studio.
-
Build AI Agents with Odoo 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 Odoo ERP through CData Connect AI.
-
Write a Simple Go Application to work with TaxJar Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to TaxJar.
-
Use Azure AI Foundry to Talk to Your Microsoft Exchange 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 Microsoft Exchange for you.
-
Access Basecamp Data from MySQL in PHP
Connect to Basecamp through the standard MySQL libraries in PHP.
-
Choosing the Best Method to Connect Amazon S3 to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Amazon S3 from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous BenchmarkEmail Replication to SQLite
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to SQLite.
-
Publish Microsoft Teams-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Teams.
-
Access Live Google Ad Manager Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Ad Manager from your Excel spreadsheets.
-
Create SAP BusinessObjects BI Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP BusinessObjects BI from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData Power BI Connector for Act CRM
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Act CRM.
-
Connect to Oracle Eloqua Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Oracle Eloqua and the SQL Gateway to access Oracle Eloqua from Google Apps Script.
-
Automated Continuous Pipedrive Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Pipedrive replication to Apache Cassandra.
-
Getting Started with the CData SSIS Components for Google Campaign Manager 360
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Campaign Manager 360.
-
How to work with Oracle Data in Apache Spark using SQL
Access and process Oracle Data in Apache Spark using the CData Software JDBC Driver.
-
Load OnePageCrm Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load OnePageCrm to a database.
-
Migrating data from Amplitude to Snowflake using CData SSIS Components.
Easily push Amplitude to Snowflake using the CData SSIS Tasks for Amplitude and Snowflake.
-
Explore Geographical Relationships in Quaderno Data with Power Map
Create data visualizations with Quaderno in Power Map.
-
Access Live Suadeo Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Suadeo into the statistical analysis tools available in SAS JMP. This article shows how to use Suadeo in the Graph Builder and Query Builder.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Close to Power BI dashboards. Simply drag and drop Close into data visuals on the Power BI canvas.
-
Automated Planio Data Replication to Teradata
Use CData Sync to Customize and automate Planio replication to Teradata.
-
How to Query Live Adobe Target Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Adobe Target data in natural language using Python.
-
Connect to Shortcut from a Connection Pool in WebLogic
Use the CData JDBC Driver for Shortcut to connect to Shortcut from Web applications running on WebLogic.
-
Automated Continuous Google Campaign Manager 360 Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to SQL Server.
-
Query Zoho Inventory Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Zoho Inventory from Node.js.
-
Integrating Gumloop with Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Facebook Ads within automated workflows.
-
Publish NetSuite-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live NetSuite CRM & ERP.
-
Connect Sage Intacct to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sage Intacct using the CData Python MCP Server.
-
Integrating Antigravity CLI with WooCommerce via CData CLI
Connect WooCommerce to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Google Cloud Storage using the Model Context Protocol.
-
Integrate Strava with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Strava with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Strava.
-
Build Exact Online-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Exact Online to explore live Exact Online Data in GitHub Copilot to assist with building Exact Online-powered applications.
-
Access Live FreshBooks 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 FreshBooks through MCP integration.
-
Import RSS Feeds into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access RSS Feeds. In this article, you will use the OData format to import RSS Feeds into Microsoft Power Query.
-
Integrating Trello Data in Talend Cloud Data Management Platform
Connect Trello Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Trello.
-
Edit and Search Landbot External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Landbot to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Landbot objects that you can access from apps and the dashboard.
-
Visualize PolarTeamPro Data in Tableau
The CData ODBC driver for PolarTeamPro enables you integrate PolarTeamPro into Tableau dashboards.
-
Integrate Live Google Contacts Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Google Contacts from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Contacts.
-
Use ChatGPT to Talk to Your Splunk 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 Splunk for you.
-
Edit and Search Instagram External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Instagram to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Instagram objects that you can access from apps and the dashboard.
-
Build MVC Applications with Connectivity to Teamwork Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Teamwork from an ASP.NET MVC application.
-
Build Dashboards with Auth0 Data in DBxtra
Create dynamic dashboards and perform analytics based on Auth0 in DBxtra.
-
Integrating Claude Code CLI with Mode 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 Antigravity CLI with Tanda via CData CLI
Connect Tanda to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create a Data Access Object for ZohoPeople Data using JDBI
A brief overview of creating a SQL Object API for ZohoPeople in JDBI.
-
Integrate Live Omnisend Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Omnisend to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Access Live Missive Data in AWS Lambda
Connect to live Missive in AWS Lambda using the CData JDBC Driver.
-
Connect to WordPress Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for WordPress in Airbyte.
-
How to Visualize SuiteCRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live SuiteCRM in Python.