How to enable Relativity Connector in VOD?

In order to export out the data into relativity, first we need to enable connector so that it is visible in the admin settings as follows:

Here are the steps to enable the Relativity connector in Venio's SQL database:

1. Check if the 'ENABLE_CONNECTOR' key exists.

SELECT * FROM VenioPCD.dbo.tbl_pj_ControlSetting WHERE [Key] = 'ENABLE_CONNECTOR'

2. If it doesn't exist, insert a new row to enable it:

INSERT INTO VenioPCD.dbo.tbl_pj_ControlSetting ([Key], Value)
VALUES ('ENABLE_CONNECTOR', 1)

3. If it does exist, update the value to 1 to enable it.

UPDATE VenioPCD.dbo.tbl_pj_ControlSetting
SET Value = 1
WHERE [Key] = 'ENABLE_CONNECTOR'

4. Verify it is enabled:

SELECT * FROM VenioPCD.dbo.tbl_pj_ControlSetting WHERE [Key] = 'ENABLE_CONNECTOR'

The connector should now be enabled in Venio's VenioPCD. A re-start of the IIS might be needed to reflect the changes.