CData Software - Knowledge Base
Recent Articles
-
Import Amazon S3 Data Using Azure Data Factory
Use CData Connect AI to connect to Amazon S3 Data from Azure Data Factory and import live Amazon S3 data.
-
Connect to Kintone Data in Ruby
Connect to Kintone data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Viewing Wistia Data in RAD Studio Data Explorer
How to view Wistia data in RAD Studio Data Explorer using the CData ODBC Driver for Wistia.
-
Build Gmail-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Gmail Data from Zoho Analytics and import live Gmail data.
-
Trigger Dropbox IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Dropbox with standard wizards in Logic Apps.
-
Replicate Attio Data from PowerShell
Write a quick PowerShell script to query Attio data. Use connectivity to the live data to replicate Attio data to SQL Server.
-
Connect to Harvest from Asprova with CData Software ODBC Driver for Harvest
This article shows how to connect faster to Harvest data from Asprova.
-
Connect to Placid Data in DBArtisan
Use wizards in DBArtisan to configure Placid data as a data source.
-
Automated Continuous BigCommerce Replication to IBM DB2
Use CData Sync for automated, continuous, customizable BigCommerce replication to IBM DB2.
-
How to Connect to Live Discord Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Discord data securely in real time.
-
Establish a Live Connection with CapsuleCRM Data using Tableau Bridge
The CData ODBC Driver for CapsuleCRM enables you to integrate live CapsuleCRM data into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous TaxJar Replication to Oracle
Use CData Sync for automated, continuous, customizable TaxJar replication to Oracle.
-
Visualize Elasticsearch Data in Sisense
Create an ElastiCube in Sisense app with access to Elasticsearch data.
-
AfterShip Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on AfterShip facts in real time.
-
Integrate Aircall Data in the Pentaho Report Designer
Publish reports based on Aircall data in the Pentaho BI tool.
-
Integrating SharePoint Data in Talend Cloud Data Management Platform
Connect SharePoint Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SharePoint.
-
Create Microsoft Teams-Connected Business Apps in AppSheet
Connect to Microsoft Teams Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft Teams data.
-
Query Vertica Data as a SQL Server Database in Node.js
Execute SQL Server queries against Vertica data from Node.js.
-
Connect to PayPal Data in RapidMiner
Integrate PayPal data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software JDBC Driver for AlloyDB in MicroStrategy
Connect to AlloyDB data in MicroStrategy Developer using the CData Software JDBC Driver for AlloyDB.
-
Connect to Lakebase Data in HULFT Integrate
Connect to Lakebase as a JDBC data source in HULFT Integrate
-
Build SAP Business One-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live SAP Business One data without replication.
-
Analyze Live SAP Ariba Procurement Data in SAS Viya
Use CData Connect AI to connect to SAP Ariba Procurement data from SAS Viya and deploy self-service analytics using live SAP Ariba Procurement data.
-
Create Data Visualizations Based On ConstantContact Data in Mode
Use CData Connect AI to connect to ConstantContact Data from Mode and build visualizations using live ConstantContact data.
-
Automate NetSuite SuiteAnalytics Data Replication to Couchbase
Use CData Sync to Customize and automate NetSuite SuiteAnalytics data replication to Couchbase.
-
Integrate Grafana with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Grafana with External Services.
-
Creating Klaviyo-Connected Applications in Unqork
You can use CData Connect AI to feed Klaviyo data to Unqork and build custom business apps.
-
Build an OLAP Cube in SSAS from LeadDesk Data
Establish a connection to LeadDesk data data from SQL Server Analysis Services, and use the LeadDesk Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to PhantomBuster Data in HULFT Integrate
Connect to PhantomBuster as a JDBC data source in HULFT Integrate
-
Build Visualizations of ScrapingBee Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ScrapingBee data in Birst.
-
Build Bright Data-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Bright Data data.
-
Consume Lakebase OData Feeds in PowerBuilder
This article demonstrates how to consume Lakebase data as OData feeds from PowerBuilder using the API Server.
-
Build Data Flows from Cassandra to SQL Server using SSIS
Easily back up Cassandra data to SQL Server using the SSIS components for Cassandra.
-
Bridge Hive Connectivity with Apache NiFi
Access and process Hive data in Apache NiFi using the CData JDBC Driver.
-
Build Charts with GraphQL Data in Clear Analytics
Create dynamic charts and perform analytics based on GraphQL data in Clear Analytics.
-
Analyze Sugar CRM Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Sugar CRM data with the CData JDBC Driver for Sugar CRM.
-
Query eBay Data as a MySQL Database in Node.js
Execute MySQL queries against eBay data from Node.js.
-
Model, Search, and Visualize Live Microsoft Dataverse Data in ThoughtSpot
Use CData Connect AI to connect to live Microsoft Dataverse data for modeling, searching, and visualizing.
-
Configure the CData JDBC Driver for Printful in a Connection Pool in Tomcat
Connect to Printful data from a connection pool in Tomcat.
-
Use Manus AI to Talk to Your ZohoDesk 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 ZohoDesk data.
-
Access Live Google Calendar Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Calendar data from your Google Sheets.
-
Build Egnyte-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Egnyte Data and create custom apps in Mendix.
-
Build an OLAP Cube in SSAS from ShipEngine Data
Establish a connection to ShipEngine data data from SQL Server Analysis Services, and use the ShipEngine Data Provider to build OLAP cubes for use in analytics and reporting.
-
Replicate GraphQL Data in Heroku for Use in Salesforce Connect
Replicate GraphQL data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Todoist Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Todoist data from HeidiSQL.
-
Use the CData Software ODBC Driver for Beeminder in MicroStrategy Desktop
Connect to Beeminder data in MicroStrategy Desktop using the CData Software ODBC Driver for Beeminder.
-
Visualize SpaceX 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 SpaceX data into TIBCO Spotfire.
-
Getting Started with the CData JDBC Driver for Google Cloud Storage
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Cloud Storage.
-
Establish a Live Connection with MailerLite Data using Tableau Bridge
The CData ODBC Driver for MailerLite enables you to integrate live MailerLite data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Agents in Relevance AI with Access to Live Bannerbear Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Bannerbear data within intelligent agent workflows.
-
Connect to Notion Data from a Connection Pool in JBoss
Integrate Notion data into Java servlets: Use the Management Console in JBoss to install the Notion JDBC Driver.
-
Integrate Adobe Commerce with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Adobe Commerce with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Adobe Commerce data.
-
Build Toggl-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Toggl data.
-
How to Create Power BI Visual Reports with Real-Time Google Spanner Data
Use CData Power BI Connectors to visualize Google Spanner data in Power BI.
-
Query ZohoExpense Data in ColdFusion
Write standard ColdFusion data access code to connect to ZohoExpense data.
-
Access Live Customer.io Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Customer.io data into the statistical analysis tools available in SAS JMP. This article shows how to use Customer.io data in the Graph Builder and Query Builder.
-
Connect Microsoft Entra ID Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft Entra ID data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Productboard Data from MySQL in PHP
Connect to Productboard through the standard MySQL libraries in PHP.
-
Create Xero-Connected Applications in Appsmith
Connect to Xero Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Xero data.
-
How to work with Dynamics 365 Data in Apache Spark using SQL
Access and process Dynamics 365 Data in Apache Spark using the CData Software JDBC Driver.
-
Migrating data from Teamwork to Google BigQuery using CData SSIS Components.
Easily push Teamwork data to Google BigQuery using the CData SSIS Tasks for Teamwork and Google BigQuery.
-
Analyze MailerSend Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for MailerSend from Power Pivot. You will use the Table Import Wizard to load MailerSend data. You can visually build the import query or use any SQL supported by the driver.
-
Interact with Live Microsoft OneDrive Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Microsoft OneDrive data.
-
Create GitLab-Connected Business Apps in AppSheet
Connect to GitLab Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to GitLab data.
-
Query Toggl Data in DataGrip
Create a Data Source for Toggl in DataGrip and use SQL to query live Toggl data.
-
Natively Connect to Kintone Data in PHP
The CData ODBC driver for Kintone enables you to create PHP applications with connectivity to Kintone data. Leverage the native support for ODBC in PHP.
-
How to Work with QuickBooks Time Data in ETL Validator JDBC
Connect to QuickBooks Time from ETL Validator jobs using the CData Software JDBC Driver.
-
Write a Simple Go Application to work with Shortcut Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Shortcut data.
-
Visualize Live Superchat Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Superchat data.
-
Import and Visualize Spark Data in Power View
Create data visualizations based on Spark data in Excel.
-
How to use SQLAlchemy ORM to access Salesforce Marketing Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Salesforce Marketing data.
-
Build Pipelines with Live PolarTeamPro Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to PolarTeamPro from Google Cloud Data Fusion, enabling the integration of live PolarTeamPro data into the building and management of effective data pipelines.
-
Integrating Antigravity CLI with Bright Data data via CData CLI
Connect Bright Data data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous Confluence Replication to Oracle
Use CData Sync for automated, continuous, customizable Confluence replication to Oracle.
-
Build a Simple VCL Application for Excel Data
How to build a simple VCL Application to view Excel data in RAD Studio using the CData ODBC Driver for Excel.
-
Connect to AfterShip Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live AfterShip data from Filemaker Pro on Mac.
-
Automated Continuous MongoDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable MongoDB replication to SingleStore.
-
Write a Simple Go Application to work with ZohoExpense Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ZohoExpense data.
-
Analyze OData Services in Infragistics Reveal
Use CData Connect AI to create on OData API on top of OData services and visualize live OData services in Infragistics Reveal.
-
How to Connect to Live Adobe Analytics Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Adobe Analytics data for you.
-
Build Data Flows from Bugsnag to SQL Server using SSIS
Easily back up Bugsnag data to SQL Server using the SSIS components for Bugsnag.
-
Connect to PolarTeamPro Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for PolarTeamPro Data and connect to PolarTeamPro data in Akorbi Digital RunMyProcess.
-
Automate QuickBooks Time Data Replication to Couchbase
Use CData Sync to Customize and automate QuickBooks Time data replication to Couchbase.
-
Access Live SingleStore Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SingleStore data into the statistical analysis tools available in SAS JMP. This article shows how to use SingleStore data in the Graph Builder and Query Builder.
-
Connect to Live ConstantContact Data in MicroStrategy through CData Connect AI
Create a live connection to ConstantContact Data in CData Connect AI and connect to your ConstantContact data from MicroStrategy.
-
Build a Simple VCL Application for Blackbaud FE NXT Data
How to build a simple VCL Application to view Blackbaud FE NXT data in RAD Studio using the CData ODBC Driver for Blackbaud FE NXT.
-
Connect to Phoenix Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Phoenix and the Script function in FileMaker Pro to connect to Phoenix and work with Phoenix data in your FileMaker application.
-
Access Live HCL Domino Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live HCL Domino data from your Excel spreadsheets.
-
Integrate Clio with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Clio with External Services.
-
How to connect to Excel Online Data in DBVisualizer
Integrate Excel Online data with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Data Visualizations Based On Facebook Data in Mode
Use CData Connect AI to connect to Facebook Data from Mode and build visualizations using live Facebook data.
-
Use the CData Software JDBC Driver for Bugsnag in MicroStrategy Web
Connect to Bugsnag data in MicroStrategy Web using the CData Software JDBC Driver for Bugsnag.
-
Automate Tickspot Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Tickspot data from PowerShell? This article demonstrates how to utilize the Tickspot Cmdlets for tasks like connecting to Tickspot data, automating operations, downloading data, and more.
-
Integrate Google's Vertex AI Agent with Live PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live PayPal data within intelligent workflows.
-
Build MVC Applications with Connectivity to SAP HANA Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP HANA from an ASP.NET MVC application.
-
How to connect SharePoint with IBM Cloud Object Storage Data through external lists
Provide IBM Cloud Object Storage data to SharePoint users as an external list.
-
Create Power BI Reports on Real-Time NASA Data
Use the CData ODBC Driver for NASA to visualize NASA data in Power BI Desktop.
-
Design BIRT Reports on Webflow Data
Provide current Webflow data to your embedded analytics.
-
Automated Continuous Freshservice Replication to Databricks
Use CData Sync for automated, continuous, customizable Freshservice replication to Databricks.
-
Connect to Exact Online Data from PowerBuilder via JDBC
This article demonstrates how to access Exact Online data from PowerBuilder using the Exact Online JDBC Driver.