OK, so it looks like you want to use OS accounts to connect and authenticate against Oracle rather than separate Oracle-specific accounts - is this correct? In my world this is called IWA - Integrated Windows Authentication. I know how to do this for SQL server but not Oracle. You can test such data connections in a LIBNAME statement. For SQL Server it looks like this:   libname SQLSRVR odbc noprompt = "server=SQLServerName;DRIVER=SQL Server Native Client 11.0;Trusted Connection=yes" DATABASE = MyDatabase schema = dbo; Note, there is no user account or password supplied. The "Trusted Connection=yes" option says use my Windows account to authenticate with SQL Server. For Oracle the equivalent option is "Integrated Security=yes".    ... View more

Thank you all for your input, we probably going to go the authdomain way as we already have our Oracle credential in it, and yes it has is pros and cons.  Security Dept. are ok with it.     Thanks again! ... View more

Sure, no problem.  Yes, that is what I mean. ... View more

Hello,   I missed the webinar and was wondering if it was recorded and available to download.    Thanks.   Laurent ... View more

Thanks! That is what I needed.is good.   You can get a list of your registered spn with the command setspn -L your host  I think you miss some spn.   You could try to fill the spn field that is now blank with your full qualified hostname, then restart the metadata server. ... View more

I was making mistake in creating zip file. Now its working thank you.   You are correct when you EGP file is nothing but a ZIP file. Thanks ... View more

Windows is a little bit different to the Unix approaches. Having fast IO in the local iron you will benfit the most of it. Check the Margareth Crevar papers for those. A starting point could be:  http://support.sas.com/resources/papers/proceedings15/SAS1501-2015.pdf       Did you think off Utilloc ? remember each of the requests shoudl have sufficient space. by spreading the total you are also lowering the maximum of a single process. ... View more

I'm very much with @SASKiwi on this one: In order to "productionize" EG projects you need to export the code and run it in batch on the server.    Depending on your environment and user priviledges this is still something which could be set-up and maintained by an end-user group (so it's not real IT like production grade and end-users could still have full control over the code with short change cycles).   What you describe is something I've seen happening already multiple times. It's kind-of the normal process. First "business" users get EG and they use it for simple point and click stuff, then they get more experienced and the EG projects get bigger and more complex, and the business processes supported by these EG projects become more and more. At some point the problem starts with missing "audit trails", reports can't get replicated as everybody uses a bit different data preparation steps for the same. That's when such user groups start to create data marts as common source of truth for the whole group. But then more and more data gets added and some sort of organicly grown unplanned data warehouse environment gets established. The users start to spend more and more time maintaining a "messy" environment instead of spending this time to answer business questions.   I feel the situation you describe is for a group which is reaching the point where "things get out of hand". So besides of resolving the immediate issue I feel it's the time for some re-design and "process re-engineering" so that these users can spend their time with what they should be doing.    ... View more