CData Software - Knowledge Base
Recent Articles
-
Analyze MongoDB in Cognos Analytics
Use CData Connect AI to connect to MongoDB from Cognos Analytics and analyze live MongoDB.
-
Access Live SAP Hybris C4C in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP Hybris C4C into the statistical analysis tools available in SAS JMP. This article shows how to use SAP Hybris C4C in the Graph Builder and Query Builder.
-
Integrating Gumloop with Microsoft Teams via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft Teams within automated workflows.
-
How to Connect to Live Spark in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Apache Spark SQL without replication.
-
How to use SQLAlchemy ORM to access Sugar CRM in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sugar CRM.
-
Create Power BI Reports on Real-Time Tableau CRM Analytics
Use the CData ODBC Driver for Tableau CRM Analytics to visualize Tableau CRM Analytics in Power BI Desktop.
-
How to Visualize Salesforce Data in Python with pandas
Use pandas and other modules to analyze and visualize live Salesforce & Force.com in Python.
-
Visualize Amazon DynamoDB from Tableau
Use the Tableau Desktop business intelligence tool to connect to Amazon DynamoDB.
-
Getting Started with the CData Python Connector for Cassandra
Learn to install and license the CData Python Connector
-
Create a Data Access Object for Gmail using JDBI
A brief overview of creating a SQL Object API for Gmail in JDBI.
-
How to Access Live Azure Data Catalog in Power Automate Desktop via ODBC
The CData ODBC Driver for Azure Data Catalog enables you to integrate Azure Data Catalog into workflows built using Microsoft Power Automate Desktop.
-
How to Use a Microsoft Access Database to Update Oracle Service Cloud in Real Time
Update Oracle Service Cloud data by creating a linked table in Microsoft Access with the CData Oracle Service Cloud ODBC Driver.
-
Build Agents in Relevance AI with Access to Live Hive via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Apache Hive within intelligent agent workflows.
-
Bind Live JotForm Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live JotForm data
-
Hive Reporting in OBIEE with the Hive JDBC Driver
Deploy the Hive JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Freshdesk from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Freshdesk to connect to Freshdesk and execute queries in PowerBuilder.
-
Configure the CData JDBC Driver for Airtable in a Connection Pool in Tomcat
Connect to Airtable from a connection pool in Tomcat.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Google BigQuery.
-
A PostgreSQL Interface for Snowflake using the CData ODBC Driver
Use the SQL Gateway and Snowflake ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create NetSuite-Connected Dashboards in Grafana
Connect to NetSuite via CData Connect AI in Grafana and create custom business dashboards with real-time access to NetSuite CRM & ERP.
-
DataBind Adobe Experience Manager to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Adobe Experience Manager with the DevExpress Windows Forms and Web controls to provide Adobe Experience Manager to a chart.
-
Build Charts with Slack in Clear Analytics
Create dynamic charts and perform analytics based on Slack in Clear Analytics.
-
Use the CData Software JDBC Driver for xBase in MicroStrategy Desktop
Connect to xBase in MicroStrategy Desktop using the CData Software JDBC Driver for xBase.
-
Prepare, Blend, and Analyze HubSpot in Alteryx Designer (ODBC)
Build workflows to access live HubSpot for self-service data analytics.
-
Build Visualizations of QuickBooks in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of QuickBooks Desktop in Birst.
-
Query Access through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft Access from Node.js.
-
Integrate Microsoft Project in the Pentaho Report Designer
Publish reports based on Microsoft Project in the Pentaho BI tool.
-
Query Databricks as a SQL Server Database in Node.js
Execute SQL Server queries against Databricks from Node.js.
-
Explore Geographical Relationships in Drift with Power Map
Create data visualizations with Drift in Power Map.
-
Natively Connect to SurveyMonkey in PHP
The CData ODBC driver for SurveyMonkey enables you to create PHP applications with connectivity to SurveyMonkey. Leverage the native support for ODBC in PHP.
-
Connect to GitHub from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live GitHub from Filemaker Pro on Mac.
-
Oracle HCM Cloud Reporting in OBIEE with the Oracle HCM Cloud JDBC Driver
Deploy the Oracle HCM Cloud JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Load SharePoint to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft SharePoint to a database.
-
Use JayDeBeApi to access OneNote in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft OneNote.
-
Import MariaDB into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access MariaDB. In this article, you will use the OData format to import MariaDB into Microsoft Power Query.
-
PowerShell Scripting to Replicate MarkLogic to MySQL
Write a simple PowerShell script to replicate MarkLogic to a MySQL database.
-
Connect to Salesloft in the Denodo Platform
Use CData driver technologies to create a virtual data source for Salesloft in the Denodo Virtual DataPort Administrator.
-
Access Live Power BI XMLA in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Power BI XMLA from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
A PostgreSQL Interface for OneNote (MySQL Remoting via JDBC)
Use the Remoting features of the OneNote JDBC Driver to create a PostgreSQL entry-point for data access.
-
Work with Live SAP HANA in Power Query
Use CData Connect AI to connect to SAP HANA and work with live SAP HANA in Microsoft Power Query.
-
Rapidly Develop SAP Ariba Source-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Build Visualizations of Adobe Analytics in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Adobe Analytics in Birst.
-
How to connect and process Sybase IQ from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Sybase IQ.
-
Migrating data from SAP to Snowflake using CData SSIS Components.
Easily push SAP ERP/NetWeaver to Snowflake using the CData SSIS Tasks for SAP and Snowflake.
-
Query Sage Cloud Accounting as a MySQL Database in Node.js
Execute MySQL queries against Sage Business Cloud Accounting from Node.js.
-
Build Monday.com-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Monday.com and create custom apps in Mendix.
-
Replicate Marketo to Multiple Databases via the CData Sync CLI
Replicate Marketo to disparate databases with a single configuration.
-
Add Avalara AvaTax to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Avalara AvaTax with the Informatica Enterprise Data Catalog to classify and organize data.
-
Add Office 365 to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Office 365 with the Informatica Enterprise Data Catalog to classify and organize data.
-
Natively Connect to Jira in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Atlassian Jira. Leverage the native support for ODBC in PHP.
-
Automated Continuous Dynamics CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to delimited files (CSV/TSV).
-
DataBind Controls to Sage Intacct in C++Builder
DataBind to Sage Intacct in C++Builder with standard components and controls.
-
Visualize Live Kintone in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Kintone.
-
Access Live SAP Business One in AWS Lambda
Connect to live SAP Business One in AWS Lambda using the CData JDBC Driver.
-
Object-Relational Mapping (ORM) with MySQL 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 MySQL into a Java-based ORM framework, Hibernate.
-
Getting Started with the CData ADO.NET Provider for JSON
-