Ispirer Website
Ispirer Toolkit Overview
Free Trial
Parameterize login information after import script generation
You can use environment variables to specify the SERVIСE, PASSWORD and USER for the whole run in sqlways_all.bat. But first you need to specify those environment variables in the SQLWays, so that it used them in all the bat files with the commands, like:
The Password is specified as %PASSWORD% here.
So, as the result you will have bat files for data and ddl loading with the commands like, e.g. for Oracle:
sqlplus %USER%/%PASSWORD%@%SERVICE% @calendar_ddl.sql
All the bat files are run using the sqlways_all.bat file with the command like:
sqlways_imp.exe /bat=sqlways_all.bat
So, all that is left to do is to update the sqlways_all.bat file with the following SET commands before the CALL statements:
set USER=ora set PASSWORD=pass set SERVICE=ora
As the result the SQLPLUS command will be executed as follows:
sqlplus ora/pass@ora @calendar_ddl.sql
So, changing just three values in the sqlways_all.bat file, you can control which user, password and service name must be used for the whole load.