Ask the Expert

Can XI be used in BW to load Excel flat files?

Can XI be used in BW to load flat files (Excel based)? What are the advantages/ disadvantages of this? Also, what other areas of BW can XI be used in in BW release 3.5?

    Requires Free Membership to View

Yes, it could. But it is not designed to do this. The easiest way to load a flat file is to use the GUI_UPLOAD function or the MULTIPART MIME feature of the BSP (HTMLB:file). XI should be used if and only if all data exchange traffic is routed through the middleware.

Mind that XI is nothing other than another instance of WebAS, so the underlying engine is the same as the one used in BW. XI is helpful if you can use some predefined adapters, but this wont be the case for Excel files. Please also mind, that the upload should be done from Excel CSV file format only, rather than the Excel generic binary format.

This was first published in February 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: