SQL Dynamic Broker Service would allow you to generate service objects dynamically based on sql tables. I t is capable to create service objects for tables across various schemas as well. In this I read sql columns for those tables and convert them to properties for that particular service object. Currently there are two methods Read and List. Currently you have provide connection string for it to work, it does not support logging as "Network Service" or "Impersonate" Options