To use the addons in a standalone setup you need to create an account at the provider's website. I assumed that Heroku had some agreement with the providers which lets them bypass this and instead passes on the user's Heroku details transparently
Heroku Addons are super well documented and easy to develop and deploy. One of the best parts of the platform.