Configuring a Secure Access to your organisation’s Data Vault drive

  1. The user using SFTP generates an SSH key pair (private/public) and provides the public key to the Organisation Data Manager.

  2. The Organisation Data Manager adds the SSH public key in the Data Vault SFTP connector.

  3. The Organisation Data Manager obtains the SFTP user for the organisation from our support team and shares it with the user using SFTP.

  4. The user connects to SFTP via any preferred SFTP client (FileZilla, Cyberduck, Terminal, etc.):

Copying Data via SFTP

Load data into the target folder or table.

Copying unstructured data (files)

Use any preferred SFTP client (FileZilla, Cyberduck, Terminal, etc.) to load your files data into the files folder - for example via Terminal:

scp -i <path to private key> /<path/to/folder> <sftp user>@<sftp server>:<organisation-data-vault-drive>/files/<folder> -r

Copying structured or semi-structured data (database tables)

Note: A Data Vault database needs to be created from the Data Vault UI first.

Use any preferred SFTP client (FileZilla, Cyberduck, Terminal, etc.) to load your table data into the target table folder - for example via Terminal:

scp -i <path to private key> /<path/to/source-database>/<source-table> <sftp user>@<sftp server>:<organisation-data-vault-drive>/databases/<data-vault-database>/<data-vault-table> -r
Did this answer your question?