CData Software - Knowledge Base
Recent Articles
-
Establish a Live Connection with LDAP Objects using Tableau Bridge
The CData ODBC Driver for LDAP enables you to integrate live LDAP into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live GitHub Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to GitHub from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Nethunt Data in DBeaver
Use the CData ODBC Driver to connect to Nethunt in DBeaver.
-
Use Biml to Build SSIS Tasks to Replicate RSS Feeds to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate RSS Feeds to SQL Server.
-
How to Connect the Power BI Service to Oracle SCM: Complete Guide
Connect to the CData Software Power BI Connector for Oracle SCM from PowerBI.com to provide real-time Oracle SCM across the organization.
-
Connect to Highrise Data in DBArtisan
Use wizards in DBArtisan to configure Highrise CRM as a data source.
-
DataBind Controls to Adobe Analytics Data in C++Builder
DataBind to Adobe Analytics in C++Builder with standard components and controls.
-
Import Real-Time CircleCI Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use CircleCI in ColdFusion.
-
Use Biml to Build SSIS Tasks to Replicate Authorize.Net Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Authorize.Net to SQL Server.
-
Create SSAS Tabular Models from Oracle HCM Cloud Data
How to build a SQL Server Analysis Service Tabular Model from Oracle HCM Cloud using CData drivers.
-
Import Real-Time Wistia Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Wistia in ColdFusion.
-
Moving Data from SAP HANA to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP HANA data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Access WordPress Data Using Entity Framework
This article shows how to access WordPress 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 Salesforce CRM Analytics
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Salesforce CRM Analytics.
-
Natively Connect to Microsoft OneDrive Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft OneDrive. Leverage the native support for ODBC in PHP.
-
Access Strava Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Strava from HeidiSQL.
-
Connect to ClickTime Data in JRuby
Create a simple JRuby app with access to live ClickTime.
-
Connecting Mastra with SingleStore 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 SingleStore, no replication required.
-
Analyze ConvertAPI Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of ConvertAPI and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Import Dropbox Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Dropbox. In this article, you will use the OData format to import Dropbox into Microsoft Power Query.
-
Create Data Visualizations Based On AlloyDB Data in Mode
Use CData Connect AI to connect to AlloyDB Data from Mode and build visualizations using live
-
Connect to Adobe Commerce Data from PowerBuilder via JDBC
This article demonstrates how to access Adobe Commerce from PowerBuilder using the Adobe Commerce JDBC Driver.
-
Connect to Adobe Commerce Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Adobe Commerce from Filemaker Pro on Mac.
-
Configure the CData JDBC Driver for NASA in a Connection Pool in Tomcat
Connect to NASA from a connection pool in Tomcat.
-
Build Charts with Discord Data in Clear Analytics
Create dynamic charts and perform analytics based on Discord in Clear Analytics.
-
Publish Outlook-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Outlook.
-
Create GitLab-Connected Applications in Appsmith
Connect to GitLab Data via CData Connect AI in Appsmith and create custom business applications with real-time access to GitLab.
-
Replicate Multiple SAP Business One Accounts
Replicate multiple SAP Business One accounts to one or many databases.
-
Build Semantic Layer Views for Airtable Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Airtable.
-
Bridge Salesforce Pardot Connectivity with Apache NiFi
Access and process Salesforce Pardot in Apache NiFi using the CData JDBC Driver.
-
Connect to Square Data in NetBeans
Connect to Square in NetBeans with the data source configuration wizard.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Monday.com to Power BI dashboards. Simply drag and drop Monday.com into data visuals on the Power BI canvas.
-
Import Real-Time Amazon Marketplace Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Amazon Marketplace in ColdFusion.
-
How to connect to LeadDesk Data in DBVisualizer
Integrate LeadDesk with visual data analysis tools and data connection wizards in DBVisualizer
-
Bind Live Exact Online Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Exact Online data
-
Configure the CData JDBC Driver for LinkedIn Ads in a Connection Pool in Tomcat
Connect to LinkedIn Ads from a connection pool in Tomcat.
-
Import Real-Time Oracle SCM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Oracle SCM in ColdFusion.
-
Automate Egnyte Data Replication to SAP HANA
Use CData Sync to customize and automate Egnyte replication to SAP HANA.
-
Connect to Office 365 Data in NetBeans
Connect to Microsoft Office 365 in NetBeans with the data source configuration wizard.
-
Automate Guru Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Guru and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Integrate with Paylocity Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Paylocity in SnapLogic.
-
Access Live PagerDuty Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate PagerDuty into the statistical analysis tools available in SAS JMP. This article shows how to use PagerDuty in the Graph Builder and Query Builder.
-
Create Odoo Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Odoo data access from reports, embedded analytics, and more.
-
How to connect and process Microsoft Access from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Access.
-
Query SingleStore Data as a SQL Server Database in Node.js
Execute SQL Server queries against SingleStore from Node.js.
-
Replicate Gmail Data from PowerShell
Write a quick PowerShell script to query Gmail. Use connectivity to the live data to replicate Gmail to SQL Server.
-
Connect to Front Data in Ruby
Connect to Front in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Semantic Layer Views for Greenhouse Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Greenhouse.
-
Publish Crystal Reports on Quickbase Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Quickbase.
-
Create Informatica Mappings From/To a JDBC Data Source for Hugging Face
Create Hugging Face data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Avaza Data in Jaspersoft Studio
Execute SQL to remote Avaza in Jaspersoft Studio.
-
Automate Aha! Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Aha! and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to and Visualize Live Oracle HCM Cloud Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Oracle HCM Cloud.
-
Visualize Live DocuSign Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live DocuSign using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Easily Query Jira Assets Data in OpenOffice Base
Connect to Jira Assets data in OpenOffice Base using the CData ODBC Driver for Jira Assets and generate reports with live data insights.
-
Bidirectional Access to Zoom Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Zoom in Filemaker Pro for Mac or Windows.
-
Access Zendesk 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 Zendesk.
-
Build Semantic Layer Views for Google Cloud Storage Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Cloud Storage.
-
Integrating LangGraph with Dynamics 365 Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft Dynamics 365 within automated workflows.
-
Build Opsgenie-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Opsgenie Data in Gemini Code Assist to assist with building Opsgenie-powered applications.
-
How to Query Live Bitbucket Data in Claude Desktop
Connect to and query live Bitbucket Data in Claude Desktop using CData MCP Server.
-
Connect to Reckon Accounts Hosted Data from HeidiSQL
Use CData Connect AI to connect to and query live Reckon Accounts Hosted from HeidiSQL.
-
Automate ServiceNow Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ServiceNow from PowerShell? This article demonstrates how to utilize the ServiceNow Cmdlets for tasks like connecting to ServiceNow, automating operations, downloading data, and more.
-
Integrate Live Splunk Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Splunk from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Splunk.
-
DataBind Intercom Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Intercom to a chart.
-
A PostgreSQL Interface for Okta Data (MySQL Remoting via JDBC)
Use the Remoting features of the Okta JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate PayPal Integration Tasks from PowerShell
Are you in search of a quick and easy way to access PayPal from PowerShell? This article demonstrates how to utilize the PayPal Cmdlets for tasks like connecting to PayPal, automating operations, downloading data, and more.
-
Build Kintone-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Kintone Data and create custom apps in Bubble.
-
How to create an RPA flow for Couchbase Data in UiPath Studio
Use the Couchbase ODBC Driver to create workflows that access real-time Couchbase without any coding.
-
Create Reports with OneNote Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft OneNote.
-
Publish Reports with Egnyte Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Egnyte.
-
Create Zoho Recruit Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Zoho Recruit data access from reports, embedded analytics, and more.
-
How to import Redshift Data into Apache Solr
Use the CData Software JDBC Driver for Redshift in Data Import Handler and create an automated import of Amazon Redshift to Apache Solr Enterprise Search platform.
-
Prepare, Blend, and Analyze ElevenLabs Data in Alteryx Designer (ODBC)
Build workflows to access live ElevenLabs for self-service data analytics.
-
Connect to Printful Data in DBeaver
Use the CData ODBC Driver to connect to Printful in DBeaver.
-
RSS Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on RSS facts in real time.
-
How to work with Qualaroo Data in Apache Spark using SQL
Access and process Qualaroo Data in Apache Spark using the CData Software JDBC Driver.
-
Visualize DB2 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to IBM DB2.
-
Automate Lakebase Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Lakebase and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build Data Flows from SpaceX to SQL Server using SSIS
Easily back up SpaceX to SQL Server using the SSIS components for SpaceX.
-
Automated Continuous Teamgate Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Teamgate replication to Amazon Redshift.
-
ETL Jumpseller in Oracle Data Integrator
This article shows how to transfer Jumpseller into a data warehouse using Oracle Data Integrator.
-
How to connect Amazon QuickSight to Basecamp Data
Create a connection to Basecamp in CData Connect AI and insert Basecamp into Amazon QuickSight SPICE to build interactive dashboards.
-
Process & Analyze Gorgias Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Gorgias Data.
-
How to create an RPA flow for Slack Data in UiPath Studio
Use the Slack ODBC Driver to create workflows that access real-time Slack without any coding.
-
Use the CData ODBC Driver for DocuSign in Microsoft Power Query
You can use the CData DocuSign ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import DocuSign into Microsoft Power Query.
-
Automated Continuous Google Calendar Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Google Calendar replication to AlloyDB.
-
Build Spark-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Apache Spark SQL.
-
Work with Phoenix Data in FoxPro
Load Apache Phoenix into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query Live Highrise Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Highrise CRM directly from the development environment.
-
Import Real-Time LaunchDarkly Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use LaunchDarkly in ColdFusion.
-
LINQ to eBay 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 eBay Data Provider.
-
Using the CData Software ODBC Driver for PolarTeamPro in PyCharm
Connect to PolarTeamPro as an ODBC data source in PyCharm using the CData Software ODBC Driver for PolarTeamPro.
-
Automated Continuous Exa Replication to MySQL
Use CData Sync for automated, continuous, customizable Exa replication to MySQL.
-
Getting Started with the CData Excel Add-In for Snapchat Ads
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Snapchat Ads.
-
Analyze JotForm Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of JotForm and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to connect to Flowlu Data with Squirrel SQL client
Connect to Flowlu and execute queries in the Squirrel SQL Client.
-
Use the CData Software JDBC Driver for Clio in MicroStrategy Desktop
Connect to Clio in MicroStrategy Desktop using the CData Software JDBC Driver for Clio.
-
How to Query Live Sugar CRM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Sugar CRM data in natural language using Python.
-
Build a PostgreSQL Interface for Microsoft Planner Data using the CData JDBC Driver
Use the Remoting features of the Microsoft Planner JDBC Driver to create a PostgreSQL entry-point for data access.