Versions Compared

Version Old Version 4 New Version 5
Changes made by

Douglas Loyo

Douglas Loyo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This "How to" guide was made possible thanks to the Michael and Susan Dell Foundation.

Description

The following instructions will guide you through the instantiation of the Google Cloud Ed-Fi ODS/API v3.4 VM and tools.

Prerequisites

This will be a hands-on exercise activity using the Ed-Fi ODS/API deployed in a VM on Google Cloud, and you will need to provide your own laptop and have access to a Google Cloud tenancy.

...

Setup Instructions

1) Login to (https://console.cloud.google.com/compute/instances)

...

5) To be able to access the VM you will need to use the following credentials:

  • Username: Administrator
  • Password: EdFi!sCool

*NOTE: We recommend you change the password on the Administrator account upon first login.

*Optionally, you can create a windows account. To do this click the arrow next to RDP and select "Set windows password"

6) A prompt will come up. Make sure that you type edfi for the username. After you click on "Set" it will give you a secure password. NOTE: You should save that password in a secure place.

76) Open RDP (Remote Desktop Connection). Hit your windows key and type RDP and enter.

87) Use the external IP, edfi user and the password it gave you to connect to the VM

98) At this point you should be in the VM and we can start exploring the Ed-Fi ODS API

Exploring the Ed-Fi ODS API:

Exploring Databases

1) Open SSMS (Sql Server Management Studio) by clicking on the icon on the task bar.

...

3) Expand the databases on the left panel (Object Explorer). You will see a list of all databases. At this point you can expand and explore all tables and objects in the Ed-Fi ODS databases.

         Image RemovedImage Added

Exploring IIS and the Available Sites

1) Open IIS (Internet Information Services) by clicking on the icon on the task bar.hitting the windows key, typing IIS and hitting enter. 

Image Added        Image Removed

2) Expand the server by clicking on the arrow on the left. (Expand all websites and virtual directories) (#1)

3) Click on the application that says api (#2)Api that is under the v3.4.0Sandbox virtual directory.

4) On the right "Actions" panel click on browse 443 (#3). It will open a Chrome Browser window . Click on Browse as Guest. Then go back to the IIS window and click on Browse 443 again. This time it should open a second tab with the api URL.

          Image Removed

          Image Removedwith the ODS\API URL.

Image Added

Image Added

5. Without closing the Chrome browser you can return to IIS and explore the other applications by selecting them and clicking on Browse 443.

6. Open the "docsDocs" application that resides inside the /v3.4.0Sandbox/ virtual directory. This is the production sandbox swagger. Click on the resources link on the right.

        Image RemovedImage Added

7) Authorize your session: Click on the authorize button and use the following credentials.        client

  • client_id:

...

  •  A0hcXwnYrwaj
  • client_secret:

...

  •  fIM7AKJNYqDRF2DPgD8zup8i

Then click on the "Authorize" button and the inputs should switch to asterisks. This means you are authorized. At this point you can click the "Close" button.

Image RemovedImage RemovedImage AddedImage Added

8) Execute the students request: Scroll all the way to the bottom of the screen and locate the students request. Click on the arrow on the right to expand it (#1). Then proceed to click on the "GET" request (#2) to expand the options. Click on the "Try it out" button (#3) and scroll to the bottom until you see a big blue button that says "Execute". 

...

Production:

Sandbox:


Exploring the Ed-Fi ODS API through PostMan

1) Open Postman. Click on the icon on the task bar.

...

Note: you have to have authenticated first by running the "POST Get Auth Token" request and getting an access_token as described above. 

         


KNOW Issues:

1) When executing "gcloud compute instance create" it gives the following errors:

...