Oracle Service Cloud Data Cloud Connectivity

Explore a compilation of guides and tutorials demonstrating how to establish connections to Oracle Service Cloud data through CData Connect Cloud using different applications and tools.

CData Connect Cloud provides access to Oracle Service Cloud data from popular BI, analytics, ETL, and custom applications. In addition to pre-built client tools, CData Connect Cloud enables direct real-time bi-directional integration from a wide range of cloud applications. Below you will find a list of guides and tutorials for integrating with live Oracle Service Cloud data.

Connect Cloud Integrations

Click below to jump to articles related to specific integration use-case.

Business Intelligence & Analytics - charting, reports, and more (Tableau, Power BI, Amazon QuickSight, etc.)
ETL & Replication - moving and replicating data (AWS Glue, Oracle Data Integrator, etc.)
Data Virtualization - retrieving and manipulating data (DbVisualizer, SQL Server PolyBase, etc.)
Software Development - developing custom applications (.NET, AngularJS, Ruby, Python, etc.)
Data Management - managing data (DBArtisan, RazorSQL, SQuirreL, etc.)
Workflow Automation - building automated workflows (SSIS, Power Automate, etc.)

Business Intelligence & Analytics

Product	Article Title
Alteryx Designer	Prepare, Blend, and Analyze Oracle Service Cloud in Alteryx Designer (ODBC)
Alteryx Designer	Work with Live Oracle Service Cloud Data in Alteryx Designer (Connect Cloud)
Amazon QuickSight	Build Interactive Dashboards from Oracle Service Cloud Data in Amazon QuickSight
Amazon SageMaker	Integrate Live Oracle Service Cloud data into Amazon SageMaker Canvas
Aqua Data Studio	Connect to Oracle Service Cloud in Aqua Data Studio
AWS Databricks	Process & Analyze Oracle Service Cloud Data in Databricks (AWS)
Azure Analysis Services	Model Oracle Service Cloud Data Using Azure Analysis Services
Birst	Build Visualizations of Oracle Service Cloud in Birst
BIRT	Design BIRT Reports on Oracle Service Cloud
Clear Analytics	Build Charts with Oracle Service Cloud in Clear Analytics
Cognos Analytics (On-Prem)	Analyze Oracle Service Cloud Data in Cognos Analytics
DBxtra	Build Dashboards with Oracle Service Cloud in DBxtra
Domo	Create Datasets from Oracle Service Cloud in Domo Workbench
Dundas BI	Build Dashboards with Oracle Service Cloud in Dundas BI
Excel (on Mac OS)	Work with Oracle Service Cloud Data in MS Excel on Mac OS X
FineReport	Feed Oracle Service Cloud into FineReport
Google Sheets	Access Live Oracle Service Cloud Data in Google Sheets
IBM Cognos BI	Create Data Visualizations in Cognos BI with Oracle Service Cloud
Infragistics Reveal	Analyze Oracle Service Cloud Data in Infragistics Reval
JasperServer	Create Oracle Service Cloud Reports on JasperReports Server
Jaspersoft BI Suite	Connect to Oracle Service Cloud in Jaspersoft Studio
JReport Designer	Integrate with Oracle Service Cloud in JReport Designer
Klipfolio	Create Oracle Service Cloud-Connected Visualizations in Klipfolio
KNIME	Enable the Oracle Service Cloud JDBC Driver in KNIME
LINQPad	Working with Oracle Service Cloud in LINQPad
Looker	Analyze Oracle Service Cloud Data in Looker
Looker Studio	Create Reports from Oracle Service Cloud Data in Looker Studio
Metabase	Create Interactive Oracle Service Cloud-Connected Metabase Dashboards
Microsoft Excel	Access Live Oracle Service Cloud Data in Excel Desktop
Microsoft Excel for the Web	Access Live Oracle Service Cloud Data in Excel for the Web
Microsoft SSAS	Build an OLAP Cube in SSAS from Oracle Service Cloud
MicroStrategy	Connect to Live Oracle Service Cloud Data in MicroStrategy through Connect Cloud
MicroStrategy	Use the CData JDBC Driver for Oracle Service Cloud in MicroStrategy
Microstrategy Desktop	Use the CData JDBC Driver for Oracle Service Cloud in MicroStrategy Desktop
Microstrategy Web	Use the CData JDBC Driver for Oracle Service Cloud in MicroStrategy Web
Mode Analytics	Create Oracle Service Cloud-Connected Visualizations in Mode
OBIEE	Oracle Service Cloud Reporting in OBIEE with the Oracle Service Cloud JDBC Driver
pandas	Use pandas to Visualize Oracle Service Cloud in Python
Pentaho Report Designer	Integrate Oracle Service Cloud in the Pentaho Report Designer
Power BI Desktop	Author Power BI Reports on Real-Time Oracle Service Cloud
Power BI Service	Visualize Live Oracle Service Cloud Data in the Power BI Service
Power Pivot	Access Oracle Service Cloud Data in Microsoft Power Pivot
Power Query	Access Oracle Service Cloud Data in Microsoft Power Query
Qlik Cloud	Create Apps from Oracle Service Cloud Data in Qlik Sense Cloud
QlikView	Connect to and Query Oracle Service Cloud in QlikView over ODBC
R	Analyze Oracle Service Cloud in R (JDBC)
R	Analyze Oracle Service Cloud in R (ODBC)
RapidMiner	Connect to Oracle Service Cloud in RapidMiner
Redash	Query, Visualize, and Share live Oracle Service Cloud Data in Redash
SAP Analytics Cloud	Analyze Oracle Service Cloud Data in SAP Analytics Cloud
SAP Business Objects	Create an SAP BusinessObjects Universe on the CData JDBC Driver for Oracle Service Cloud
SAP Crystal Reports	Publish Reports with Oracle Service Cloud in Crystal Reports (JDBC)
SAP Crystal Reports	Publish Reports with Oracle Service Cloud in Crystal Reports (Connect Cloud)
SAS	Use the CData ODBC Driver for Oracle Service Cloud in SAS for Real-Time Reporting and Analytics
SAS JMP	Use the CData ODBC Driver for Oracle Service Cloud in SAS JMP
SAS Viya	Analyze Live Oracle Service Cloud Data in SAS Viya
Sisense	Visualize Live Oracle Service Cloud in Sisense
Spago BI	Connect to Oracle Service Cloud in SpagoBI
Tableau	Visualize Oracle Service Cloud in Tableau Desktop
Tableau Cloud	Build Oracle Service Cloud Visualizations in Tableau Cloud
Tableau Server	Publish Oracle Service Cloud-Connected Dashboards in Tableau Server
TIBCO Spotfire	Visualize Oracle Service Cloud in TIBCO Spotfire through ADO.NET
TIBCO Spotfire	Visualize Oracle Service Cloud Data in TIBCO Spotfire
TIBCO Spotfire Server	Operational Reporting on Oracle Service Cloud from Spotfire Server
Visio	Link Visio Shapes to Oracle Service Cloud
Zoho Analytics	Create Oracle Service Cloud-Connected Dashboards in Zoho Analytics

