CData Software - Knowledge Base
Recent Articles
-
A PostgreSQL Interface for CouchDB Data using the CData ODBC Driver
Use the SQL Gateway and CouchDB ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to load Typeform data into Elasticsearch via Logstash
Introducing a simple method to load Typeform data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Impala Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache Impala from your Google Sheets.
-
Connect and Visualize Live Google Spanner Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Google Spanner into the Databricks platform and create visualization dashboards with real-time Google Spanner.
-
Analyze Certinia Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Certinia with the CData JDBC Driver for Certinia.
-
Add IBM Informix Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for IBM Informix with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed LinkedIn Ads to Power BI dashboards. Simply drag and drop LinkedIn Ads into data visuals on the Power BI canvas.
-
Automated Continuous SAP Hybris C4C Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to PostgreSQL.
-
Connect to and Query Oracle Service Cloud Data in QlikView over ODBC
Create data visualizations with Oracle Service Cloud in QlikView.
-
Integrate ZohoExpense with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ZohoExpense with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ZohoExpense.
-
Use the CData Software ODBC Driver for Close in SAS for Real-Time Reporting and Analytics
Connect to real-time Close in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Close.
-
How to Build an ETL App for Sage 300 Data in Python with CData
Create ETL applications and real-time data pipelines for Sage 300 in Python with petl.
-
How to Connect the Power BI Service to OnePageCrm: Complete Guide
Connect to the CData Software Power BI Connector for OnePageCrm from PowerBI.com to provide real-time OnePageCrm across the organization.
-
Connect to Real-Time Deel Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Deel in Power Apps.
-
Connect to DB2 Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for DB2 and the SQL Gateway to access IBM DB2 from Google Apps Script.
-
Getting Started with the CData ADO.NET Provider for Tavily
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrate Perplexity Data in Pentaho Data Integration
Build ETL pipelines based on Perplexity in the Pentaho Data Integration tool.
-
How to Query DB2 Data in MySQL Workbench
Execute MySQL queries against live IBM DB2 from MySQL Workbench.
-
Create Asana-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Asana Data from OutSystems and build custom enterprise apps using live Asana.
-
How to Visualize Mocean Data in Python with pandas
Use pandas and other modules to analyze and visualize live Mocean in Python.
-
Build SAP ByDesign-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP ByDesign Data and create custom apps in Bubble.
-
How to create Invoiced federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Invoiced in MySQL .
-
Connecting Mastra with Excel Online Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Microsoft Excel Online, no replication required.
-
How to connect PolyBase to SAP Business Warehouse
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP Business Warehouse.
-
Automated Continuous PayPal Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable PayPal replication to Apache Cassandra.
-
Use Manus AI to Talk to Your Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Freshservice.
-
How to import Reckon Accounts Hosted Data into Apache Solr
Use the CData Software JDBC Driver for Reckon Accounts Hosted in Data Import Handler and create an automated import of Reckon Accounts Hosted to Apache Solr Enterprise Search platform.
-
Extend Google Sheets with SFTP Data
Make calls to SFTP from Google Apps Script via the API Server.
-
Access Live Telegram Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Telegram into the statistical analysis tools available in SAS JMP. This article shows how to use Telegram in the Graph Builder and Query Builder.
-
Connect to Workday from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Workday, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Connect to Live Neo4J Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Neo4J for you.
-
Automate Mixpanel Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Mixpanel from PowerShell? This article demonstrates how to utilize the Mixpanel Cmdlets for tasks like connecting to Mixpanel, automating operations, downloading data, and more.
-
Publish Crystal Reports on YouTube Analytics Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date YouTube Analytics.
-
Use Claude to Talk to Your Square 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 Square for you.
-
Integrating GitHub Copilot CLI with ElevenLabs 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 and Visualize Live CloudConvert Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live CloudConvert.
-
How to integrate Active Directory with Apache Airflow
Access and process Active Directory in Apache Airflow using the CData JDBC Driver.
-
Connect to SendGrid Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SendGrid as an External Source in Dremio.
-
Automated Continuous Oracle Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Oracle replication to Apache Cassandra.
-
Build Dashboards with Calendly Data in DBxtra
Create dynamic dashboards and perform analytics based on Calendly in DBxtra.
-
Use the CData ODBC Driver for Azure Data Lake Storage in Microsoft Power Query
You can use the CData Azure Data Lake Storage ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Azure Data Lake Storage into Microsoft Power Query.
-
How to Create Power BI Visual Reports with Real-Time Tanda Data
Use CData Power BI Connectors to visualize Tanda in Power BI.
-
Extract, Transform, and Load LDAP Objects in Informatica PowerCenter
Create a simple Workflow for LDAP in Informatica PowerCenter.
-
Automated Continuous Greenhouse Replication to MongoDB
Use CData Sync for automated, continuous, customizable Greenhouse replication to MongoDB.
-
DataBind Charts to Deel Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Deel 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.
-
Load QuickBooks Time Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load QuickBooks Time to a database.
-
Automated Continuous Raisers Edge NXT Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to PostgreSQL.
-
Use Dash to Build to Web Apps on BigQuery Data
Create Python applications that use pandas and Dash to build BigQuery-connected web apps.
-
Access SQL Analysis Services Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SQL Analysis Services from your Oracle system.
-
Creating MailChimp-Connected Applications in Unqork
You can use CData Connect AI to feed MailChimp to Unqork and build custom business apps.
-
Analyze Redshift Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Amazon Redshift in Microsoft R Open.
-
Create Informatica Mappings From/To a JDBC Data Source for Discourse
Create Discourse data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Shippo Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Shippo in the Denodo Virtual DataPort Administrator.
-
Integrating GitHub Copilot CLI with Instantly 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.
-
Manage ScrapingBee Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ScrapingBee.
-
Build MVC Applications with Connectivity to PingOne Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access PingOne from an ASP.NET MVC application.
-
Replicate Multiple JSON Accounts via the CData Sync CLI
Replicate multiple JSON accounts to one or many databases.
-
Load CapsuleCRM Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load CapsuleCRM to a database.
-
Easily Integrate ShipStation Data in Lazarus Pascal IDE
Learn how to easily integrate live ShipStation in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Parquet Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Apache Parquet from Informatica Cloud.
-
How to connect to PhantomBuster Data with Squirrel SQL client
Connect to PhantomBuster and execute queries in the Squirrel SQL Client.
-
Edit and Search Power BI XMLA External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Power BI XMLA to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Power BI XMLA objects that you can access from apps and the dashboard.
-
Getting Started with the CData Tableau Connector for Teradata
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Teradata.
-
Visualize Live Hive Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Apache Hive.
-
Use JayDeBeApi to access SAP Netweaver Gateway Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP Netweaver Gateway.
-
LINQ to ShipEngine 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 ShipEngine Data Provider.
-
How to Visualize Campaigner Data in Python with pandas
Use pandas and other modules to analyze and visualize live Campaigner in Python.
-
Validate Gorgias Data with QuerySurge
Access and validate Gorgias in QuerySurge using the CData JDBC Driver.
-
Integrate Perigon Data in the Pentaho Report Designer
Publish reports based on Perigon in the Pentaho BI tool.
-
Build Semantic Layer Views for SAP HANA Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP HANA.
-
Create Salesforce Data 360 Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Salesforce Data 360 data access from reports, embedded analytics, and more.
-
Connect to Sybase IQ Data in NetBeans
Connect to Sybase IQ in NetBeans with the data source configuration wizard.
-
Build Data Flows from Superchat to SQL Server using SSIS
Easily back up Superchat to SQL Server using the SSIS components for Superchat.
-
Connect to SAP Netweaver Gateway from Asprova with CData Software ODBC Driver for SAP Netweaver Gateway
This article shows how to connect faster to SAP Netweaver Gateway data from Asprova.
-
Design BIRT Reports on Ontraport Data
Provide current Ontraport to your embedded analytics.
-
Integrate Theia IDE with Live Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Getting Started with the CData Excel Add-In for SAP HANA XS Advanced
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP HANA XS Advanced.
-
How to Connect DBeaver to Google Tasks via a JDBC Driver
Manage Google Tasks with visual tools in DBeaver like the query browser.
-
Visualize ChargeOver Data in Tableau
The CData ODBC driver for ChargeOver enables you integrate ChargeOver into Tableau dashboards.
-
Connect to Mistral AI Data in Aqua Data Studio
Access Mistral AI from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Use a Microsoft Access Database to Update Microsoft Ads Data in Real Time
Update Microsoft Ads data by creating a linked table in Microsoft Access with the CData Microsoft Ads ODBC Driver.
-
Visualize Mouseflow Data in Tableau
The CData ODBC driver for Mouseflow enables you integrate Mouseflow into Tableau dashboards.
-
Create Dynamic Apollo Grids Using the Infragistics XamDataGrid
Learn how you can connect Apollo to Infragistics XamDataGrid to build dynamic grids.
-
Replicate Multiple Shortcut Accounts
Replicate multiple Shortcut accounts to one or many databases.
-
Access Live Vault CRM Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Vault CRM data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Oracle Service Cloud Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Oracle Service Cloud in Airbyte.
-
Connect to JobNimbus Data from PowerBuilder via JDBC
This article demonstrates how to access JobNimbus from PowerBuilder using the JobNimbus JDBC Driver.
-
Analyze SAP Business Warehouse Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP Business Warehouse and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Visualize Freshservice Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Freshservice into TIBCO Spotfire.
-
ETL Calendly in Oracle Data Integrator
This article shows how to transfer Calendly into a data warehouse using Oracle Data Integrator.
-
Connect to Omnisend Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Omnisend and the SQL Gateway to access Omnisend from Google Apps Script.
-
Connect to Supabase Data in Jaspersoft Studio
Execute SQL to remote Supabase in Jaspersoft Studio.
-
Connect to Excel Online Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrating Dataiku with QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live QuickBooks Time.
-
Build Apps with Live Smartsheet Data Using the Low-Code Development Platform of Mendix
Connect Smartsheet with Mendix to build apps using the CData JDBC Driver for Smartsheet.
-
Build Zoom Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Zoom and build visualizations in Tableau.
-
Use the CData Software ODBC Driver for LDAP in MicroStrategy Desktop
Connect to LDAP in MicroStrategy Desktop using the CData Software ODBC Driver for LDAP.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Azure DevOps using the Model Context Protocol.
-
Connect to HubDB Data in NetBeans
Connect to HubDB in NetBeans with the data source configuration wizard.
-
Back Up Instagram to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Instagram. In this article, we will employ an SSIS workflow to populate a database with Instagram data.