I am new to GeoNetwork. But now my organization wants to invest in it to see how we can make the best use of it for publishing, sharing and distributing metadata.
We currently have all our GIS data (mostly feature classes) stored in ArcSDE databases on SQL Server 2008 R2. Only brief information about the data has been captured, therefore no standardization has been pursued.
My question is if we get a GeoNetwork catalogue set up, what is the best way to integrate it with the existing SQL Server databases. Also how does each metadata record in GeoNetwork get associated with the actual dataset in SQL Server? Can we set up GeoNetwork for it to automatically extract simple metadata of our specified from the SQL Server and push it to the GeoNetwork catalogue?