I am using the SQL ODBC connection for set up of a RE.
I can extract a single db to a .dm2 file. Now i want to put a second and third db on the same .dm2 file. Is that possible?
My current system has 9 dbs for a very narrow base of data. Users has all the customer data, and Orders has all the Order HeaderData. Offering has all the order details , Discounts has all the discount schemes.
I wanted to model the interaction between the dbs so I could get working on a DW model.
Is this possible, or is it because the postback of changes to a db would get all confused whit multiple dbs?
TIA
__Stephen