Export and import Connections, Listeners, and Formats

Overview

Use Export/Import to copy Connections, Listeners, and Formats between accounts or duplicate them with all the parameters, including encrypted credentials. 

Export Connections, Listeners, and Formats

Step 1. Click Export/Import in the Connections window.

Step 2. Select Export, and then select the Connections, Formats, and Listeners to export. 

Step 3. Click Export All or Export Selected. A file with the extension .etld will be downloaded to your local drive.

Import Connections, Listeners, and Formats

Step 1. Click Export/Import in the Connections window.

Step 2. Select Import, click Please choose the dump file to import, and then select the file. 

Step 3. After selecting the file, select the objects to import, collision policy, and extra tags if needed. Click Import Selected or Import All.

Collision policies

The following collision policies are supported:

• Add: Etlworks will create new Formats, Connections, and Listeners. The following rules are used when creating the Flow's artifacts: 

  1. When you import a Connection, Listener, or Format, Etlworks creates a new object with the same parameters as the original but adds the suffix (timestamp). For example: FW XML file [05-17-2017_14-52-41]. It makes sense to change all generated names to something else — for example, removing the (timestamp) suffix and modifying the name. Ensure that the new name is unique; otherwise, Etlworks will not allow you to change it.

  2. If you are importing an HTTP Listener, the original endpoint will be updated. Change the URL Pattern before using the new Listener. The URL Pattern must be globally unique across all Listeners. 

• Replace: Etlworks will replace existing Connections, Formats, and Listeners if the name and the type are the same as in the Flow to import.
• Keep. Etlworks will keep existing Flows, Connections, Formats, and Listeners if the name and the type are the same as in the Flow to import.

Tags

If you choose to add new tags, the selected tags will be added to all Formats, Connections, and Listeners, created or updated during the import.

Export File Encryption

Every export file is encrypted with the default key.

To override the key used for encryption and decryption of the export files, go to Settings -> Security -> Export/Import Encryption section and provide your own Private Key in PEM format and the optional Private Key Passphrase.

This function is only available to customers with dedicated instances.

How to generate the key

Key should be in PEM format (PKCS#1) that starts with the tag "-----BEGIN RSA PRIVATE KEY-----".

• On Linux or Mac systems - use ssh-keygen -t rsa -m PEM.
• On Windows - install OpenSSH Client (Apps & features -> Optional features->OpenSSH Client), generate the key using ssh-keygen -t rsa -m PEM. Alternatively, install PuTTY, use PuTTYgen to generate the key.