ETL & Replication

Product	Article Title
Airbyte	Connect to Oracle Service Cloud Data in Airbyte ELT Pipelines
Amazon Redshift	Automated Continuous Oracle Service Cloud Replication to Amazon Redshift
Amazon S3	Automated Continuous Oracle Service Cloud Replication to Amazon S3
Apache Airflow	Bridge Oracle Service Cloud Connectivity with Apache Airflow
Apache Camel	Integrate with Oracle Service Cloud using Apache Camel
Apache Cassandra	Automated Continuous Oracle Service Cloud Replication to Apache Cassandra
Apache Kafka	Automated Continuous Oracle Service Cloud Replication to Apache Kafka
Apache NiFi	Bridge Oracle Service Cloud Connectivity with Apache NiFi
Apache NiFi Batch Operations	Perform Batch Operations with Oracle Service Cloud Data in Apache NiFi
AWS Glue	Build ETL Jobs with Oracle Service Cloud Data in AWS Glue Jobs
Azure Data Factory	Import Oracle Service Cloud Data Using Azure Data Factory
Azure Data Lake	Automated Continuous Oracle Service Cloud Replication to Azure Data Lake
Azure Synapse	Automated Continuous Oracle Service Cloud Replication to Azure Synapse
BIML	Use Biml to Build SSIS Tasks to Replicate Oracle Service Cloud to SQL Server
CloverDX	Connect to Oracle Service Cloud in CloverDX (formerly CloverETL)
Couchbase	Automated Continuous Oracle Service Cloud Replication to Couchbase
CSV	Automated Continuous Oracle Service Cloud Replication to Local Delimited Files
Databricks	Automated Continuous Oracle Service Cloud Replication to Databricks
ETL Validator	How to Work with Oracle Service Cloud in ETL Validator
FoxPro	Work with Oracle Service Cloud in FoxPro
Google AlloyDB	Automated Continuous Oracle Service Cloud Replication to Google AlloyDB
Google BigQuery	Automated Continuous Oracle Service Cloud Replication to Google BigQuery
Google Cloud SQL	Automated Continuous Oracle Service Cloud Replication to Google Cloud SQL
Google Data Fusion	Build Oracle Service Cloud-Connected ETL Processes in Google Data Fusion
Google Data Fusion	Build Pipelines with Live Oracle Service Cloud Data in Google Cloud Data Fusion (CData Connect Cloud)
Heroku / Salesforce Connect	Replicate Oracle Service Cloud for Use in Salesforce Connect
HULFT Integrate	Connect to Oracle Service Cloud in HULFT Integrate
IBM DB2	Automated Continuous Oracle Service Cloud Replication to IBM DB2
Informatica Cloud	Integrate Oracle Service Cloud in Your Informatica Cloud Instance
Informatica PowerCenter	Create Informatica Mappings From/To a JDBC Data Source for Oracle Service Cloud
Jaspersoft ETL	Connect to Oracle Service Cloud in Jaspersoft Studio
Microsoft Access	Automated Continuous Oracle Service Cloud Replication to Microsoft Access
Microsoft Azure Tables	Automated Continuous Oracle Service Cloud Replication to Azure SQL
Microsoft Excel	Transfer Data from Excel to Oracle Service Cloud
Microsoft Power Automate	Build Oracle Service Cloud-Connected Automated Tasks with Power Automate (Desktop)
MongoDB	Automated Continuous Oracle Service Cloud Replication to MongoDB
MySQL	Automated Continuous Oracle Service Cloud Replication to MySQL
Oracle Data Integrator	ETL Oracle Service Cloud in Oracle Data Integrator
Oracle Database	Automated Continuous Oracle Service Cloud Replication to Oracle
petl	Extract, Transform, and Load Oracle Service Cloud in Python
PostgreSQL	Automated Continuous Oracle Service Cloud Replication to PostgreSQL
Replicate to MySQL	Replicate Oracle Service Cloud to MySQL with PowerShell
SAP HANA	Automated Continuous Oracle Service Cloud Replication to SAP HANA
SingleStore	Automated Continuous Oracle Service Cloud Replication to SingleStore
SnapLogic	Integrate Oracle Service Cloud with External Services using SnapLogic (JDBC)
SnapLogic	Integration with Oracle Service Cloud Data in SnapLogic (Connect Cloud)
Snowflake	Automated Continuous Oracle Service Cloud Replication to Snowflake
SQL Server	Automated Continuous Oracle Service Cloud Replication to SQL Server
SQL Server Linked Server	Connect to Oracle Service Cloud Data as a SQL Server Linked Server
SQLite	Automated Continuous Oracle Service Cloud Replication to SQLite
Talend	Connect to Oracle Service Cloud and Transfer Data in Talend
UiPath Studio	Create an RPA Flow that Connects to Oracle Service Cloud in UiPath Studio
Vertica	Automated Continuous Oracle Service Cloud Replication to a Vertica Database

