Connect On-Prem BI Infrastructure to IFS Cloud¶

This page provides information on connecting On-Prem BI Infrastructure to IFS Cloud for purpose of using Analysis Models - Tabular functionalities. You can open the Environment Parameters page from the Navigator (menu path: Solution Manager/Reporting and Analysis/Analysis Models - Tabular/Setup/Environment Parameters.

Notes¶

Validate the SQL and SSAS server names and credentials using a tool like Microsoft SSMS.
- More information on SSMS: https://learn.microsoft.com/en-us/sql/ssms/sql-server-management-studio-ssms
Make sure Oracle server is reachable from the host running SQL Server.
- Validate the Oracle server name and credentials using a tool like SQL*Plus to do a test connection.
- E.g. command sqlplus ifsinfo/ifsinfo@10.10.10.10/myuatsid
- More information on it can be found here: https://www.oracle.com/database/technologies/sqlplus-cloud.html
For more information on Installation Parameters please refer:
- Installation Parameters for Analysis Models - Tabular
- Installation Parameters for IFS Analysis Models
- The optional secret ifsamSqlServerNameInt maybe required only in Scenario 6 when IFS Cloud is hosted by IFS managed service and SQL server hosted in customer on-premise. When the SQL server is exposed using a public IP address, that public IP address may not resolve internally within SSIS packages. In that case this secret can be used to configure the private/internal IP address of the SQL server.

Note

If the SQL Server has an instance name and/or a different port, it can be specified in the following format. It is recommended to use only the port number if required as below.

<servername>[:<port>]
examples:
  10.1.1.1
  10.1.1.1:1434
  dw.mydomain.com
  dw.mydomain.com:1434