Hello Flexera Community Members!
We are trying to find out if the Business Adapter Studio can connect to a source connection hosted in Azure using either the Service Principal Name (SPN) or a generated access token for authentication?
The goal is to import various business data sources into a staging database hosted in Azure SQL, have the data normalized, and then import the data from the staging database into Flexera One.
However, the InfoSec team requires multi-factor authentication for accounts (including functional ids) accessing Azure Resources, which is not ideal in this scenario.
Jun 30, 2022 09:06 PM
Yes, you can use Service Principal Name (SPN). for Azure Adaptor connection. You may refer below doc
Jul 01, 2022 12:59 AM - edited Jul 01, 2022 01:04 AM
Unfortunately this isn't possible today. You CAN use PowerShell (or other similar methods) to pull the data to save as a flat file or push into another local DB which the Business Adapter Studio can connect to.
I would add that as an IDEA. If you do - please link it here as I think this would be a great addition to our tool as more and more are moving their workloads off of local resources and leveraging more modern authentication methods.
Jul 01, 2022 09:29 AM