After you create the database instance and customize the database scripts, you can create the master index tables and insert the custom data.
In the master index project, right-click the Database Script node, and then select Properties from the Database Script context menu.
Do one of the following:
For Oracle: In the Database Server field, change <host> to the database server address and change <SID> to the SID name of the database you created in Step 2: Create a Master Index Database and User (Repository). If Oracle is not listening on the default port, 1521, enter the correct port number. You can use “localhost” as the hostname if the database resides on the same machine as NetBeans.
For SQL Server: In the Database Server field, change the URL to the following:
where server is the address of the database server, port is the port number on which SQL Server is listening, and database is the name of the database. You can use “localhost” for the hostname if the database resides on the same machine as NetBeans.
In the Password field, enter the password of the administrator user you created when you created the database (creating an administrator user is described under Step 2: Create a Master Index Database and User (Repository)).
In the User field, enter the administrator user’s logon ID.
Make sure you enter the database logon credentials for the administrator user you created. You cannot use the logon credentials for the default system user (the database tables will be created, but the master index application will not function correctly).
Close the dialog box by clicking the “X” icon in the upper right corner of the dialog box.
For each additional script to run against the database, right-click the name of the script, and then select Run. On the confirmation dialog box, click OK.