Data Virtualization

Product	Article Title
Access Linked Tables	Update Oracle Service Cloud with a Microsoft Access Linked Table
APOS Live Data Gateway	Build Semantic Layer Views for Oracle Service Cloud (JDBC)
APOS Live Data Gateway	Build Semantic Layer Views for Oracle Service Cloud Data (Connect Cloud)
Denodo	Create A Data Source for Oracle Service Cloud in Denodo Platform
Dremio	Connect to Oracle Service Cloud as an External Source in Dremio
MySQL Federated Tables	Connect to Oracle Service Cloud as Federated Tables in MySQL
Oracle Database	Access Oracle Service Cloud as a Remote Oracle Database
PostgreSQL FDW	A PostgreSQL Interface for Oracle Service Cloud
Salesforce Connect	Edit and Search Oracle Service Cloud External Objects in Salesforce Connect
Salesforce External Services	Connect to Oracle Service Cloud through External Services in Salesforce
SQL Server Linked Servers	Connect to Oracle Service Cloud as a Linked Server
SQL Server PolyBase	Connect to Oracle Service Cloud Data using PolyBase with Connect Cloud
SQL Server PolyBase	Connect to Oracle Service Cloud as an External Data Source using PolyBase
TIBCO Data Virtualization	Access Live Oracle Service Cloud Data in TIBCO Data Virtualization

