Using SSDS Explorer

Hands-On Lab
Session 4.3 - Lab 01
Using SSDS Explorer

 S+S Deep Dive Training

 

Description 3
Goals and Objectives 3
IF You Have Previously Done This Lab 3
Expected Duration 3
Step 1 - Launching SSDS Explorer Tool 3
Step 2 – Create(Post) an Authority 5
Step 3 - Create (POST) a container 6
Step 4 - Create (POST) an entity 6
Step 5 - Query service and retrieve metadata for all you authorities 7
Step 6 - Query an authority and retrieve metadata for all containers within it 8
Step 7 - GET an authority 9
Step 8 - GET a container 10
Step 9 - GET an entity 11
Step 10 - Update (PUT) an entity 12
Step 11 - Delete an entity 13
Step 12 - Delete a container 14
Step 13 - Delete an authority 15
 
 

 

Information in this document, including URL and other Internet Web site references, is subject to change without notice.  Unless otherwise noted, the example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious, and no association with any real company, organization, product, domain name, e-mail address, logo, person, places or events is intended or should be inferred.  Complying with all applicable copyright laws is the responsibility of the user.  Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document.  Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.

2001-2006 Microsoft Corporation.  All rights reserved.

Microsoft, MS-DOS, Windows, Windows NT, Active Directory, Authenticode, IntelliSense, FrontPage, JScript, MSDN, PowerPoint, Visual Basic, Visual C++, Visual C#, Visual Studio, Win32, and Windows Media are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

The names of actual companies and products mentioned herein may be the trademarks of their respective owners.
Session 4.3 - Lab 01
Using SSDS Explorer

Description
This lab will show you how to use SSDS Explorer-a tool shipped with SSDS SDK to manipulate data in SSDS.
Goals and Objectives

 Understand SSDS Authority-Container-Entity data model.

IF You Have Previously Done This Lab

 

Expected Duration

20 Minutes

Step 1 - Launching SSDS Explorer Tool

1. Go to Start menu, click All Programs->Microsoft SQL Server Data Services, click SSDS Explorer:
 
2. You’ll see SSDS Explorer is launched:
 

 
Step 2 – Create(Post) an Authority

1. Ensure the Address Bar shows service scope. (https://data.beta.mssds.com/v1/).
2. Press the Authority template button. Skeleton XML payload appears in the editor window.
3. Provide authority Id value in the XML payload. As you enter authority id, the Address Bar shows that authority id in the URI.
4. Press POST. If operation is successful a green check mark appears in the status box.
 

Note.If you get below prompt,
 
please enter the following username and password :
UserName:yanwang
Password: iHGR4A8Wz3dv1zZ3d0Ra

Step 3 - Create (POST) a container

1. Ensure the Address Bar shows appropriate authority scope. For example, https://<authority-id>.data.beta.mssds.com/v1/.

2. Press the Container template button. Skeleton XML payload appears in the editor window.

3. Provide Id value for the container in the XML Payload. As you enter container id, the Address Bar URI updates.

4. Press POST. If operation is successful a green check mark appears in the status box.
 

Step 4 - Create (POST) an entity

1. Ensure the Address Bar shows appropriate container scope. For example, https://<authority-id>.data.beta.mssds.com/v1/<container-id>.

2. Press the Entity template button. Skeleton XML payload appears in the editor window.

3. Provide Id value for the entity in the XML Payload. As you enter entity id, the Address Bar URI updates.

4. Add optional user-defined properties:

5. Press appropriate Property type button to add a user-defined property of specific type.

6. Specify property name and value. Specify property name by changing the start and end XML tag values.

7. Press POST. If operation is successful a green check mark appears in the status box.

 

Step 5 - Query service and retrieve metadata for all you authorities

1. Ensure the Address Bar shows service scope (https://data.beta.mssds.com/v1/).

2. Enter the following query in the Query box

from e in entities select e

3. Press the Query button.
 

Step 6 - Query an authority and retrieve metadata for all containers within it

1. Ensure the Address Bar shows specific authority scope (https://<authority-id>.data.beta.mssds.com/v1/).

2. Enter the following query in the Query box

from e in entities select e

3. Press the Query button.
 

Step 7 - GET an authority

1. Ensure the Address Bar shows specific authority scope (https://<authority-id>.data.beta.mssds.com/v1/).

2. Press the GET button.

 

Step 8 - GET a container

Ensure the Address Bar shows specific container scope (https://<authority-id>.data.beta.mssds.com/v1/<container-id>).

Press the GET button.
 

Step 9 - GET an entity

1. Ensure the Address Bar shows specific entity scope (https://<authority-id>.data.beta.mssds.com/v1/<container-id>/<entity-id>).

2. Press the GET button.

 

Step 10 - Update (PUT) an entity

1. Ensure the Address Bar shows specific entity scope (https://<authority-id>.data.beta.mssds.com/v1/<container-id>/<entity-id>).

2. Press the GET button.

3. Update user-defined properties as follows:

4. Update existing user-defined properties

5. Delete any user-defined properties.

6. Add new user-defined properties using the Property buttons of appropriate type.

7. Press POST. The updated entity payload is sent back to the service.

8. If you query a container the result is an EntitySet. To update a specific entity in the EntitySet, the entity must be the active entity in the editor window. This can be done by holding the control key and pressing the left mouse button. For additional keyboard shortcuts, see Keyboard Shortcuts for SSDS Explorer.

 

Step 11 - Delete an entity

1. Ensure the Address Bar shows specific entity scope (https://<authority-id>.data.beta.mssds.com/v1/<container-id>/<entity-id>).

2. Press the DELETE button to delete the entity.

 

Step 12 - Delete a container

1. Ensure the Address Bar shows specific container scope (https://<authority-id>.data.beta.mssds.com/v1/<container-id>).

2. Press the DELETE button to delete the container.
 

Step 13 - Delete an authority

Authority deletion is not supported in this release.