Customize virtual path and port
Published 23 July 2021
From v1.12.9 of SQL Data Catalog, we now allow you to customize the path and port it serves its content from.
On Windows
- Stop the SQL Data Catalog Windows Service.
- Make a note of your current connection string (stored as an Environment Variable)
- Set the system environment variable
Redgate_SqlDataCatalog_Path
to the path-prefix you'd like SQL Data Catalog to respond on (default is/
). - Set the system environment variable
Redgate_SqlDataCatalog_Port
to the port you'd like SQL Data Catalog to respond on (default is15156
). - Start the Configuration App and run through it.
- Re-enter the connection details to your existing classification database when prompted.
- Continue through the config app.
- At its final step, it'll pick up your Path and Port changes, allocating the required URLs on your system.
- Start the SQL Data Catalog Windows Service.
On Linux
Run SQL Data Catalog with the above environment variables set, e.g.
docker run -it --rm \
-p 127.0.0.1:80:8080/tcp \
-v "$PWD/logs:/usr/share/Red Gate" \
-e "REDGATE_SqlDataCatalog_StateStorage__ConnectionString=Your Connection String Here" \
-e "Redgate_SqlDataCatalog_Path=/desired-virtual-path" \
-e "Redgate_SqlDataCatalog_Port=8080" Docker Image Id \
IAgreeToTheEULA
The above snippet runs SQL Data Catalog once, cleaning up (removing) the docker container after execution.
It maps the local address 127.0.0.1:80 to port 8080 inside the container (to match the Redgate_SqlDataCatalog_Port setting), letting you access the application from http://localhost.
It maps the local process directory ./logs to the logging directory within the container, letting you read the logs after the execution.
Finally, it configures catalog to serve its content from /desired-virtual-path.