Is it possible to connect an external database (like postgres) using an analysis script?
Yes, you can!
There are two ways to do it, one option is running an external analysis, then you can run your analysis on your intranet and access your DB, another way is running an analysis on Tago and add analysis IPs on your firewall whitelist .
Also, to run it on TagoIO (not external) you will need TagoBuilder to add Postgres drivers.
After creating the script with Tago Builder, I upload the file in the “Files” section of the TagoIO administrator. Now, how can I use this file as an internal script?
You need to create an analysis and upload your script to the analysis page, like the image below: