FileSystem DataSource in DBFS FileSystem In Remote Designer

Here is how to use User Properties which is applicable to all files in a DBFS FileSystem on Remote Designer.

  1. Create a DBFS filesystem using Elixir Repertoire Server web interface.
  2. Add files into the filesystem by dragging them from a folder in Windows Explorer or files in other filesystems while holding the Ctrl key, right-click on file in other filesystem and select Copy or create files in filesystem explicitly.
  3. Right-click on any individual file and select Edit File Properties.... A window which is similar to Figure 12.2, “File Attributes” will appear. User can enter some keywords for easy reference.

    Figure 12.2. File Attributes

    File Attributes
  4. In the User Properties tab, user can add or modify user property. For demonstration, we will add an additional user property with Creator for Name and Thomas for Value. Click on Finish to confirm all changes.
  5. Next, create a FileSystem DataSource in the same DBFS filesystem. For Root, enter the path of the DBFS filesystem. It should be something like: repository:/<DbfsFileSystemName>.
  6. In the next page of the wizard, user will need to enter the name of the property entered in the file previously, which was Creator. Note that this is case-sensitive. Click Finish to confirm the changes.
  7. Load the datasource. By scrolling to the outmost right of the loaded data, user will be able to find two additional columns. They are Keywords and Creator. The keywords and user property entered for the files will be displayed.