Relational data in PI Database

Discussion created by veljovic on Jun 2, 2014
Latest reply on Jun 11, 2014 by mhamel



I am having the following problem:


to generate some reports in my application, I need time-based data which comes from PI Database and some relational data which comes from a relational DB(for example Oracle).


Now, as the amount of data is huge, the relational database is periodically cleaned, say data older than 30 days is deleted. If someone wants a report which needs data older than


30 days, I have a problem because it is not available anymore(relational part).


Therefore, I am wondering if it is possible to store the relevant relational data also in PI database, and if so, how to do it? Is this a good idea at all?




Thanks in advance,