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,