Retrieving MARC records over SFTP

Customers may collect MARC records over SFTP by following these instructions

What is SFTP?

SFTP (SSH File Transfer Protocol) is a secure file transfer protocol. It runs over the SSH protocol. It supports the full security and authentication functionality of SSH.

SFTP has pretty much replaced legacy FTP as a file transfer protocol, and is quickly replacing FTP/S. It provides all the functionality offered by these protocols, but more securely and more reliably, with easier configuration. There is basically no reason to use the legacy protocols any more.

SFTP also protects against password sniffing and man-in-the-middle attacks. It protects the integrity of the data using encryption and cryptographic hash functions, and authenticates both the server and the user.

From: https://www.ssh.com/academy/ssh/sftp 

How can I access Digital Theatre+ MARC records using SFTP?

Already have a public key?

Send the public key for your SSH key pair to our Support Team requesting access to MARC records via sftp-marc.digitaltheatreplus.com.

Don't have a public key?

You can generate a key pair as follows:

  1. Open a terminal
  2. Run the command:  ssh-keygen -P "" -m PEM -f digital-theatre-marc
  3. This will generate two text files:
    1. The private key: digital-theatre-marc
    2. The public key: digital-theatre-marc.pub
  4. Send only the public key to our Support Team; do not send the private key ⚠️.  The private key is essentially the password.
  5. Place both the public and private key pair into a secure storage location, such as an encrypted password manager.  You will need the private key to connect to the SFTP service.

Note: By default, we will use your email address as the username.  If you wish a different email address to be used, please let us know when you send your public key to us.

Windows users

Generating an SSH key pair requires the use of an SSH client.  MacOS and Linux users should already have the client installed.  Windows users may need to follow these instructions: Install OpenSSH using Windows Settings

Configuring your SFTP client

Once we have confirmed that your access is set up, you can configure your SFTP client to login using the following details:

  • Server: sftp://sftp-marc.digitaltheatreplus.com
  • Port: 22
  • Username: your email address (or the address you requested we use)
  • SSH Private Key: The private key file from the pair (not the file ending with .pub)

Navigating the MARC records listing

  1. MARC records are organised into folders representing the year and month (e.g. 2022-04)
  2. In each folder you will find:
    1. Master files
      1. Master files containing records for all the items published on the platform (including written, audio and video)
      2. Master files containing records for written items published on the platform
      3. Master files containing records for audio items published on the platform
      4. Master files containing records for video items published on the platform
    2. Incremental files
      1. Incremental files contain all changes (newly published, updated or removed) since the previous month.
      2. Incremental files are organised the same way Master files are, with all, written, audio and video files for your convenience.
    3. Country specific files
      1. Due to licensing restrictions on a small number of our content items, you will see that files contain an ISO 3166-1 alpha-3 code in their names.  If your country is not listed, we recommend you select a country that is geographically close to your location.

SFTP access example set up using Cyberduck

What is Cyberduck?

Cyberduck is an open-source client for FTP and SFTP, WebDAV, and cloud storage available for macOS and Windows (as of version 4.0) licensed under the GPL.

From: https://en.wikipedia.org/wiki/Cyberduck 

Configuring Cyberduck

Note: Digital Theatre+ does not recommend specific software clients, and is not affiliated with Cyberduck.

1 Start Cyberduck  
2 Click Open Connection Screenshot 2022-04-28 at 18.12.37
3 Select SFTP (SSH File Transfer Protocol)  Screenshot 2022-04-28 at 18.12.24

Enter connection configuration details

4

Click Connect

Screenshot 2022-04-28 at 18.33.58
5 Right click on the file you want and click Download Screenshot 2022-04-28 at 18.35.40