topic Re: Change REPOSITORY/LOGIN credentials at top of EG script? in SAS Enterprise Guide

Change REPOSITORY/LOGIN credentials at top of EG script?

deleted_user — Tue, 18 May 2010 21:53:21 GMT

I would like to be able to change the login credentials at the top of a SAS script in EG. For example, when I run PROC OLAP to create a cube, I need to use a different user-id than the one I use for all other types of development. Currently, I am just manually changing the "Repository and Server" to use a different connection that conatins the 2nd userid. Then when the script is finished, I change it back. Is there a way to automate this using SAS code?

Re: Change REPOSITORY/LOGIN credentials at top of EG script?

ChrisHemedinger — Wed, 26 May 2010 20:59:20 GMT

You can change the EG script (VBS file) to call SetActiveProfile on the application object. Something like:

objApp.SetActiveProfile("MyOlapProfile")

This assumes that the necessary credentials are available within the profile.

Chris

Re: Change REPOSITORY/LOGIN credentials at top of EG script?

jklein271 — Wed, 02 Jun 2010 14:46:40 GMT

Chris:

Is there a similar way to set the server, port, user, and password without calling the profile itself? I'm trying to schedule the EG vbs using a 3rd party enterprise scheduler. The problem I appear to be hitting is that the runtime user in the scheduler logs into the server as a non-interactive user. Since there is no profile available to it the vbs executes, but no code is run in the EG 4.2 project.

Thanks.

Re: Change REPOSITORY/LOGIN credentials at top of EG script?

ChrisHemedinger — Thu, 03 Jun 2010 14:46:35 GMT

Unfortunately, no. There isn't a way to create a profile on the fly via automation, although you might be able to rig something up by creating a Configuration42.xml file in the profile area for the running user. That would require some additional script logic on your part.

Chris