Assure DQ

Currently, our reports from Infogix Assure are saved to the server. 

1) How would we go about going from saving them to the server, to the oracle database? 

2) Also, is there a way to move the existing reports on the server to the database after we have completed the first question?

Hi Adam,

Where these reports store is configurable within the IA.properties. Per our "Infogix Properties Guide" PDF :

Please note, any report still on the server will not migrate to the database. This will be a change moving forward only. The reports already created will remain on the file system ( or database ), until retention kicks in.

Matthew Kennedy

Matt,

Currently, this is what is in our IA properties files in dev.

# File Store Configuration
# FileSystem or Database
FILESTORE_BACKEND=FileSystem
ENABLE_FILESTORE_ENCRYPTION=false
ENABLE_FILESTORE_COMPRESSION=false

I understand I would have to make the two ENABLE lines to true, What would I put where "FileSystem" is located?

Thanks,

Adam

Based on the aim the team is shooting for, this value would be defined as "Database"

Matthew Kennedy

Also, where would I see on the database side if I wanted to validate that it wrote it to the database?

Matt,

Once I have the IA properties file changed and applied to the server, where will the report write to on the server?

Adam

Adam,

If the value is set to "FileSystem" it will write to the same directory it currently is pointing to on the OS. If "Database" is set as the value, this will write to the database table for the control. Navigating to Assure's "admin console" > "dynamic tables" will allow better insight on which table corresponds with which report due to the right-side column labeled "purpose".

Matthew Kennedy

Is there any way to write a SQL command to validate that the report wrote to the database?  If so what would that SQL command look like?

Matt,

Where are on the database is it writing the reports to?

Adam

Adam,

The table name itself would entirely be dependent on the report type / control name. When possible, please open a support case so we may discuss further. I am happy to walk through this with you over a 'zoom' call.

Matthew Kennedy

Matt,

Two more question:

So the file storage configuration properties is for just "control reports", correct? 

So are the "user report" being written to the database already and not to the server?

Adam

Adam,

User reports are always stored within the database, using a dynamic table per user report. The "FILESTORE_BACKEND" value mentioned above has no impact on this.

Matthew Kennedy