PuTTY
Used to create an SSH tunnel. An active session is required to connect to the backend database and LDAP directory.
The hostname is ec2-54-68-101-218.us-west-2.compute.amazonaws.com; or IP address 54.68.101.218
The forwarding ports are as follows:
- L1389=10.0.0.200:389 (for LDAP on share1)
- L389=10.0.0.235:389 (for LDAP on share-training)
- L1521=10.0.0.114:1521 (for Oracle on db)
Software can be downloaded at http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html
Configuration Screenshot
Hostname
Private key
The actual private key file can be obtained on AWS IT Infrastructure for SHARE Development Team
Ports
No need to include the letter L in Source port, it will be added by the tool
Oracle SQL Developer
Used to connect to the backend Oracle database to access the Semantics Manager's reporting views described here: https://share.cdisc.org/sm/common/help/Reference/DatabaseViews.html
Software can be downloaded at http://www.oracle.com/technetwork/developer-tools/sql-developer
Configuration Screenshot
- Password is noi$yEnd65
- Reporting views are under these database named users:
- CDISC – for libraries SHARE-Testing (ID:4); and, SHARE (ID:5)
- CDISC_TRAINING – for libraries SHARE-Training (ID:4); and, SHARE-Sandbox (ID:5)
- View names contain library ID in the suffix, e.g., SHARE.RPT_ASSET_5 is the RPT_ASSET for the production SHARE library
Apache Directory Studio
Used to access SHARE user directory. User information in Semantics Managers are stored in the LDAP server.
Software can be downloaded at http://directory.apache.org/studio/downloads.html
Configuration Screenshot
Network Parameters
Authentication Parameters
- Password is 0ink0ink
- Not advisable to delete LDAP account once it is used by Semantics Manager
- Use Semantics Manager's user account Synchronize functionality to sync changes made in Apache Directory Studio
Overview
Content Tools