Skip to content

Oracle Communities

Register to the Data Intelligence Summit Mexico Register today to the Oracle Analytics Data Intelligence Summit in Mexico on April 8th
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
New Oracle Analytics Release March 2025 New Oracle Analytics March 2025 release for Oracle Analytics Cloud and Analytics Server
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

101

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