Can I extend the schema name from a database profile

Document created by rich_patterson Employee on Nov 19, 2014Last modified by dave_lesshafft on Mar 1, 2016
Version 2Show Document
  • View in full screen mode
If you want to run the same process across different environments, but the username/schema is different for the different environments.
You can NOT use parameters to specify the user/schema from a database profile.


You could configure the login, for each specific DB, to use a particular user by default, removing the need to specify that user from within the SQL


You may also set up common "views" within each of the DBs ( prod, dev, test, qa, etc ), which could be called by this connection... so the process/profile could call these "views", which could be written specific for each DB/environment, to get the data required
2 people found this helpful