Google Analytics Connector and Sales Demo

The project has two sections:

1. Google Analytics Connector The application is built as a Java class file, using the Google analytics API to pull web site analytics data, and place inside a MYSQL database.

Following functionalities were implemented:

1. Connect to the Google Analytics API with a Google account from a properties file.

2. Properties for the class includes anything environment specific, database connect info, Google account info, timeout settings, OS dependent paths, etc.

3. Retrieve all NEW data (data not in the MYSQL database) for the whole sites.

4. Used a SAX parser to convert XML to Java Objects.

5. Report (log) any invalid / incomplete data.

6. Protect against API timeouts.

7. Report (log) API unavailability.

8. Method that if called by an external thread would interrupt the execution, and clean up all memory structures and external connections to the API and database.

9. Insert the data into a MYSQL database structure that closely matches the API data format, but has additional fields to help with retrieval at a later date, such as “insert time” and “a unique identifier”.

10. The insert should be transactional so ensure partial data is not inserted.

11. Report (log) database errors and rollback any pending inserts that are related to the data being inserted.

12. Perform all data operations in less than 1 minute optimally, 5 minutes absolutely.

13. The database structure should have sufficient indexing to allow fast retrieval of all data.

2. Sales Demo

Developed sales demo to simulate a web application. Content lives within an XML file. It simulates a web application that already exists and used by the customer Sales-force. Application works in IE 6, 7, 8 and the most recent version of FireFox (Mac & PC), Safari (Mac & PC) and Google Chrome.