CData Software - Knowledge Base
Recent Articles
-
Natively Connect to Sugar CRM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Sugar CRM. Leverage the native support for ODBC in PHP.
-
Build Dashboards with ZohoDesk Data in Dundas BI
Create dynamic dashboards and perform analytics based on ZohoDesk in Dundas BI.
-
Build an OLAP Cube in SSAS from Perigon Data
Establish a connection to Perigon data from SQL Server Analysis Services, and use the Perigon Data Provider to build OLAP cubes for use in analytics and reporting.
-
Getting Started with the CData Power BI Connector for Paymo
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Analyze Slack Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Slack and visualize live Slack in Infragistics Reveal.
-
Integrating Gumloop with Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Freshdesk within automated workflows.
-
Establish a Live Connection with Monday.com Data using Tableau Bridge
The CData ODBC Driver for Monday.com enables you to integrate live Monday.com into Tableau Cloud dashboards using the Tableau Bridge.
-
Build a PostgreSQL Interface for SAP HANA XS Advanced Data using the CData JDBC Driver
Use the Remoting features of the SAP HANA XS Advanced JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Microsoft Planner Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Apache Kafka.
-
Create Data Visualizations in Cognos BI with Humanity Data
Access Humanity as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Rapidly Develop Dynamics NAV-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Dynamics NAV.
-
How to connect PolyBase to Lakebase
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Lakebase.
-
Build Apps with Live Gumroad Data Using the Low-Code Development Platform of Mendix
Connect Gumroad with Mendix to build apps using the CData API Driver for JDBC.
-
Access Live Neo4J Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Neo4J in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build PabblySubscriptions-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live PabblySubscriptions.
-
How to create LionDesk federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for LionDesk in MySQL .
-
Migrating data from Zoho Recruit to Databricks using CData SSIS Components.
Easily push Zoho Recruit to Databricks using the CData SSIS Tasks for Zoho Recruit and Databricks.
-
Connect to Mistral AI Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Mistral AI and the SQL Gateway to access Mistral AI from Google Apps Script.
-
Connect to Optimizely Data in DBArtisan
Use wizards in DBArtisan to configure Optimizely as a data source.
-
Feed Quaderno Data into FineReport
How to set Quaderno as a JDBC data source in FineReport.
-
Back Up Box to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Box. In this article, we will employ an SSIS workflow to populate a database with Box data.
-
Connect to Missive Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Missive.
-
Use ChatGPT to Talk to Your Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Acumatica ERP for you.
-
Access SparkPost Data from MySQL in PHP
Connect to SparkPost through the standard MySQL libraries in PHP.
-
Integrate Pipeline CRM Data in Pentaho Data Integration
Build ETL pipelines based on Pipeline CRM in the Pentaho Data Integration tool.
-
Automated Continuous Freshservice Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Freshservice replication to Google BigQuery.
-
Access Live Cloudant Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live IBM Cloudant from your Google Sheets.
-
Establish a Live Connection with Azure Data Lake Storage Data using Tableau Bridge
The CData ODBC Driver for Azure Data Lake Storage enables you to integrate live Azure Data Lake Storage into Tableau Cloud dashboards using the Tableau Bridge.
-
How to create ElevenLabs federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ElevenLabs in MySQL .
-
Use the CData Software ODBC Driver for ServiceDesk Plus in MicroStrategy Web
Connect to ServiceDesk Plus in MicroStrategy Web using the CData Software ODBC Driver for ServiceDesk Plus.
-
Connect to SAP SuccessFactors LMS Data in DBArtisan
Use wizards in DBArtisan to configure SAP SuccessFactors LMS as a data source.
-
Getting Started with the CData ADO.NET Provider for Typeform
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrate Open WebUI with Live Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Zoho CRM from within the chat interface.
-
How to Access Presto Data Using Entity Framework
This article shows how to access Presto using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Analyze Google Spanner Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google Spanner and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous Shippo Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Shippo replication to Apache Kafka.
-
Migrating data from Trello to Databricks using CData SSIS Components.
Easily push Trello to Databricks using the CData SSIS Tasks for Trello and Databricks.
-
Analyze Google Drive Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Drive and visualize live Google Drive in Infragistics Reveal.
-
Create Informatica Mappings From/To an ODBC Data Source for Auth0
Create an ODBC connection to Auth0 in Informatica and browse and transfer Auth0.
-
Extract, Transform, and Load Pushbullet Data in Informatica PowerCenter
Create a simple Workflow for Pushbullet in Informatica PowerCenter.
-
Integrate Goose with Live ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live ServiceNow from within the local AI agent.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Cosmos DB actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Integrate Goose with Live GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live GitHub from within the local AI agent.
-
Analyze Zoho Inventory Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Zoho Inventory and visualize live Zoho Inventory in Infragistics Reveal.
-
Connect and Query Live Oracle SCM Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Oracle SCM into Databricks
-
How to import MarkLogic Data into Apache Solr
Use the CData Software JDBC Driver for MarkLogic in Data Import Handler and create an automated import of MarkLogic to Apache Solr Enterprise Search platform.
-
Bridge Zoho Projects Connectivity with Apache NiFi
Access and process Zoho Projects in Apache NiFi using the CData JDBC Driver.
-
Automate Neo4J Data Replication to Azure Data Lake
Use CData Sync to customize and automate Neo4J replication to Azure Data Lake.
-
Viewing Google Directory Data in RAD Studio Data Explorer
How to view Google Directory in RAD Studio Data Explorer using the CData ODBC Driver for Google Directory.
-
Import Google Calendar Data Using Azure Data Factory
Use CData Connect AI to connect to Google Calendar Data from Azure Data Factory and import live Google Calendar.
-
Use Dash to Build Web Apps on SQL Analysis Services Data via CData Connect AI
Build interactive Dash web apps on live SQL Analysis Services using pandas and the CData Connect AI Python SDK.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Sybase IQ to Power BI dashboards. Simply drag and drop Sybase IQ into data visuals on the Power BI canvas.
-
Replicate Multiple BenchmarkEmail Accounts via the CData Sync CLI
Replicate multiple BenchmarkEmail accounts to one or many databases.
-
How to connect to eBay Analytics Data from Spring Boot
Connect to eBay Analytics in a Spring Boot Application using the CData JDBC Driver for eBay Analytics
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Jira
Provide connectivity to Atlassian Jira through an SAP BusinessObjects universe.
-
Connect to Elorus Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Elorus and work with Elorus in your FileMaker applications.
-
How to connect to AlloyDB Data from IntelliJ
Integrate connectivity to Google AlloyDB with wizards in IntelliJ.
-
Automated Continuous Mailjet Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Mailjet replication to Google BigQuery.
-
Connect to SAP Fieldglass Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP Fieldglass in Airbyte.
-
Working with GetResponse Data in LINQPad
Execute LINQ queries to GetResponse in LINQPad.
-
Create Slack-Connected Business Apps in AppSheet
Connect to Slack Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Slack.
-
Bridge Bugsnag Connectivity with Apache NiFi
Access and process Bugsnag in Apache NiFi using the CData JDBC Driver.
-
Moving Data from Amazon DynamoDB to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Amazon DynamoDB data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to integrate Metabase with API Data
Use CData Connect AI to connect to live API and create an interactive dashboard in Metabase from API.
-
Replicate AlloyDB Data to Multiple Databases via the CData Sync CLI
Replicate Google AlloyDB to disparate databases with a single configuration.
-
Working with Sybase Data in LINQPad
Execute LINQ queries to Sybase in LINQPad.
-
Connect to Freshteam Data in Aqua Data Studio
Access Freshteam from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
OData Services Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to OData through CData Connect AI using different applications and tools.
-
Using the CData Software ODBC Driver for ConstantContact in PyCharm
Connect to ConstantContact as an ODBC data source in PyCharm using the CData Software ODBC Driver for ConstantContact.
-
Access Live Authorize.Net Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Authorize.Net data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Elorus Data in RazorSQL
Connect to Elorus from wizards and query Elorus from the GUI in the RazorSQL database management tool.
-
How to Connect to Live Procore Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Procore for you.
-
DataBind Controls to SharePoint Data in C++Builder
DataBind to Microsoft SharePoint in C++Builder with standard components and controls.
-
Integrating Cursor CLI with Invoiced 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.
-
Build Visualizations of Greenhouse Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Greenhouse in Birst.
-
Design BIRT Reports on Cloudflare Data
Provide current Cloudflare to your embedded analytics.
-
How to Query Live LaunchDarkly Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live LaunchDarkly data in natural language using Python.
-
Integrate Live Telegram Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Telegram to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Natively Connect to Unbounce Data in PHP
The CData ODBC driver for Unbounce enables you to create PHP applications with connectivity to Unbounce. Leverage the native support for ODBC in PHP.
-
Automated Continuous Dynamics 365 Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Amazon Redshift.
-
Bind Live Microsoft Teams Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Teams data
-
Connect to Live Google Sheets Data in MicroStrategy through CData Connect AI
Create a live connection to Google Sheets Data in CData Connect AI and connect to your Google Sheets from MicroStrategy.
-
How to Query Live LeadDesk Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live LeadDesk data in natural language using Python.
-
Object-Relational Mapping (ORM) with Coinbase 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 Coinbase into a Java-based ORM framework, Hibernate.
-
How to Query Live Microsoft Ads Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft Ads data in natural language using Python.
-
Automate Amplitude Data Replication to Azure Synapse
Use CData Sync to customize and automate Amplitude replication to Azure Synapse.
-
Create Informatica Mappings From/To an ODBC Data Source for Planio
Create an ODBC connection to Planio in Informatica and browse and transfer Planio.
-
Automated Continuous Egnyte Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Egnyte replication to Apache Cassandra.
-
How to Connect to Live SAP Hybris C4C Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your SAP Hybris C4C for you.
-
Connect to Live Active Directory Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Active Directory in CData Connect AI and connect to your Active Directory from PostgreSQL.
-
Automate Highrise Data Replication to SAP HANA
Use CData Sync to customize and automate Highrise CRM replication to SAP HANA.
-
Connect to Workable Data in DBeaver
Use the CData ODBC Driver to connect to Workable in DBeaver.
-
Connect to Cloudant from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from IBM Cloudant, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Visualize SAP BusinessObjects BI Data in TIBCO Spotfire through OData
Integrate SAP BusinessObjects BI into dashboards in TIBCO Spotfire.
-
Create Egnyte Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Egnyte from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query ConstantContact Data as a MySQL Database in Node.js
Execute MySQL queries against ConstantContact from Node.js.
-
Automate LDAP Integration Tasks from PowerShell
Are you in search of a quick and easy way to access LDAP from PowerShell? This article demonstrates how to utilize the LDAP Cmdlets for tasks like connecting to LDAP, automating operations, downloading data, and more.
-
Create Datasets from IBM Cloud Object Storage in Domo Workbench and Build Visualizations of IBM Cloud Object Storage Data in Domo
Use the CData Software ODBC Driver for IBM Cloud Object Storage to create datasets from IBM Cloud Object Storage in Domo Workbench and then build visualizations in the Domo service.
-
Publish Crystal Reports on Microsoft OneDrive Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft OneDrive.
-
Natively Connect to Delighted Data in PHP
The CData ODBC driver for Delighted enables you to create PHP applications with connectivity to Delighted. Leverage the native support for ODBC in PHP.