To set up repository connection and to work with it, use the Set Up Repository Connection dialog box or determine platform settings from file in the desktop application.
Set the parameters:
Name. Enter repository name that will be displayed in the login dialog box on starting Foresight Analytics Platform. Name may differ from the identifier.
Identifier. Enter repository identifier that is a metadata schema stored on the database server.
Driver. Select the driver in use in the drop-down list. For details about available drivers see the Supported DBMS section.
Set additional DBMS parameters depending on the selected driver type:
Server. Enter IP address or DNS name, with which the server with connected database (repository) is registered. The box is displayed if the driver type is selected: Microsoft SQL Server 2008, 2012\2014\2016, ODBC, Teradata, or PostgreSQL.
NOTE. When setting up repository connection, make sure that server IP address or DNS server name matches with the server specified on creating a service user on each client computer.
Schema/Database. Enter identifier of the database, to which the connection is established. Database identifier should match with repository identifier. The Schema box is displayed if the driver type is selected: Oracle, Teradata. The Database box is displayed if the driver type is selected: Microsoft SQL Server 2008, 2012\2014\2016, ODBC, PostgreSQL.
Schema. Enter identifier of the custom schema if it was created on preparing DMS back end. The box is displayed if the driver type is selected: Microsoft SQL Server 2008, 2012\2014\2016, ODBC or PostgreSQL DBMS. The default schema for Microsoft SQL Server is "dbo" and for PostgreSQL is "public".
In the desktop application, additional connection parameters to SQLite and WEB Service are available:
File Name. Select the file with database connection settings using the Select File button. A standard file selection dialog box opens. The box is displayed if the SQLite driver type is selected.
Entry Point. Enter IP address or DNS name, on which BI server is installed. The box is displayed if the WEB Service driver type is selected.
Repository Identifier. Enter identifier of the database, to which the connection is established. The box is displayed if the WEB Service driver type is selected.
Authentication Type. Select in the drop-down list one of the user authentication types on the database server:
Password. Default value. The user is authenticated by means of specifying user name and password explicitly.
Integrated Domain. The user is authenticated by means of specifying domain user name and password explicitly (of the current operating system account). If the authentication type is selected for Oracle in Windows OS, determine additional server settings.
Domain. The user is authenticated by means of specifying domain, user name and password explicitly. The authentication type is available if the driver type is selected: Oracle, Microsoft SQL Server 2008, 2012\2014\2016, ODBC, PostgreSQL.
NOTE. To use the Integrated Domain or Domain authentication type, first, add domain users or domain groups in the security manager.
The parameter is available for all DMS types, except for SQLite.
DBMS is Case Sensitive. If required, select the checkbox to work with the repository, objects and their fields in DBMS having different character case in their physical names.
NOTE. After the checkbox is selected, database objects will be available only if their exact physical names are specified.
If the checkbox is deselected, the repository name, object identifiers and their fields in DBMS are converted to lower case while the platform addresses the server.
In the desktop application this parameters is contained in the Additional Parameters dialog box.
Default Repository. Select the checkbox to display this repository automatically in the login dialog box on starting Foresight Analytics Platform if required.
NOTE. The default repository can be only one. If another default repository is already used, after the checkbox is selected, the default repository will be changed for the current connected repository.
If the default repository is not set, on starting Foresight Analytics Platform, the login dialog box will display the latest connected repository. If web application cache was cleared, the login dialog box will display the repository specified in the PP.xml file in the <metabase> section.
In the desktop application a default repository is selected in the Parameters dialog box.
After executing the operations the repository connection is set up.
To save settings, click the Apply button in the web application or the OK button in the desktop application.
The desktop application contains additional parameters to set up repository connection:
Use Unicode Encoding for Data Representation. Select the checkbox to use Unicode encoding to connect to server. It is used for text constants on creating requests. This checkbox is supported only by Oracle DBMS.
Cache Assemblies on Local Drive Only. Select the checkbox to prevent conflicts on compiling Fore units/forms/assemblies with different versions (builds) of the platform. The checkbox is deselected by default. For details see the Caching Repository Objects article.
If the checkbox is selected, the assemblies created on forms and units compilation are compiled on the local drive and not changed on the server.
If the checkbox is deselected, on starting the assemblies created on forms and units compilation, the system checks if assemblies on database server and local drive match If versions match, Foresight Analytics Platform continues working with assemblies on the local drive. If versions mismatch or there are no assemblies on the local drive, the database server compiles new assemblies and copies them to a local drive. Then Foresight Analytics Platform continues working with the assemblies on the local drive.
Cache System Tables on Server Startup. Select the checkbox to cache system metadata tables during BI server process startup. Caching allows for improving system performance and speeding up opening of complex reports that use a number of data sources in the web application by reducing the time of reading system tables from database. The checkbox is deselected by default.
IMPORTANT. Caching of system metadata tables is allowed only in the production version. When caching is used, data in system metadata tables must not be changed.
Each startup of BI server process is accompanied with creating a cache corresponding to a specific process. Cache is reset only when this process finishes. Cache is local for BI server and is global for active sessions within the running BI server process.
If a BI server cluster is used, cache is created for each work node of cluster and is not synchronized with each other.
NOTE. To set up system metadata table caching, see to the technical support by sending an email at support@fsight.ru or via technical support services that are available after registration at the website.
Lazy Loading of Object Descriptors. Select the checkbox to execute lazy loading of repository object descriptors. The checkbox is deselected by default. If the checkbox is selected, only the descriptors of the objects required to work in repository are loaded.
Features of Lazy Loading of Repository Object Descriptors
Apply Options For. Select the radio button to determine, which users of this computer have access to this repository setup:
Only for Me. Repository setup is available only for the current user.
Anyone Who Uses This Computer. Repository setup will be available for all users of this computer.
If the user has limited access permissions on Foresight Analytics Platform, and the Only for Me checkbox is selected, new repository settings are not saved. If the Anyone Who Uses This Computer checkbox is selected, the user will be denied access.
Clicking the Advanced button opens the Additional Parameters dialog box. Parameters depend on the selected driver type used for connection:
Set the parameters:
OS Users Name Format. Determine user name format on system login. If a prefix before user names is set on the server (the OS_AUTHENT_PREFIX parameter), specify the prefix in this box. The domain authentication may require specifying user name format because by default Foresight Analytics Platform uses the following name format for domain authentication: DOMAIN\USER_NAME. To create a format, the static text and the following substitutes can be used:
$User. User name.
$Domain. Domain name.
$FullDomain. Full domain name.
$FullDomainUser. Full domain user name (includes user name and full domain name separated with the @ character).
IMPORTANT. Note that format should be the same as the substitution case.
For example:
$User@$Domain.COM
In this format, user name looks as follows: IVANOV@EXAMPLE.COM.
$Domain@$User
In this format, user name looks as follows: EXAMPLE@IVANOV.
$User@$FullDomain
In this format, user name looks as follows: IVANOV@EXAMPLE.WORLD.COM.
$FullDomainUser
In this format, user name looks as follows: IVANOV@EXAMPLE.WORLD.COM.
Repository Language for the Current User. Select repository (schema) language. This setting determines language for displaying:
Names of repository objects, MDM dictionaries elements, express report titles.
Resources to create multilingual systems.
Values of time series database attributes, for which translation into different language is set.
One can select one of the radio buttons:
Default. The language is used, which was set on creating a repository.
Custom Interface Language. The interface language of Foresight Analytics Platform is used.
Other. Select one of the interface language supported by Foresight Analytics Platform in the drop-down list.
NOTE. If language settings are not determined for specified objects and names, default repository language is used.
Set the parameters:
DBMS is Case Sensitive. If required, select the checkbox to work with the repository, objects and their fields in DBMS having different character case in their physical names.
NOTE. After the checkbox is selected, database objects will be available only if their exact physical names are specified.
If the checkbox is deselected, the repository name, object identifiers and their fields in DBMS are converted to lower case while the platform addresses the server.
Connection String. Specify additional connection parameters using OLE DB or ODBC driver. Supported parameters in different OLE DB driver versions may differ. For details see Microsoft documentation.
Connection parameters specified for ODBC driver are stored in the system global variable that is automatically added to connection string when creating a database and another repository connection attribute.
When the Scheduler.xml configuration file is automatically created for task scheduler the specified connection parameters will be written in the ODBCPARAMS.
Repository Language for the Current User. Select repository (schema) language. This setting determines language for displaying:
Names of repository objects, MDM dictionaries elements, express report titles.
Resources to create multilingual systems.
Values of time series database attributes, for which translation into different language is set.
One can select one of the radio buttons:
Default. The language is used, which was set on creating a repository.
Custom Interface Language. The interface language of Foresight Analytics Platform is used.
Other. Select one of the interface language supported by Foresight Analytics Platform in the drop-down list.
NOTE. If language settings are not determined for specified objects and names, default repository language is used.
Set the parameters:
DBMS is Case Sensitive. If required, select the checkbox to work with the repository, objects and their fields in DBMS having different character case in their physical names.
NOTE. After the checkbox is selected, database objects will be available only if their exact physical names are specified.
If the checkbox is deselected, the repository name, object identifiers and their fields in DBMS are converted to lower case while the platform addresses the server.
Connection String. Specify additional connection parameters using the ODBC driver. Connection parameters are stored in the METABASE_ODBCPARAMS system global variable that is automatically added to connection string when creating a database and another repository connection.
When the Scheduler.xml configuration file is automatically created for task scheduler the specified connection parameters will be written in the ODBCPARAMS.
Repository Language for the Current User. Select repository (schema) language. This setting determines language for displaying:
Names of repository objects, MDM dictionaries elements, express report titles.
Resources to create multilingual systems.
Values of time series database attributes, for which translation into different language is set.
One can select one of the radio buttons:
Default. The language is used, which was set on creating a repository.
Custom Interface Language. The interface language of Foresight Analytics Platform is used.
Other. Select one of the interface language supported by Foresight Analytics Platform in the drop-down list.
NOTE. If language settings are not determined for specified objects and names, default repository language is used.
Set the parameters:
OS Users Name Format. Determine user name format on system login. If a prefix before user names is set on the server (the OS_AUTHENT_PREFIX parameter), specify the prefix in this box. The domain authentication may require specifying user name format because by default Foresight Analytics Platform uses the following name format for domain authentication: DOMAIN\USER_NAME. The following substitutes and static text can be used to create a format:
$User. User name.
$Domain. Domain name.
$FullDomain. Full domain name.
$FullDomainUser. Full domain user name (includes user name and full domain name separated with the @ character).
IMPORTANT. Note that format case should be the same as the substitution case.
For example:
$User@$Domain.COM
In this format, user name looks as follows: IVANOV@EXAMPLE.COM.
$Domain@$User
In this format, user name looks as follows: EXAMPLE@IVANOV.
$User@$FullDomain
In this format, user name looks as follows: IVANOV@EXAMPLE.WORLD.COM.
$FullDomainUser
In this format, user name looks as follows: IVANOV@EXAMPLE.WORLD.COM.
Authentication. Select the password authentication in the drop-down list:
Integrated. When the integrated authentication is selected, specify the user name and password created on preparing DBMS.
LDAP. When the LDAP authentication is selected, specify the user name and password to connect to LDAP server. Teradata will independently search repository user to connect to database. Communication uses the LDAP protocol.
Kerberos. If the Kerberos authentication is selected, specify user name and password to connect to LDAP server. Teradata will independently search repository user to connect to database. Communication uses the Kerberos protocol.
Repository Language for the Current User. Select repository (schema) language. This setting determines language for displaying:
Names of repository objects, MDM dictionaries elements, express report titles.
Resources to create multilingual systems.
Values of time series database attributes, for which translation into different language is set.
One can select one of the radio buttons:
Default. The language is used, which was set on creating a repository.
Custom Interface Language. The interface language of Foresight Analytics Platform is used.
Other. Select one of the interface language supported by Foresight Analytics Platform in the drop-down list.
NOTE. If language settings are not determined for specified objects and names, default repository language is used.
Set the parameters:
DBMS is Case Sensitive. If required, select the checkbox to work with the repository, objects and their fields in DBMS having different character case in their physical names.
NOTE. After the checkbox is selected, database objects will be available only if their exact physical names are specified.
If the checkbox is deselected, the repository name, object identifiers and their fields in DBMS are converted to lower case while the platform addresses the server.
User Name with Domain. Select the checkbox is to create domain users with a full user name. A domain user should be previously added in the repository security manager.
Authentication. Set up authentication parameters:
Use GSS API. Select the checkbox to use PostgreSQL server authentication via GSS API mechanism.
Kerberos Service. The Kerberos service is used with GSS API. GSS API enables the user to use various Kerberos implementations without changing application code. Specify Kerberos server name in the string, which is determined in PostgreSQL server settings.
NOTE. Parameters in the Authentication group can be set only if the Domain or Integrated Domain authentication type is selected on the Set Up Repository Connection page.
Repository Language for the Current User. Select repository (schema) language. This setting determines language for displaying:
Names of repository objects, MDM dictionaries elements, express report titles.
Resources to create multilingual systems.
Values of time series database attributes, for which translation into different language is set.
One can select one of the radio buttons:
Default. The language is used, which was set on creating a repository.
Custom Interface Language. The interface language of Foresight Analytics Platform is used.
Other. Select one of the interface language supported by Foresight Analytics Platform in the drop-down list.
NOTE. If language settings are not determined for specified objects and names, default repository language is used.
Set the parameters:
Repository Language for the Current User. Select repository (schema) language. This setting determines language for displaying:
Names of repository objects, MDM dictionaries elements, express report titles.
Resources to create multilingual systems.
Values of time series database attributes, for which translation into different language is set.
One can select one of the radio buttons:
Default. The language is used, which was set on creating a repository.
Custom Interface Language. The interface language of Foresight Analytics Platform is used.
Other. Select one of the interface language supported by Foresight Analytics Platform in the drop-down list.
NOTE. If language settings are not determined for specified objects and names, default repository language is used.
See also:
Setting Up Repository Access | Setting Up Repositories List | Foresight Analytics Platform Authentication