Adding a Database as a Device

the target database is configured as a device navigate to device management > device inventory menu click the new device discovery button enter the ip address, port (if not set, the default port is used according to the access protocol), and the access protocol, and select the device group for the assigned device should be in click the discover and add button the port number is the identifier of the connection to oracle, mssql, mysql and cassandra, teradata, hive, postgresql, and db2 via a single connect 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 navigate to administration > system config man 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 6000 7000) navigate to device management > device inventory right click the defined database device and select show properties set the sql proxy bind port property click the auto assign button multiple bind ports can be added using a comma “,” without a space to separate them ex 4042,4141,1313