veljovic

Relational data in PI Database

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

Hi,

 

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,

 

Slobodan

Outcomes