Setting Up an SFTP Connection to a Jedox Production Cloud

image_pdfimage_print

You can use the Secure File Transfer Protocol (SFTP) to transfer data from and into Jedox Production Cloud.

To connect to a machine via SFTP, you need the following:

  • Credentials and a dedicated SFTP key for your cloud environment. Provided together from Jedox Support after your order by email.
  • Send in your email your static IP. It must be added to the Jedox whitelist for SFTP connections. 
    To find out your IP, go to http://whatismyipaddress.com/.
  • An SFTP client. On  Windows, you need to download and install one, such as WinSCP. On Linux and Mac, the SFTP client is usually present by default.

Example of a SFTP connection settings:

 

After setup of the SFTP connection, the following folders will be available:

Folder Description
Backup

Keeps both snapshots triggered with ETL and complete daily backups.

  • Backup – keeps the daily backups
  • Savepoint – triggers snapshots via ETL.
Live

The actual data from the Jedox system:

  • Data – contains the persistence files of the In-Memory DB
  • Storage – contains the persistence files of the Spreadsheet Server
  • Tomcat – contains tomcat server-related files
  • Log – contains the log files
  • svs_custom – allows you to place your custom-made svs scripts
  • apache_custom – allows you to upload custom data available inside the docroot of the Web Server

 

Adding a new Jedox database into your Jedox Cloud System

  1. Connect to the cloud environment with your SCP client of choice.
  2. Copy the new Jedox database folder into the live/Data directory.
  3. Restart the machine from the production console. The new database is available in the Jedox Web Modeler.

Updating a database in the Jedox Cloud System

  1. Open Modeler in Jedox Web of your Jedox Cloud System.
  2. Delete the database for which you have an updated version.
  3. Add the updated database version as described above.

Fetching data from your Jedox Cloud System to a local machine

  1. Connect to your Jedox Cloud System using WinSCP.
  2. Go to backup/backup and copy the desired files from your daily backups.
image_pdfimage_print