Skip to content

Oracle Communities

Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
Oracle Analytics Cloud May 2025 Update The Oracle Analytics Cloud (OAC) May 2025 update enhances how users generate insights, engage with data, and distribute content
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Smartview connection to MS SQL Server

Received Response

103

Views

1

Comments

T D

T D Rank 1 - Community Starter

January 2019 in Oracle Analytics Cloud and Server

Summary

Is it possible to connect to MS SQL Server from Smartview?

Content

Hi,

For the Smartview add-in for Excel that is provided by Oracle,

is it possible to connect to Microsoft SQL Server from it?

Can you please provide any links that talk about how to do this?

Thanks for your time

0

Answers

[Deleted User] Mod

January 2019

Not directly, no, as you can see from the screenshot since SmartView ist made to utilize modeled data structures.

But nothing is stopping you from modeling your SQL Server source in OBI and the using SmartView.

0