The following settings are available in "Step 1 - Describe databases" of the setup wizard.
Select the database type. The choices are:
Specify the TNS alias used to connect to this database (Oracle only).
Specify the sysdba user name (Oracle only).
Specify the password for the SYSDBA user (Oracle only).
Specify the DBA user name (Oracle only).
A Dbvisit Replicate repository will be created in this database. This is the database username that will own this repository.
Specify the password for the Dbvisit Replicate repository user.
Specify the default tablespace of the Dbvisit Replicate repository user.
Specify the temporary tablespace of the Dbvisit Replicate repository user.
Does this database use the ASM filesystem.
Select the Database timezone if it is different. This is relevant only if columns of type TIMESTAMP WITH LOCAL TIME ZONE are replicated.
The NLS_LANG variable is set at the apply environment and behaves like the NLS_LANG evironment does: it sets the language, territory and character set of the apply session. The language and territory are not very important (they affect things like Oracle error messages shown), the character set must be set to the source database character set, so the any character strings applied are treated correctly according the character set they are in.
This is the national character set of the source database. This is relevant only for NCHAR/NVARCHAR2 columns.
Only UTF8 and AL16UTF16 values are supported; Oracle expects Unicode values to be specified in UTF16, so if the source database is using UTF8 (specified by this setting), apply does the necessary conversion to UTF16.
Any other (legacy) mutlibyte character sets are currently not supported.
Enter the database hostname (MySQL only)
Enter the user name of the the administrator (MySQL only)
Enter the password for the MySQL administrator (MySQL only)
Enter the username that logs into the target or apply database.
A Dbvisit Replicate repository will be created in this database. This is the database username that will own this repository.
Enter the ODBC DNS (SQL Server only)
Enter the user name of the the administrator (SQL Server only)
Enter the password for the administrator
Enter the username that logs into the target or apply database.
Enter the password for this user
Name of the database to use.
Name of the schema that will hold the Dbvisit Replicate repository.