CData Software - Knowledge Base
Recent Articles
-
Access Live DB2 Data in Coginiti Pro
Connect to and query live DB2 data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Samanage Data in Ruby
Connect to Samanage data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Semantic Layer Views for Access Data in APOS Live Data Gateway
Use the CData Connector for Access in APOS Live Data Gateway to build Semantic Layer Views for Access data.
-
How to connect to QuickBooks Online Data from Spring Boot
Connect to QuickBooks Online in a Spring Boot Application using the CData JDBC Driver for QuickBooks Online
-
Access Zoho Projects Data from MySQL in Amazon QuickSight
Connect to Zoho Projects and build visualizations of Zoho Projects data using a MySQL Connection in Amazon QuickSight.
-
A PostgreSQL Interface for Smartsheet Data using the CData ODBC Driver
Use the SQL Gateway and Smartsheet ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Apps with Live MySQL data in Adalo using CData Connect AI
Use CData Connect AI to integrate live MySQL data into the Adalo platform and build custom mobile and web applications with real-time MySQL data.
-
How to Access Live Neo4J Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Neo4J enables you to integrate Neo4J data into workflows built using Microsoft Power Automate Desktop.
-
How to create Visio diagrams from LinkedIn Data
Automatically update LinkedIn data with the changes you make to Visio master shapes.
-
Build Data Flows from SQL Server to Spark through SSIS
Easily push SQL Server data to Spark using the CData SSIS Tasks for Spark.
-
Automated Apollo Data Replication to Teradata
Use CData Sync to Customize and automate Apollo data replication to Teradata.
-
Access Live SQL Analysis Services Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SQL Analysis Services data into the statistical analysis tools available in SAS JMP. This article shows how to use SQL Analysis Services data in the Graph Builder and Query Builder.
-
Build AI/ML Models with Live Google Forms Data using Dataiku
Connect Google Forms Data with Dataiku using the CData API Driver for JDBC.
-
Build Dashboards with ZohoSubscriptions Data in Dundas BI
Create dynamic dashboards and perform analytics based on ZohoSubscriptions data in Dundas BI.
-
Build Perplexity-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Perplexity data and build web apps with connectivity to live Perplexity data.
-
Analyze Sugar CRM Data in Cognos Analytics
Use CData Connect AI to connect to Sugar CRM Data from Cognos Analytics and analyze live Sugar CRM data.
-
Create Adobe Experience Manager-Connected Applications in Appsmith
Connect to Adobe Experience Manager Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Adobe Experience Manager data.
-
Build AI Agents with Sybase 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 Sybase data through CData Connect AI.
-
View Reports on Real-Time Vault CRM Data in Power BI Report Server
Use the CData ODBC Driver for Vault CRM to visualize Vault CRM data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Okta Data in DBeaver
Use the CData ODBC Driver to connect to Okta data in DBeaver.
-
Integrate Devin with Live Zoho Projects Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Zoho Projects data.
-
Access Live QuickBooks Online Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate QuickBooks Online data into the statistical analysis tools available in SAS JMP. This article shows how to use QuickBooks Online data in the Graph Builder and Query Builder.
-
Connect to AgileCRM Data in JRuby
Create a simple JRuby app with access to live AgileCRM data.
-
Use Microsoft Copilot Studio to talk to your Wave Financial Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Wave Financial data for you.
-
Create SFTP Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SFTP from PowerBI.com to create Power BI Dataflows with real-time data.
-
Using the CData Software ODBC Driver for Microsoft Planner in PyCharm
Connect to Microsoft Planner as an ODBC data source in PyCharm using the CData Software ODBC Driver for Microsoft Planner.
-
Bitly Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Bitly facts in real time.
-
Replicate Multiple Samanage Accounts via the CData Sync CLI
Replicate multiple Samanage accounts to one or many databases.
-
Integrate Real-Time Access to Marketo in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Marketo data in real time.
-
Connecting Pipedream with SAP Netweaver Gateway Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on SAP Netweaver Gateway data in real time.
-
Build Charts with Salesforce Data 360 Data in Clear Analytics
Create dynamic charts and perform analytics based on Salesforce Data 360 data in Clear Analytics.
-
Query BigQuery Data as a SQL Server Database in Node.js
Execute SQL Server queries against BigQuery data from Node.js.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Directory
Provide connectivity to Google Directory data through an SAP BusinessObjects universe.
-
Import Real-Time Exact Online Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Exact Online data in ColdFusion.
-
Automated Continuous Google Contacts Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Contacts replication to Snowflake.
-
Connect to Blackbaud FE NXT Data in Ruby
Connect to Blackbaud FE NXT data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Live Snowflake Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Snowflake data into custom reports in Power BI.
-
Connect to ZohoDesk Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ZohoDesk data.
-
How to connect PolyBase to RSS
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live RSS feeds.
-
Access Live Pinterest Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Pinterest data from your Excel spreadsheets.
-
How to connect to LDAP Objects in DBVisualizer
Integrate LDAP objects with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating Kiro with Microsoft Ads 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.
-
Connect to Postmark Data from a Connection Pool in JBoss
Integrate Postmark data into Java servlets: Use the Management Console in JBoss to install the Postmark JDBC Driver.
-
Import Jira Data Using Azure Data Factory
Use CData Connect AI to connect to Jira Data from Azure Data Factory and import live Jira data.
-
How to Query Parquet Data in MySQL Workbench
Execute MySQL queries against live Parquet data from MySQL Workbench.
-
Build Apps with Live Qualaroo Data Using the Low-Code Development Platform of Mendix
Connect Qualaroo data with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous JotForm Replication to SQLite
Use CData Sync for automated, continuous, customizable JotForm replication to SQLite.
-
LINQ to Amazon Athena 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 Amazon Athena Data Provider.
-
Integrate Goose with Live YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live YouTube Analytics data from within the local AI agent.
-
Connecting Pipedream with Zoho Books Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Zoho Books data in real time.
-
How to connect to Cloudant Data from Spring Boot
Connect to Cloudant in a Spring Boot Application using the CData JDBC Driver for Cloudant
-
Viewing Copper Data in RAD Studio Data Explorer
How to view Copper data in RAD Studio Data Explorer using the CData ODBC Driver for Copper.
-
Build Charts with Landbot Data in Clear Analytics
Create dynamic charts and perform analytics based on Landbot data in Clear Analytics.
-
Automated Continuous Google Analytics Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google Analytics data replication to OneLake in Microsoft Fabric.
-
Integrate Live MailerLite Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to MailerLite from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live MailerLite data.
-
Visualize Greenhouse Data in Sisense
Create an ElastiCube in Sisense app with access to Greenhouse data.
-
Integrating Kiro with YouTube Analytics 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.
-
Connect to MYOB AccountRight Data in Claris FileMaker Pro
Use the CData ODBC Driver for MYOB AccountRight in FileMaker Pro to connect to MYOB AccountRight and work with MYOB AccountRight data in your FileMaker applications.
-
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 data within automated workflows.
-
How to Connect DBeaver to NetSuite via a JDBC Driver
Manage NetSuite data with visual tools in DBeaver like the query browser.
-
Connect to Elasticsearch Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Elasticsearch.
-
Connect to Smartsheet from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Smartsheet data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Apps with Live Gumroad Data Using the Low-Code Development Platform of Mendix
Connect Gumroad data with Mendix to build apps using the CData API Driver for JDBC.
-
Build a Simple VCL Application for Grafana Data
How to build a simple VCL Application to view Grafana data in RAD Studio using the CData ODBC Driver for Grafana.
-
Create Informatica Mappings From/To a JDBC Data Source for Box
Create Box data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to publish and share SharePoint Excel Services Data dashboards with Tableau Server
The CData ODBC driver for SharePoint Excel Services enables you integrate SharePoint Excel Services data into Tableau dashboards.
-
Migrating data from Discourse to Databricks using CData SSIS Components.
Easily push Discourse data to Databricks using the CData SSIS Tasks for Discourse and Databricks.
-
Getting Started with the CData Python Connector for BigQuery
Learn to install and license the CData Python Connector and configure a connection to live BigQuery data.
-
Query Email Data in ColdFusion
Write standard ColdFusion data access code to connect to Email data.
-
Publish Cassandra-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Cassandra data.
-
Connect to JobNimbus Data from a Connection Pool in Jetty
The JobNimbus JDBC Driver supports connection pooling: This article shows how to connect faster to JobNimbus data from Web apps in Jetty.
-
Create Datasets from Act-On in Domo Workbench and Build Visualizations of Act-On Data in Domo
Use the CData Software ODBC Driver for Act-On to create datasets from Act-On data in Domo Workbench and then build visualizations in the Domo service.
-
Airtable Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Airtable data through CData Connect AI using different applications and tools.
-
Query Exact Online Data as a MySQL Database in Node.js
Execute MySQL queries against Exact Online data from Node.js.
-
Automated Continuous Zendesk Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Zendesk replication to Google BigQuery.
-
A PostgreSQL Interface for Twitter Ads Data (MySQL Remoting via JDBC)
Use the Remoting features of the Twitter Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Missive Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Missive replication to delimited files (CSV/TSV).
-
Connect to Marketo Data in Ruby
Connect to Marketo data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Informatica Mappings From/To a JDBC Data Source for Hacker News
Create Hacker News data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to NetSuite Data in JRuby
Create a simple JRuby app with access to live NetSuite data.
-
Migrating data from Reckon Accounts Hosted to Databricks using CData SSIS Components.
Easily push Reckon Accounts Hosted data to Databricks using the CData SSIS Tasks for Reckon Accounts Hosted and Databricks.
-
Connect to Zoho Inventory in SpagoBI
Create reports featuring live Zoho Inventory data in SpagoBI Studio. Host Zoho Inventory reports on SpagoBI Server.
-
Automate Invoiced Data Replication to Azure Data Lake
Use CData Sync to customize and automate Invoiced data replication to Azure Data Lake.
-
Connect to Teamgate Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Teamgate and work with Teamgate data in your FileMaker applications.
-
Create Datasets from SuiteCRM in Domo Workbench and Build Visualizations of SuiteCRM Data in Domo
Use the CData Software ODBC Driver for SuiteCRM to create datasets from SuiteCRM data in Domo Workbench and then build visualizations in the Domo service.
-
LINQ to Quaderno 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 Quaderno Data Provider.
-
Build Reckon Accounts Hosted-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Reckon Accounts Hosted data.
-
Use the CData ODBC Driver for SAP BusinessObjects BI in Microsoft Power Query
You can use the CData SAP BusinessObjects BI ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP BusinessObjects BI data into Microsoft Power Query.
-
How to Query Hive Data in MySQL Workbench
Execute MySQL queries against live Hive data from MySQL Workbench.
-
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.
-
Build Box Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Box data and build visualizations in Tableau Cloud.
-
Validate Keap Data with QuerySurge
Access and validate Keap data in QuerySurge using the CData JDBC Driver.
-
Integrating Claude Code with FHIR Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on FHIR data within assisted coding and automated development workflows.
-
Integrating Boomi Agentstudio with Dynamics NAV Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Dynamics NAV data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build ShipStation-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 ShipStation data without replication.
-
Build Dashboards with Qualaroo Data in DBxtra
Create dynamic dashboards and perform analytics based on Qualaroo data in DBxtra.
-
Replicate Sendwithus Data to Multiple Databases via the CData Sync CLI
Replicate Sendwithus data to disparate databases with a single configuration.
-
Connect to Mode from a Connection Pool in WebLogic
Use the CData JDBC Driver for Mode to connect to Mode data from Web applications running on WebLogic.
-
Feed Dynamics NAV Data into FineReport
How to set Dynamics NAV data as a JDBC data source in FineReport.
-
Build Dashboards with Adobe Analytics Data in DBxtra
Create dynamic dashboards and perform analytics based on Adobe Analytics data in DBxtra.