Connect On-Prem BI Infrastructure to IFS Cloud¶
IMPORTANT
The CSM Portal Form available for connecting "BI Infrastructure in Azure" is currently NOT available for On-Prem setups. Therefore please contact IFS Support for connecting On-Prem infrastructure to IFS Cloud.
Introduction
To connect the BI Infrastructure created on-prem, these details need to be set in IFS Cloud service customer key vault:
| KV Key | Description | Example Value |
|---|---|---|
| bi-am-ora-dbip | IFS Oracle IP for the relevant environment | 123.123.123.123 |
| bi-am-sql-name | SQL Server url/public IP address | dw.northwind.com |
| bi-am-sql-dbname | Name of the SQL Database for data warehouse | uat-sql-srv-dw |
| bi-am-sql-un | Admin username of the SQL Server | uat-sql-admin |
| bi-am-sql-pwd | Admin user password for the SQL Server | |
| bi-am-ssis-dbname | Name of the SSISDB. Default is SSISDB | SSISDB |
| bi-am-ssis-fldrname | The Integration Service Catalog folder name | uat-xxxx |
| bi-am-ssas-name | The SSAS Server URL/public IP address | dw.northwind.com |
| bi-am-ssas-clientid | The SSAS user name (domain user) | northwind\userx |
| bi-am-ssas-clientsecret | The SSAS password | |
| bi-am-sql-agent-name | The SSIS Agent name (On-prem only property) | ifs-etl |
| bi-am-sql-srv-type | SQL Server Type (AZURE/ON_PREMISE) | ON_PREMISE |
In addition to the above, after running the pipeline with above KV changes, these two secrets need to be set on the K8s secrets. - am-sql-srv-type = ON_PREMISE (change existing value to this) - am-sql-agent-name = ifsetljob (new secret, value can be any name)