FortiAuthenticator + integration SQL DB

Forum|Forum|8 years ago
December 18, 2017
3 replies
4833 views

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!

Fortimanager

xsilver_FTNT

Staff

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_BritoAuthor

Visitor III

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

Staff

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.

Sign up

Login with SSO

Login to the community

Login with SSO