Connect On-Prem BI Infrastructure to IFS Cloud¶
Introduction¶
There are two steps to connect the BI Infrastructure (e.g. SQL Server) created on-prem with IFS Cloud.
- Use the CSM Portal form and enter details.
- Create a support ticket as detailed below.
1. Use the CSM Portal form and enter details¶
1.1 First, log in to the IFS Service Center and Navigate to the CSM Portal Form.
1.2 Fill in the header details as shown below.
1.3 Fill in the details for the Analysis Models section.
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
1.4 Make sure the details are accurate and click on Order Now.
2. Create a support ticket¶
After submitting the above form in section 1, create a support ticket with the following text.
To activate Self-Hosted BI on-prem mode set the following secrets in the "###" environment. (### - Set as required to CFG/UAT/PRD)
Key Vault secret name | Value |
---|---|
bi-am-sql-agent-name | ifs-etl |
bi-am-sql-srv-type | ON_PREMISE |
Kubernetes secret name | Value |
---|---|
ifscore.secrets.ifsamSqlServerAgentJobName | ifs-etl |
ifscore.secrets.ifsamSqlServerType | ON_PREMISE |
Note: This extra step (number 2) will not be needed in the future.