CData Software Knowledge Base

How to Access Live Unbounce in Power Automate Desktop via ODBC

The CData ODBC Driver for Unbounce enables you to integrate Unbounce into workflows built using Microsoft Power Automate Desktop.

Model, Search, and Visualize Live Epicor Kinetic in ThoughtSpot

Use CData Connect Cloud to connect to live Epicor Kinetic for modeling, searching, and visualizing.

How to integrate Metabase with Active Directory

Use CData Connect Cloud to connect to live Active Directory and create an interactive dashboard in Metabase from Active Directory.

Integrate Oracle SCM into Automated Tasks with Power Automate

Use CData Connect Cloud to connect to Oracle SCM and integrate live Oracle SCM into your Power Automate tasks.

Connect to Act CRM from HeidiSQL

Use CData Connect Cloud to connect to and query live Act CRM from HeidiSQL.

Create SAS Data Sets Reports on JasperReports Server

Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAS Data Sets data access from reports, embedded analytics, and more.

Import Google Sheets into the Power BI Service for Visualizations

Use CData Connect Cloud to connect to Google Sheets and provide access to live Google Sheets for custom reports in the Power BI Service.

Build Visualizations of ConstantContact in Birst

Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ConstantContact in Birst.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for PingOne

Provide connectivity to PingOne through an SAP BusinessObjects universe.

Create Amazon S3-Connected Nintex Workflows

Use CData Connect Cloud to connect to Amazon S3 from Nintex Workflow Cloud and build custom workflows using live Amazon S3.

Create Pinterest-Connected Business Apps in AppSheet

Use CData Software Connect Server to connect to Pinterest from AppSheet and build custom business apps using live Pinterest.

Using the CData Software ODBC Driver for Avro in PyCharm

Connect to Avro as an ODBC data source in PyCharm using the CData Software ODBC Driver for Avro.

How to use SQLAlchemy ORM to access MariaDB in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of MariaDB.

Create Data Visualizations in Cognos BI with SharePoint Excel Services

Access SharePoint Excel Services as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

DataBind Kintone to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Kintone with the DevExpress Windows Forms and Web controls to provide Kintone to a chart.

Automated Continuous QuickBooks Online Replication to Apache Cassandra

Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Apache Cassandra.

View Reports on Real-Time Box in Power BI Report Server

Use the CData ODBC Driver for Box to visualize Box in Power BI Desktop and then publish them to Power BI Report Server.

Integrate with Cosmos DB in JReport Designer

Create charts and reports based on Azure Cosmos DB in JReport Designer.

How to Work with FTP in ETL Validator JDBC

Connect to FTP from ETL Validator jobs using the CData Software JDBC Driver.

Publish ActiveCampaign-Connected Dashboards in Tableau Server via JDBC

Use CData JDBC drivers and Tableau Server to visualize live ActiveCampaign.

Replicate Clio from PowerShell

Write a quick PowerShell script to query Clio. Use connectivity to the live data to replicate Clio to SQL Server.

Choosing the Best Method to Connect Epicor Kinetic to SQL Server: 5 Options Explained

Discover multiple ways to connect and use Epicor Kinetic from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

Connect to Reckon as an External Data Source using PolyBase

Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Reckon.

ADP Reporting in OBIEE with the ADP JDBC Driver

Deploy the ADP JDBC driver on OBIEE to provide real-time reporting across the enterprise.

Automated Continuous Drip Replication to Amazon S3

Use CData Sync for automated, continuous, customizable Drip replication to Amazon S3.

Query Excel in ColdFusion

Write standard ColdFusion data access code to connect to Microsoft Excel.

How to Build Dynamic React Apps with Dynamics NAV

Use the CData Connect and React to Build Dynamic Web Apps with Live Dynamics NAV .

Create Dynamic xBase Grids Using the Infragistics XamDataGrid

Learn how you can connect xBase to Infragistics XamDataGrid to build dynamic grids.

Connect to eBay Analytics in DBArtisan

Use wizards in DBArtisan to configure eBay Analytics as a data source.

Replicate Oracle Eloqua from PowerShell

Write a quick PowerShell script to query Oracle Eloqua. Use connectivity to the live data to replicate Oracle Eloqua to SQL Server.

Build Interactive Dashboards from SAP Fieldglass in Amazon QuickSight

Create a virtual SQL Server database for SAP Fieldglass in CData Software Connect Server and import SAP Fieldglass into Amazon QuickSight SPICE to build interactive dashboards.

Query CouchDB through ODBC in Node.js

Use node-odbc to execute SQL queries against Apache CouchDB from Node.js.

Integrate with Live ADP in MuleSoft (via CData Connect Cloud)

Use CData Connect Cloud to connect to ADP from the MuleSoft Anypoint Platform to integrate live ADP into custom reports and dashboards.

Build an OLAP Cube in SSAS from SurveyMonkey

Establish a connection to SurveyMonkey data from SQL Server Analysis Services, and use the SurveyMonkey Data Provider to build OLAP cubes for use in analytics and reporting.

Connect to OData from a Connection Pool in WebLogic

Use the CData JDBC Driver for OData to connect to OData from Web applications running on WebLogic.

Connect to WordPress in RunMyProcess through Connect Cloud

Use CData Connect Cloud to create on OData API for WordPress and connect to WordPress in Akorbi Digital RunMyProcess.

Connect to Elasticsearch in Google Apps Script via SQL Gateway

Use the ODBC Driver for Elasticsearch and the SQL Gateway to access Elasticsearch from Google Apps Script.

Connect to ClickUp in CloverDX (formerly CloverETL)

Transfer ClickUp using the visual workflow in the CloverDX data integration tool.

Connect to Box in Google Apps Script via SQL Gateway

Use the ODBC Driver for Box and the SQL Gateway to access Box from Google Apps Script.

Automated Continuous Harvest Replication to OneLake in Microsoft Fabric

Use CData Sync for automated, continuous, customizable Harvest replication to OneLake in Microsoft Fabric.

Author and Share Power BI Reports on Real-Time Google Sheets

Use the CData ODBC Driver for Google Sheets to visualize Google Sheets in Power BI Desktop and then upload to the Power BI service.

Manage Google Contacts in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Google Contacts.

Extract, Transform, and Load Act CRM in Informatica PowerCenter

Create a simple Workflow for Act CRM in Informatica PowerCenter.

Create Apps from Dynamics GP in Qlik Sense Cloud

Use the CData Connect Server to create an OData API for Microsoft Dynamics GP and build apps from live Microsoft Dynamics GP in Qlik Sense Cloud.

Create SSAS Tabular Models from SAP Netweaver Gateway

How to build a SQL Server Analysis Service Tabular Model from SAP Netweaver Gateway using CData drivers.

How to create Visio diagrams from Wave Financial

Automatically update Wave Financial with the changes you make to Visio master shapes.

CData Software - Knowledge Base

Recent Articles