Register CSV Mashables

You can register any file that uses the commas-separated-values (CSV) format as a mashable information source. Access to the data in the file depends on the file location.

1. Select Connect > CSV in the Business Analytics Hub main menu.

2. Enter a unique Name for this mashable information source. MashZone NextGen uses this name to assign a unique ID. For more information, see What are valid artifact names and IDs?.

3. Choose the Location of the CSV file:

For files that are on your computer or a network drive, choose Local. Then enter the location for the file or click Browse to find the file.

With local files, Business Analytics takes a snapshot of the data. To make updates to the data available, you must reregister local CSV files.

For files that are available via HTTP, via content management systems such as SharePoint, choose Remote and enter the URL to this file.

For remote files, Business Analytics accesses the file dynamically each time the mashable is run. This ensures that updates to the data are always available.

4. If the CSV file uses a delimiter other than a comma, change the Delimiter to:

Other for any other character. Then enter the delimiter.

5. If the first line of the CSV file does not contain the names of the fields in each record, clear the Use the First Row as Column Header option.

Business Analytics will generate field names such as Column1.

6. Add metadata for this mashable, such as a description or category. For more information, see Descriptions, Providers, Categories and Tags for Artifacts external.

7. If this CSV file is remote and requires authentication information when you run it, choose the Security Profile to use for authentication and complete the fields for this profile. See Mashable Authentication with Security Profiles for details.

Business Analytics retrieves a snapshot of the CSV file, registers the data as the mashable and turns this mashable information source on (by default). Then, either:

Grant permissions to run this mashable to other users and groups:

Choose the mashble-wide Service >> mashable name permissions section to grant run permissions to all operations. Or expand a specific Operation >> operation name section to grant run permissions for just that operation.

Click on a user or group in the Search result list to add them to the list of Principals with permissions.

To allow other users to work with this mashable, you must grant run permissions at a later time.

Note:

Some groups or users may already be listed as Principals with permissions. These users and groups have been defined by a Business Analytics administrator to grant permission automatically.

You can open the artifact page for this new mashable to run the mashable, add views, take snapshots, create basic apps based on this mashable, edit the mashable, turn it off or grant permissions to other users to work with it.