First steps - Creating a Virtual Database

We saw in the previous section that we need valid credentials to connect to a Denodo database. In our case, we used the default admin user to connect to the admin database.

Now, we are going to learn how to create another database.

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 the virtual databases created in the Denodo server (and different users can have different privileges for each virtual database).

We are going to create a new database called tutorial.

  1. First, click on Administration in the Menu Bar and select the Database Management option.
  2. In the workspace, you will see the predefined Denodo databases (these databases cannot 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 button.
    2. Specify the name of the database: tutorial.
    3. 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

When changing the user, it is not necessary to disconnect and reconnect. Another option is to navigate through the Elements Tree and simply selecting the tutorial database.