non sap source sytem

[Former Member]

Hi All

We are extracting data from non sap system . kindly let me know how to configure the source system in SAP BW and which would be the best way to get connected DB connect or UD connect. as volumes of the the data to be extracted is high

regards,

Sonika

[Former Member]

Hi Sonika,

With the help of the SAP Web AS J2EE connectivity, UD

Connect (Universal Data Connect) enables reporting and

analysis of both SAP and non-SAP data.

Using UD Connect, you can access just about all relational

and multi-dimensional data sources.

UD Connect transfers the data as flat data. Multi-

dimensional data is converted to a flat format when UD

Connect is used.

For the connection to DataSources (in BW), UD Connect uses the J2EE Connector Architecture.

BI Java Connectors that are available for various drivers, protocols and providers as resource adapters.

BI JDBC Connector

BI ODBO Connector

BI SAP Query Connector

BI XMLA Connector

DATA BASE CONNECTION:

A purchasing application runs on a legacy system based on an ORACLE database.

To analyze the data from the purchasing application, the data needs to be loaded into the BW System (possibly installed on a different database, e.g. MS SQL-Server).

DB-Connect can be used to connect the DBMS of of the purchasing application and extract data from tables or views.

By default, when a BW application server is started by the SAP kernel, the system opens up a connection to the database on which the SAP system runs.

All SQL commands (irrespective of whether they are Open or Native SQL) that are submitted by the SAP kernel or by ABAP programs, relate automatically to this default connection, meaning that they run in the context of the database transaction that is active in this connection.

Connection data, such as database user name, user password, or database name are taken either from the profile parameters or from the corresponding environment variables (this is database-specific).

Thus DB Connect can be used to open up other database

connections in addition to the default connection and use these connections to transfer data from tables or views into a BW system.

Steps involved in creating DB CONNECT:

Create a DB Connect Source System

Create a DataSource

Create InfoSource and assign the Source System created to it.

Create InfoPackage and load the data.

DB Connection : Give the name of the connection.

DBMS : Enter the database type to which you want to connect in this field. (i.e. Oracle, DB2 etc)

Enter the username and password.

Conn. Info : This field contains the technical information that is analyzed in native SQL in the CONNECT statement in order to open the database connection. e.g. In Oracle enter the name of the database you want to connect

step2

You use the context menu for a database Source System  Select Database Tables to generate a DataSource for database source systems.

First, you choose a selection of tables for a database source system and create a connection to the database source system.

Next, you select the table fields for a specific table of the database Source System, and specify whether you want these table fields to be available for selection in the BW system.

step3

Based on the generated DataSources for external DB views/tables

InfoSources in BW can be established as usual.

Dataflow is now possible!

i hope this helps u.

Regards

anil

[Former Member]

hi,

check out the following link. may be it will help you

if helpful provide points

regards

harikrishna.N