SDB Explorer UI is designed with many enhanced important features for using Amazon SimpleDB services. SDB Explorer is flexible, powerful, and easy to use interface for Amazon SimpleDB. It has following important features:
AWS Identity and Access Management :
SDB Explorer is designed to explore Amazon SimpleDB service using an easy graphical user interface (GUI). And now SDB Explorer facilitates its users to interact with
AWS Identity and Access Management (IAM)
service with an attractive and simple user interface.
Upload MY-SQL table :
SDB Explorer helps to
upload structured database
table like Mysql on Amazon SimpleDB and provides an option to select a field as an item-identifier, after upload value of your selected field remains unique in an item row and rest of the columns are sorted accordingly.
SimpleDB Commander :
SimpleDB Commander
is a command line tool for Amazon SimpleDB. You can configure and
schedule SimpleDB Commander
for automation of
Export Domain
feature of SDB Explorer.
Amazon SimpleDB SELECT query :
Using SDB Explorer you can run
SELECT query
for each
Amazon SimpleDB domain
just like other database queries to fetch some specific attribute, and to use WHERE clause to make a search with specific condition.
Export domain :
Export Domain
feature in SDB Explorer helps you to export data from Amazon server to your hard disk in XML format. You have option to export all items in a SimpleDB domain in single XML or multiple XMLs as per your work requirement.
Search on Item Name ( Item Identifier ) :
This feature of SDB Explorer provides search on Item name (i.e.
Amazon SimpleDB item identifier
). Amazon does not provide search on item identifier, SDB Explorer has an extra attribute "Sdb-item-identifier" for each row. Using this feature you can quickly retrieve an item row and can perform the 'Update' and 'Delete' item row beyond the
pagination
limit.
Sort by Item Identifier ( Item Name) or Attributes :
This feature of SDB Explorer provides sorting of records in ascending/ descending order by any of the attributes. It has an extra attribute 'Sdb-item-identifier' to provide
sort on item identifier
.
Put Attribute with REPLACE :
SDB Explorer helps in putting attributes in SimpleDB domain. 'Replace' option is provided when you perform '
put attribute
' operation. You can add multi-value for an attribute OR can replace older value by choosing Replace option.
Update an Item Row or an Attribute :
SDB Explorer provides facility to
update
whole item row as well as single attribute value as per your requirement..
Displays SimpleDB Domain property :
A right click '
domain properties
' option on selected domain displays its properties. Properties get displayed are: Domain name, Total item, Item-Name Size, Total Attributes, Attribute-Name Size, Total Attribute-Values, Attribute-Values Size.
Minimizes Amazon SimpleDB request for fast listing :
SDB Explorer uses QueryWithAttributes which provides fast listing of results. It includes list of attributes-value pairs with item identifiers which reduces number of requests and hence, it saves money.
Create Domain and item row :
You can create new
Amazon SimpleDB domain
using SDB Explorer. SimpleDB Domains consist of rows and columns in which you can store your structured data. With SDB Explorer, you can also add new item row(s) any time in domain.
Delete Domain and item row :
You can
delete Amazon SimpleDB domain
/ item row using SDB Explorer. Item row can be deleted one by one or all at once using 'Delete all items' option.
Display Query Charges :
SDB Explorer shows the charges for the last executed query and the total of all executed queries for the current session which is calculated by
Amazon SimpleDB BoxUsage
in USD. Thus you are able to know about how much you have to pay.
Quick Connect :
Name option after
Access Key and Secret Key
is used for storing user's name. Quick connect menu shows saved Name to login Amazon SimpleDB. You can use 'Edit Credentials' option to add/ edit or remove AWS credentials in quick connect menu. By using 'clear history' option all your saved credentials can be deleted.
Protects AWS Credentials with or without password :
You can save your
AWS credentials
with or without password on local. When you use save without password option, your credentials are decrypted with machine name and every time when you run SDB Explorer you don't need to give password, decryption will be done automatically.
Preference panels for pagination and proxy setting :
SDB Explorer provides two options in preference window for
pagination setting and Proxy setting
which makes it more user friendly.
Help on start up :
On start up SDB Explorer provides help for you, if you don't have an
account on Amazon SimpleDB
. It also guides you how to create a domain on Amazon SimpleDB, if you have no domain in your account.
Tip and Tricks :
SDB Explorer provides tips and tricks on startup which helps users in getting information about its features and makes it easy to perform SimpleDB operations.
Debug on/off :
You can set
debug on
to create debug logs of all the activities performed in your Amazon SimpleDB account. Using debug logs you can track all the activities in SDB Explorer. Set 'debug off' stops debug logging.
Support for new Region End Point in Asia-Pacific (Tokyo) :
SDB Explorer starts supporting new region end point in Asia-Pacific (Tokyo), so that user can choose a region for domains to optimize for latency, minimize costs, or address regulatory requirements. Users from Japan can take benifits from Tokyo Region to reduce latency to end-users, keep their data entirely in Japan.
Upload My SQL Data to Amazon Simple DB
SDB Explorer provides feature to upload bulk data to Amazon SimpleDB from MY SQL. You can specify primary key of your database table as an Amazon SimpleDB Item Name. SDB Explorer provides you better visualization and statistics of your uploading data. SDB Explorer allows you to generate item names automatically for uploading data in bulk.
Import data from CSV file to Amazon Simple DB:
SDB Explorer allows to import data from CSV file to Amazon SimpleDB. You can upload data of CSV file to Amazon SimpleDB. You need to provide settings for CSV parser and you can specify column number from your CSV file that you would like upload as Amazon SimpleDB Item Name. If you do not have unique data in any column to set as Amazon SimpleDB Item Name then you can use auto generate item name option.
Bulk Upload with Direct Cell Editing:
SDB Explorer supports
Direct Cell Editing
feature providing you an editor window to insert data only for bulk upload. You will get an editor window of your specified dimension and using that window you can start inserting data into cell.
Add/Manage Database Connection Profile :
SDB Explorer provides you feature to create profile to connect with your database. This profile is useful when you are trying to upload data from MySQL. This profile save your host address, port number, database user and their password.
Basic text editing on Amazon Simple DB Queries :
Editing queries using SDB Explorer is now become more easier. User can copy - paste queries and undo - redo changes. User can also comment query and can run only selected part of query.
