CData Software Knowledge Base

Integrate Amazon S3 in Pentaho Data Integration

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

Connect to Excel Online from a Connection Pool in Jetty

The Excel Online JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Excel Online from Web apps in Jetty.

How to Connect the Power BI Service to Workday: Complete Guide

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

Automated Continuous Power BI XMLA Replication to AlloyDB

Use CData Sync for automated, continuous, customizable Power BI XMLA replication to AlloyDB.

Natively Connect to Zendesk in PHP

The CData ODBC driver for Zendesk enables you to create PHP applications with connectivity to Zendesk. Leverage the native support for ODBC in PHP.

Analyze Shippo in R via ODBC

Create data visualizations and use high-performance statistical functions to analyze Shippo in Microsoft R Open.

Deploy the ADO.NET Provider for Parquet on an SSRS Report Server

Connect to Apache Parquet from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

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

Provide connectivity to Twitter through an SAP BusinessObjects universe.

Manage ConstantContact in DBArtisan as a JDBC Source

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

Integrate Reckon Accounts Hosted in the Pentaho Report Designer

Publish reports based on Reckon Accounts Hosted in the Pentaho BI tool.

Parquet Reporting and Star Schemas in OBIEE

Create a star schema that shows perspectives on Parquet facts in real time.

Query Bitbucket in DataGrip

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

Provide OData Services of Stripe from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Stripe by developing a WCF Service Application.

Replicate Avro from PowerShell

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

Connect to Pipedrive as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for Pipedrive.

Bidirectional Access to Email from FileMaker Pro

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

Automated Continuous Google Ad Manager Replication to MongoDB

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

Create Reports with MySQL in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date MySQL.

Integrate Dynamics CRM in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Dynamics CRM from Informatica Cloud.

Automated Continuous Bullhorn CRM Replication to Microsoft Access

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

Write a Simple Go Application to work with Adobe Analytics on Linux

Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Adobe Analytics.

Build Semantic Layer Views for Impala in APOS Live Data Gateway

Use the CData Connector for Impala in APOS Live Data Gateway to build Semantic Layer Views for Apache Impala.

Feed BigCommerce into FineReport

How to set BigCommerce as a JDBC data source in FineReport.

How to update Salesforce from Excel

This article explains how to transfer data from Excel to Salesforce using the Excel Add-In for Salesforce.

Working with Bullhorn CRM in LINQPad

Execute LINQ queries to Bullhorn CRM in LINQPad.

Extend Google Sheets with Kintone

Make calls to the API Server from Google Apps Script.

Automate Bitbucket Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Bitbucket from PowerShell? This article demonstrates how to utilize the Bitbucket Cmdlets for tasks like connecting to Bitbucket, automating operations, downloading data, and more.

How to Use a Microsoft Access Database to Update SQL Server in Real Time

Update SQL Server data by creating a linked table in Microsoft Access with the CData SQL Server ODBC Driver.

Operational Reporting on BambooHR from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote BambooHR.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Data Catalog

Provide connectivity to Google Data Catalog through an SAP BusinessObjects universe.

How to integrate Metabase with Oracle Financials Cloud

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

How to Import Data from SurveyMonkey into Google Sheets

Import SurveyMonkey into a Google spreadsheet that is automatically refreshed.

Automated Continuous Oracle HCM Cloud Replication to SQLite

Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to SQLite.

How to connect to CSV with Squirrel SQL client

Connect to CSV/TSV Files and execute queries in the Squirrel SQL Client.

Connect to PayPal from a Connection Pool in WebLogic

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

Analyze QuickBooks Time in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of QuickBooks Time and visualize QuickBooks Time in SAP Analytics Cloud.

Publish NetSuite-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live NetSuite CRM & ERP.

Replicate Azure Active Directory to Multiple Databases via the CData Sync CLI

Replicate Azure Active Directory to disparate databases with a single configuration.

Create Tableau CRM Analytics-Connected Enterprise Applications in OutSystems

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

Access Live GraphQL in SAS JMP via ODBC

You can use the CData ODBC Driver to integrate GraphQL into the statistical analysis tools available in SAS JMP. This article shows how to use GraphQL in the Graph Builder and Query Builder.

Automated Continuous eBay Analytics Replication to Microsoft Access

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

Use the CData Software JDBC Driver for HubDB in MicroStrategy

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

Connect to Redshift through External Services in Salesforce

Use CData Connect Cloud to securely connect Salesforce External Services with Redshift using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

How to use SQLAlchemy ORM to access Microsoft Exchange in Python

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

Migrating data from Amazon DynamoDB to Google BigQuery using CData SSIS Components.

Easily push Amazon DynamoDB to Google BigQuery using the CData SSIS Tasks for Amazon DynamoDB and Google BigQuery.

Connect to WordPress in CloverDX (formerly CloverETL)

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

Build Pipelines with Live PayPal in Google Cloud Data Fusion (via CData Connect Cloud)

Use CData Connect Cloud to connect to PayPal from Google Cloud Data Fusion, enabling the integration of live PayPal into the building and management of effective data pipelines.

Analyze Live Power BI XMLA in SAS Viya

Use CData Connect Cloud to connect to Power BI XMLA from SAS Viya and deploy self-service analytics using live Power BI XMLA.

How to Access Azure Table Using Entity Framework

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

Deploy the ADO.NET Provider for xBase on an SSRS Report Server

Connect to xBase from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

Build Visualizations of xBase in Birst

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

Create a Data Access Object for REST using JDBI

A brief overview of creating a SQL Object API for REST in JDBI.

How to connect to LinkedIn Ads in DBVisualizer

Integrate LinkedIn Ads with visual data analysis tools and data connection wizards in DBVisualizer

How to use SQLAlchemy ORM to access Cassandra in Python

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

Visualize Live Greenplum in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live Pivotal GreenPlum into custom reports in Power BI.

Automated Continuous JotForm Replication to Microsoft Access

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

PingOne Reporting in OBIEE with the PingOne JDBC Driver

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

How to connect to Google Campaign Manager 360 from Spring Boot

Connect to Google Campaign Manager 360 in a Spring Boot Application using CData JDBC Google Campaign Manager 360 Driver

Access Live Google Campaign Manager 360 in SAS JMP via ODBC

You can use the CData ODBC Driver to integrate Google Campaign Manager 360 into the statistical analysis tools available in SAS JMP. This article shows how to use Google Campaign Manager 360 in the Graph Builder and Query Builder.

Import eBay Analytics into Microsoft Power Query

The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access eBay Analytics. In this article, you will use the OData format to import eBay Analytics into Microsoft Power Query.

Connect to HarperDB in CloverDX (formerly CloverETL)

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

How to Seamlessly Import Email Data into IBM SPSS Modeler

Integrate Email data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

CData Software - Knowledge Base

Recent Articles