on 08-13-2013 7:59 PM
SAP BusinessObjects Business Intelligence platform 4.0 SP4 on default database (DB2) on server AIXv 7.1.
MS SQL server 2005
In IDT I did below steps to integrate sql server with BIP 4.0 sp4
1) Created a .cnx connection
2) published connection to repository
3) then I have one .cns connection
4) Build a df on .cns connection
5) build a BL on DF
Note: all processes are in running status in CMC and I am able to see the connection in CMC
Below error is appearing in IDT while trying to access the database/its tables from data foundation layer in connection area.
Servers in CMS ...:6400 and cluster @....:6400 with kind connection server and service CS_CORBA_Network layer. All such servers could be down or disabled by administator(FWM 01014)
Please advise me
Hi,
what is the full error text being shown ? the quoted piece above doesn't seem complete.
Thanks,
H
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Henry
thanks for reply. Above error is complete and I would like add one more point is
Its working well when I choose single source and I am able to see the data tables.
But above error is there when I choose multisource enabled.
Note: my connection method is using MS SQL server 2005 with OLEDB
OK. a Multisource worlflow would use the Data Federation adaptive processing server . make sure that is up and running
for a single source workflow, the connection server uses the files at
under \dataAccess\connectionserver\drivers
for the multisource workflow, it will use the drivers under \dataAccess\connectionServer\jdbc\drivers\datafederator
Not forgetting that in both cases the .SBO files will need to be modified.
Regards,
H
have you installed the middleware (as discussed on your other thread) and defined the ODBC DSN for both 32 and 64 bit drivers?
also, i was talking about jdbc or odbc . Looking again, your are trying to multisource using an OLEDB olap connection, which isn't supported. More info here: http://scn.sap.com/thread/3307226
1. Another thread was for integration of application which is running on IBM i series.So I will treat this as a separate and I will continue my discussion there only to make sure not to mix up.
Coming back to this thread issue.
My requirement is creating relational connection, not OLAP connection through IDT.
2. File->new->relational connection
then provided resource name and description
then I have chosen database middle ware drivers in hierarchy list
Microsoft->MS SQL SERVER 2005->OLE DB providers
After completing all the next steps issue is coming when multisource enabled but it works well for single source.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.