Challenge! Use external SQL database for Sharepoint metadata - External Data field not available.

Sharepoint Online:

I have a Sharepoint document library. I have a project database (project number,project name, project manager etc.) this information needs to be tagged to multiple documents. I want to use the project number as a lookup field (site lookup doesnt work well...)

Anyone have a suggestion on how to best achieve this?