Using the Database Proxy Schema Tool

You can download a tool to generate schema metadata for building database rule sets.

Before downloading and running the database proxy schema tool, ensure that your local system satisfies the following prerequisites:

Your Java JRE is at version 1.6 or later.
You are running on a supported Linux or Window operating system.
The target database is accessible from the system where the schema tool is running.

You can download the database proxy schema tool from the Catalog > Database Rule Templates page:

Click the Download Database Proxy Schema Tool icon.
The downloaded database proxy schema tool is stored in a compressed archive file. To install the tool, extract the files from the compressed archive into any local directory. The contents of the directory should be similar to the following example:
```
\dbproxy
        \bin            (schema tool scripts)
        \lib            (libraries used by the schema tool)
        \license        (license files)
        README.txt      (usage information)
```

Run the database proxy schema tool by using the following commands:

On Windows systems:
```
dbproxy\bin\schema-tool.bat
```
On Linux systems:
```
dbproxy/bin/schema-tool -attributes -db2 
   -host [target_db_host_ip] 
   -port [target_db_port]
   -user [target_db_user]
   -password [target_db_password]
   -db [target_db_name]
   -outputFile
```
In this command, the following attributes are specified:

target_db_host_ip

The host name or IP address of the target database.

target_db_port

The port number of the target database.

target_db_user

The user name authorized to access the target database.

target_db_password

The password accompanying the specified user name to access the target database.

target_db_name

The name of the target database.

The output from the schema tool is a JSON file that is required to create a database rule set for the target database. For more information, see Creating database rule sets.