SQL Data Catalog

Customize virtual path and port

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 is 15156).
  • 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.



Didn't find what you were looking for?