A method and system for mapping datasources in a metadata model that provides datasource connections that are structurally isolated from the metadata model and which incorporate physical datasource addressing information for mapping a logical datasource structured within the metadata model to a particular physical datasource "on-the-fly", and in a run-time environment. In an embodiment of the present invention, security can be implemented to limit user access leveraging an organization's security regime.