CData Software - Knowledge Base
Recent Articles
-
Natively Connect to HCL Domino Data in PHP
The CData ODBC driver for HCL Domino enables you to create PHP applications with connectivity to HCL Domino. Leverage the native support for ODBC in PHP.
-
Manage Mistral AI Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Mistral AI.
-
Provide OData Services of Google Drive Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Drive by developing a WCF Service Application.
-
Use the CData ODBC Driver for Paymo from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Paymo to connect to Paymo from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Paymo in Excel.
-
Connect to Google Tasks from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Tasks to connect to Google Tasks from Web applications running on WebLogic.
-
Build Automated MariaDB-Connected Workflows in Zapier
Use CData Connect AI to connect to live MariaDB and build automated workflows in Zapier.
-
Replicate Multiple HCL Domino Accounts
Replicate multiple HCL Domino accounts to one or many databases.
-
Import Real-Time Epicor Kinetic Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Epicor Kinetic in ColdFusion.
-
Integrate Okta Data in the Pentaho Report Designer
Publish reports based on Okta in the Pentaho BI tool.
-
Excel Spreadsheet Automation on SendInBlue Data with the QUERY Formula
Pull data from SendInBlue, automate spreadsheets, and more with the QUERY formula.
-
Build Charts with Customer.io Data in Clear Analytics
Create dynamic charts and perform analytics based on Customer.io in Clear Analytics.
-
Visualize Pinecone Data in Sisense
Create an ElastiCube in Sisense app with access to Pinecone.
-
Connect to BigCommerce Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for BigCommerce in the Denodo Virtual DataPort Administrator.
-
Replicate Facebook Data to Multiple Databases via the CData Sync CLI
Replicate Facebook to disparate databases with a single configuration.
-
Query Shopify Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Shopify entities in PHP by modeling them as objects.
-
Create Power BI Reports on Real-Time ConstantContact Data
Use the CData ODBC Driver for ConstantContact to visualize ConstantContact in Power BI Desktop.
-
How to Easily Query Highrise Data in OpenOffice Base
Connect to Highrise data in OpenOffice Base using the CData ODBC Driver for Highrise and generate reports with live data insights.
-
Use Manus AI to Talk to Your Sage Cloud Accounting 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 Sage Business Cloud Accounting.
-
Connect to Testmonitor Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Testmonitor using standard SQL.
-
Connect to Tally Data in ACL Analytics
Connect to Tally ERP via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Tally ERP.
-
Use the CData Software JDBC Driver for Gmail in MicroStrategy Desktop
Connect to Gmail in MicroStrategy Desktop using the CData Software JDBC Driver for Gmail.
-
Automated Continuous LinkedIn Replication to SingleStore
Use CData Sync for automated, continuous, customizable LinkedIn replication to SingleStore.
-
Build Automated Google Sheets-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Sheets and build automated workflows in Zapier.
-
Work with Live Azure Analysis Services Data in Power Query
Use CData Connect AI to connect to Azure Analysis Services and work with live Azure Analysis Services in Microsoft Power Query.
-
Access Live Azure Synapse Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure Synapse from your Google Sheets.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Oracle Eloqua to Power BI dashboards. Simply drag and drop Oracle Eloqua into data visuals on the Power BI canvas.
-
Integrating Codex CLI with Box 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 to Harvest Data in JRuby
Create a simple JRuby app with access to live Harvest.
-
A PostgreSQL Interface for Salesforce Data 360 Data (MySQL Remoting via JDBC)
Use the Remoting features of the Salesforce Data 360 JDBC Driver to create a PostgreSQL entry-point for data access.
-
A PostgreSQL Interface for Bannerbear Data (MySQL Remoting via JDBC)
Use the Remoting features of the Bannerbear JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use JayDeBeApi to access BenchmarkEmail Data in Python
Use standard Python scripting and the development environment of your choice to access live BenchmarkEmail.
-
Connect to PayPal Data from AWS Glue
Use CData Connect AI to gain access to live PayPal from your AWS Glue jobs.
-
Excel Spreadsheet Automation on Shortcut Data with the QUERY Formula
Pull data from Shortcut, automate spreadsheets, and more with the QUERY formula.
-
Integrate Real-Time Access to PingOne in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to PingOne in real time.
-
Access Avro 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 Apache Avro.
-
Automate Simplesat Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Simplesat from PowerShell? This article demonstrates how to utilize the Simplesat Cmdlets for tasks like connecting to Simplesat, automating operations, downloading data, and more.
-
How to Seamlessly Import Float Data into IBM SPSS Modeler
Integrate Float data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Query Azure Data Lake Storage Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Azure Data Lake Storage and perform CRUD operations on Azure Data Lake Storage from Node.js.
-
Build Visualizations of Zoho Books Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoho Books in Birst.
-
Connect Insightly to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Insightly with IBM WebSphere for seamless data integration and connectivity.
-
Analyze Azure Data Catalog Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Azure Data Catalog with the CData JDBC Driver for Azure Data Catalog.
-
Automate Presto Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Presto from PowerShell? This article demonstrates how to utilize the Presto Cmdlets for tasks like connecting to Presto, automating operations, downloading data, and more.
-
Object-Relational Mapping (ORM) with Egnyte 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 Egnyte into a Java-based ORM framework, Hibernate.
-
How to publish and share CampaignMonitor Data dashboards with Tableau Server
The CData ODBC driver for CampaignMonitor enables you integrate CampaignMonitor into Tableau dashboards.
-
Create a Data Access Object for SharePoint Excel Services Data using JDBI
A brief overview of creating a SQL Object API for SharePoint Excel Services in JDBI.
-
Connect to Figshare Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Figshare in the Denodo Virtual DataPort Administrator.
-
How to create Calendly federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Calendly in MySQL .
-
Automated Continuous Paylocity Replication to Databricks
Use CData Sync for automated, continuous, customizable Paylocity replication to Databricks.
-
Add Testmonitor Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Testmonitor with the Informatica Enterprise Data Catalog to classify and organize data.
-
ETL Deel in Oracle Data Integrator
This article shows how to transfer Deel into a data warehouse using Oracle Data Integrator.
-
Connect to Aha! Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Aha! in the Denodo Virtual DataPort Administrator.
-
Integrating GitHub Copilot CLI with AgileCRM 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.
-
Build SAP BusinessObjects BI-Connected Apps in Choreo
Use CData Connect AI to connect to SAP BusinessObjects BI Data from Choreo and build custom apps using live SAP BusinessObjects BI.
-
Integrating Dataiku with Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Power BI XMLA.
-
Use Manus AI to Talk to Your Dynamics CRM 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 Microsoft Dynamics CRM.
-
Connect to Oracle Data from AWS Glue
Use CData Connect AI to gain access to live Oracle Database from your AWS Glue jobs.
-
Analyze Act-On Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Act-On and visualize live Act-On in Infragistics Reveal.
-
Build HBase-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for HBase Data and create custom apps in Bubble.
-
Connect to Salesforce Data from PowerBuilder via ADO.NET
This article demonstrates how to access Salesforce & Force.com from Appeon PowerBuilder using the CData ADO.NET Provider for Salesforce.
-
Create Datasets from Notion in Domo Workbench and Build Visualizations of Notion Data in Domo
Use the CData Software ODBC Driver for Notion to create datasets from Notion in Domo Workbench and then build visualizations in the Domo service.
-
How to import BigCommerce Data into Apache Solr
Use the CData Software JDBC Driver for BigCommerce in Data Import Handler and create an automated import of BigCommerce to Apache Solr Enterprise Search platform.
-
Validate ZohoExpense Data with QuerySurge
Access and validate ZohoExpense in QuerySurge using the CData JDBC Driver.
-
Prepare, Blend, and Analyze Microsoft Teams Data in Alteryx Designer (Connect AI)
Build workflows to access live Microsoft Teams for self-service data analytics.
-
Connect and Query Live Paylocity Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Paylocity into Databricks
-
Automate Box Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Box from PowerShell? This article demonstrates how to utilize the Box Cmdlets for tasks like connecting to Box, automating operations, downloading data, and more.
-
Automated Continuous Moosend Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Moosend replication to Amazon Redshift.
-
Model Azure Analysis Services Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Azure Analysis Services, enabling the direct import of real-time Azure Analysis Services.
-
Connect to Act-On Data in JRuby
Create a simple JRuby app with access to live Act-On.
-
Excel Spreadsheet Automation on Blackbaud FE NXT Data with the QUERY Formula
Pull data from Blackbaud FE NXT, automate spreadsheets, and more with the QUERY formula.
-
How to Create Power BI Visual Reports with Real-Time Short.io Data
Use CData Power BI Connectors to visualize Short.io in Power BI.
-
How to Query Live SuiteCRM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SuiteCRM data in natural language using Python.
-
Build MVC Applications with Connectivity to MySQL Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access MySQL from an ASP.NET MVC application.
-
Build a Simple VCL Application for Coinbase Data
How to build a simple VCL Application to view Coinbase in RAD Studio using the CData ODBC Driver for Coinbase.
-
Access Live Splunk Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Splunk from your Excel spreadsheets.
-
Build Semantic Layer Views for HCL Domino Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for HCL Domino.
-
How to Connect the Power BI Service to EnterpriseDB: Complete Guide
Connect to the CData Software Power BI Connector for EnterpriseDB from PowerBI.com to provide real-time EnterpriseDB across the organization.
-
Automate Tasks in Power Automate Using the CData API Server
Automate WooCommerce actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
How to create SAP Ariba Procurement federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP Ariba Procurement in MySQL .
-
Import and Visualize Confluence Data in Power View
Create data visualizations based on Atlassian Confluence in Excel.
-
Connect to Airtable in SpagoBI
Create reports featuring live Airtable in SpagoBI Studio. Host Airtable reports on SpagoBI Server.
-
Visualize SuiteCRM Data in TIBCO Spotfire through OData
Integrate SuiteCRM into dashboards in TIBCO Spotfire.
-
Connect to Facebook Ads Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Facebook Ads Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Access Helpscout Data from MySQL in PHP
Connect to Helpscout through the standard MySQL libraries in PHP.
-
Analyze Oracle Service Cloud Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Oracle Service Cloud from Power Pivot. You will use the Table Import Wizard to load Oracle Service Cloud. You can visually build the import query or use any SQL supported by the driver.
-
Import Real-Time Delighted Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Delighted in ColdFusion.
-
Use the CData Software JDBC Driver for CSV in MicroStrategy Desktop
Connect to CSV/TSV Files in MicroStrategy Desktop using the CData Software JDBC Driver for CSV.
-
Create Informatica Mappings From/To a JDBC Data Source for Azure Analysis Services
Create Azure Analysis Services data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect to Highrise Data in DBVisualizer
Integrate Highrise CRM with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to SharePoint Data in NetBeans
Connect to Microsoft SharePoint in NetBeans with the data source configuration wizard.
-
Consume Salesforce CRM Analytics OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Salesforce CRM Analytics feeds that reflect any changes in SAP Lumira.
-
Replicate HBase Data to Multiple Databases via the CData Sync CLI
Replicate Apache HBase to disparate databases with a single configuration.
-
LINQ to Apify 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 Apify Data Provider.
-
Getting Started with the CData Python Connector for Google Search
Learn to install and license the CData Python Connector
-
Connect to and Visualize Live Supabase Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Supabase.
-
Use the CData Software ODBC Driver for Oracle in SAS for Real-Time Reporting and Analytics
Connect to real-time Oracle Database in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Oracle.
-
Deel Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Deel facts in real time.
-
Create IBM Informix-Connected Applications in Appsmith
Connect to IBM Informix Data via CData Connect AI in Appsmith and create custom business applications with real-time access to IBM Informix.
-
Integrating Cursor CLI with Oracle SCM 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.
-
Replicate CapsuleCRM Data to Multiple Databases
Replicate CapsuleCRM to disparate databases with a point-and-click configuration.
-
Bidirectional Access to Sage Intacct Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Sage Intacct in Filemaker Pro for Mac or Windows.