on 06-30-2011 8:30 AM
Hi All,
My Requirement:
The file is being triggered through MDM Adapter as an xml file and this should be send to the BI system as a file before datastaging.
Could anyone explain me how to proceed to the above stated interface as am not aware of connecting the BI system.
Thanks in Advance.
Regards,
Lavanya
Edited by: Lavanya Balanandham on Jun 30, 2011 1:00 PM
Hi All,
Could anyone help me out in providing the document for MDM-PI(7.1)-BI scenario.
Regards,
Lavanya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lavanya,
There are three or four ways of how you send data to BI. But first check with BI Team on how they want to receive data. Then you can design accordingly. Its easy to push from PI, but to process in BI is also need to be taken in account for your design. If it is from PI only, then you can use any of the options given in above links.
Regards,
---Satish
Hi Lavanya!
I have handeled the same scenario but My Sender thing is JDBC.
U can Use Receiver Proxy or File Adapter in the Sender side.Better u can use File When if the case is just want to Place the file in BI.
For this U need to have the Connection details of BI server nothing hard in this. U can use Receiver File Adapter to place a file in BI Server.(For placing file u can use the al11 transaction in BI).
Hope this will help u.
Regard's
Preethi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hai Lavanya!
Create a File Receiver Channel.
In Parameter Tab
Adapter Type : File
Transport Protocol :File Transfer Protocol(FTP)
Message Protocal :File Content Conversion
Adapter Engine :Central Adapter Engine
In Target tab
Target Directory :Ask the BI team about the details of the director where u want to place the file. Then that directory name should be the input to this field.
File Name Schema :U can give any name. In that the file will create in that directory which u mentioned above.
Server :IP address of the BI syatem.
Port : u want ot give the Port Number.
Data Connection :Active
Connection Scecurity:None
Give Anonymous Login:
User Name :Ask the BI Team to provied u a User name and Password to Place the File the Directory.
Password :
Connect Mode :Your choice for test u can try (Per File transfer)
Tranfer Mode :Binary
In Processing Tab
File Construction Mode:Your choice.For Test u can give(Append)
File Type:Binary.
I Content Conversion Tab
I can suggest only when i know the Target File Structure. So regarding this if u need any help ask me by replying to this message.
Here i have mentioed u all the genearl Things.Configure your Receiver channel like and Test it.If u have any issue. Let me Know.
Regard's
Preethi.
Hi Preethi,
Thanks for the reply.
I need to send as an xml file to the BI system.
My query is that,
as of now they are using datastaging server where we would place the file but could anyone suggest me whether to place the file in datastage is feasible or to send data directly to BI is a better solution .
Thanks in advance
Lavanya.B
Hi,
These will help you to design the interface
BI integration Using XI
/people/kamaljeet.kharbanda/blog/2005/09/16/xi-bi-integration
How tou2026Push Data into BW from XI
How To u2026Push data from BI to XI (including receiver examples)
Regards
Sesha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check this:
Best Regards,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
use ABAP proxy in receiver side to send data to BI.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.