Common Data for Multiple BSVs

customaware · Post by **customaware** » Wed Oct 16, 2013 7:04 am

Imagine I have an app (BSV) that manages Human Resources issues and another (BSV) that manages payroll.

What is the best way to utiise a single source of data for Employees between the two apps so as to avoid having to enter and maintain all of the employees in two places?

I know I could add Payroll to the HR app but that is becoming to cumbersome.

Basically, multiple BSVs that point to the same physical data for some but not all BOs.

Powerm · Post by **Powerm** » Wed Oct 16, 2013 7:48 am

Use the AwareIM external database connection option ( create a BO which connects to your other BSV's table(s) ) .

customaware · Post by **customaware** » Wed Oct 16, 2013 8:27 am

I have tried that.

Seems it has some issues.

Cannot see the ID attribute to allocate as Primary Key
LoginName does not show up in the secondary BSV
Same for password
Hidden attributes show up but are not really necessary.

Also.....when specify you need to enter the Database. Hence if you enter BASDBTEST that sort of works but then when you deploy you would have to go and manually change them all to BASDB

Bryan · Post by **Bryan** » Thu Oct 17, 2013 6:30 pm

Take a look at web services from one Aware IM business space to the next. It will give you similar data to the DB connection but should allow you to have a single source for your user BO. You will need to construct the consumption of the web service return data coming back such that it either updates or adds users based on your needs.