CData Software Knowledge Base

Connect to SAP Ariba Source from PowerBuilder via ODBC

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

Analyze Acumatica in Infragistics Reveal

Use CData Connect Cloud to create on OData API on top of Acumatica ERP and visualize live Acumatica ERP in Infragistics Reveal.

Connect to SAP Netweaver Gateway in CloverDX (formerly CloverETL)

Transfer SAP Netweaver Gateway using the visual workflow in the CloverDX data integration tool.

Create Data Visualizations in Cognos BI with Twitter

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

Connect to GitHub in Jaspersoft Studio

Execute SQL to remote GitHub in Jaspersoft Studio.

How to Access Live Impala in Visual Studio Code via Cline

Run the CData MCP Server for Impala on Windows Subsytem for Linux (WSL) and connect to live Apache Impala from the Cline extension in Visual Studio Code.

Build Coinbase-Connected Web Apps in Servoy

Use Servoy Developer to easily connect to Coinbase and build web apps with connectivity to live Coinbase.

Connect to SAP SuccessFactors from a Connection Pool in JBoss

Integrate SAP SuccessFactors into Java servlets: Use the Management Console in JBoss to install the SAP SuccessFactors JDBC Driver.

Access Live Salesforce in Excel (Desktop) through Connect Spreadsheets

Use Connect Spreadsheets by CData to gain access to live Salesforce & Force.com from your Excel spreadsheets.

Import Amazon DynamoDB Using Azure Data Factory

Use CData Connect Cloud to connect to Amazon DynamoDB from Azure Data Factory and import live Amazon DynamoDB.

Use JayDeBeApi to access Slack in Python

Use standard Python scripting and the development environment of your choice to access live Slack.

View Reports on Real-Time Adobe Analytics in Power BI Report Server

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

Demo: Migrate Data from Salesforce to SharePoint

CData Data Providers offer a wide range of uses, including the ability to migrate data between sources quickly. Download this demo that helps you transfer Salesforce.com data into SharePoint.

Build Workday-Connected Apps in Mendix

Use CData Connect Cloud to create an OData feed for Workday and create custom apps in Mendix.

Connect to Azure Analysis Services as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for Azure Analysis Services.

Connect Zoom to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

Connect to your Zoom using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

How to Connect to Jira Service Management in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Atlassian Jira Service Management. Leverage the pyodbc module for ODBC in Python.

Create Data Visualizations in Cognos BI with Salesforce Data Cloud

Access Salesforce Data Cloud as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Use the CData Software ODBC Driver for QuickBooks Online in SAS for Real-Time Reporting and Analytics

Connect to real-time QuickBooks Online in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for QuickBooks Online.

Create Reports from Redis in Looker Studio

Use CData Connect Cloud to gain access to live Redis and create custom reports in Looker Studio.

Bidirectional Access to JotForm from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate JotForm in Filemaker Pro for Mac or Windows.

Visualize Elasticsearch in TIBCO Spotfire through OData

Integrate Elasticsearch into dashboards in TIBCO Spotfire.

Build Microsoft Dataverse-Connected Dashboards Using Zoho Analytics

Use CData Connect Cloud to connect to Microsoft Dataverse from Zoho Analytics and import live Microsoft Dataverse (CDS).

How to Work with ShipStation in AWS Glue Jobs Using JDBC

Connect to ShipStation from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

How to create Quickbase federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Quickbase in MySQL .

Model, Search, and Visualize Live Active Directory in ThoughtSpot

Use CData Connect Cloud to connect to live Active Directory for modeling, searching, and visualizing.

Prepare, Blend, and Analyze Salesforce Marketing in Alteryx Designer (ODBC)

Build workflows to access live Salesforce Marketing Cloud for self-service data analytics.

Integrate Dropbox in the Pentaho Report Designer

Publish reports based on Dropbox in the Pentaho BI tool.

How to import FHIR into Apache Solr

Use the CData Software JDBC Driver for FHIR in Data Import Handler and create an automated import of FHIR to Apache Solr Enterprise Search platform.

How to Connect DBeaver to TaxJar via a JDBC Driver

Manage TaxJar with visual tools in DBeaver like the query browser.

Perform Batch Operations with Microsoft Teams in Apache NiFi

Connect to Microsoft Teams and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

Connect to Greenhouse in Google Apps Script via SQL Gateway

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

How to load SurveyMonkey data into Elasticsearch via Logstash

Introducing a simple method to load SurveyMonkey data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

How to connect SharePoint with Printful through external lists

Provide Printful to SharePoint users as an external list.

Automated Continuous Square Replication to Microsoft Access

Use CData Sync for automated, continuous, customizable Square replication to Microsoft Access.

Build Automated Workflows with Live Azure Table in Workato

Use CData Connect Cloud to connect to live Azure Table Storage and build automated workflows in Workato.

Query Microsoft Project in DataGrip

Create a Data Source for Microsoft Project in DataGrip and use SQL to query live Microsoft Project.

How to publish and share QuickBooks dashboards with Tableau Server

The CData ODBC driver for QuickBooks enables you integrate QuickBooks Desktop into Tableau dashboards.

Query Workday from Node.js

Use the OData endpoint of the CData API Server to connect to your Workday and perform CRUD operations on Workday from Node.js.

How to connect PolyBase to Oracle Service Cloud

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Oracle Service Cloud.

Use the CData Software JDBC Driver for HubSpot in MicroStrategy

Connect to HubSpot in MicroStrategy Developer using the CData Software JDBC Driver for HubSpot.

Create Data Visualizations Based On SAP HANA in Mode

Use CData Connect Cloud to connect to SAP HANA from Mode and build visualizations using live

How to connect to Calendly with Squirrel SQL client

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

Rapidly Develop Google Directory-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.

Extract, Transform, and Load SuiteCRM in Informatica PowerCenter

Create a simple Workflow for SuiteCRM in Informatica PowerCenter.

PowerShell Scripting to Replicate Teradata to MySQL

Write a simple PowerShell script to replicate Teradata to a MySQL database.

Analyze Printful with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Printful from Power Pivot. You will use the Table Import Wizard to load Printful. You can visually build the import query or use any SQL supported by the driver.

CData Software - Knowledge Base

Recent Articles