Infogix Reports on Server to Database

Follow

Adam Walker

• November 23, 2020 17:50

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?

0

• 

  Matthew Kennedy

  • November 23, 2020 18:21
  • Edited

  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

  0

  Comment actions Permalink
• 

  Adam Walker

  • May 17, 2021 12:00

  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

   

  0

  Comment actions Permalink
• 

  Matthew Kennedy

  • May 17, 2021 12:16

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

  Matthew Kennedy

  0

  Comment actions Permalink
• 

  Adam Walker

  • May 17, 2021 12:38

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

  0

  Comment actions Permalink
• 

  Adam Walker

  • May 17, 2021 14:27

  Matt,

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

  Adam

  0

  Comment actions Permalink
• 

  Matthew Kennedy

  • May 17, 2021 14:46
  • Edited

  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

  0

  Comment actions Permalink
• 

  Adam Walker

  • May 17, 2021 14:52

  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?

  0

  Comment actions Permalink
• 

  Adam Walker

  • May 18, 2021 11:22

  Matt,

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

  Adam

   

  0

  Comment actions Permalink
• 

  Matthew Kennedy

  • May 18, 2021 11:36
  • Edited

  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

  0

  Comment actions Permalink
• 

  Adam Walker

  • May 18, 2021 12:15

  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

   

  0

  Comment actions Permalink
• 

  Matthew Kennedy

  • May 18, 2021 13:01

  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

  0

  Comment actions Permalink

Please sign in to leave a comment.