Software Development

Product	Article Title
AWS Lambda	Access Live Oracle Service Cloud Data in AWS Lambda
.NET Charts	DataBind Charts to Oracle Service Cloud
.NET QueryBuilder	Rapidly Develop Oracle Service Cloud-Driven Apps with Active Query Builder
Angular JS	Using AngularJS to Build Dynamic Web Pages with Oracle Service Cloud
Apache Spark	Work with Oracle Service Cloud in Apache Spark Using SQL
AppSheet	Create Oracle Service Cloud-Connected Business Apps in AppSheet
Bubble.io	Build Oracle Service Cloud-Connected Apps in Bubble
C++Builder	DataBind Controls to Oracle Service Cloud Data in C++Builder
Choreo	Build Custom Apps on Oracle Service Cloud Data in Choreo
ColdFusion	Query Oracle Service Cloud in ColdFusion Using JDBC
ColdFusion	Query Oracle Service Cloud in ColdFusion Using ODBC
Dash	Use Dash & Python to Build Web Apps on Oracle Service Cloud
Delphi	DataBind Controls to Oracle Service Cloud Data in Delphi
DevExpress	DataBind Oracle Service Cloud to the DevExpress Data Grid
EF - Code First	Access Oracle Service Cloud with Entity Framework 6
EF - LINQ	LINQ to Oracle Service Cloud
EF - MVC	Build MVC Applications with Connectivity to Oracle Service Cloud
Filemaker Pro	Bidirectional Access to Oracle Service Cloud from FileMaker Pro
Filemaker Pro (on Mac)	Bidirectional Access to Oracle Service Cloud from FileMaker Pro (on Mac)
Go	Write a Simple Go Application to work with Oracle Service Cloud on Linux
Google Apps Script	Connect to Oracle Service Cloud Data in Google Apps Script
Hibernate	Object-Relational Mapping (ORM) with Oracle Service Cloud Entities in Java
IntelliJ	Connect to Oracle Service Cloud in IntelliJ
JBoss	Connect to Oracle Service Cloud from a Connection Pool in JBoss
JDBI	Create a Data Access Object for Oracle Service Cloud using JDBI
Jitterbit	Integrate with Live Oracle Service Cloud Data in Jitterbit
JRuby	Connect to Oracle Service Cloud in JRuby
Mendix	Build Oracle Service Cloud-Connected Apps in Mendix
Microsoft Power Apps	Integrate Live Oracle Service Cloud Data into Custom Business Apps Built in Power Apps
NodeJS	Query Oracle Service Cloud Data in Node.js (via Connect Cloud)
NodeJS	Query Oracle Service Cloud through ODBC in Node.js
OutSystems	Create Oracle Service Cloud-Connected Enterprise Applications in OutSystems
PHP	Access Oracle Service Cloud in PHP through Connect Server
PHP	Natively Connect to Oracle Service Cloud in PHP
PowerBuilder	Connect to Oracle Service Cloud from PowerBuilder
PowerShell	Pipe Oracle Service Cloud to CSV in PowerShell
PyCharm	Using the CData ODBC Driver for Oracle Service Cloud in PyCharm
Python	Connect to Oracle Service Cloud in Python on Linux/UNIX
React	Build Dynamic React Apps with Oracle Service Cloud Data
Ruby	Connect to Oracle Service Cloud in Ruby
RunMyProcess	Connect to Oracle Service Cloud Data in RunMyProcess
RunMyProcess DSEC	Connect to Oracle Service Cloud in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5	Integrate Real-Time Access to Oracle Service Cloud in SAPUI5 MVC Apps
Servoy	Build Oracle Service Cloud-Connected Apps in Servoy
Spring Boot	Access Live Oracle Service Cloud Data in Spring Boot Apps
SQLAlchemy	Use SQLAlchemy ORMs to Access Oracle Service Cloud in Python
Tomcat	Configure the CData JDBC Driver for Oracle Service Cloud in a Connection Pool in Tomcat
Unqork	Create Oracle Service Cloud-Connected Applications in Unqork
VCL App (RAD Studio)	Build a Simple VCL Application for Oracle Service Cloud
WebLogic	Connect to Oracle Service Cloud from a Connection Pool in WebLogic

