Allows you to enter connection information for either your Oracle or SQL Server database.
The displayed wizard page differs depending on which database type you specified
earlier in the wizard.
I want to load the data schema to an already existing user - Indicates that you have already created a user to which the wizard can load the data.
I want to create a new user and load the database to the new user - Indicates that you want the wizard to create a new user to which the data will be loaded.
Load Stored Procedures to create or update the tables or indexes in the database – You can select this check box if you want to load the stored procedures for creating a set of database tables or indexes (Before Update 20, this checkbox was enabled by default). Stored procedures must be loaded during site creation if you want to run Data Validator jobs and to import data from an in-house application database and to load and process the data using the data reader patterns of SmartPlant Fusion. Stored procedures are database scripts that create custom tables in the database to process the data in CSV files while running jobs.
If you have not selected this check box while creating a site and still want to run
Data Validator jobs, you can update your site to load the stored procedures. For more information,
see Update a site.
Clear the Load Stored Procedures to create or update the tables or indexes in the database check box to manually load the stored procedures. All the database scripts for stored
procedures are located at [product_installation_location]\SPFServerManager\DatabaseScripts\Stored Procedures\[DB Type]. For more information on manually loading stored procedures, see Manually loading stored procedures during site creation.
Oracle Net alias - Enter the name of the database instance where the tablespace resides. (Oracle only)
Database server - Enter the name of the server that hosts the SQL Server database. (SQL Server only)
System username - Enter the name of the Oracle or SQL Server user who has privileges to create SDx users. This box is disabled if you are using an existing user.
Password - Enter the password for the system user. This box is disabled if you are using an existing user.
Enter the SQL database connection string - Enter the SQL server connection string that is used to connect to the database if you have selected the Configure the SQL Server connection manually option in New Site Wizard > Database Platform.