A database is defined without opening a file, by a wizard of six steps. The wizard is reached with "Add Database" in the bar of a group of [[Invantive Query Tool Multi-Platform/Discover Databases|Discover Databases]], which opens it with that group already chosen. It is available from release 28.0. The wizard follows the wizard of Invantive Query Tool for Microsoft Windows, described in [[Invantive UniversalSQL/General/Discover Databases|Discover Databases]]. The title of the window is "New Database" on the first and the last step, and "Add Data Container to" and the name of the database on the steps in between. Each step has a line of explanation under the title, and the buttons "Back", "Next", "Cancel" and "Finish" stand at the bottom. ![[20261008-qtm-database-wizard.png]] ## Step 1: The Database The first step asks for what the log-on window shows. The line reads "A database is what you log on to. Give the database a name you will recognise and choose the group it belongs under." The step has five fields: - "Name" is the name of the database. - "Group" is the group it belongs under. The group is filled in when the wizard is opened from the bar of a group, and a name which does not exist yet makes a new group. - "Short Description" and "Description" explain the database. - "Sort Order" is the place among the other databases of the group. It starts at 500. "Next" is available as soon as the name and the group are filled in. ## Step 2: The Type of Data Container A database has one or more data containers to exchange data with. The second step asks which type the first one is: - "Platform Reached Directly with Driver": the platform and the driver are named, and the product connects to it. A database on a server of an organisation itself is of this type. - "Data Containers of Invantive Cloud Database": a database on Invantive Cloud and a service account are named, and the Invantive Credentials Server hands over the platforms behind it. The first type is the one to choose unless an organisation manages its databases on Invantive Cloud. ## Step 3: The Driver The third step asks "Which driver reaches the platform?". It is skipped for the second type, since the Invantive Credentials Server states the driver itself. The box "Search Drivers" narrows the list "Available Drivers" down to the drivers whose name contains the text. Choosing a driver shows its icon, its name and the name which a settings file writes for it. A driver which the licence does not cover is listed and greyed, so that the platform is known to be reachable and what it takes; "Next" stays unavailable for such a driver. ## Step 4: The Connection The fourth step asks "Where is the platform, and who are you on it?". For a platform reached directly, the page shows the connection fields of the driver, such as `Host`, `Port` and `Database` for PostgreSQL, each with its explanation. A driver which has no connection fields shows an empty page. A field which stays empty is left to the driver. For the second type the page asks for the three things that type is made of: "Database", the segment of the address with which Invantive Cloud knows the database; "Credentials Server", which stays empty for the standard server; and "Data Containers", a list of aliases in which an asterisk means all of them. "Next" is available when the database is filled in. ## Step 5: The Log-on Window The fifth step asks "What does the log-on window ask for, and what does it offer?". "Default User Name" and "Default Password" are what the log-on window starts with. A default password is stored readable in the settings file, and an empty default password makes the product ask for the password at log-on. More choices, such as showing the user name without letting it be changed, are made afterwards in the [[Invantive Query Tool Multi-Platform/Database Editor|Database Editor]]. ## Step 6: Saving The last step says "This is what the database will hold." and lists the data containers with their driver, their alias and their order. The alias of a data container is made from the name of the driver, with the number of the data container behind it from the second one on. "Add Another Data Container" goes back to the second step for a database which reads from more than one platform. A text under the list names the settings file the database is stored in, which is the settings file of the user, and says that a copy of that file is written to the backup folder first. "Finish" writes the database. A database is saved once it reads from at least one platform. The database is in the log-on window and in Discover Databases as soon as the wizard closes. A tile of a database which was added while the window of Discover Databases stands open carries a blue edge at the left.