Analytics-Plus Help

Creating a New Table

 

  • Create Table by Importing data from Files & Feeds
  • Create Table by Importing data from Relational Databases
  • Design a New Table from Scratch
  • Enter Data Right Away

 

ManageEngine Analytics Plus provides different options to create a table to store your tabular data. As already discussed, once you create a database you can create any number of tables within it.

When you create a table in a database using any of the options provided, you need to provide a name which is mandatory and it should be unique in that database. You can optionally provide a description about the table.

Click on new icon in the right top corner of the database or every report/table in the database and then choose New Table. On clicking, various options to create a table will be listed which are discussed below.

 

Create Table by Importing data from Files & Feeds

Often you would already have data locally stored in tabular file formats like CSV, TSV, XLS & XLSX (Excel), XML, JSON and HTML files. The data in such formats could also be available as a URL or Web feed. You would like to import or copy and paste such data into ManageEngine Analytics Plus to jumpstart your analysis and reporting over it.

You can read a detailed step by step instruction document on how to create a table by Importing data from Files and Feeds by clicking here.

 

 

Create Table by Importing data from Relational Databases

 

You can pull data from relational database and upload the same into ManageEngine Analytics Plus. You can connect to the databases like MySQL, Oracle, SQL Server, Sybase, PostfreSQL, DB2,TeraData, MS Access or any JDBC driver supported database.You can use Upload Tool to pull data from your databases and upload the same into ManageEngine Analytics Plus.

 

Design a New Table from Scratch

Use this option if you would like to create a new table from scratch, by defining the columns to be present along with its properties (like type, default value etc.,). You might add data subsequently into this table or import data from an external file into this table.

The following list explains the fields to be filled while designing a table

Once you have added the necessary columns in the table, click Save in the toolbar. The Save dialog will pop up. Provide the name and description for the table. Click OK to save the table.

You can edit or delete a column by clicking the settings icon (which appears on mouse over), and then select the corresponding option.

 

 

Enter Data Right Away

If you are an Microsoft Excel or spreadsheet user who would like to first enter the data into the tables and then worry about naming the columns or formatting them, then this is the option that you have to choose. 

In the sheet, you can start entering the data that you wish to add under the respective columns named Column1, Column2 etc., You can also rename the column headers by double clicking on them and providing a name. As mentioned already, do ensure that column names are unique in a table.

Once you are done with your data entry, click on the Save button in the toolbar. This will prompt the Save dialog where you need to provide the name of the table (mandatory) and description (optional). The new table will be created with the given name, including the newly added data and columns.

 

You can also rename a table from the Navigation Tree on the left, which lists all the view in the database or from the Reports Explorer.

Share this post : FacebookTwitter