BI Studio manages multiple database connections and other bi specific resource files (reports, queries etc.) in a project file. The project file extension is “biapp” and has a custom icon.
The project file is an encrypted and human unreadable file, which includes all database connections. The user has the option to save the database connection password into its project file.
To create an project file, either uses the Project Selector dialog or the Project Explorer window.
The Project Selector dialog will be only shown on Application start up. The Project Selector toolbar contains New Project, Edit Project and Open Project buttons. Using these buttons, you can create a new project, edit or open an existing project.
The user must enter a app project name and browse a project file; otherwise the “OK” button will not be enabled.
To create a new database connection, click the “Add” button. A connection dialog will be shown and a database engine (system) can be selected from the combo-box.
After selecting a database engine, you will get the connection specific options.
After filling the fields and testing the connection, click the “OK” button to save the connection. The dialog will be closed automatically.
The following steps explain how to add a connection:
· Click the “Add” button and Connection dialog will appear.
· Select a host engine
· Fill the connection fields
· Click “OK” button