Repository registrations and databases
Repository registrations contain the information for the connection to a repository database.
Note: You can use Microsoft SQL Server, Oracle, and PostgreSQL repository databases. PostgreSQL
repositories require database interface version 1.14 and newer.
To register a repository database, right-click in the tree and select . The dialog New Registration opens.
To create and register a repository database, right-click in the tree and select . The dialog Create Repository opens.
After the creation, the new database registration will be displayed underneath the node.
Note: We recommend that you use SQL Server Authentication for all SQL Server repositories
that are accessed by Dashboards or by Application Studio WebServices. From Infor BI version 10.6, a single database connection is established between a Dashboards server or an Application Studio WebServices and SQL Server. There is no longer a connection for each user. If you use Windows
authentication, the credentials of the first user who accesses the repository are
used. Subsequent users may receive error message when they log on, and be prompted
for their credentials.
Related topics