FortiAuthenticator + integration SQL DB

[Alan_Brito]

Hello Guys,

I have a PoC demand with FortiAutenticator.

The Client has an ERP system, where the database is SQL.

Is it possible to perform API integration of users registered in SQL with FortiAutenticator?

If so, could you help me start the walk.

Thanks!

[xsilver_FTNT]

Hi,

it depends what this ERP does/can-handle, for example DC is also database but has LDAP front-end .. so if that SQL based ERP has LDAP front-end as well we can simply sync users from that ERP into FAC.

Otherwise some scripting will be probably needed .. 

How do you wan to have users in FAC ?

Is static one-time sync from ERP to FAC OK ?

If so, you can do some SELECT * FROM users; to get user list, or do LDIF and parse .. as FAC can import users from CSV for example. Alt. you can use REST API to do some more sophisticated juggling. See Docs .. 

https://docs.fortinet.com/d/fortiauthenticator-rest-api-solution-guide-5

Kind regards,

Tomas

[Alan_Brito]

Hello, Understood, you study as alternatives presented. The integration with an LDAP base I quite liked the idea.

My initial thought goes in the following line:   - My client is from the hospital area; - The solution is to attend patients in a network of visitors, so when the patient is admitted to the hospital, we collect some fields in SQL / ERP to generate user authentication and network password visitors; - Our competitor has this solution, but the hospital wants to change; - Our main challenge and the competitor is the following: Patient enters the hospital, opens the medical record and receives his user authentication, however, at the end of the service it is necessary to clean this user created in the base of the FortiAutenticator.   I'm reading about the REST API because I'll probably need to use it to clean up the users after the end of the attendance.   Thanks for Help!

[xsilver_FTNT]

yes, REST API sounds to me like tool for you to create & keep FSSO user record for active clients/patients and close/remove the record when client leave the hospital.