RT Demo: Edge Database-Exporting the Results of Your Research

Introduction - Edge Database

Researchers can export their summarized, aggregated and/or analysis results data, which do not contain sensitive information, to the public Edge database. This enhances analytical capabilities, enabling connections from the Edge database to local applications and/or other public data sources.

Note: Users are required to submit initial table export requests, and any subsequent changes to the given table schema, for review and approval by the Data Steward.

Below mentioned are detailed instructions guiding through the export process for new Edge Database

1. Log into SDC web portal.

2. Navigate to the Datasets page.

3. Scroll down to the 'My Edge Database' section.

4. Click on ‘Request to Export Table to Edge Database’ button.

   Open

   

    

5. Fill in the required fields on the form.

   1. Please enter the name of the table to be exported to the public Edge database. E.g. wazedata_test01

   2. What are the primary Project, Data Provider and Sub-Dataset/Data Type used to create your table? E.g. Waze, CVP, FRA-ARDS

   3. List any additional data sources that are used to create your table dataset.

   4. Provide justification for your request.

   5. Click the check box for Acceptable Use Policy Agreement.

      Open

      

6. Once all the required information has been selected and entered, click the 'Submit' button. This will send your request to the Data Owner/ Data Steward for review.

7. Once the Data Steward has provided their approval, researchers will receive an email stating that their request was approve/denied.

Instructions- Export/download data from EdgeDB)

Driver Manager

1. VPN from your DOT laptop.

2. Open Dbearver.

3. In the DBeaver menu, open Database → Driver Manager

4. In the Driver Manager dialog box, select PostgreSQL, then click Edit…

5. In Edit Driver ‘PostgreSQL' dialog box, click the Libraries tab

6. Select and Delete the following
   org.postgresql:postgresql:RELEASE
net.postgis:postgis-jdbc:RELEASE
net.postgis:postgis-geometry:RELEASE

7. Click Add Folder

8. In the Open driver directory dialog box, navigate to: C:\Users\Public\JDBC Drivers\PostgreSQL and click Select Folder.

9. Click Find Class.

10. From the Driver Class dropdown, select org.postgresql.Driver

11. Click OK.

12. Click Close

New Database Connection

1. In the DBeaver toolbar, click the New Database Connection button

2. In the Connect to a database/Select your database dialog box, search for and select PostgreSQL

3. Click Next

4. In the Connect to a database/Connection Settings dialog box, on the Main tab, enter the Host, Port, Database, Username and Password that were provided to you .

5. Click Test Connection

6. You should see a new Connection test dialog box giving information about the server. Similar to the following.

7. If you get an error, recheck the information you entered on step 4.

8. If you continue to get an error, please contact the Enablement Team via the Service Desk.

Instructions for Data Provider/Data Stewards

A new table “Export Table Requests” section has been added to the  Export Requests view which outlines individual request details and approval status.

Data providers can see the requests in the ‘Export Table Requests’ tab of the SDC web portal, as seen in the Figures below;

Actions of Review

1. Notify Review: The request of the Researcher is sent to the data provider for approval by
   sending him/her a notification over an email. The data provider has to accept or reject the
   request from the SDC web portal under the section named ‘Export Table Requests’.