Enable a VFS metastore

Before you can use a remote metastore, you must enable the VFS connection in the PDI client. To do this you will create a metastore configuration XML file, then edit the VFS connection information in that file.

Perform the following steps to enable a VFS metastore:

  1. Open the PDI client and create a VFS connection to the storage location that you want to use as your metastore.

    The VFS connection information will be saved to a file. See Create a VFS connection

  2. Close the PDI client.

  3. Navigate to the \Users\<yourusername>\.pentaho\metastore\pentaho\Amazon S3 Connection\ directory and copy the VFS connection file you just created to the Users\<yourusername>\.kettle directory.

  4. Rename the file to metastore-config.

  5. Open the metastore-config file with any text editor and add scheme and rootPath elements, along with their values.

    See the appropriate section in Metastore configuration.

  6. Save and close the metastore-config file.

  7. Restart the PDI client.

The remote VFS metastore is now enabled. Note that the previous connections in the PDI client still exist in your local metastore directory, but no longer display in the PDI client. When you create a new VFS connection, the new connection will be in the location specified in your metastore-config file.

Last updated

Was this helpful?