CData Software - Knowledge Base
Recent Articles
-
Configure the CData JDBC Driver for QuickBooks Online in a Connection Pool in Tomcat
Connect to QuickBooks Online from a connection pool in Tomcat.
-
How to create an RPA flow for Active Directory Data in UiPath Studio
Use the Active Directory ODBC Driver to create workflows that access real-time Active Directory without any coding.
-
Access Coda Data from MySQL in PHP
Connect to Coda through the standard MySQL libraries in PHP.
-
Replicate Multiple Nethunt Accounts via the CData Sync CLI
Replicate multiple Nethunt accounts to one or many databases.
-
How to Build an ETL App for Jodoo Data in Python with CData
Create ETL applications and real-time data pipelines for Jodoo in Python with petl.
-
Connect to RabbitMQ Data in CloverDX (formerly CloverETL)
Transfer RabbitMQ using the visual workflow in the CloverDX data integration tool.
-
Build MVC Applications with Connectivity to Cloudflare Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Cloudflare from an ASP.NET MVC application.
-
Connect to Active Directory Data in Jaspersoft Studio
Execute SQL to remote Active Directory in Jaspersoft Studio.
-
Replicate Suadeo Data from PowerShell
Write a quick PowerShell script to query Suadeo. Use connectivity to the live data to replicate Suadeo to SQL Server.
-
Connect to eBay Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for eBay to connect to eBay and execute queries in PowerBuilder.
-
How to Visualize Azure Table Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure Table Storage in Python.
-
How to Connect DBeaver to Salesforce via a JDBC Driver
Manage Salesforce & Force.com with visual tools in DBeaver like the query browser.
-
Replicate Outreach.io Data in Heroku for Use in Salesforce Connect
Replicate Outreach.io to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create SSAS Tabular Models from Shopify Data
How to build a SQL Server Analysis Service Tabular Model from Shopify using CData drivers.
-
Use the CData ODBC Driver for Sugar CRM in Microsoft Power Query
You can use the CData Sugar CRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sugar CRM into Microsoft Power Query.
-
How to Connect to Cassandra Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apache Cassandra. Leverage the pyodbc module for ODBC in Python.
-
Connect to AlloyDB Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google AlloyDB from Crystal Reports.
-
Edit and Search Acumatica External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Acumatica ERP to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Acumatica objects that you can access from apps and the dashboard.
-
Natively Connect to SAP Ariba Procurement Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAP Ariba Procurement. Leverage the native support for ODBC in PHP.
-
Replicate Multiple BigCommerce Accounts
Replicate multiple BigCommerce accounts to one or many databases.
-
Connect to SAP SuccessFactors Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP SuccessFactors in Airbyte.
-
Analyze Amazon S3 Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Amazon S3 with the CData JDBC Driver for Amazon S3.
-
Replicate Clockify Data from PowerShell
Write a quick PowerShell script to query Clockify. Use connectivity to the live data to replicate Clockify to SQL Server.
-
Automated Continuous Paymo Replication to Databricks
Use CData Sync for automated, continuous, customizable Paymo replication to Databricks.
-
How to Access Live Webex Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Webex enables you to integrate Webex into workflows built using Microsoft Power Automate Desktop.
-
How to import LDAP Objects into Apache Solr
Use the CData Software JDBC Driver for LDAP in Data Import Handler and create an automated import of LDAP to Apache Solr Enterprise Search platform.
-
Build Oracle Financials Cloud Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Oracle Financials Cloud and build visualizations in Tableau.
-
How to Connect to Bitly Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Bitly. Leverage the pyodbc module for ODBC in Python.
-
Build a PostgreSQL Interface for Freshservice Data using the CData JDBC Driver
Use the Remoting features of the Freshservice JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Dash to Build to Web Apps on Adobe Commerce Data
Create Python applications that use pandas and Dash to build Adobe Commerce-connected web apps.
-
Build Apps with Live Google AlloyDB in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google AlloyDB into the Adalo platform and build custom mobile and web applications with real-time Google AlloyDB.
-
Integrating LlamaIndex with Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Bullhorn CRM in real time.
-
Connect to Real-Time Invoiced Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Invoiced in Power Apps.
-
Build Visualizations of Teamwork Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Teamwork in Birst.
-
Access Live CockroachDB Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate CockroachDB into the statistical analysis tools available in SAS JMP. This article shows how to use CockroachDB in the Graph Builder and Query Builder.
-
Consume WooCommerce OData Feeds in PowerBuilder
This article demonstrates how to consume WooCommerce as OData feeds from PowerBuilder using the API Server.
-
Connect to Zoho Books Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Zoho Books Data and connect to Zoho Books in Akorbi Digital RunMyProcess.
-
Connect to Bannerbear Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Bannerbear in the Denodo Virtual DataPort Administrator.
-
Build Dashboards with Airtable Data in DBxtra
Create dynamic dashboards and perform analytics based on Airtable in DBxtra.
-
Connect and Query Live Office 365 Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Microsoft Office 365 into Databricks
-
Connect to Sybase IQ Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Sybase IQ and the Script function in FileMaker Pro to connect to Sybase IQ and work with Sybase IQ in your FileMaker application.
-
Connect to JotForm Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to JotForm and work with JotForm in your FileMaker applications.
-
How to Access Live Delighted Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Delighted enables you to integrate Delighted into workflows built using Microsoft Power Automate Desktop.
-
Connect Zoho Recruit Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zoho Recruit using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
DataBind Controls to Suadeo Data in C++Builder
DataBind to Suadeo in C++Builder with standard components and controls.
-
How to create an RPA flow for Deel Data in UiPath Studio
Use the Deel ODBC Driver to create workflows that access real-time Deel without any coding.
-
Build a PostgreSQL Interface for FormSite Data using the CData JDBC Driver
Use the Remoting features of the FormSite JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to MYOB AccountRight Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for MYOB AccountRight and the Script function in FileMaker Pro to connect to MYOB AccountRight and work with MYOB AccountRight in your FileMaker application.
-
Work with Office 365 Data in FoxPro
Load Microsoft Office 365 into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Sybase Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Sybase using standard SQL.
-
Query Square Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Square entities in PHP by modeling them as objects.
-
Connect to Sentry Data in Jaspersoft Studio
Execute SQL to remote Sentry in Jaspersoft Studio.
-
Use the CData Software ODBC Driver for Greenhouse in SAS for Real-Time Reporting and Analytics
Connect to real-time Greenhouse in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Greenhouse.
-
Automate Redis Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Redis and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Bidirectional Access to Microsoft Teams Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Teams in Filemaker Pro for Mac or Windows.
-
Integrating Boomi Agentstudio with Zoho Books Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Zoho Books, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Replicate Grafana Data from PowerShell
Write a quick PowerShell script to query Grafana. Use connectivity to the live data to replicate Grafana to SQL Server.
-
LINQ to Slack 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 Slack Data Provider.
-
How to Visualize HelloSign Data in Python with pandas
Use pandas and other modules to analyze and visualize live HelloSign in Python.
-
Getting Started with the CData Tableau Connector for Salesforce Pardot
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Salesforce Pardot.
-
Automated Continuous Salesloft Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Salesloft replication to IBM DB2.
-
How to Access Factorial Data Using Entity Framework
This article shows how to access Factorial using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData Excel Add-In for Hive
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Hive.
-
Automated Continuous Delighted Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Delighted replication to Google Cloud SQL.
-
Build a Simple VCL Application for Mixpanel Data
How to build a simple VCL Application to view Mixpanel in RAD Studio using the CData ODBC Driver for Mixpanel.
-
Import and Visualize Marketo Data in Power View
Create data visualizations based on Marketo in Excel.
-
Build Charts with Microsoft OneDrive Data in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft OneDrive in Clear Analytics.
-
Create PabblySubscriptions Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time PabblySubscriptions data access from reports, embedded analytics, and more.
-
Create Data Visualizations in Cognos BI with Excel Online Data
Access Microsoft Excel Online as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Aha! Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Aha! facts in real time.
-
Integrate Cline with Live Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Xero Accounting from within your IDE.
-
Build AI/ML Models with Live PostgreSQL Data using Dataiku
Connect PostgreSQL Data with Dataiku using the CData JDBC Driver for PostgreSQL.
-
Connect to Cloudant Data from HeidiSQL
Use CData Connect AI to connect to and query live IBM Cloudant from HeidiSQL.
-
Build Data Flows from Webex to SQL Server using SSIS
Easily back up Webex to SQL Server using the SSIS components for Webex.
-
Manage Salesforce Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Salesforce.
-
Automated Continuous SharePoint Excel Services Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to PostgreSQL.
-
How to Access Live LinkedIn Ads Data in Visual Studio Code via Cline
Run CData MCP Server for LinkedIn Ads on Windows Subsytem for Linux (WSL) and connect to live LinkedIn Ads from the Cline extension in Visual Studio Code.
-
Integrate Stripe Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Stripe and integrate live Stripe into your Power Automate tasks.
-
Connect to Shopify Data from a Connection Pool in JBoss
Integrate Shopify into Java servlets: Use the Management Console in JBoss to install the Shopify JDBC Driver.
-
Build OData-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for OData to explore live OData Services in Gemini Code Assist to assist with building OData-powered applications.
-
How to Work with Auth0 Data in AWS Glue Jobs Using JDBC
Connect to Auth0 from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect to & Open Everhour Data in Microsoft Excel
This article uses the CData ODBC driver for Everhour to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Connect to Live IBM Informix Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your IBM Informix for you.
-
Build Charts with AdRoll Data in Clear Analytics
Create dynamic charts and perform analytics based on AdRoll in Clear Analytics.
-
Bidirectional Access to Figshare Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Figshare in Filemaker Pro for Mac or Windows.
-
Use the CData ODBC Driver for Jodoo in Microsoft Power Query
You can use the CData Jodoo ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Jodoo into Microsoft Power Query.
-
Use Dash to Build Web Apps on YouTube Analytics Data via CData Connect AI
Build interactive Dash web apps on live YouTube Analytics using pandas and the CData Connect AI Python SDK.
-
How to Create Power BI Visual Reports with Real-Time Certinia Data
Use CData Power BI Connectors to visualize Certinia in Power BI.
-
How to Connect Instagram 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 Instagram data in real time using natural language.
-
Natively Connect to ChartMogul Data in PHP
The CData ODBC driver for ChartMogul enables you to create PHP applications with connectivity to ChartMogul. Leverage the native support for ODBC in PHP.
-
Query Dynamics NAV Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft Dynamics NAV from Node.js.
-
Use the CData Software ODBC Driver for GitLab in SAS for Real-Time Reporting and Analytics
Connect to real-time GitLab in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for GitLab.
-
Query Typeform Data as a MySQL Database in Node.js
Execute MySQL queries against Typeform from Node.js.
-
Operational Reporting on Front Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Front.
-
Build a Simple VCL Application for Vault CRM Data
How to build a simple VCL Application to view Veeva Vault & Vault CRM in RAD Studio using the CData ODBC Driver for Vault CRM.
-
Migrating data from VWO to Google BigQuery using CData SSIS Components.
Easily push VWO to Google BigQuery using the CData SSIS Tasks for VWO and Google BigQuery.
-
Natively Connect to ScrapingBee Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ScrapingBee. Leverage the native support for ODBC in PHP.
-
How to Work with Mixpanel Data in AWS Glue Jobs Using JDBC
Connect to Mixpanel from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to use SQLAlchemy ORM to access Google Drive Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Drive.
-
Explore Geographical Relationships in Typeform Data with Power Map
Create data visualizations with Typeform in Power Map.