Data Management

Product	Article Title
Apache Solr	Import Oracle Service Cloud Data into Apache Solr
Coginiti Pro	Access Live Oracle Service Cloud Data in Coginiti Pro
DataGrip	Qeury Oracle Service Cloud Data in DataGrip
DB Artisan	Manage Oracle Service Cloud in DBArtisan as a JDBC Source
DB Artisan	Connect to Oracle Service Cloud in DBArtisan
DBeaver	Connect to Oracle Service Cloud in DBeaver
DbVisualizer	Connect to Oracle Service Cloud in DBVisualizer
HeidiSQL	Connect to Oracle Service Cloud Data in HeidiSQL
Informatica Enterprise Data Catalog	Add Oracle Service Cloud to Informatica Enterprise Data Catalog
MySQL Workbench	Query Oracle Service Cloud Data in MySQL Workbench (Connect Server)
MySQL Workbench	Query Oracle Service Cloud in MySQL Workbench (ODBC)
QuerySurge	Validate Oracle Service Cloud Data with QuerySurge
RazorSQL	Connect to Oracle Service Cloud in RazorSQL
SQuirreL	Connect to Oracle Service Cloud in Squirrel SQL Client

Workflow Automation

Product	Article Title
MuleSoft Anypoint	Access Oracle Service Cloud in Anypoint Using SQL
Nintex Workflow Cloud	Build Oracle Service Cloud-Connected Workflows in Nintex
Power Automate	Integrate Oracle Service Cloud Data into Power Automate Automated Tasks
SSIS Export	Export Data from SQL Server to Oracle Service Cloud through SSIS
SSIS Import	Import Oracle Service Cloud Data into SQL Server using SSIS
SSIS Lookup	Insert New or Update Existing Oracle Service Cloud Records from SQL Server

Ready to get started?

Learn more about CData Connect Cloud or sign up for free trial access:

Free Trial