Archive both ERP and BW systems in one SAP-IQ ?

[former_member199694]

hi,

we are working on implementing SAP-IQ solution for our ERP and BW systems.

Wondering, if we can archive both in one SAP-IQ server?

Is it possible to take backup separately based on repository level?

would appreciate your feedback on this.

Thanks,

Raj Sampath

[markmumy]

How do you plan on archiving Suite and BW?  Are you using ILM and NLS?  The "how" will determine whether or not it can be done.

Mark

[former_member199694]

Archiving would be -

ERP --> ILM DBStore--> SAPIQ and

BW-->NLS-->SAP-IQ.

Requirement:

Both ERP/BW-NLS would be archived in one SAP-IQ server.

Taking backup in repository level from Prod SAP-IQ and refresh on Test SAP-IQ

Thanks,

Raj

[markmumy]

OK, so there are a few different answers to this...

At a high level, can this be done?  Yes.  Both ILM and NLS require standalone installs of IQ and configuration of the up stream product (Suite/BW).  You would then create separate database users for each archival method.  From a practical point, though, do you want to do this?  Likely no.

The real answer comes down to licenses.  What options/licenses did you purchase?  If you purchased the NLS option and the ILM option, you must have separate installations.  See, the NLS IQ option gives you the right to deploy and use IQ for the SOLE purpose of BW.  That means that the IQ instance licensed under the SAP NLS IQ option can only be loaded by BW and can only be queries via BW.  The same is true of the ILM license. 

See, these are both restricted use licenses for use only by their respective products.  Any attempt to load ILM data into an NLS runtime licensed server would be a license violation.

The alternative is that you could purchase IQ Enterprise Edition (IQEE) with appropriate options (VLDB and Unstructured Data).  In this case, the IQ instance is a full use license and you have the ability to use any means to load and query data.

Now on to the other question.  You cannot do a partial backup of an IQ instance.  If you have IQEE and have both NLS and ILM data in the same server, you must performa a backup of all data.  This presents quite some challenges as Suite and BW will archive data at different times.  Additionally, they each have very different schedules for backing up the archived data.  So, mixing the two archives into a single instance of IQ would lead some some very tricky integration needed between Suite and BW.

So yes, it could be done, but in reality you don't want to do it.  Licenses are the big prohibitor.  Architecture and coordination would present some operational challenges that make it quite difficult.

If the concern is more hardware than anything else, I would recommend that you have two IQ installs on the same host; one for NLS and one for ILM.  You could also employ virtualization on the host and have two different VMs; one with NLS and one with ILM.

What types of licenses/options were purchased?  That would certainly help direct the proper answer.  Also, what is the reasoning behind wanting to combine these into a single instance?

Mark