In Azure Purview, explain the process of setting up a custom data source connector for an obscure legacy database system that lacks a pre-built connector. Include the steps involved, potential challenges, and considerations for maintaining data lineage and governance