SFTP Connections to Jedox Cloud

image_pdfimage_print

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

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

  • Credentials and a dedicated SFTP key for your Cloud environment, as provided by in an email from Jedox Support after your order was placed.
  • 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.
  • You must email your static IP to Jedox Support so it can be added to the Jedox whitelist for SFTP connections. 
    To find out your IP, go to http://whatismyipaddress.com/.

Example of an SFTP connection setup:

 

After setup of the SFTP connection, the following folders will be available under /ps/user_data/live/:

Folder Description
/backup

Keeps both snapshots triggered by Integrator and complete daily backups.

  • /backup – keeps the daily backups
  • /savepoint – triggers snapshots via Integrator
/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 files related to Tomcat server (Integrator)
  • /log – contains the log files
  • /svs_custom – contains 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 Jedox Cloud 

  1. Connect to the Jedox Cloud environment with your SCP client of choice.
  2. Copy the new Jedox database folder into the /ps/user_data/live/data directory.
  3. Restart the machine from the production console. The new database will be available in the Jedox Web Modeler.

Updating a database in Jedox Cloud

  1. Open Modeler in Jedox Web of your Jedox Cloud instance.
  2. Delete the existing database that you want to update.
  3. Add the updated database version as described above.

Fetching data from Jedox Cloud to a local machine

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