Datastream

From ISOR
(Difference between revisions)
Jump to: navigation, search
(make sure you are connected to UNI's VPN.)
(Access / Workflow)
Line 10: Line 10:
 
# Added value data sets from respected sources such as MSCI, DJ Stoxx and FTSE All World.
 
# Added value data sets from respected sources such as MSCI, DJ Stoxx and FTSE All World.
  
=Access / Workflow=
+
=Overview=
==VPN==
+
== Install Clients ==
up to date (F5 BigIp) VPN-Client
+
You might need to '''install 2 clients''' on your machine:
 +
# A VPN client, an up to date (F5 BigIp) VPN-Client ([https://zid.univie.ac.at/en/services/services-from-a-z/v/vpn-virtual-private-network/ ZID])
 +
# A VNC client, to connect to the desktop at the datacenter, like tigervnc (former tight-vnc),
 +
[[File:linux_icon.png|14px]] linux: yum install tigervnc ''or'' apt-get install tigervnc-viewer,
  
for detailed instructions please use the relevant [https://zid.univie.ac.at/en/services/services-from-a-z/v/vpn-virtual-private-network/ ZID] instructions.
+
or similar viewers for windows, etc.
 +
<!--
 +
or
  
 +
* java enabled web-browser to run an unsigned applet (which could cause troubles)
 +
-->
 +
== Steps ==
 +
There are a few '''steps to follow''':
 +
# Stay within the UNI's network (if working from hone, use the VPN).
 +
# Book a time slot for your session
 +
# Once your time slot has started, retrieve your password
 +
# Connect to the data-center's desktop using a tiger/tight vnc-viewer 
 +
= Steps =
 +
==VPN==
 +
Once connected via VPN, you could check the functionality by just connecting to [http://calc.isor.univie.ac.at:8787 Calc]
 +
 
==Book Session==
 
==Book Session==
 
Because our license is "per seat", [https://shib.isor.univie.ac.at/booking-datastream/calendar.php you have to book a time-slot.] "Fair-play" is assumed, restrict yourself to a couple of hours per week not to get restricted.
 
Because our license is "per seat", [https://shib.isor.univie.ac.at/booking-datastream/calendar.php you have to book a time-slot.] "Fair-play" is assumed, restrict yourself to a couple of hours per week not to get restricted.
  
==3) Virtual Desktop==
+
==Retrieve Password==
 +
After your time slot has begun, [https://shib.isor.univie.ac.at/booking-datastream/show_password.php retrieve your password.]
 +
 
 +
== Virtual Desktop==
 
[[File:VirtualDesktop.gif|right|frameless|100px|caption]]
 
[[File:VirtualDesktop.gif|right|frameless|100px|caption]]
After your booked session has started, [https://shib.isor.univie.ac.at/booking-datastream/show_password.php retrieve your password.]
+
# After you have already connected to the UNI's VPN,
 
+
# start your vnc-viewer and use your [https://shib.isor.univie.ac.at/booking/datastream/show_password.php session-password] to establish a connection
===Prerequisites===
+
* vnc-client like tigervnc (former tight-vnc), [[File:linux_icon.png|14px]]:
+
yum install tigervnc ''or'' apt-get install tigervnc-viewer
+
or similar viewers for windows, etc.
+
or
+
* java enabled web-browser to run an unsigned applet (which could cause troubles)
+
 
+
===Start Virtual Desktop===
+
====make sure you are connected to UNI's VPN.====
+
 
[[File:vncviewer.png]]  click '''<Connect>''' [https://shib.isor.univie.ac.at/booking/datastream/show_password.php and provide password.] [[File:Vnc_passwd.png]]
 
[[File:vncviewer.png]]  click '''<Connect>''' [https://shib.isor.univie.ac.at/booking/datastream/show_password.php and provide password.] [[File:Vnc_passwd.png]]
  
 
Apple might require to fill in '''datastream.isor.univie.ac.at:5900'''
 
Apple might require to fill in '''datastream.isor.univie.ac.at:5900'''
  
[[File:linux_icon.png|14px]]: run
+
[[File:linux_icon.png|14px]]  vncviewer datastream.isor.univie.ac.at:0
  vncviewer datastream.isor.univie.ac.at:0
+
and authenticate with your [https://shib.isor.univie.ac.at/booking/datastream/show_password.php session-password.]
+
  
Best to use the Full-Screen-Mode, note the keys to escape, e.g. '''<Strg> + <Alt> + <Shift> + <F>'''
+
<!--Best to use the Full-Screen-Mode, note the keys to escape, e.g. '''<Strg> + <Alt> + <Shift> + <F>'''
  
On your remote screen you may use <F8> for <Ctrl>, <Alt>, etc.
+
On your remote screen you may use <F8> for <Ctrl>, <Alt>, etc.-->
  
 
Log on as '''Researcher'''. A new Desktop will be prepared for you, which could take up to two minutes.
 
Log on as '''Researcher'''. A new Desktop will be prepared for you, which could take up to two minutes.
  
==Applications==
+
=Applications=
===Excel===
+
==Excel==
 
You can query and retrieve your results directly from within Excel through plugins by using the icon at the upper left corner of your desktop.
 
You can query and retrieve your results directly from within Excel through plugins by using the icon at the upper left corner of your desktop.
  
===Storage Clients===
+
==Storage Clients==
 
Various clients have been installed for saving your data, like Google-drive, u:cloud or Dropbox. Don't forget to save your work before your session ends. Everything will be deleted, so that the next user starts without any left-overs.
 
Various clients have been installed for saving your data, like Google-drive, u:cloud or Dropbox. Don't forget to save your work before your session ends. Everything will be deleted, so that the next user starts without any left-overs.
== Documentation ==
+
=Documentation =
 
* [https://w3.loibl.com/uni/datastream_5_1_getting_started.pdf getting started]
 
* [https://w3.loibl.com/uni/datastream_5_1_getting_started.pdf getting started]
 
* [https://w3.loibl.com/uni/datastream_guide_excel2010.pdf use Excel]
 
* [https://w3.loibl.com/uni/datastream_guide_excel2010.pdf use Excel]

Revision as of 13:52, 13 July 2021

The Datastream Terminal is used for remote computing. Since only one University member can access it at a time, a time slot has to be booked before hand.

Contents

1 Functional Range

Datastream gives you access to the world's largest and most respected historical financial numerical database such as

  1. Worldwide equity coverage direct from the stock markets
  2. Comprehensive market indices,
  3. Economics data direct from national government sources as well as the OECD and IMF,
  4. Fixed income securities and associated indices, commodities and derivatives data.
  5. Forecast earnings data from IBES, fundamental data from Worldscope, and
  6. Added value data sets from respected sources such as MSCI, DJ Stoxx and FTSE All World.

2 Overview

2.1 Install Clients

You might need to install 2 clients on your machine:

  1. A VPN client, an up to date (F5 BigIp) VPN-Client (ZID)
  2. A VNC client, to connect to the desktop at the datacenter, like tigervnc (former tight-vnc),
Linux icon.png linux: yum install tigervnc or apt-get install tigervnc-viewer, 
or similar viewers for windows, etc.

2.2 Steps

There are a few steps to follow:

  1. Stay within the UNI's network (if working from hone, use the VPN).
  2. Book a time slot for your session
  3. Once your time slot has started, retrieve your password
  4. Connect to the data-center's desktop using a tiger/tight vnc-viewer

3 Steps

3.1 VPN

Once connected via VPN, you could check the functionality by just connecting to Calc

3.2 Book Session

Because our license is "per seat", you have to book a time-slot. "Fair-play" is assumed, restrict yourself to a couple of hours per week not to get restricted.

3.3 Retrieve Password

After your time slot has begun, retrieve your password.

3.4 Virtual Desktop

caption
  1. After you have already connected to the UNI's VPN,
  2. start your vnc-viewer and use your session-password to establish a connection

Vncviewer.png click <Connect> and provide password. Vnc passwd.png

Apple might require to fill in datastream.isor.univie.ac.at:5900

Linux icon.png  vncviewer datastream.isor.univie.ac.at:0


Log on as Researcher. A new Desktop will be prepared for you, which could take up to two minutes.

4 Applications

4.1 Excel

You can query and retrieve your results directly from within Excel through plugins by using the icon at the upper left corner of your desktop.

4.2 Storage Clients

Various clients have been installed for saving your data, like Google-drive, u:cloud or Dropbox. Don't forget to save your work before your session ends. Everything will be deleted, so that the next user starts without any left-overs.

5 Documentation

Personal tools
Namespaces

Variants
Actions
Navigation
Tools