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
Short Description VARCHAR2(60)
Long Description VARCHAR2(4000)
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.