sap data services 4.2 installation

[rinturoy_kidanganfrancis]

Hi Experts

we have a environment of SAP BO 4.0 and sap bods 4.1

Now the requirement is to install sap bods 4.2 in new server and migrate the existing 4.1 settings to the new server. Could you please guide me how to proceed with this?

I understand sap bods needs a sap bo bi platform .Is there any way to install sap bods without bi platform?

Your inputs are much appreciated .

[rinturoy_kidanganfrancis]

Hello experts

thanks for your valuable input.

Finally its agreed from the client to proceed with IPS and then data services 4.2

they have an existing oracle database available and db admin teamfrom their end.

In order to use the exisitng database and install IPS & DS, what information will be needed from the dba team?

i understand two database from CMS and Auditing should be created. apart from this any other details should be received  from DBA team for DS&IPS installtion?

[former_member185603]

You need to ask DB to create DS Repository.

[rribeiro]

Create repository with authorization bellow:

Create session,

Create view

Create sequence to

Create Procedure

[Former Member]

You need more than 2 databases - 1 each for local, profiler and central. SQL server authentication and connection between the server and DB should be checked.

[DayaJha]

Only Create 2 schema for BOIPS and regarding BODS repository please copy the latest backup of BODS 4.1 in new SQL Server schema.

After completion of DBA activity upgrade the local, Profile & Secure central repository using SAP Business Objects Repository manager or REPOMAN Command.

Thanks,

Daya

[rinturoy_kidanganfrancis]

Hello Daya

Thanks for the input. this is oracle database. I have requested for two schema (one for cms and one for audit) for installtion of IPS

Could you clarify for data services. what should be done

[DayaJha]

Better option is create new schema in Oracle DB & copy existing Local, Profile & Secure Central schema backup.

After completion of above activity upgrade repository (all 3) using SAP Business Objects Repository Manager or REPOMAN command.

After completion of upgrade activity add all repository in Central management console asign the rights.

Thanks,

Daya

[rinturoy_kidanganfrancis]

Hello Daya.

Assumptions

FOR IPS

creata two database for audit and CMS

For Dataservices

do we need a seperate schema? ( as u said Better option is create new schema in Oracle DB )

I will ask admin team to take backup and restore on new environment the following

local,profile,secure central schemas

the only clarification needed whether i should ask them to create additonal schema for data services or just the backup/restore of local,profile,secure central schemas will be sufficient?

[DayaJha]

No Just ask him to restore the latest backup of local,profile,secure central repository and assign appropriate rights.

Thanks,

Daya

[rinturoy_kidanganfrancis]

Hello Daya

assuming we are not creating a schema for ds repositoryand we are using the backup/resotre of local,profile ,central repositoryfrom existing systems,

which option should be selected during repostory configuration?

use a exisitng database server or  skip configuration

since we didnt create a schema for DS. how to configure those settings.

[venkataramana_paidi]

Hi Rintu,

You have to use skip  configuration in the data services.  We can configure the repository,job server  and access server after the completion of the installation.

Thanks & Regards,

Ramana.

[rinturoy_kidanganfrancis]

Hello

since we didnt create the schema, where could  the existingg backup of local,central schema should be restored?

[venkataramana_paidi]

We need to create schema or restore the backup before doing the configuration of the data services.  Without restore of the backup file we cannot do any thing .

[DayaJha]

You can skip that activity,after installation use sap business object data services repository manager to upgrade repository.

Thanks,

Daya

[rinturoy_kidanganfrancis]

Hello Daya

Thanks for your input.

1. have to create schema for DS

2.take backup of exisiting repository in the current environment and restore to the new schema created for DS.

3. upgrade each  repository using repository manager.

4. import/export the ATL files

or

1.have to create schema for DS

2.create new repository using repository manager as per the existing enviroment.

4. import/export the ATL files.

which could be the best way to proceed

[rinturoy_kidanganfrancis]

Hi All

I am unable to find the software SAP DS 4.2 SP1 P2 in Service marketplace. have anyone faced these issue earlier?

[former_member185603]

Why do you want to install SP1, P2, if you have latest SP3 patch1. Go with latest one.

[rinturoy_kidanganfrancis]

I understand . but the client requirement was to go with 4.2 SP1 P2 since they have already implementated in other account

[rinturoy_kidanganfrancis]

Hello

Can someone comment on the below query

1. have to create schema for DS

2.take backup of exisiting repository in the current environment and restore to the new schema created for DS.

3. upgrade each  repository using repository manager.

4. import/export the ATL files

or

1.have to create schema for DS

