Elastic Marts Builder
2 files included in this download
Description
Elastic Marts Builder allows business users and developers to easily allocate an elastic data mart (i.e. a database) inside the Teradata System. Using an on demand self service portlet, the user can create a database, upload comma separated values (.CSV) data, and begin analysis – all within 5-10 minutes.
.png)
For installation and configuration, see the Elastic Marts Builder Installation Guide. For general background info on this portlet, see What is the Teradata Agile Analytics Cloud?. Please note that while this product is not officially supported, you can talk to other users and get help in the Cloud Computing forum. Also, note that the download now includes the full source code for the portlet.
README
------------------------------------------- Teradata Elastic Marts Builder Overview ------------------------------------------- The idea for Elastic Marts is to create an environment on a Teradata System, where users can come and self create their personal database workspace. This is mainly for business users that might not be very technical and database savvy. It allows users to create a private Elastic Mart database, upload data into database tables within the space, and download data from them. Once the data is within the Elastic Mart, they can run SQL queries to join table data between it and their EDW using familiar business tools, such as Business Objects or normal SQL queries. Users are required to renew and extend their Elastic Marts every 30 days by clicking on an email renewal link. Elastic Mart accounts that have not been renewed or extended will be permanently deleted, so environment space will be preserved. The Teradata Elastic Marts Builder is a Viewpoint Portlet that helps faciliate the creation of Elastic Marts. Teradata Viewpoint Portal is required for deployment. ------------------------------------------- Current Features in 0.9 ------------------------------------------- * User self creation of personal Elastic Mart environment. * Uploading of Comma Separated (CSV) data files into Elastic Mart tables. * Downloading of Elastic Mart table data as Comma Separated (CSV) files. * Deletion of Elastic Mart tables. * Granting of Elastic Mart permissions to user's existing database user account. * Automatic expiration of unused Elastic Marts. * Renewal/Extension of Elastic Marts. ------------------------------------------- Installation Instructions ------------------------------------------- For Elastic Marts Builder installation instructions, please visit: http://developer.teradata.com/viewpoint/reference/elastic-marts-builder-...
CHANGELOG
--------------------------------------------------------------------------------------------------- These features were new in version 0.9.1 (released 2010-03-05): --------------------------------------------------------------------------------------------------- ETOOLS-2650: Make the OK button on the account creation screen accessible via the Enter Key ETOOLS-2643: Move hard coded properties url out of sqlmapconfigsandboxapi.xml ETOOLS-1986: Check for duplication CSV header column names ETOOLS-1433: Minor Formatting -- Update "Advanced" link for Table Upload to display DDL correctly
Discussion
how does this manage resource consumption. soon elastic datamarts could be as plentiful as rabbits in june.
The current 0.9 version of the portlet does not perform any resource management out of the box. An open source version will be released shortly, which will allow you to modify the code that generates the data marts to your specifications.
A way to perform resource management would be to modify the portlet's user creation DDL to assign each newly created user to a specific profile that has a certain type of account string. Based on the account string, then each of these "Data Mart" users could be put into a resource management system (i.e. resource partitions & allocation groups).