We our moving to a federated database model where we will have our application sub systems create their own database. We are going to require developers to create objects in the business layer that retrieves their own sysb system data. At the database level there will be no dependencies between components. This means that queries involving different servers (linked servers) will not be permitted. We use stored procedures for all of our reports.
We are currently using CR ver 8.5 and might be moving to ver 10 (RAS). we use ODBC as our data source.
I have read in the forums were multiple database calls have been made and then there is a common field that is linked together between these two database calls.
Not sure if thats the solution we would use for a federated database. Any thoughts?
i appreciate the feedback,
CKruelle
We are currently using CR ver 8.5 and might be moving to ver 10 (RAS). we use ODBC as our data source.
I have read in the forums were multiple database calls have been made and then there is a common field that is linked together between these two database calls.
Not sure if thats the solution we would use for a federated database. Any thoughts?
i appreciate the feedback,
CKruelle