2.create new repository using repository manager as per the existing enviroment.

4. import/export the ATL files.

which could be the best way to proceed

[DayaJha]

Hi Roy,

Only deploy latest backup in new schema and then do the below steps:

(a) Upgrade using SAP Business Objects Repository Manager or REPOMAN Command

(b) Add in Central management console and apply rights & security

(c) Validate & Test the Job

Thanks,

Daya

[rinturoy_kidanganfrancis]

Hello Team

I have installed IPS 4.1 Sp3 and data services 4.2 SP1 .Thanks for your support.

Can some1 guide in post installation steps for IPS 4.1SP3. in our existing system they use IPS 4.0 and DS 4.0.

upgrade management tool cannot be used for 4.0 releases.

expecting your valuable input

[DayaJha]

Hi Roy,

Below is the Post Installation check list for BOIPS & BODS.

Post Installation Check List from BOIPS Side:

• Check all Services are up & running:
  (a) <Server Name>.AdapticeJobServer
  (b) <Server Name>.AdapticeProcessingServer
  (c) <Server Name>.CentralManagementServer
  (d) <Server Name>.EIMAdaptiveProcessingServer
  (e) <Server Name>.InputFileRepositoryServer
  (f) <Server Name>.OutputFileRepositoryServer
• Check all Common Services are available in EIMAdaptiveProcessingServer
• If you are using Information Steward then check FRS Directory location is fine or not and also check Information Steward Services.
• Check Java Heap Size of EIMAdaptiveProcessingServer & Information Steward Service.

Post Installation Check List from BODS Side:

• Check all local repository, Profile repository & Secure central repository is Active Status or not
• Check rights & security related to all repository
• Check below parameters in BODS Client
  (a) Substitution parameter
  (b) System Configuration
  (c) Format Data Type (Flat Files, CSV)
  (d) Datastore (SAPR3,SAP BW, RDBMS)
• Check below parameters in BODS Server
  (a) Job Server Configuration
  (b) Access Server Configuration
  (c) RFC Configuration
• Now validate the Jobs (Batch/Real Time) at Top Level and if error comes fix those errors
• Now Execute the Jobs using Scheduler or other BI Tools

Thanks,

Daya

[rinturoy_kidanganfrancis]

Hello Team

IPS,DS is installed with a database name: EHDV01 and three schemas

created

one for CMS,AUDIT and one for DS.

Now the customer requirement is to reconfigure with new DB and new

schemas being created.

Please let us know the suggested steps

[Former Member]

Hi,

Yes you can install IPS (Information Platform Services) instead of BI platform. IPS is actually recommended by SAP for CMS.

Arun

[rinturoy_kidanganfrancis]

Hello Arun,

Thanks for your reply. I understand IPS or BI can be used for sap data services 4.2 installation.

One of our project requirements is to install sapdata servicess 4.2 first and after a month they have a plan to install sap bo 4.1.

How its possible to install sap bods 4.2 without sap bo?

is there anyway to do a standalone installtion?

[Former Member]

Hi,

Its not possible to install DS without SAP BO. Yes standalone installation is possible -

1) Install IPS first

2) Then Install DS 4.2 on IPS. Here, IPS will act as the BO CMS.

Hope this helps.

Arun

[DayaJha]

Hi Francis,

Please refer the below link regarding your query.

Tutorial: How to install SAP Data Services 4.2 - Part 1

Link:

http://scn.sap.com/docs/DOC-50135

SAP Data Services 4.2 Upgrade steps

Link:

http://scn.sap.com/community/data-services/blog/2013/12/12/sap-business-objects-data-services-migrat...

Also  refer the below thread and SNotes

http://scn.sap.com/thread/3463870

1740516 - SAP Data Services 4.x and SAP Information Steward 4.x compatibility with SAP Business Intelligence platform and Information Platform Services for active releases
Link:

https://service.sap.com/sap/support/notes/1740516

1603393 - Installation Scenarios - Data Services 4.x
Link:

https://service.sap.com/sap/support/notes/1603393

Thanks,

Daya

[rinturoy_kidanganfrancis]

Hello Daya

Thanks for your valuable input.. As i said before we need to migrate the existing settings from sap bods 4.0 sp2 to newly installed sap bods 4.2 sp1. It is an oracle database for the existing 4.0 sp2.

As per my understanding, i will install sap bods 4.2sp1 on new server. post that how to migrate the jobs/etc from the old server to the new sap bods 4.2 sp1

[DayaJha]

Hi Francis,

Please refer the below thread regarding BODS Migration

Thanks,

Daya