CData Software - Knowledge Base
Recent Articles
-
Integrating Amazon S3 Data in Talend Cloud Data Management Platform
Connect Amazon S3 Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Amazon S3.
-
Access Live LaunchDarkly Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate LaunchDarkly into the statistical analysis tools available in SAS JMP. This article shows how to use LaunchDarkly in the Graph Builder and Query Builder.
-
ETL JSON in Oracle Data Integrator
This article shows how to transfer JSON into a data warehouse using Oracle Data Integrator.
-
How to load Clari data into Elasticsearch via Logstash
Introducing a simple method to load Clari data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData Connect AI Python SDK for Confluence
Install the CData Connect AI Python SDK to read and write live Atlassian Confluence with standard DB-API 2.0 Python code.
-
Build Charts with PostgreSQL Data in Clear Analytics
Create dynamic charts and perform analytics based on PostgreSQL in Clear Analytics.
-
Access Spark Data from MySQL in Amazon QuickSight
Connect to Spark and build visualizations of Apache Spark SQL using a MySQL Connection in Amazon QuickSight.
-
Integrate LibreChat with Live Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Zoho Projects from within the chat interface.
-
How to Access Zoho Creator Data Using Entity Framework
This article shows how to access Zoho Creator using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Prepare, Blend, and Analyze Float Data in Alteryx Designer (ODBC)
Build workflows to access live Float for self-service data analytics.
-
A PostgreSQL Interface for Google Calendar Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Calendar JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import Real-Time Redshift Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Amazon Redshift in ColdFusion.
-
How to Query Live Gumroad Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Gumroad data in natural language using Python.
-
Integrate Oracle Eloqua Reporting Data in the Pentaho Report Designer
Publish reports based on Oracle Eloqua Reporting in the Pentaho BI tool.
-
Use Dash to Build to Web Apps on Wave Financial Data
Create Python applications that use pandas and Dash to build Wave Financial-connected web apps.
-
Connect to PolarTeamPro Data as an External Source in Dremio
Use the CData JDBC Driver to connect to PolarTeamPro as an External Source in Dremio.
-
Integrate Live SAP Ariba Source Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP Ariba Source to Blue Prism using the CData ODBC Driver for SAP Ariba Source to create automated workflows for repetitive business tasks.
-
Build Pipedrive Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Pipedrive and build visualizations in Tableau.
-
Use Dash to Build Web Apps on Paylocity Data via CData Connect AI
Build interactive Dash web apps on live Paylocity using pandas and the CData Connect AI Python SDK.
-
Build a Simple VCL Application for Certinia Data
How to build a simple VCL Application to view Certinia in RAD Studio using the CData ODBC Driver for Certinia.
-
Model, Search, and Visualize Live Sage 200 Data in ThoughtSpot
Use CData Connect AI to connect to live Sage 200 for modeling, searching, and visualizing.
-
How to Work with Google Calendar Data in AWS Glue Jobs Using JDBC
Connect to Google Calendar from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Microsoft Teams Replication to MongoDB
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to MongoDB.
-
Import Phoenix Data Using Azure Data Factory
Use CData Connect AI to connect to Phoenix Data from Azure Data Factory and import live Apache Phoenix.
-
Strava Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Strava facts in real time.
-
Connect to Discord Data in NetBeans
Connect to Discord in NetBeans with the data source configuration wizard.
-
Integrate Factorial Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Factorial from Informatica Cloud.
-
Connect and Query Live Google Spanner Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Google Spanner into Databricks
-
Connect to DB2 Data in Aqua Data Studio
Access IBM DB2 from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Consume Google Sheets OData Feeds in PowerBuilder
This article demonstrates how to consume Google Sheets as OData feeds from PowerBuilder using the API Server.
-
Use Claude to Talk to Your SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SAP SuccessFactors LMS for you.
-
Visualize Cassandra 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 Apache Cassandra into TIBCO Spotfire.
-
Query, Visualize, and Share live Greenplum Data in Redash
Use CData Connect AI to connect to live Pivotal GreenPlum in Redash for querying, visualizing, and sharing.
-
Prepare, Blend, and Analyze Slack Data in Alteryx Designer (Connect AI)
Build workflows to access live Slack for self-service data analytics.
-
Access Wave Financial 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 Wave Financial.
-
How to create Jodoo federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Jodoo in MySQL .
-
Connect to SurveyMonkey Data in Claris FileMaker Pro
Use the CData ODBC Driver for SurveyMonkey in FileMaker Pro to connect to SurveyMonkey and work with SurveyMonkey in your FileMaker applications.
-
Publish ClickTime-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ClickTime.
-
Automated Continuous Amazon DynamoDB Replication to Oracle
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to Oracle.
-
Build Gong-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Gong Data and create custom apps in Mendix.
-
Getting Started with the CData ADO.NET Provider for Rebilly
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Analyze Impala Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Apache Impala in Microsoft R Open.
-
Getting Started with the CData Power BI Connector for Telegram
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Perform Batch Operations with MariaDB Data in Apache NiFi
Connect to MariaDB and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Import Real-Time NASA Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use NASA in ColdFusion.
-
Back Up Notion to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Notion data.
-
How to Seamlessly Import Sugar CRM Data into IBM SPSS Modeler
Integrate Sugar CRM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Microsoft Dataverse Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Dataverse (CDS) from Informatica Cloud.
-
Build Apps with Live Adobe Analytics in Adalo using CData Connect AI
Use CData Connect AI to integrate live Adobe Analytics into the Adalo platform and build custom mobile and web applications with real-time Adobe Analytics.
-
Create Odoo-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Odoo Data from OutSystems and build custom enterprise apps using live Odoo ERP.
-
How to Connect to & Open Acumatica Data in Microsoft Excel
This article uses the CData ODBC driver for Acumatica to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
NetSuite Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on NetSuite facts in real time.
-
Automate Spark Data Replication to Azure Data Lake
Use CData Sync to customize and automate Apache Spark SQL replication to Azure Data Lake.
-
Build a Singer.io Tap for SpaceX With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SpaceX data using
-
Prepare, Blend, and Analyze AdRoll Data in Alteryx Designer (ODBC)
Build workflows to access live AdRoll for self-service data analytics.
-
Connect to Intercom Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Intercom to connect to Intercom and execute queries in PowerBuilder.
-
Connect to Facebook Data in CloverDX (formerly CloverETL)
Transfer Facebook using the visual workflow in the CloverDX data integration tool.
-
Create Datasets from Basecamp in Domo Workbench and Build Visualizations of Basecamp Data in Domo
Use the CData Software ODBC Driver for Basecamp to create datasets from Basecamp in Domo Workbench and then build visualizations in the Domo service.
-
Import Real-Time HubDB Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use HubDB in ColdFusion.
-
Integrate Real-Time Access to Facebook Ads in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Facebook Ads in real time.
-
Query Live Email 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 Email directly from the development environment.
-
Getting Started with the CData Excel Add-In for Sybase IQ
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Sybase IQ.
-
Connect to Google Search from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Search to connect to Google Search from Web applications running on WebLogic.
-
Integrate with live Vault CRM Data in Jitterbit
Use CData Connect AI to connect to and integrate live Veeva Vault & Vault CRM in Jitterbit.
-
Import Real-Time Airtable Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Airtable in ColdFusion.
-
Automated Continuous Redis Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Redis replication to Google BigQuery.
-
Connect to Microsoft Teams from a Connection Pool in WebLogic
Use the CData JDBC Driver for Microsoft Teams to connect to Microsoft Teams from Web applications running on WebLogic.
-
Manage Nuclia Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Nuclia.
-
Build Voice Agents in ElevenLabs with access to Live Sage 200 Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Sage 200.
-
Integrate Templated Data in Pentaho Data Integration
Build ETL pipelines based on Templated in the Pentaho Data Integration tool.
-
Connect to SparkPost Data in RapidMiner
Integrate SparkPost with standard components and data source configuration wizards in RapidMiner Studio.
-
How to integrate Contentful with Apache Airflow
Access and process Contentful in Apache Airflow using the CData JDBC Driver.
-
Publish Elorus-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Elorus.
-
Connect to CockroachDB Data from PowerBuilder via JDBC
This article demonstrates how to access CockroachDB from PowerBuilder using the CockroachDB JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Egnyte Data
Use CData Power BI Connectors to visualize Egnyte in Power BI.
-
A PostgreSQL Interface for QuickBooks Online Data using the CData ODBC Driver
Use the SQL Gateway and QuickBooks Online ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Scrapfly Data in Tableau
The CData ODBC driver for Scrapfly enables you integrate Scrapfly into Tableau dashboards.
-
Connect to Clio Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Clio to connect to Clio and execute queries in PowerBuilder.
-
Connect Act CRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Act CRM using the CData Python MCP Server.
-
Build a Simple VCL Application for FHIR Data
How to build a simple VCL Application to view FHIR in RAD Studio using the CData ODBC Driver for FHIR.
-
Create Dashboards and Visualize Live Authorize.Net Data in Geckoboard
Use CData Connect AI to connect to live Authorize.Net and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Semantic Layer Views for Jodoo Data in APOS Live Data Gateway
Use the CData Connector for Jodoo in APOS Live Data Gateway to build Semantic Layer Views for Jodoo.
-
Build MySQL-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for MySQL Data and create custom apps in Bubble.
-
Using the CData Software ODBC Driver for Quaderno in PyCharm
Connect to Quaderno as an ODBC data source in PyCharm using the CData Software ODBC Driver for Quaderno.
-
Build Automated PostgreSQL-Connected Workflows in Zapier
Use CData Connect AI to connect to live PostgreSQL and build automated workflows in Zapier.
-
How to Access Live FormSite Data in Power Automate Desktop via ODBC
The CData ODBC Driver for FormSite enables you to integrate FormSite into workflows built using Microsoft Power Automate Desktop.
-
Query Live Sybase 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 Sybase directly from the development environment.
-
Automated Continuous Sybase IQ Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Sybase IQ replication to Google Cloud SQL.
-
Query Azure Analysis Services Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Azure Analysis Services from Node.js.
-
Connect to Pinecone Data in Ruby
Connect to Pinecone in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Enable the HelloSign JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with HelloSign.
-
Build ActiveCampaign Visualizations in Tableau Desktop
Use CData Connect AI to connect to live ActiveCampaign and build visualizations in Tableau.
-
Automate SuiteCRM Data Replication to Couchbase
Use CData Sync to Customize and automate SuiteCRM replication to Couchbase.
-
Connect and Query Live Oracle Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Oracle Database into Databricks
-
Build Google Search-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Search.
-
Automated Continuous Aweber Replication to Vertica
Use CData Sync for automated, continuous, customizable Aweber replication to Vertica.
-
Access Live BigCommerce Data in AWS Lambda
Connect to live BigCommerce in AWS Lambda using the CData JDBC Driver.
-
LINQ to xBase 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 xBase Data Provider.
-
Automated Continuous SAP HANA XS Advanced Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Apache Kafka.
-
Automated Continuous SurveyMonkey Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Apache Kafka.