CData Software - Knowledge Base
Recent Articles
-
How to connect Amazon QuickSight to Gong Data
Create a connection to Gong in CData Connect AI and insert Gong into Amazon QuickSight SPICE to build interactive dashboards.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed NetSuite CRM & ERP to Power BI dashboards. Simply drag and drop NetSuite CRM & ERP into data visuals on the Power BI canvas.
-
How to Connect to Live Dynamics 365 Business Central 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 Dynamics 365 Business Central without replication.
-
Access Live Confluence 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 Atlassian Confluence through MCP integration.
-
How to connect to Accelo Data with Squirrel SQL client
Connect to Accelo and execute queries in the Squirrel SQL Client.
-
Use JayDeBeApi to access Hive Data in Python
Use standard Python scripting and the development environment of your choice to access live Apache Hive.
-
Getting Started with the CData JDBC Driver for Foursquare
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Foursquare.
-
Access Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Access facts in real time.
-
Import SAP Business One Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP Business One Data and provide access to live SAP Business One for custom reports in the Power BI Service.
-
Create Reports with Neo4J Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Neo4J.
-
Integrate Cosmos DB Data into Power Automate Desktop using CData Connect
CData Connect for Cosmos DB Data enables you to integrate Azure Cosmos DB into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Freshteam Replication to MongoDB
Use CData Sync for automated, continuous, customizable Freshteam replication to MongoDB.
-
Automated Continuous Bugsnag Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Bugsnag replication to delimited files (CSV/TSV).
-
Write a Simple Go Application to work with Neo4J Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Neo4J.
-
Integrating LlamaIndex with Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Outreach.io in real time.
-
Access Live VWO Data in AWS Lambda (with IntelliJ IDEA)
Connect to live VWO in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Zoom Replication to Snowflake
Use CData Sync for automated, continuous, customizable Zoom replication to Snowflake.
-
Back Up Microsoft OneDrive to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Microsoft OneDrive. In this article, we will employ an SSIS workflow to populate a database with Microsoft OneDrive data.
-
Provide OData Services of eBay Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for eBay by developing a WCF Service Application.
-
Create Dynamic LinkedIn Ads Grids Using the Infragistics XamDataGrid
Learn how you can connect LinkedIn Ads to Infragistics XamDataGrid to build dynamic grids.
-
DataBind Controls to HDFS Data in Delphi
DataBind to Apache HDFS in Delphi with standard data access components and controls.
-
Connect to Insightly Data from a Connection Pool in JBoss
Integrate Insightly into Java servlets: Use the Management Console in JBoss to install the Insightly JDBC Driver.
-
How to Connect to Live Basecamp 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 Basecamp through natural language.
-
How to use SQLAlchemy ORM to access Cassandra Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Apache Cassandra.
-
How to update Instagram from Excel
This article explains how to transfer data from Excel to Instagram using the Excel Add-In for Instagram.
-
Automate Shippo Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Shippo from PowerShell? This article demonstrates how to utilize the Shippo Cmdlets for tasks like connecting to Shippo, automating operations, downloading data, and more.
-
Visualize Live Cassandra Data in the Power BI Service
Use CData Connect AI to connect to live Apache Cassandra and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Access Data in Aqua Data Studio
Access Microsoft Access from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
DataBind Google Cloud Storage Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Google Cloud Storage with the DevExpress Windows Forms and Web controls to provide Google Cloud Storage to a chart.
-
Access Bitbucket Data from MySQL in Amazon QuickSight
Connect to Bitbucket and build visualizations of Bitbucket using a MySQL Connection in Amazon QuickSight.
-
Connect to CapsuleCRM Data in JRuby
Create a simple JRuby app with access to live CapsuleCRM.
-
Build a Simple VCL Application for SageHR Data
How to build a simple VCL Application to view SageHR in RAD Studio using the CData ODBC Driver for SageHR.
-
Connect to Real-Time Google Translate Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Google Translate in Power Apps.
-
Query, Visualize, and Share live Splunk Data in Redash
Use CData Connect AI to connect to live Splunk in Redash for querying, visualizing, and sharing.
-
How to Access Cassandra Data Using Entity Framework
This article shows how to access Apache Cassandra using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Bitbucket Data in RazorSQL
Connect to Bitbucket from wizards and query Bitbucket from the GUI in the RazorSQL database management tool.
-
Use the CData SSIS Components to Insert New or Update Existing SAP Business One Records from SQL Server
Easily push SQL Server data to SAP Business One using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SAP Business One or update existing records with data from a SQL Server database.
-
Import Real-Time Odoo Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Odoo ERP in ColdFusion.
-
Connect to Calendly Data in Ruby
Connect to Calendly in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to create an RPA flow for Amazon Marketplace Data in UiPath Studio
Use the Amazon Marketplace ODBC Driver to create workflows that access real-time Amazon Marketplace without any coding.
-
How to Query Wistia Data in MySQL Workbench
Execute MySQL queries against live Wistia from MySQL Workbench.
-
Access Foursquare Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Foursquare from your Oracle system.
-
Access Xero 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 Xero Accounting.
-
How to connect to PostgreSQL Data from IntelliJ
Integrate connectivity to PostgreSQL with wizards in IntelliJ.
-
Connect to Live Salesforce CRM Analytics Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Salesforce CRM Analytics in CData Connect AI and connect to your Salesforce CRM Analytics from PostgreSQL.
-
Load Suadeo Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Suadeo to a database.
-
Access Live Zuora 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 Zuora through MCP integration.
-
Use ChatGPT to Talk to Your Presto 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 Presto for you.
-
Use the CData Software ODBC Driver for Close in MicroStrategy Web
Connect to Close in MicroStrategy Web using the CData Software ODBC Driver for Close.
-
How to Visualize Azure Data Lake Storage Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure Data Lake Storage in Python.
-
A PostgreSQL Interface for Procore Data (MySQL Remoting via JDBC)
Use the Remoting features of the Procore JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Databricks Agent Bricks to Talk to Your FHIR Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your FHIR for you.
-
Use the CData Software ODBC Driver for Teamwork in SAS for Real-Time Reporting and Analytics
Connect to real-time Teamwork in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Teamwork.
-
Connect to Epicor Kinetic Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Epicor Kinetic and the Script function in FileMaker Pro to connect to Epicor Kinetic and work with Epicor Kinetic in your FileMaker application.
-
Connect to Couchbase Data in Ruby
Connect to Couchbase in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Oracle SCM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Oracle SCM and the SQL Gateway to access Oracle SCM from Google Apps Script.
-
Create Power BI Reports on Real-Time Stack Exchange Data
Use the CData ODBC Driver for Stack Exchange to visualize Stack Exchange in Power BI Desktop.
-
Use the CData Software ODBC Driver for Keap in SAS for Real-Time Reporting and Analytics
Connect to real-time Keap in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Keap.
-
How to Connect the Power BI Service to HelloSign: Complete Guide
Connect to the CData Software Power BI Connector for HelloSign from PowerBI.com to provide real-time HelloSign across the organization.
-
Oracle SCM Reporting in OBIEE with the Oracle SCM JDBC Driver
Deploy the Oracle SCM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Edit and Search External GitHub Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of GitHub to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create GitHub Data objects that you can access from apps and the dashboard.
-
DataBind Salesforce Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Salesforce with the DevExpress Windows Forms and Web controls to provide Salesforce & Force.com to a chart.
-
Use Dash to Build to Web Apps on Azure Table Data
Create Python applications that use pandas and Dash to build Azure Table-connected web apps.
-
Connect to Perigon Data in HULFT Integrate
Connect to Perigon as a JDBC data source in HULFT Integrate
-
Connect to Clio Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Clio and the SQL Gateway to access Clio from Google Apps Script.
-
Integrating Claude Code CLI with OnePageCrm 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 SageHR to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SageHR using the CData Python MCP Server.
-
Use the CData Software ODBC Driver for Reply.io in MicroStrategy Web
Connect to Reply.io in MicroStrategy Web using the CData Software ODBC Driver for Reply.io.
-
How to Query Live SharePoint Excel Services Data in Claude Desktop
Connect to and query live SharePoint Excel Services Data in Claude Desktop using CData MCP Server.
-
Use the CData Software JDBC Driver for Microsoft Dataverse in MicroStrategy
Connect to Microsoft Dataverse (CDS) in MicroStrategy Developer using the CData Software JDBC Driver for Microsoft Dataverse.
-
Automated Continuous Zoho Books Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Zoho Books replication to Google Cloud SQL.
-
Use the CData ODBC Driver for Reply.io in Microsoft Power Query
You can use the CData Reply.io ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Reply.io into Microsoft Power Query.
-
Getting Started with the CData JDBC Driver for Samanage
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Samanage.
-
LINQ to Drift 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 Drift Data Provider.
-
Create Testmonitor Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Testmonitor data access from reports, embedded analytics, and more.
-
How to Access SAP Fieldglass Data Using Entity Framework
This article shows how to access SAP Fieldglass using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Dynamic Amazon Athena Grids Using the Infragistics XamDataGrid
Learn how you can connect Amazon Athena to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Microsoft Dataverse Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Apache Cassandra.
-
Automated Continuous Google Cloud Storage Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to SQL Server.
-
How to Create Power BI Visual Reports with Real-Time Shippo Data
Use CData Power BI Connectors to visualize Shippo in Power BI.
-
Connect to Oracle Service Cloud Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Oracle Service Cloud.
-
Access Live Jira Assets Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Jira Assets data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Visualize Zoho Creator Data in Sisense
Create an ElastiCube in Sisense app with access to Zoho Creator.
-
Connect to Amazon S3 Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Amazon S3 and the Script function in FileMaker Pro to connect to Amazon S3 and work with Amazon S3 in your FileMaker application.
-
Integrate SAP SuccessFactors LMS with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP SuccessFactors LMS with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP SuccessFactors LMS.
-
Create CockroachDB Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time CockroachDB data access from reports, embedded analytics, and more.
-
Work with SAP BusinessObjects BI Data in FoxPro
Load SAP BusinessObjects BI into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Dashboards with Freshservice Data in Dundas BI
Create dynamic dashboards and perform analytics based on Freshservice in Dundas BI.
-
Object-Relational Mapping (ORM) with SageHR 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 SageHR into a Java-based ORM framework, Hibernate.
-
Connect to Jumpseller Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Jumpseller and the SQL Gateway to access Jumpseller from Google Apps Script.
-
Automated Continuous Egnyte Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Egnyte replication to Apache Kafka.
-
Integrate Oracle Eloqua Data into Power Automate Desktop using CData Connect
CData Connect for Oracle Eloqua Data enables you to integrate Oracle Eloqua into workflows built using Microsoft Power Automate Desktop.
-
Integrate Open WebUI with Live Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Lakebase from within the chat interface.
-
Connect to Wistia Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use the CData Software ODBC Driver for Ontraport in MicroStrategy
Connect to Ontraport in MicroStrategy Developer using the CData Software ODBC Driver for Ontraport.
-
Connect to Google Search Results as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Search.
-
How to Easily Query Missive Data in OpenOffice Base
Connect to Missive data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to ServiceNow Data from AWS Glue
Use CData Connect AI to gain access to live ServiceNow from your AWS Glue jobs.
-
Connect to SendInBlue Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SendInBlue and the SQL Gateway to access SendInBlue from Google Apps Script.
-
Build AI/ML Models with Live Apify Data using Dataiku
Connect Apify Data with Dataiku using the CData API Driver for JDBC.