Skip to content

Connect On-Prem BI Infrastructure to IFS Cloud RemoteΒΆ

To connect the BI Infrastructure created on-prem, fill the following yaml file and pass in 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) on premise
## i.e. Scenario 1
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: ON_PREMISE              ## SQL Server installation type - ON_PREMISE in this case.
      name: am-sql-srv-type
    ifsamSqlServerName:
      data: ifsdw.mydomain.com      ## Public IP address for sql server or host (Format: <ip/host>[:port]).
      name: am-sql-srv-name
    ifsamSsisFolderName:
      data: ifs-etl                 ## SQL Server Integration Services Catalog Folder Name (has to be manually created).
      name: am-ssis-fold-name
    ifsamSsasServerName:
      data: ifs_ssas_srv            ## An internally resolving name of SSAS within the on-prem network.
      name: am-ssas-srv-name
    ifsamSsasUsername:
      data: mydomain\MyWiaUser      ## SSAS user name (A Windows Integrated Auth user).
      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
    ifsamSqlServerAgentJobName:
      data: ifs-etl-job             ## A name for the SQL Server Agent job (The job will be created by an Aurena assistant).
      name: am-sql-agent-name
  passwords: 
    ifsamSqlServerPassword:
      data: xxxxxxx                 ## Password for the SQL Server user.
      name: am-sql-pwd
    ifsamSsasPassword:
      data: xxxxxxx                 ## Password for the SSAS user.
      name: am-ssas-pwd
    ifsamIfsinfoPassword:
      data: xxxxxxx                 ## Password for IFSINFO / IAL_OWNER user.
      name: am-ifsinfo-pwd

Download the template yaml file from here.