BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Aug 23.

using connection to connect query using SQL in Lumira


 
Search this topic... | Search Lumira / Visual Intelligence... | Search Box
Register or Login to Post    Forum Index -> Other Products -> Lumira / Visual Intelligence  Previous TopicPrint TopicNext Topic
Author Message
psk
Principal Member
Principal Member



Joined: 04 Aug 2004

Posts: 241



PostPosted: Thu Apr 12, 2018 12:07 pm 
Post subject: using connection to connect query using SQL in Lumira

Is there a way to use the existing connection(universe) to use the data source as "query using sql"? Because while refreshing the dashboard using sql requires password from the users. How can we avoid this?
Back to top
katullus
Forum Associate
Forum Associate



Joined: 21 Aug 2009
ASUG Icon
Posts: 786
Location: NYC always in my heart


flag
PostPosted: Fri May 11, 2018 11:17 am 
Post subject: Re: using connection to connect query using SQL in Lumira

Not sure I understand the question, but anytime you want to bypass the username/pw, then needs to be setup on the server side.
Back to top
psk
Principal Member
Principal Member



Joined: 04 Aug 2004

Posts: 241



PostPosted: Fri May 11, 2018 12:36 pm 
Post subject: Re: using connection to connect query using SQL in Lumira

When I create a storyboard using SQL, users are asked to enter DB credentials when they refresh the story board in BILaunchpad.

How can we setup in server?
Back to top
kevlray
Forum Associate
Forum Associate



Joined: 23 Jun 2010

Posts: 895
Location: California


flag
PostPosted: Mon May 14, 2018 10:14 am 
Post subject: Re: using connection to connect query using SQL in Lumira

Kinda depends on the database. If you are using MS-SQL. The database credentials could be set up using Windows Authentication. But I think that requires AD accounts. I do not know how it is done with other databases.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Other Products -> Lumira / Visual Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0297 seconds using 17 queries. (SQL 0.0030 Parse 0.0009 Other 0.0258)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo