CData Software - Knowledge Base
Recent Articles
-
Build Semantic Layer Views for iContact Data in APOS Live Data Gateway
Use the CData Connector for iContact in APOS Live Data Gateway to build Semantic Layer Views for iContact.
-
Automate Teamgate Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Teamgate from PowerShell? This article demonstrates how to utilize the Teamgate Cmdlets for tasks like connecting to Teamgate, automating operations, downloading data, and more.
-
Connect to Dropbox Data in JRuby
Create a simple JRuby app with access to live Dropbox.
-
Access Live Pushbullet Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Pushbullet into the statistical analysis tools available in SAS JMP. This article shows how to use Pushbullet in the Graph Builder and Query Builder.
-
Connect and Visualize Live Redis Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Redis into the Databricks platform and create visualization dashboards with real-time Redis.
-
Model Oracle SCM Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Oracle SCM, enabling the direct import of real-time Oracle SCM.
-
Connect to PostgreSQL Data from a Connection Pool in Jetty
The PostgreSQL JDBC Driver supports connection pooling: This article shows how to connect faster to PostgreSQL from Web apps in Jetty.
-
Connect to HubSpot Data in Claris FileMaker Pro
Use the CData ODBC Driver for HubSpot in FileMaker Pro to connect to HubSpot and work with HubSpot in your FileMaker applications.
-
Getting Started with the CData ODBC Driver for ZarMoney
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ZarMoney.
-
Write a Simple Go Application to work with Chargebee Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Chargebee.
-
Automated Continuous Shopify Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Shopify replication to Google BigQuery.
-
Access TaxJar Data from MySQL in Amazon QuickSight
Connect to TaxJar and build visualizations of TaxJar using a MySQL Connection in Amazon QuickSight.
-
Import CockroachDB Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to CockroachDB Data and provide access to live CockroachDB for custom reports in the Power BI Service.
-
Connect to xBase Data from a Connection Pool in JBoss
Integrate xBase into Java servlets: Use the Management Console in JBoss to install the xBase JDBC Driver.
-
Build AI Agents with Confluence 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 Atlassian Confluence through CData Connect AI.
-
Connect to LeadDesk Data in RazorSQL
Connect to LeadDesk from wizards and query LeadDesk from the GUI in the RazorSQL database management tool.
-
Build MVC Applications with Connectivity to WooCommerce Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access WooCommerce from an ASP.NET MVC application.
-
How to Connect to & Open Twilio Data in Microsoft Excel
This article uses the CData ODBC driver for Twilio to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Dashboards with BenchmarkEmail Data in Dundas BI
Create dynamic dashboards and perform analytics based on BenchmarkEmail in Dundas BI.
-
Natively Connect to LightSpeedRetail Data in PHP
The CData ODBC driver for LightSpeedRetail enables you to create PHP applications with connectivity to LightSpeedRetail. Leverage the native support for ODBC in PHP.
-
Connect to Apify from a Connection Pool in WebLogic
Use the CData JDBC Driver for Apify to connect to Apify from Web applications running on WebLogic.
-
How to connect Amazon QuickSight to SharePoint Data
Create a connection to Microsoft SharePoint in CData Connect AI and insert Microsoft SharePoint into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrating LangChain with Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Ad Manager within automated workflows.
-
Build Discourse-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Discourse.
-
Connect to Attio Data in Jaspersoft Studio
Execute SQL to remote Attio in Jaspersoft Studio.
-
Natively Connect to Oracle HCM Cloud Data in PHP
The CData ODBC driver for Oracle HCM Cloud enables you to create PHP applications with connectivity to Oracle HCM Cloud. Leverage the native support for ODBC in PHP.
-
Connect to Testmonitor Data in RazorSQL
Connect to Testmonitor from wizards and query Testmonitor from the GUI in the RazorSQL database management tool.
-
Analyze Browserless Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Browserless in Microsoft R Open.
-
Build SAP Fieldglass Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Fieldglass and build visualizations in Tableau Cloud.
-
Extend Google Sheets with REST Data
Make calls to REST from Google Apps Script via the API Server.
-
Connect to Sybase IQ Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Sybase IQ Data and connect to Sybase IQ in Akorbi Digital RunMyProcess.
-
Build Sage 200-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Sage 200.
-
Automated Continuous Elasticsearch Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Elasticsearch replication to IBM DB2.
-
Connect to Real-Time Cloudant Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for IBM Cloudant and Dataflow to import and use IBM Cloudant in Power Apps.
-
Visualize Live Dynamics 365 Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft Dynamics 365 and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to FHIR Data in RapidMiner
Integrate FHIR with standard components and data source configuration wizards in RapidMiner Studio.
-
Creating MySQL-Connected Applications in Unqork
You can use CData Connect AI to feed MySQL to Unqork and build custom business apps.
-
Integrate Oracle Financials Cloud with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Oracle Financials Cloud with External Services.
-
Getting Started with the CData JDBC Driver for LightSpeedRetail
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for LightSpeedRetail.
-
Edit and Search Yelp External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Yelp to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Yelp objects that you can access from apps and the dashboard.
-
Automated Continuous Shopify Replication to Oracle
Use CData Sync for automated, continuous, customizable Shopify replication to Oracle.
-
Design BIRT Reports on Phoenix Data
Provide current Apache Phoenix to your embedded analytics.
-
Connect to AfterShip from a Connection Pool in WebLogic
Use the CData JDBC Driver for AfterShip to connect to AfterShip from Web applications running on WebLogic.
-
Build Dashboards with Foursquare Data in Dundas BI
Create dynamic dashboards and perform analytics based on Foursquare in Dundas BI.
-
Automated Continuous Basecamp Replication to SingleStore
Use CData Sync for automated, continuous, customizable Basecamp replication to SingleStore.
-
Connect to Rebilly Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Rebilly using standard SQL.
-
Provide OData Services of IBM Cloud Object Storage Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for IBM Cloud Object Storage by developing a WCF Service Application.
-
Create a Data Access Object for Active Directory Data using JDBI
A brief overview of creating a SQL Object API for Active Directory in JDBI.
-
Automated Continuous Oracle Service Cloud Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Google BigQuery.
-
Use Biml to Build SSIS Tasks to Replicate Box Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Box to SQL Server.
-
Query Salesforce Pardot Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Salesforce Pardot and perform CRUD operations on Salesforce Pardot from Node.js.
-
Integrate with Google Search Results using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Search to a JSON file on disk.
-
Connect to Attio Data from PowerBuilder via ADO.NET
This article demonstrates how to access Attio from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automate Bullhorn CRM Data Replication to SAP HANA
Use CData Sync to customize and automate Bullhorn CRM replication to SAP HANA.
-
Access Live Figshare Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Figshare data source in TIBCO Data Virtualization Studio and gain access to live Figshare from your TDV Server.
-
Build Data Flows from Foursquare to SQL Server using SSIS
Easily back up Foursquare to SQL Server using the SSIS components for Foursquare.
-
Getting Started with the CData Tableau Connector for Figshare
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Excel Spreadsheet Automation on Gorgias Data with the QUERY Formula
Pull data from Gorgias, automate spreadsheets, and more with the QUERY formula.
-
Integrate Real-Time Access to Helpscout in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Helpscout in real time.
-
Connect Marketo to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Marketo with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software JDBC Driver for Jodoo in MicroStrategy
Connect to Jodoo in MicroStrategy Developer using the CData Software JDBC Driver for Jodoo.
-
Automated Continuous Basecamp Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Basecamp replication to AlloyDB.
-
Access Live Kafka Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Kafka data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Automated Continuous PostgreSQL Replication to IBM DB2
Use CData Sync for automated, continuous, customizable PostgreSQL replication to IBM DB2.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for PivotalTracker
Provide connectivity to PivotalTracker through an SAP BusinessObjects universe.
-
How to connect PolyBase to Cloudant
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live IBM Cloudant.
-
Import Teradata Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Teradata. In this article, you will use the OData format to import Teradata into Microsoft Power Query.
-
Viewing SharePoint Data in RAD Studio Data Explorer
How to view Microsoft SharePoint in RAD Studio Data Explorer using the CData ODBC Driver for SharePoint.
-
How to connect PolyBase to AdRoll
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live AdRoll.
-
Connect to Odoo Data in Ruby
Connect to Odoo ERP in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Live Egnyte Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Egnyte using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build an OLAP Cube in SSAS from Pipedrive Data
Establish a connection to Pipedrive data from SQL Server Analysis Services, and use the Pipedrive Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrating Cursor CLI with Coda 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.
-
Access Live Azure Data Catalog Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Azure Data Catalog data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to update Redshift from Excel
This article explains how to transfer data from Excel to Redshift using the Excel Add-In for Redshift.
-
Object-Relational Mapping (ORM) with Yelp 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 Yelp into a Java-based ORM framework, Hibernate.
-
Analyze Attio Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Attio with the CData JDBC Driver for Attio.
-
Automate SAP Ariba Procurement Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP Ariba Procurement and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Integrating Claude Code CLI with HelloSign 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.
-
Use the CData Software JDBC Driver for Instantly in MicroStrategy Web
Connect to Instantly in MicroStrategy Web using the CData Software JDBC Driver for Instantly.
-
Connect to EnterpriseDB Data as an External Source in Dremio
Use the CData JDBC Driver to connect to EnterpriseDB as an External Source in Dremio.
-
Automated Continuous ZohoExpense Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ZohoExpense replication to IBM DB2.
-
How to Seamlessly Import CloudConvert Data into IBM SPSS Modeler
Integrate CloudConvert data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Google Drive Data in HULFT Integrate
Connect to Google Drive as a JDBC data source in HULFT Integrate
-
How to Use a Microsoft Access Database to Update MongoDB Data in Real Time
Update MongoDB data by creating a linked table in Microsoft Access with the CData MongoDB ODBC Driver.
-
Access Airtable Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Airtable from HeidiSQL.
-
Connect to Parallel from a Connection Pool in WebLogic
Use the CData JDBC Driver for Parallel to connect to Parallel from Web applications running on WebLogic.
-
View Reports on Real-Time Dynamics 365 Business Central Data in Power BI Report Server
Use the CData ODBC Driver for Dynamics 365 Business Central to visualize Dynamics 365 Business Central in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Oracle HCM Cloud Data in CloverDX (formerly CloverETL)
Transfer Oracle HCM Cloud using the visual workflow in the CloverDX data integration tool.
-
Connect and Visualize Live Smartsheet Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Smartsheet into the Databricks platform and create visualization dashboards with real-time Smartsheet.
-
Query, Visualize, and Share live IBM Cloud Object Storage Data in Redash
Use CData Connect AI to connect to live IBM Cloud Object Storage in Redash for querying, visualizing, and sharing.
-
Replicate Multiple SAS xpt Accounts via the CData Sync CLI
Replicate multiple SAS xpt accounts to one or many databases.
-
Visualize PingOne Data in TIBCO Spotfire through ADO.NET
Integrate PingOne into dashboards in TIBCO Spotfire.
-
Analyze Simplesat Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Simplesat from Power Pivot. You will use the Table Import Wizard to load Simplesat. You can visually build the import query or use any SQL supported by the driver.
-
Use Databricks Agent Bricks to Talk to Your Trello Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Trello for you.
-
How to connect SharePoint with Qualaroo Data through external lists
Provide Qualaroo to SharePoint users as an external list.
-
Access Live Google Analytics Data in AWS Lambda
Connect to live Google Analytics in AWS Lambda using the CData JDBC Driver.
-
Integrate Zoho Recruit Data in Pentaho Data Integration
Build ETL pipelines based on Zoho Recruit in the Pentaho Data Integration tool.
-
How to Query Live Clockify Data in Perplexity MacOS Desktop
Connect to and query live Clockify Data in Perplexity Desktop using CData MCP Server.
-
Migrating data from xBase to Google BigQuery using CData SSIS Components.
Easily push xBase to Google BigQuery using the CData SSIS Tasks for xBase and Google BigQuery.