Connect Azure BI Infrastructure to IFS Cloud RemoteΒΆ
To connect the BI Infrastructure created in Azure, fill in the following YAML file and pass it to the installer.
## This yml file is to be used with the IFS installer when IFS Cloud is deployed as REMOTE
## and the customer has deployed the BI infrastructure (e.g. SQL Server) in their own Azure Subscription
## i.e. Scenario 2
ifscore:
secrets:
ifsamSqlServerSsisDbName:
data: SSISDB ## The name of the SSIS database, default is SSISDB.
name: am-sql-ssisdb-name
ifsamIfsDataSource:
data: 10.10.10.10/SID1 ## Oracle <ORACLE HOST IP>/<SID>.
name: am-ifs-data-src
ifsamSqlServerDbName:
data: ifs-sql-dw ## The name of the SQL Server database inside the SQL Server, has to be manually created.
name: am-sql-db-name
ifsamSqlServerType:
data: AZURE ## SQL Server installation type AZURE in this case
name: am-sql-srv-type
ifsamSqlServerName:
data: ifs-sql-srv.database.windows.net ## Azure SQL Server url (Format: <name>.database.windows.net)
name: am-sql-srv-name
ifsamSsisFolderName:
data: ifs-etl ## SQL Server Integration Serivices Catalog Folder Name (has to be manually created).
name: am-ssis-fold-name
ifsamSsasServerName:
data: asazure://uk.asazure.windows.net/ifsaassrv ## Azure Analysis Service url (Format: asazure://<region>.asazure.windows.net/<name>)
name: am-ssas-srv-name
ifsamSsasUsername:
data: app:<GUID> ## Azure Service Principal Client ID (Make sure prefix "app:" is there like app:<guid>).
name: am-ssas-un
ifsamSsisProjectName:
data: IFSCloudAnalysisModelsSSISFramework ## Must be IFSCloudAnalysisModelsSSISFramework (created by Aurena).
name: am-ssis-proj-name
ifsamIfsinfoUsername:
data: IFSINFO ## IFSINFO / IAL_OWNER user name.
name: am-ifsinfo-un
ifsamSqlServerUsername:
data: MySqlUser ## SQL Server user (A Sql Server Authentication type user with db owner privileges).
name: am-sql-un
ifsamCustomerType:
name: am-customer-type ## MANAGED | REMOTE - REMOTE in this case.
data: REMOTE
passwords:
ifsamSqlServerPassword:
data: xxxxxxx ## Password for the SQL Server user.
name: am-sql-pwd
ifsamSsasPassword:
data: xxxxxxx ## Azure Service Principal secret's value (Usually a 40 char string, not a guid).
name: am-ssas-pwd
ifsamIfsinfoPassword:
data: xxxxxxx ## Password for IFSINFO / IAL_OWNER user.
name: am-ifsinfo-pwd
Download the template YAML file from here.
For more information on Installation Parameters please refer: