Adding a Database as a Device
prerequired configuration the port number is the identifier of the connection to oracle, mssql, mysql and cassandra, teradata, hive, postgresql, and db2 via a kron pam sql proxy the port number must be defined in the device properties of the mssql, mysql and cassandra, teradata, hive, postgresql, db2, sap hana, and couchbase databases the following system configuration parameter should be set for the port assignment option 1 navigate to administration > system config manager 2 click + add button and inside of the pop up select the add new system parameter button 3 set the “ sql proxy bind port range ” parameter with the requested port range parameter name parameter value sql proxy bind port range port range (e g 1000 2000) the target database is configured as a device 1 navigate to devices > inventory 2 click + add button and inside of the pop up select the add device button 3 information , enter the following required information a ip address b device name c port (if not set, the default port is used according to the access protocol) d access protocol (oracle tns, mssql, postgresql etc ) e element type 4 group membership, enter your device group 5 properties, click the auto assign (this will use the setup parameter of system configuration manager guided earlier) 6 click test connection to control the connection information you provided and save once the configurations are complete, to define a database, go to the options button of the device you defined when you select access protocol the following inputs will be appear database/service name this is the name of the database you want to connect to it’s a unique identifier for the database on the server username this is the username of the account you’re using to access the database it must match the username created in the users database password this is the password associated with the database username it’s used to authenticate the user and grant access to the database alias (optional) this is an optional nickname you can give to the database connection (only in oracle databases) it’s used to easily identify the database in the future without having to remember the specific database name finally you can click the test connection button for checking the credentials are right or not