Databases

Virtual DataPort uses a simple structure of databases and folders to organize its elements. The administrator of the Virtual DataPort defines a set of databases and may define a hierarchical structure of folders inside it. The users then create views and web services in a database and place them inside a folder. According to this classification, a view or web service belongs to a unique database and to a unique folder inside it.

Note

Although this organization in databases and folders provides a logical structure for your data, it is intended to address the management needs of Virtual DataPort users. It may not suit your discovery needs.

To start browsing by databases and folders go to Browse > Databases / Folders. You will see the set of databases on the sidebar.

Browsing by databases and folders

Browsing by databases and folders

If you click a database, you will see a page with all its details:

  • The Summary tab shows a description for the database. At first, it is obtained from Virtual DataPort. However, if you have the proper permissions, you will see a edit icon next to the description. Click it and define a new description, which will be specific to the Data Catalog.

  • In the Summary tab you can also find the Connection URLs button. Click it and obtain the URLs to connect to the database through all the available APIs: JDBC, ODBC, REST and OData.

    URLs to connect to a database of Virtual DataPort through all the available APIs

    Click the copy icon next to each URL to copy it to the clipboard

    Note

    The Connection URLs button may have been disabled by the administrator of the Data Catalog.

  • From the Views and Web services tabs you can browse all the elements created in the database. If you click the name of a view or web service, you will see its details page.

  • An administrator of the Data Catalog can add custom properties to the database to improve the information you have about it. According to the configuration, they will appear inside a new section of the Summary tab or in a new tab. Again, if you have the proper permissions, you will see a edit icon to edit them.

On the sidebar, you can expand a database and navigate through its folders. Expand a folder and discover its views, its web services ant also its subfolders. If you click a view or a web service, you will see its details page.

You can filter the elements shown in the sidebar. Under the Database title you have a search bar. Type some query terms on it and press ENTER (or click the search icon). The sidebar will list only those elements that match with the query. Take into account that the search only filters on the elements of those databases that have been previously expanded.

Note

Notice that when you are browsing by databases and folders, you are obtaining real-time data from Virtual DataPort. It may be different from the data you get when browsing by categories or tags, which comes from the metadata stored in the Data Catalog during the last synchronization.