Use this tool to import data to a new table created in the database currently loaded in the Engine. For example, this tool is useful when you want to create a Master table.
How to import a table
1 Select the source of the data to be imported. Options range from MS Access to text files.
2 For a text file, select file features and whether the first row contains the file header.
3 In the columns section, create the definition of the columns by selecting Get columns or Add columns. The definition of a column can be changed by double-clicking it. You should define as many columns as there are in the file.
4 Use the Column up and Column down buttons to change the position of a column.
Use links to delete existing relations between columns in different tables and to create new relations between columns. Creating links is important when working with the Engine. If the links have not been created or have been created incorrectly, it is not possible to work with various levels of resolution in the analysis. You cannot obtain reliable results when you mix columns from different tables in the database in a crosstab or a Venn diagram.
BIRT Analytics provides two export tools. Export File exports a segment to a plain text file. Export Database exports a segment to a table in the database. Supported export file formats are: CSV (comma‑separated values) file, a standard format supported by programs such as Excel and text editors including Ultraedit and Notepad++, and PDF file. Both tools provide Save and Save As options.
When you save an export definition, both the segment and the export configuration are saved in your personal folders. You can share your folders with others by granting viewing permission to a user or to a group or groups of users. Groups can contain from just one to any number of individuals. Permission granting is managed in the BA Admin tool.
How to export to a text file
1 In Enrichment—Import‑Export, choose Export➛File.
2 Drag the segment you want to export from Scratchpad and drop it in Segment to export.
3 In Delimiter, select a column character separator: Tab, Pipe, or Flat.
4 In End of line, select an end-of-line character: CR, LF, CRLF, or LFCR.
5 To save the file in the application server, choose Deferred. You can download this file from the application server by choosing Downloads.
6 To add a field containing the Uniform Resource Name (unique identifier) to the generated file, choose URN.
7 In Available columns, to select the fields to export, drag each field from the left pane to the right pane. To change the order of the fields, use the up and down arrow buttons.
How to export to a database
The export-to-database tool exports a segment to a new table in the analytical database engine. You must select the database in which you want to create the new table, the name of the new table, and the fields to create in the destination table.
This tool shows a list of deferred export files. This list shows the date, type, name, and file size. To download or delete an export file from the application server, you must open it.
