7 Installing Using a SQL Server Repository

7.1 Installing the Oracle GoldenGate Veridata Software

1. Start the database that you are using for the Oracle GoldenGate Veridata repository.

2. Close all applications that use this database.

3. Follow the steps in Section A, "Downloading Oracle GoldenGate Veridata" to obtain the software.

4. Unzip the downloaded .zip file using WinZip or a similar compression program.

5. Run the installer.

   • As a wizard: Double click the GoldenGate_Veridata_platformrelease program and then follow the installation steps. The wizard is shown in this documentation.

   • As a shell process: From the command console of the operating system, issue the following command, and then follow the installation steps. The text prompts are similar to those shown on the wizard screens. To accept the default when using the command console, press Enter.

     Start /wait GoldenGate_Veridata_platformrelease.exe -c
     

6. Welcome: Click Next to start the installation.

7. Destination Directory: Select an installation directory. You can accept the default (to be created during installation), type a path name, or click Browse to go to a different directory. If installing more than one instance of this software, select a different directory or sub-directory each time that you run the installer.

8. Data Location: Select a location for the user data. The data directory is where Oracle GoldenGate Veridata stores reports and other files that contain information about out-of-sync rows. You can accept the default (to be created during installation), type a path name, or click Browse to go to a different directory. This directory will contain data from the tables that are compared, so it should reside on a secure system.

9. Web Server Configuration: Accept the default shutdown and HTTP ports or specify different ones. The shutdown port is used by Oracle GoldenGate Veridata to shut down the server processes. The HTTP port is used by the embedded Tomcat web server application to connect to the Oracle GoldenGate Veridata Web component.

10. Create Veridata Users: Specify which of the following methods you want to use to create Oracle GoldenGate Veridata users:

    • Use the Tomcat Web Service administrative tool to manually create users after the installation.

    • Have the installation program import users from an existing Oracle GoldenGate Veridata installation. You will need to know the Oracle GoldenGate Veridata administrator user for that installation.

    Whichever option you select, you can add users as needed after the installation using the Tomcat Web Service administrative tool.

11. Import Veridata Web: This screen is displayed if you elect to import users from an existing Oracle GoldenGate Veridata installation. Enter the installation directory and the administrator's login user name and password.

12. Web Server Admin User: Specify an initial Oracle GoldenGate Veridata administrator user. The administrator is the most privileged role in Oracle GoldenGate Veridata and can perform all configuration, execution, and monitoring functions. Keep a record of this login. It is required to create other users after installation.

13. Veridata Repository: Select SQL Server as the database that will be the Oracle GoldenGate Veridata repository.

14. Database Driver Configuration: Specify how Oracle GoldenGate Veridata connects to the SQL Server database. Click the Choose from predefined Data Sources radio button to enable a list of predefined ODBC data sources (DSNs). Click the Manually define a SQL Server connection radio button to open the following fields to define the new JDBC connection:

    • Host: The name of the computer on which SQL Server is running

    • Port: (optional) The port on which SQL Server is listening

    • Instance: (optional) The name of the SQL Server instance

    • Use Integrated Security: Check this box to use Windows SQL Server Integrated Security to log on

    Contact your system administrator or consult the documentation for your operating system if you are unable to create a DSN. For basic instructions on creating the connection outside of the installer, see Appendix C, "Configuring an ODBC connection for a SQL Server Repository".

15. Confirm the DSN connection information.

16. Veridata Repository, database option: Use any combination of these options to specify how the Oracle GoldenGate Veridata repository will be configured.

    • Login: Oracle GoldenGate Veridata requires a login to connect to the repository. Specify whether to create a new login for this purpose or to use an existing login. Use an existing login if you already created one for Oracle GoldenGate Veridata, or if you are reinstalling Oracle GoldenGate Veridata to a different location from a previous one and want to retain the old repository. An existing login must have DML and DDL privileges for the Oracle GoldenGate Veridata repository.

    • Database: Specify whether to create a new database for the repository or use an existing one.

17. Login Screens: The next screens vary, depending on your previous selection for the repository configuration.

    • Veridata Repository Admin:

      To create a new login or database (or both), you are prompted for the credentials of an existing database login that can be used to create the object(s). The login will be used only for this purpose and must have administrator or DBA privileges.

    • Veridata Repository:

      To create a new login, you are prompted to give it a name and password.

      To create a new database, you are prompted to give it a name.

      To use an existing login, you are prompted for the login name and password.

      To use an existing database, you are prompted for its name. If the specified database already contains Oracle GoldenGate Veridata objects, you are prompted to specify whether to drop and recreate them (removes existing objects) or to use them (preserves existing objects).

18. Windows Services: It is recommended that you install Oracle GoldenGate Veridata as a Windows service. When installed as a service, software can operate independently of user connections, which can accidentally be terminated, and you can configure it to start manually or at system start-up.

    • Before you elect to install as a service, you must identify the user that will start the service. This logon will be granted full access to Oracle GoldenGate Veridata files. You can install the service to log on as the LocalSystem user, or you can specify a different user. If you specify a different user, that user must be granted LogonAsService privilege or the service will not start.

    • When that is done, either accept the default service name or change it as required. If there are, or will be, other instances of this software on the local system, make certain that each service name is unique.

    To prevent installation as a service, deselect the check box.

19. Windows Services User: If you elected to install Oracle GoldenGate Veridata as a service, this screen is displayed. Select Logon as Local System for Oracle GoldenGate Veridata to log on as LocalSystem when the service is started. If you select Logon as a specific user instead, enter the logon information of the user you wish to start the service.

    Note:

    The user that starts the Windows service must have LogonAsService rights. If you specify a user that does not have these rights, the service will not start.

20. Start after install: Specify whether or not to start the software after the installation is finished. By default, it is installed to start manually. If you are installing it as a service, a system administrator can change the properties so that it starts automatically when the system starts.

21. Start Menu Folder: To add Oracle GoldenGate Veridata to the Programs list of the Start menu, you can accept the default shortcut name (to be created during installation), type a different one, or select one from the list. To make the shortcut available to everyone who uses this system, select Create Shortcuts for all users; otherwise, it will only be available to the current user.

    To exclude Oracle GoldenGate Veridata from the Start menu, select Don't create a Start Menu folder. If you are installing this software as a service, it can be started from the installation folder or the Services control panel.

22. Information: Review your installation selections. Click Back to make changes or click Next to begin the installation.

23. Completing the Oracle GoldenGate Veridata Setup Wizard: To view the Oracle GoldenGate Veridata help system after the installation is done, accept the default. To prevent the help system from launching, clear the check box. The Oracle GoldenGate Veridata help system contains an introduction to the software, information about specific functions and tasks, and a detailed tour of the web interface. This tour can help both new and experienced users get started more quickly with a better understanding of the work flow and tools.

24. Click Finish to close the installer.

25. The SQL Server repository must be running before the Oracle GoldenGate Veridata Server Windows service can start. You can add the database as a startup dependency to the server service. Adding a dependency to a service requires a system administrator to modify its Registry entry. For more information, consult the Microsoft documentation or website.