SQL Server Initial Table Definition and Data Load

From the RPS - RPS Manager application, the following steps create SQL scripts to create the tables and columns required in SQL Server. These tables and columns are those that were defined earlier in the RPS Mapping. Files are also created containing the initial data to be loaded into these tables and the data is loaded.

  1. Select to configure the RPS node.

    • Select the menu item File | RPS Node Configuration.

    The Configure RPS Node dialog is then displayed. (The details in steps a through f of this step should be pre-filled and match those details entered during the "Define RPS Mapping" section.)

  2. Check the configuration details.

    1. Schema = ErewhonInvestmentsModelSchema.

    2. Mapping = ErewhonRPS.

    3. Jade Database Mode = Full.

    4. Relational Database Name = Erewhon.

    5. Connection String = DSN=SQLServerODBC; Database=Erewhon.

    6. Set the Auto Start Datapump option.

      With this option selected, the data pump is started automatically when the RPS node is started. It also allows operations such as database reorganizations to be performed without user intervention. (The data pump needs to be started after the load as it failed to run at start up because the SQL server database did not exist.)

      Note that when Auto Start Datapump is enabled, the Ask for RDB Login option must be unchecked.

    7. Check Auto Execute Drop/Reload in the Data Pump Restart Options.

    8. Enter C:\<JadeVer>RPS\RPSSQLScripts as the Alter Script Path.

    9. Check Use Sqlcmd in the Data Pump Restart Options.

    10. The Server Name must be set to the server name of the SQL Server.

    11. Enter C:\<JadeVer>RPS\RPSSQLScripts as the RDB Path.

    12. Click OK.

    The configuration options are applied and the following message is displayed.

    Configuration successful

  3. When the configuration has been checked, run RPS | Setup RDBMS. This extracts and runs the table creation scripts and extracts and loads the data.

  4. Use the SQL Server Manager to check that the data has been loaded.

    1. From the Start menu, run SQL Server Management Studio Express.

    2. Select the Erewhon database.

    3. Select menu item File | New | Query with Current Connection.

    4. Enter the following query.

      Select * from AddressableEntity

      This query will output all of the data in the AddressableEntity table.

    5. Press F5, to run the new query.

All data from the AddressableEntity table is then displayed.