CData Software - Knowledge Base
Recent Articles
-
Access Live Microsoft OneDrive Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft OneDrive in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Hacker News Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Hacker News in the Denodo Virtual DataPort Administrator.
-
Connect to Elasticsearch Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Elasticsearch.
-
Access Live SharePoint Excel Services Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SharePoint Excel Services in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build AI/ML Models with Live Google Drive Data using Dataiku
Connect Google Drive Data with Dataiku using the CData JDBC Driver for Google Drive.
-
Feed Delighted Data into FineReport
How to set Delighted as a JDBC data source in FineReport.
-
DataBind Controls to Epicor Kinetic Data in C++Builder
DataBind to Epicor Kinetic in C++Builder with standard components and controls.
-
Create Datasets from Insightly in Domo Workbench and Build Visualizations of Insightly Data in Domo
Use the CData Software ODBC Driver for Insightly to create datasets from Insightly in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Attio Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Attio to connect to Attio and execute queries in PowerBuilder.
-
Connect to Coinbase Data from PowerBuilder via ADO.NET
This article demonstrates how to access Coinbase from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Cloudant Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Cloudant to connect to IBM Cloudant and execute queries in PowerBuilder.
-
Integrate with Live Asana Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Asana from the MuleSoft Anypoint Platform to integrate live Asana into custom reports and dashboards.
-
Build a Singer.io Tap for ActiveCampaign With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ActiveCampaign data using
-
How to Connect to Freshteam Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Freshteam. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Hive Replication to Oracle
Use CData Sync for automated, continuous, customizable Hive replication to Oracle.
-
Automate HubDB Integration Tasks from PowerShell
Are you in search of a quick and easy way to access HubDB from PowerShell? This article demonstrates how to utilize the HubDB Cmdlets for tasks like connecting to HubDB, automating operations, downloading data, and more.
-
Build Data Flows from WordPress to SQL Server using SSIS
Easily back up WordPress to SQL Server using the SSIS components for WordPress.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Humanity
Provide connectivity to Humanity through an SAP BusinessObjects universe.
-
Connect to Nuclia Data from PowerBuilder via ADO.NET
This article demonstrates how to access Nuclia from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Semantic Layer Views for Flowlu Data in APOS Live Data Gateway
Use the CData Connector for Flowlu in APOS Live Data Gateway to build Semantic Layer Views for Flowlu.
-
How to Access Live Epicor Kinetic Data in Visual Studio Code via Cline
Run CData MCP Server for Epicor Kinetic on Windows Subsytem for Linux (WSL) and connect to live Epicor Kinetic from the Cline extension in Visual Studio Code.
-
How to connect Amazon QuickSight to Redis Data
Create a connection to Redis in CData Connect AI and insert Redis into Amazon QuickSight SPICE to build interactive dashboards.
-
Getting Started with the CData ADO.NET Provider for FormSite
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Visualize Datadog 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 Datadog into TIBCO Spotfire.
-
Video: Connecting to Google BigQuery Data from Microsoft Excel
This video shows how to use the CData ODBC Driver for Google BigQuery to connect to Google BigQuery. You will create a DSN and then use the Data Connection Wizard in Excel to retrieve BigQuery data.
-
Create Freshdesk-Connected Applications in Appsmith
Connect to Freshdesk Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Freshdesk.
-
Create Apps from Elasticsearch Data in Qlik Sense Cloud
Use CData Connect AI to connect to Elasticsearch Data and build apps from live Elasticsearch in Qlik Sense Cloud.
-
Getting Started with the CData ADO.NET Provider for Asana
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Asana.
-
Access Live Clockify Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Clockify into the statistical analysis tools available in SAS JMP. This article shows how to use Clockify in the Graph Builder and Query Builder.
-
How to integrate SAP with Apache Airflow
Access and process SAP ERP/NetWeaver in Apache Airflow using the CData JDBC Driver.
-
Integrating Gumloop with Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Email within automated workflows.
-
Create Data Visualizations Based On FTP Data in Mode
Use CData Connect AI to connect to FTP Data from Mode and build visualizations using live
-
Publish Reports with Exact Online Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Exact Online.
-
Bidirectional Access to GitLab Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate GitLab in Filemaker Pro for Mac or Windows.
-
Use ChatGPT to Talk to Your Gong 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 Gong for you.
-
Access NetSuite Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live NetSuite CRM & ERP from HeidiSQL.
-
Deel Reporting in OBIEE with the Deel JDBC Driver
Deploy the Deel JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create a Data Access Object for Missive Data using JDBI
A brief overview of creating a SQL Object API for Missive in JDBI.
-
Use Biml to Build SSIS Tasks to Replicate Spark Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Apache Spark SQL to SQL Server.
-
How to publish and share Square Data dashboards with Tableau Server
The CData ODBC driver for Square enables you integrate Square into Tableau dashboards.
-
Connect to SAP Hybris C4C Data in HULFT Integrate
Connect to SAP Hybris C4C as a JDBC data source in HULFT Integrate
-
Connect to Zuora Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Zuora.
-
ETL Gorgias in Oracle Data Integrator
This article shows how to transfer Gorgias into a data warehouse using Oracle Data Integrator.
-
Create Reports with SAP BusinessObjects BI Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP BusinessObjects BI.
-
A PostgreSQL Interface for IBM Cloud Object Storage Data (MySQL Remoting via JDBC)
Use the Remoting features of the IBM Cloud Object Storage JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access Neo4J Data Using Entity Framework
This article shows how to access Neo4J using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Add Smartsheet Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Smartsheet with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Excel Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Excel replication to Apache Kafka.
-
Cosmos DB Reporting in OBIEE with the Cosmos DB JDBC Driver
Deploy the Cosmos DB JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Query Live Cvent Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Cvent directly from the development environment.
-
Connect to and Query Azure Data Lake Storage Data in QlikView over ODBC
Create data visualizations with Azure Data Lake Storage in QlikView.
-
LINQ to Hive 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 Hive Data Provider.
-
How to publish and share Coda Data dashboards with Tableau Server
The CData ODBC driver for Coda enables you integrate Coda into Tableau dashboards.
-
Create eBay Analytics Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time eBay Analytics data access from reports, embedded analytics, and more.
-
Connect to HBase Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Apache HBase.
-
How to connect SharePoint with ActiveCampaign Data through external lists
Provide ActiveCampaign to SharePoint users as an external list.
-
Consume SQL Analysis Services OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SQL Analysis Services feeds that reflect any changes in SAP Lumira.
-
Load Planio Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Planio to a database.
-
How to connect to LDAP Objects from IntelliJ
Integrate connectivity to LDAP with wizards in IntelliJ.
-
Rapidly Develop Postmark-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 Postmark.
-
Integrating OpenCode Terminal with MySQL 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 CData Connect AI to Access Salesforce Marketing Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Salesforce Marketing Cloud in the Power Pivot business intelligence tool.
-
Connect and Visualize Live Sugar CRM Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Sugar CRM into the Databricks platform and create visualization dashboards with real-time Sugar CRM.
-
Getting Started with the CData Power BI Connector for Optimizely
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build Apps with Live Sage Intacct in Adalo using CData Connect AI
Use CData Connect AI to integrate live Sage Intacct into the Adalo platform and build custom mobile and web applications with real-time Sage Intacct.
-
Query LinkedIn Data through ODBC in Node.js
Use node-odbc to execute SQL queries against LinkedIn from Node.js.
-
Access FormSite 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 FormSite.
-
Analyze FTP Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for FTP from Power Pivot. You will use the Table Import Wizard to load FTP Servers. You can visually build the import query or use any SQL supported by the driver.
-
LINQ to Workday 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 Workday Data Provider.
-
Provide OData Services of Clio Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Clio by developing a WCF Service Application.
-
How to create an RPA flow for MailChimp Data in UiPath Studio
Use the MailChimp ODBC Driver to create workflows that access real-time MailChimp without any coding.
-
DataBind Charts to Twilio Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Twilio from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Build PivotalTracker-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live PivotalTracker.
-
Automated Continuous Google Contacts Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Contacts replication to Google Cloud SQL.
-
Replicate Clockify Data to Multiple Databases via the CData Sync CLI
Replicate Clockify to disparate databases with a single configuration.
-
How to Query Live Aircall Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Aircall data in natural language using Python.
-
Build Data Flows from SQL Server to Instagram through SSIS
Easily push SQL Server data to Instagram using the CData SSIS Tasks for Instagram.
-
Create SSAS Tabular Models from MailerSend Data
How to build a SQL Server Analysis Service Tabular Model from MailerSend using CData drivers.
-
How to connect and process Stack Exchange from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Stack Exchange.
-
Integrate ZohoMarketingHub Data in the Pentaho Report Designer
Publish reports based on ZohoMarketingHub in the Pentaho BI tool.
-
Analyze Impala Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Apache Impala with the CData JDBC Driver for Impala.
-
How to connect to Microsoft Dataverse Data from Spring Boot
Connect to Microsoft Dataverse in a Spring Boot Application using the CData JDBC Driver for Microsoft Dataverse
-
Visualize SQL Server Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft SQL Server.
-
Connect to Rebilly Data in HULFT Integrate
Connect to Rebilly as a JDBC data source in HULFT Integrate
-
Connect to SAP Hybris C4C Data from PowerBuilder via JDBC
This article demonstrates how to access SAP Hybris C4C from PowerBuilder using the SAP Hybris C4C JDBC Driver.
-
Integrating Codex CLI with Telegram 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 an OLAP Cube in SSAS from Zoho Inventory Data
Establish a connection to Zoho Inventory data from SQL Server Analysis Services, and use the Zoho Inventory Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Browserless
Provide connectivity to Browserless through an SAP BusinessObjects universe.
-
Connect to Basecamp Data in RapidMiner
Integrate Basecamp with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Vault CRM Data in Google Apps Script via Connect AI
Use CData Connect AI to access Veeva Vault & Vault CRM in Google Apps Script.
-
Build a Singer.io Tap for ClickUp With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ClickUp data using
-
Build Automated SAP Fieldglass-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP Fieldglass and build automated workflows in Zapier.
-
Use Biml to Build SSIS Tasks to Replicate Presto Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Presto to SQL Server.
-
Publish Reports with Mixpanel Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mixpanel.
-
Connect to SAP ByDesign Data from PowerBuilder via JDBC
This article demonstrates how to access SAP Business ByDesign from PowerBuilder using the SAP ByDesign JDBC Driver.
-
Create a Data Access Object for Salesforce Marketing Data using JDBI
A brief overview of creating a SQL Object API for Salesforce Marketing Cloud in JDBI.
-
Connect to Retently Data in Jaspersoft Studio
Execute SQL to remote Retently in Jaspersoft Studio.
-
Prepare, Blend, and Analyze Google Directory Data in Alteryx Designer (Connect AI)
Build workflows to access live Google Directory for self-service data analytics.
-
Create MarkLogic-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to MarkLogic Data from Klipfolio and build custom visualizations using live MarkLogic.
-
Create BambooHR-Connected Nintex Workflows
Use CData Connect AI to connect to BambooHR Data from Nintex Workflow Cloud and build custom workflows using live BambooHR.