CData Software Knowledge Base

A PostgreSQL Interface for Pinterest using the CData ODBC Driver

Use the SQL Gateway and Pinterest ODBC Driver to create a PostgreSQL entry-point for data access.

Connect to Shippo from PowerBuilder via ODBC

This article demonstrates how to use the CData ODBC Driver for Shippo to connect to Shippo and execute queries in PowerBuilder.

Connect to Google Ad Manager in Aqua Data Studio

Access Google Ad Manager from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

Automated Continuous Dynamics CRM Replication to SQL Server

Use CData Sync for automated, continuous, customizable Dynamics CRM replication to SQL Server.

Connect to Veeva Vault in SpagoBI

Create reports featuring live Veeva Vault & Vault CRM in SpagoBI Studio. Host Veeva Vault reports on SpagoBI Server.

Create Apps from Zoho Books in Qlik Sense Cloud

Use CData Connect Cloud to connect to Zoho Books and build apps from live Zoho Books in Qlik Sense Cloud.

LDAP Reporting in OBIEE with the LDAP JDBC Driver

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

Create Dynamic SAS xpt Grids Using the Infragistics XamDataGrid

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

Import Amazon DynamoDB into FileMaker Pro

Create reports that integrate Amazon DynamoDB in Filemaker Pro.

How to Connect to Tableau CRM Analytics in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Tableau CRM Analytics. Leverage the pyodbc module for ODBC in Python.

How to Access AlloyDB Using Entity Framework

This article shows how to access Google AlloyDB using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

Integrate Okta in Pentaho Data Integration

Build ETL pipelines based on Okta in the Pentaho Data Integration tool.

Automated Continuous Jira Service Management Replication to OneLake in Microsoft Fabric

Use CData Sync for automated, continuous, customizable Atlassian Jira Service Management replication to OneLake in Microsoft Fabric.

Connect to Google Ads in SpagoBI

Create reports featuring live Google Ads in SpagoBI Studio. Host Google Ads reports on SpagoBI Server.

Create Dropbox Reports on JasperReports Server

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

Visualize Live BigCommerce in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live BigCommerce.

How to Connect to & Open AlloyDB in Microsoft Excel

This article uses the CData ODBC driver for AlloyDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

Integrate Live Odoo into Custom Business Apps Built in Power Apps

Use CData Connect Cloud to connect to Odoo ERP and integrate live Odoo ERP into apps built in Microsoft Power Apps.

Build Google Sheets-Connected Apps in Bubble

Use CData Connect Cloud to create an OData feed for Google Sheets and create custom apps in Bubble.

Automated Continuous Printful Replication to PostgreSQL

Use CData Sync for automated, continuous, customizable Printful replication to PostgreSQL.

Connect to IBM Cloud Object Storage in JRuby

Create a simple JRuby app with access to live IBM Cloud Object Storage.

How to connect to Couchbase with Squirrel SQL client

Connect to Couchbase and execute queries in the Squirrel SQL Client.

Create Zuora-Connected Enterprise Applications in OutSystems

Use CData Connect Cloud to connect to Zuora from OutSystems and build custom enterprise apps using live Zuora.

Build Automated Workflows with Live Slack in Workato

Use CData Connect Cloud to connect to live Slack and build automated workflows in Workato.

Use the CData ODBC Driver for Email in Microsoft Power Query

You can use the CData Email ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Email into Microsoft Power Query.

Use the CData Software ODBC Driver for Printify in MicroStrategy Desktop

Connect to Printify in MicroStrategy Desktop using the CData Software ODBC Driver for Printify.

Connect to FHIR in Aqua Data Studio

Access FHIR from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

How to create Dynamics 365 Business Central federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Dynamics 365 Business Central in MySQL .

Replicate Asana from PowerShell

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

Connect to HBase in Jaspersoft Studio

Execute SQL to remote Apache HBase in Jaspersoft Studio.

Replicate Dynamics GP to Multiple Databases via the CData Sync CLI

Replicate Microsoft Dynamics GP to disparate databases with a single configuration.

Excel Spreadsheet Automation on Tally with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Query QuickBooks Time in DataGrip

Create a Data Source for QuickBooks Time in DataGrip and use SQL to query live QuickBooks Time.

Automated Continuous Google Ad Manager Replication to SQLite

Use CData Sync for automated, continuous, customizable Google Ad Manager replication to SQLite.

Build Semantic Layer Views for Workday in APOS Live Data Gateway

Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Workday.

Automated Continuous SendGrid Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable SendGrid replication to Google Cloud SQL.

Process & Analyze SAP Concur in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Concur .

Connect to Procore in DBArtisan

Use wizards in DBArtisan to configure Procore as a data source.

Automated Calendly Replication to Teradata

Use CData Sync to Customize and automate Calendly replication to Teradata.

Connect to Live SAP Business One in MicroStrategy through CData Connect Cloud

Create a live connection to SAP Business One in CData Connect Cloud and connect to your SAP Business One from MicroStrategy.

How to Query Sugar CRM in MySQL Workbench

Execute MySQL queries against live Sugar CRM from MySQL Workbench.

Stream MarkLogic into Apache Kafka Topics

Access and stream MarkLogic in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

Connect to ClickUp in DBeaver

Use the CData ODBC Driver to connect to ClickUp in DBeaver.

Automated Continuous Raisers Edge NXT Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Google Cloud SQL.

A PostgreSQL Interface for Highrise using the CData ODBC Driver

Use the SQL Gateway and Highrise ODBC Driver to create a PostgreSQL entry-point for data access.

How to use SQLAlchemy ORM to access Klaviyo in Python

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

CData Software - Knowledge Base

Recent Articles