Add Custom Data to a Jet Analytics Project
The Jet Data Manager allows you to insert your own data into tables, whether they come from a data source or are created in the Jet Data Manager as custom tables. An example of where this would be useful is when you have data that you wish to use in the data warehouse or cubes, but the data does not presently exist in a source database. Records can be inserted into these tables in either the Staging or Data Warehouse areas of a project.
There are two methods of creating custom data:
-
Insert records via file import
This feature requires that the drivers for Excel are installed.
The two examples below illustrate how to perform each method by inserting a list of holidays into a custom Holidays table.
Insert records manually
-
Right-click the Tables node, and select Add Custom Table.
-
Give the table a descriptive name (say, Holidays) and press OK.
-
Right-click the Holidays table node and select Add Custom field.
-
Add two custom fields named Date and Description.
-
Right-click the Holidays table, and navigate to Advanced > Custom Data.
-
Manually enter the dates and descriptions of holidays. When finished, click OK
Insert records via file import
-
Prepare an Excel file that contains the data that you wish to import. In the spreadsheet, give descriptive names to your column headers , and save the file to a path that can be accessed from within the Jet Data Manager.
On the same screen as Step #6 above, click Import Data
-
Perform the following steps;
Click Select File , and navigate to the path of where your Excel document is saved.
In the Work Sheets drop-down, pick which sheet from your workbook contains your data.
Check the box Remove Existing Data to have the Jet Data Manager delete any records that may already exist in the table you are importing data into.
Under Field Mapping, in the drop-down fields, map the columns in the spreadsheet to the columns in your table.
-
Click OK.