Im trying to import data from my SAP ERP, I succesfully did it using an ETL -> flat files.
Another test is to perform the import by using SQL Tables.
- Is this feasible by replacing the table containing the data (fact, fac2, wb) ?
- Once BPC -SQL is installed, everytime I create a new Appset, a DB is created in SQL... in my opinion, this may be created with particular characteristics, features, etc... therefore are there any properties or some "particular info" that can be missed by replacing the table ?
- If I do not replace the table but send data from my ERP SQL table to the BPC SQL table, am I taking a risk by trying to match tables?
If there is a chance to do it, can you please provide some advice / info for this procedure...
Thanx in advance