Import, export, and back up data

This topic describes how you can export and import data through XML files and how to back it up.

Export data

You can export data to use with another connector. You can export resources such as data sources, connections, connection groups, and user maps in order to share them across installations. When you export data, an XML file is created that can be imported into another instance of the product.

The Export grid contains multiple tabs, each with grid data organized into several columns. Each column features a search box, enabling you to search within a specific column.

To export data:

  1. Click the Actions button Actions button in the top banner, and select Export from the menu. The Export Connect Data dialog box opens.

  2. Select the data you want to export in the tabs. The Servers tab is only visible for users with Site roles with a multi-node server installation.

    The grid contains multiple tabs, each with grid data organized into several columns. Each column features a search box, enabling you to search within a specific column.

  3. Click Export.

    Note: Exports do not include your stored passwords. In the exported file, the Password fields show OBFUSCATED_PASSWORD. Before importing a file, manually update the Password fields with the correct passwords. Optionally, if you do not want to include passwords in the import file, import the file with the OBFUSCATED_PASSWORD value, and edit the data sources before using them.

Back to top

Import data

This section describes how to import data from an XML file into Connect.

To import data:

  1. Click the Actions button Actions button in the top banner, and select Import from the menu. The Import Connect Data dialog box opens.

  2. Browse to the XML import file.
  3. Click Import.

Note: Depending on your role, imports may not include Global settings. You will need to set them manually. For details, see Troubleshooting. If you did not update the passwords in your imported file, you need to edit the data sources and set the correct passwords before using them.

Troubleshooting import:

For large XML files, you may need to increase the parameter com.microfocus.connect.max.read.size.

The default value is 2048000 (2 megabytes).

Windows

  1. Run the following command from a command prompt:

    %MFCONNECT_HOME%\WebServer\bin\Tomcat9w.exe //ES//ConnectWebServer

  2. In the Java options, update the value below as needed:

    -Dcom.microfocus.connect.max.read.size=2048000

Linux

  1. Open the setenv.sh file in the /MicroFocusConnect/WebServer/bin folder.

  2. Update the value below as needed:

    -Dcom.microfocus.connect.max.read.size=2048000

 

Back to top

Database backup

To perform backup, follow instructions in the official PostgreSQL documentation, in the section "Backup and Restore."

Back to top