First steps - Creating a Virtual Database

We have seen in the previous sections of the Tutorial that we need valid user credentials to connect to a Denodo database.

In our example, we used the default "admin" user and the "admin" database. Now, we are going to learn how to create another database for this tutorial.

To complete the tutorial this step is not neccessary. If you are going to use the default admin database you can continue to the next section.

NOTE

The Denodo server can contain different virtual databases. A virtual database is a schema comprised of data sources, views, stored procedures, web services, etc. Each virtual database is independent of the rest of virtual databases created in the Denodo server (and different users can have different privileges for each virtual database).

Now, you are going to create a new database called "tutorial".

  1. First, click on the Administration top menu and select the Database Management option.
  2. In the workspace you will see the predefined Denodo databases (these databases can not be dropped):
    • admin: default database for Denodo Virtual DataPort.
    • itpilot: default database for Denodo ITPilot.

  3. You are going to start a new project, so you will need to create a new database (this is a best practice):
    1. Click on the New Database button.
    2. Specify the name of the database: tutorial.
    3. And click Ok.

That's all!

Now, you can follow this Tutorial using this new database, so disconnect your current session (File > Disconnect) and log in again into the tutorial database:

  • Login: admin
  • Password: admin
  • URI: //localhost:9999/tutorial

Another option is connecting to the tutorial database without having to disconnect and connect again, using the File > Switch to database menu option (see screenshot below).