Connecting local database via ngrok
If you need to connect your local database and don’t want to use the on-premise version, you can go for an option of connecting via ngrok.
We highly recommend this approach for testing purposes only, as ngrok is a 3rd party proxy that provides a temporary connection (40-120 minutes depending on your plan), and re-connection will be required.
To connect your local database via ngrok, follow the steps below:
  1. 1.
    Create your account at ngrok in case you do not have one
  2. 3.
    Unzip the archive (initial instructions can be found here)
  3. 4.
    Open Terminal (MacOS, Linux) or command line (Windows) and navigate the Downloads folder (or any other folder where the ngrok folder has been saved). Use command cd Downloads
  4. 5.
    To authenticate, find your personal authtoken on your authtoken page. The token should look like this: ./ngrok authtoken 20JWDkD3uwe2wuRqhCvuTkQ0LE3_5N6KtiEBDLD3fXZkRHpej
  5. 6.
    In case of success, you’ll get the following message: Authtoken saved to configuration file: /Users/user_name/.ngrok2/ngrok.yml
  6. 7.
    To expose a local app server or database using one of these commands :
1
app server: ./ngrok http 80 (or port your server is hosted on)
2
mysql: ./ngrok tcp 3306
3
postgre: ./ngrok tcp 5432
4
mssql: ./ngrok tcp 1433
5
mongodb: ./ngrok tcp 27017
Copied!
The output will list a forwarding URL, which will point to your local server - find the Forwarding line and copy the host and the port there
Obtaining host and port
Next, navigate UI Bakery - Connect Datasource
  • Select your data source and specify the copied host and port together with the other database details
  • Click Test Connection to ensure that the connection can be established
  • In case of success, Connect Datasource
Specifying connection details
Last modified 20d ago
Copy link