CData Software - Knowledge Base
Recent Articles
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Adobe Analytics
Provide connectivity to Adobe Analytics through an SAP BusinessObjects universe.
-
Query YouTube Analytics in DataGrip
Create a Data Source for YouTube Analytics in DataGrip and use SQL to query live YouTube Analytics.
-
Access Live BigCommerce Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live BigCommerce data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to HubDB from a Connection Pool in WebLogic
Use the CData JDBC Driver for HubDB to connect to HubDB from Web applications running on WebLogic.
-
Getting Started with the CData Python Connector for Todoist
Learn to install and license the CData Python Connector
-
How to Connect to & Open SQL Analysis Services in Microsoft Excel
This article uses the CData ODBC driver for SQL Analysis Services to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate ADP into Power Automate Desktop using CData Connect
CData Connect for ADP enables you to integrate ADP into workflows built using Microsoft Power Automate Desktop.
-
Excel Spreadsheet Automation on Adobe Analytics with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Access Live SQL Analysis Services in Coginiti Pro
Connect to and query live SQL Analysis Services from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect and Query Live Acumatica Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Acumatica ERP into Databricks
-
Trigger Adobe Commerce IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Analyze IBM Informix in Cognos Analytics
Use CData Connect AI to connect to IBM Informix from Cognos Analytics and analyze live IBM Informix.
-
Build Charts with Reckon in Clear Analytics
Create dynamic charts and perform analytics based on Reckon in Clear Analytics.
-
Connect to Live Twitter Ads in MicroStrategy through CData Connect AI
Create a live connection to Twitter Ads in CData Connect AI and connect to your Twitter Ads from MicroStrategy.
-
Create Datasets from Sybase IQ in Domo Workbench and Build Visualizations of Sybase IQ in Domo
Use the CData Software ODBC Driver for Sybase IQ to create datasets from Sybase IQ in Domo Workbench and then build visualizations in the Domo service.
-
Access Live MYOB AccountRight in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live MYOB AccountRight through MCP integration.
-
Create Dynamic Oracle Eloqua Grids Using the Infragistics XamDataGrid
Learn how you can connect Oracle Eloqua to Infragistics XamDataGrid to build dynamic grids.
-
Access Live Microsoft Teams in Excel 365 Online (Excel for the web)
Connect to Microsoft Teams from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Power BI Reports on Real-Time SAP
Use the CData ODBC Driver for SAP to visualize SAP ERP/NetWeaver in Power BI Desktop.
-
Access Live Zoho Books in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoho Books from your Google Sheets.
-
Create Informatica Mappings From/To an ODBC Data Source for Authorize.Net
Create an ODBC connection to Authorize.Net in Informatica and browse and transfer Authorize.Net.
-
Build Semantic Layer Views for IBM Informix in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for IBM Informix.
-
Integrate Microsoft Dataverse into Automated Tasks with Power Automate
Use CData Connect AI to connect to Microsoft Dataverse (CDS) and integrate live Microsoft Dataverse (CDS) into your Power Automate tasks.
-
How to integrate Smartsheet with Apache Airflow
Access and process Smartsheet in Apache Airflow using the CData JDBC Driver.
-
Visualize Live SAP Netweaver Gateway of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP Netweaver Gateway using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use JayDeBeApi to access Printify in Python
Use standard Python scripting and the development environment of your choice to access live Printify.
-
How to Query Live SAP Ariba Source Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP Ariba Source data in natural language using Python.
-
Create Informatica Mappings From/To a JDBC Data Source for QuickBooks
Create QuickBooks data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Data Flows from SharePoint to SQL Server using SSIS
Easily back up Microsoft SharePoint to SQL Server using the SSIS components for SharePoint.
-
Automate Oracle Eloqua Replication to Azure Data Lake
Use CData Sync to customize and automate Oracle Eloqua replication to Azure Data Lake.
-
View Reports on Real-Time BambooHR in Power BI Report Server
Use the CData ODBC Driver for BambooHR to visualize BambooHR in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to TaxJar in HULFT Integrate
Connect to TaxJar as a JDBC data source in HULFT Integrate
-
How to connect SharePoint with Monday.com through external lists
Provide Monday.com to SharePoint users as an external list.
-
Connect to HubSpot in Google Apps Script via Connect AI
Use CData Connect AI to access HubSpot in Google Apps Script.
-
Create Aha! Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create a Data Access Object for Aha! using JDBI
A brief overview of creating a SQL Object API for Aha! in JDBI.
-
Connect to Eventbrite in NetBeans
Connect to Eventbrite in NetBeans with the data source configuration wizard.
-
Provide OData Services of GitHub from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for GitHub by developing a WCF Service Application.
-
Prepare, Blend, and Analyze ServiceNow in Alteryx Designer (ODBC)
Build workflows to access live ServiceNow for self-service data analytics.
-
Integrate xBase in the Pentaho Report Designer
Publish reports based on xBase in the Pentaho BI tool.
-
Automated Continuous Azure Active Directory Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Azure Active Directory replication to Azure SQL Database.
-
Create Apps from Google Sheets in Qlik Sense Cloud
Use CData Connect AI to connect to Google Sheets and build apps from live Google Sheets in Qlik Sense Cloud.
-
Build Dashboards with QuickBooks Online in DBxtra
Create dynamic dashboards and perform analytics based on QuickBooks Online in DBxtra.
-
How to publish and share Jira Assets dashboards with Tableau Server
The CData ODBC driver for Jira Assets enables you integrate Jira Assets into Tableau dashboards.
-
Build Semantic Layer Views for Couchbase in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Couchbase.
-
Create Adobe Commerce Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Adobe Commerce data access from reports, embedded analytics, and more.
-
How to update Odoo from Excel
This article explains how to transfer data from Excel to Odoo using the Excel Add-In for Odoo.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Raisers Edge NXT
Provide connectivity to Raisers Edge NXT through an SAP BusinessObjects universe.
-
Integrating Gumloop with YouTube Analytics via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on YouTube Analytics within automated workflows.
-
Bridge Pinterest Connectivity with Apache NiFi
Access and process Pinterest in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Stripe Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Stripe replication to Google Cloud SQL.
-
Use JayDeBeApi to access Zoom in Python
Use standard Python scripting and the development environment of your choice to access live Zoom.
-
Viewing Salesloft in RAD Studio Data Explorer
How to view Salesloft in RAD Studio Data Explorer using the CData ODBC Driver for Salesloft.
-
Access Live Couchbase in Coginiti Pro
Connect to and query live Couchbase from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use Dash to Build to Web Apps on Google Sheets
Create Python applications that use pandas and Dash to build Google Sheets-connected web apps.
-
Import and Visualize Amazon DynamoDB in Power View
Create data visualizations based on Amazon DynamoDB in Excel.
-
Create Amazon Athena-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Amazon Athena from OutSystems and build custom enterprise apps using live Amazon Athena.
-
Create Informatica Mappings From/To an ODBC Data Source for Highrise
Create an ODBC connection to Highrise in Informatica and browse and transfer Highrise CRM.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Azure SQL Database.
-
Use the CData ODBC Driver for SharePoint Excel Services in Microsoft Power Query
You can use the CData SharePoint Excel Services ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SharePoint Excel Services into Microsoft Power Query.
-
How to create an RPA flow for SAP HANA in UiPath Studio
Use the SAP HANA ODBC Driver to create workflows that access real-time SAP HANA without any coding.
-
Connect to Live Azure Table in MicroStrategy through CData Connect AI
Create a live connection to Azure Table in CData Connect AI and connect to your Azure Table Storage from MicroStrategy.
-
Create Paylocity-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Paylocity from OutSystems and build custom enterprise apps using live Paylocity.
-
How to Use a Microsoft Access Database to Update Bullhorn CRM in Real Time
Update Bullhorn CRM data by creating a linked table in Microsoft Access with the CData Bullhorn CRM ODBC Driver.
-
How to create Visio diagrams from Lakebase
Automatically update Lakebase with the changes you make to Visio master shapes.
-
Add Splunk to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Splunk with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData Software ODBC Driver for Neo4J in MicroStrategy Web
Connect to Neo4J in MicroStrategy Web using the CData Software ODBC Driver for Neo4J.
-
Explore Geographical Relationships in MySQL with Power Map
Create data visualizations with MySQL in Power Map.
-
SAP Hybris C4C Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP Hybris C4C through CData Connect AI using different applications and tools.
-
Query Google Contacts from Node.js
Use the OData endpoint of the CData API Server to connect to your Google Contacts and perform CRUD operations on Google Contacts from Node.js.
-
Integrate Live Epicor Kinetic into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Epicor Kinetic from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Epicor Kinetic.
-
Connect to Google Spanner in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Spanner in the Denodo Virtual DataPort Administrator.
-
How to work with YouTube Analytics in Apache Spark using SQL
Access and process YouTube Analytics in Apache Spark using the CData Software JDBC Driver.
-
Use Dash to Build to Web Apps on CouchDB
Create Python applications that use pandas and Dash to build CouchDB-connected web apps.
-
Connect to Real-Time HubSpot Data in Power Apps Using Dataflows to Build Custom Applications
-