In this document the PublicDNS is

The AMI's Pre-installed PostgreSQL Database

The information you need to access the billing data in AMI's PostgresSQL database is shown below. The database has one user account with read access to the data. You will use this user name and password when accessing the content of the Cloud Billing Database.

database namebilling
user namebilling_viewer

The AMI depends on its Security Group to enforce database security. We do not want to burden the technical staff with the task of maintaining database users and password. We believe it is less burdensome to restrict access to the AMI on which the database resides.

If you need access to the database contact the AMI's administrator. The AMI administrator will add your client IP address to the AMI's Security Group.

The PostgreSQL documentation is available at:

The AMI's Pre-installed Service

The service performs two functions. The first is to load the data from the Amazon S3 billing files into the PostgreSQL database. The seconds is to communicate with the outside world. For example the most important information you need to communicate to the server is the location of the S3 bucket that contain the billing files.

You can interact directly with the service using any web browser. All you need is enter the http://PublicDNS/rest/v1/ into the browsers destination URL window.

The Sample Web Application

This web application interact indirectly with AMI's pre-installed service. It provides a more familiar user experience. Its most important feature is that it provides an interactive query tool. This tool presents the database content in a more user friendly fashion than does the service itself.

The easiest way to access this application is to connect to the Cloud Billing AMI's home page. Start a web browser. Enter http://PublicDNS into the browsers destination URL window.

The AMI's web server will automatically re-direct you to the Dowd and Associates Cloud Billing web page. Note that the re-direction adds the address of the PublicDNS in the query string.

This web application demonstrates how to interact with AMI's pre-installed service. Use it as is or as the starting point of your own reporting web site.

Amazon Web Services, the "Powered by Amazon Web Services" logo, AWS, and Amazon S3 are trademarks of, Inc. or its affiliates in the United States and/or other countries.