SQL View access in Flexera One?

[DerekMac]

I only have experience with on-prem and greatly enjoy writing SQL Views and Business Adapters. Now I am unemployed and might be working with Flexera One. I see it still has Business Adapters, but how can we write SQL queries and access views in Flexera One? There is no DB access, correct? The only way I can think of is listing views via a Business Adapter query and I question if the account has permissions to see the way the views are built.

FYI ... https://www.linkedin.com/in/derek-macintosh/

[Nico_Erasmus · Accepted solution]

Hi @DerekMac 

Correct, you do not have SQL access in FlexeraOne.  The way to work with it is to create Business adapters against reports of base objects (Inventory Devices, Installations, Applications, etc), import those to SQL via the API using the business adapter, and then you can work with the data in SQL.  You can then use this data to write back to FlexeraOne via business importer.

Regards