Integrate EDITable with Inforiver 3.x

This guide will help you deploy EDITable in your Inforiver environment.

Make sure you have already updated your existing Inforiver 2.x instance to 3.x by following the instructions available on the Overview page.

Follow the steps mentioned in this guide to integrate EDITable into your existing Inforiver environment. With EDITable, you can leverage Power BI to maintain and manage your reference data or flat tables in real-time across your desired data platforms. EDITable supports bulk edits/updates, Type 2 SCDs, robust audit and governance with row and columnar access controls, approval workflows and much more, without any code or extensive customizations.

You can find detailed instructions and screenshots to assist you through the process. Follow them carefully to ensure a smooth and successful update.

1. Edit the ACI configuration

1. Launch the Azure CLI window and run the following command to export the container instance in a YAML script file.

az container export -g <resource_group_name> -n <container_instance_name> --file output_file 

Launch Azure CLI and execute the command

2. To download the output file, click Manage files -> Download and enter the path of the output file. Click Download.

Download the output file

3. Click on the output file to download it to your local system.

Download locally

4. Open the file in Visual Studio Code to add the new EDITable container properties as below.

Container properties:

- name: editable-writeback-worker 
    properties: 
      configMap: 
        keyValuePairs: {} 
      environmentVariables: 
      - name: ADMIN_PORTAL_URL 
        value:  
      - name: PRODUCT_BUILD
        value: mde
      image: turing.azurecr.io/turing-mdm-worker:OPV3.0.2.0
      ports: []
      resources: 
        requests: 
          cpu: 1 
          memoryInGB: 3.0  

5. Now, change or add the PRODUCT_BUILD environment variables for the below containers. The value of this variable should be common.

   1. inforiver-cron

   2. inforiver-orchestrator

6. Enter the password to pull the image from the registry. You would have received it during the initial deployment. If not, please get in touch with our support team. Also, add the Storage account name and the access keys in the respective sections. Access keys can be obtained from the respective storage account's Access keys section.

7. Replace the old tag version of the image with the new version. Choose 'Replace all' to update the changes on all the containers.

Replace image tag version

8. Now, change the apiVersion value to ‘2023-02-01-preview’

update apiVersion

9. We will now save the file and upload it back to the Azure CLI.

10. Open the Azure CLI, and remove the old output file by using the following command:

rm output_file 

11. To upload the updated output file back to Azure CLI, click Manage files -> Upload as shown below.

Upload file

12. Select the updated output file from the file explorer.

Select updated file

13. After uploading the file, go to the container instances - Overview page. Choose Delete to delete the container instances so that you can update them with the new configuration file.

click 'Delete'

Deleting container instances

14. After the ACI is deleted, execute the following command in the Azure CLI to create the container instances:

az container create -g <resource_group_name> -n <container_instance_name> --file output_file  

Create new container instance

15. Azure Container Instances will now begin provisioning with the latest configuration that we have uploaded. Please wait until the status is complete.

Updating container instances

2. Add Environment variables in the App service

1. Go to the App service and navigate to Settings -> Environment variables. Click Add on the right.

Add Env variables

2. Add the following env values and select Apply.

Environment variable 1:

Name: PRODUCT_BUILD

Value: common

3. Click Apply to save the settings.

click 'Apply'

4. Select Confirm to restart the app.

Confirm restart

Ensure all the above steps are completed carefully. With this, you have successfully updated your Inforiver container instances and app service to integrate EDITable within Inforiver environment.

ACI Updated

If you encounter any issues or require further support, please get in touch with our technical support team.