Databases

Because of the variety of methods used for connecting and authenticating with databases, please contact Xylok support at support@xylok.io for help with your specific database.

PostgreSQL

Requirements

psql installed and in the PATH
Access from the machine running the script to the server

Process

When a script with a Postgres benchmark is used, there will be a prompt at the beginning for the database host name, user, and password. If any of these aren’t needed (i.e., there’s no password), simply press enter when prompted.

After entering the information, the information won’t actually be tried until the script reaches the data collection for the database and, in an effort to not break other data, there won’t be a warning if collection is failing during execution. We recommend opening the .xylok results file the first time you try this process and search for “PostgreSQL” or “Column privileges” to check if you correctly received table results back or not. (You can of course also examine the results in Xylok itself.)

Oracle Database 19c

Requirements

sqlplus installed and in the PATH
Access from the machine running the script to the server

Process

When the collection script for Oracle DB 19c is executed, it will prompt for a connection string that sqlplus will use to access the database. The format of the string is “/@:/<service_name> as sysdba”.

The collection script will not output information to the screen. Progress of the collection can be monitored by checking data in the .xylok result file. Any errors during the execution will also be captured in the .xylok result file.