Skip to content

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: