Skip to Content
0
Former Member
Aug 21, 2008 at 04:59 AM

Transfer data from external DBMS to SAP BI

6 Views

Hi,

Can any one tell me how i can transfer data from an external DBMS to an SAP BI system. The concern here is that the fields that are coming from the external DB is having length more than 60 characters. I dont want to use multiple infoObjects in BI to hold the data b'coz majority of the fields coming in are having length more than 60. The format of the external table is shown below.

Column Max length

Field1 VARCHAR2(15)

Field2 VARCHAR2(250)

Field3 VARCHAR2(250)

Field4 VARCHAR2(250)

Short Description VARCHAR2(60)

Long Description VARCHAR2(4000)

Field5 VARCHAR2(30)

Field6 VARCHAR2(30)

Field7 VARCHAR2(1000)

Is there any way to transfer the data froom external DBMS directly into a DB table in SAP BI?

Please give suggestions.

Thanks in Advance.