DataSources in BI 7.0

[Former Member]

Hello All,

We are just beginning to implement a BI solution in our landscape and would like to know the following:

1) Which DataSource should we be using 3.x or 7.0? What are pros/cons of using one over the another?

2) I replicate 0PLANT_ATTR datasource and BI shows that as an Emulated 3.x datasource. Is that by default or is there some way I can replicate that as a 7.0 datasource (without having to migrate the replicated 3.x datasource in BI)? I read some posts where during replication you have an option of chosing 3.x or 7.0 replication but that option does not seem to show up in my case.

3) If I have to migrate the replicated ds, is there any downside to always migrating it "With Export"?

Thanks,

Asheesh

[Former Member · Accepted solution]

1) Which DataSource should we be using 3.x or 7.0? What are pros/cons of using one over the another?

https://forums.sdn.sap.com/click.jspa?searchID=6224486&messageID=1628297

Further insights

Always good to migrate with export option to revert back to old method

Migration FAQ's

https://www.sdn.sap.com/irj/sdn/developerareas/bi?rid=/library/uuid/7c2a7c65-0901-0010-5e8c-be0ad9c0...

http://help.sap.com/saphelp_nw2004s/helpdata/en/43/f00e2696d24c5fe10000000a155369/content.htm

new NW2004s Data flow

R/3---->PSA only (using Infopackage) for all the Loads -Mandatory

PSA -

---

>ODS/Cube -->load using DTP ,create transformation first

no Datamart architecture in NW2004s

so ODS -

---

>Cube load using DTP ,creating transformation first

Once loaded to PSA in DTP you have the option of FULL or DELTA ,full loads all the data from PSA and DELTA loads only the last load of PSA.

Go through the links for Lucid explainations

Infopackage -

http://help.sap.com/saphelp_nw2004s/helpdata/en/43/03808225cf5167e10000000a1553f6/content.htm

DTP

http://help.sap.com/saphelp_nw2004s/helpdata/en/42/f98e07cc483255e10000000a1553f7/frameset.htm

Creating DTP

http://help.sap.com/saphelp_nw2004s/helpdata/en/42/fa50e40f501a77e10000000a422035/content.htm

Pre-requisite-

You have used transformations to define the data flow between the source and target object.

Creating transformations-

http://help.sap.com/saphelp_nw2004s/helpdata/en/f8/7913426e48db2ce10000000a1550b0/content.htm

ODS to Cube -

http://help.sap.com/saphelp_nw2004s/helpdata/en/ce/dc87c1d711f846b34e0e42ede5ebb7/content.htm

Hope it Helps

Chetan

@CP..

[Former Member · Accepted solution]

Thanks guys for the quick response. Your comments have been very helpful.

Thanks,

Asheesh

[Former Member · Accepted solution]

welcome & Good Luck

Hope it Helps

Chetan

@CP..

[Former Member]

Hi mittal

Its always better to keep the option with export because it will keep the copy of data which is done by 3.x datasource.we can again work on it if the load fails when u try with with the 7.0 datasource.

The data will be lost if u donot select with export and it will become a problem when the load fails wen u try with 7.0 datasource by not keeping the copy of data side.

[Former Member]

Hi,

1.Actually if there are 3.x data sources available its the best practice to use them.

2.An emulated data source means

3.x DataSources (object type R3TR ISFS) exist in the BI database in the metadata tables that were available in releases prior to SAP NetWeaver 7.0.

The emulation permits you to display and use the DataSource 3.x using the interfaces of the new DataSource concept. The DataSource (R3TR RSDS) is instantiated from the metadata tables of the DataSource 3.x.

You can display a 3.x DataSource as an emulated DataSource in DataSource maintenance in BI. You can also model the data flow with transformations for an emulated DataSource if there are already active transfer rules and a transfer structure and a PSA for the 3.x DataSource. Once you have defined the objects of the data flow, you can set the processes for data transfer (loading process using InfoPackage and data transfer process), along with other data processing processes in BI. We recommend that you use process chains.

Emulation and definition of the objects and processes of the data flow that are based on the emulation in accordance with the new concept are a preparatory step in migrating the DataSource.

If you use an emulated DataSource 3.x, note that the InfoPackage does not use all of the settings defined in the 3.x data flow because in the new data flow it only loads the data into the PSA. To prevent problems arising from misunderstandings about using the InfoPackage, we recommend that you only use the emulation in development and test systems.

Using Emulated data sources

http://help.sap.com/saphelp_nw70/helpdata/en/42/fda7cf2a5f517be10000000a1553f6/frameset.htm

<b>Migrating 3.x DataSources</b>

1. In the original system (development system), in the Data Warehousing Workbench, choose Migrate in the context menu of the 3.x DataSource.

2. If you want to restore the 3.x DataSource at a later time, choose With Export on the next screen.

3. Specify a transport request.

4. Transport the migrated DataSource to the target system (quality system, productive system).

5. Activate the DataSource in the target system.

<b>Migrating 3.x DataSources (UD Connect, Web Service)</b>

http://help.sap.com/saphelp_nw70/helpdata/en/42/fda7cf2a5f517be10000000a1553f6/frameset.htm

Hope this helps

Regards

Karthik