DSN's for Information Analyzer
-
- Participant
- Posts: 64
- Joined: Wed Sep 26, 2007 6:52 am
- Location: Syracuse ,NY
DSN's for Information Analyzer
Hi All,
We have recently migrated IBM Information Server from Windows to Unix box.
Earlier in windows,we use to create a System DSN' for a profiling Db2 database. and use that DSN in information Analyzer for creating reports.
But now as the Information Server is migrated to Unix ..We have made DSN entries in the .odbc.ini file in DSEngine folder of Information server
We tried to use the same DSN in information Analyzer but in vain...
We are getting the following error while we select ODBC Connector while configuring a Data store in information Analyzer
"Unable to connect to selected conatiner.Please check whether the connector has been installed on the engine tier system"
Please let me know if there is a specific method how we configure a DSN for IA and use the ODBC connector in IA Data store to use the DSN.
We have recently migrated IBM Information Server from Windows to Unix box.
Earlier in windows,we use to create a System DSN' for a profiling Db2 database. and use that DSN in information Analyzer for creating reports.
But now as the Information Server is migrated to Unix ..We have made DSN entries in the .odbc.ini file in DSEngine folder of Information server
We tried to use the same DSN in information Analyzer but in vain...
We are getting the following error while we select ODBC Connector while configuring a Data store in information Analyzer
"Unable to connect to selected conatiner.Please check whether the connector has been installed on the engine tier system"
Please let me know if there is a specific method how we configure a DSN for IA and use the ODBC connector in IA Data store to use the DSN.
Althaf
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 64
- Joined: Wed Sep 26, 2007 6:52 am
- Location: Syracuse ,NY
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 64
- Joined: Wed Sep 26, 2007 6:52 am
- Location: Syracuse ,NY
I did the same as mentioned by you,
i.e
1)specfying the ODBC connections in .odbc.ini file at
2) After making an entry for above databases .I mooved ahead to make an entry into uvodbc.config file as below
I started off by checking on the Analysis settings on information Analyzer.As soon as i open I get the error below
I move ahead and try to check connection settings for Analysis engine which is succeded ,But when i try to check connection for analysis database .I find the ODBC drop down list empty.
Can any one please help out what i am doing wrong.
I need to configure my analysis settings and connect to my profiling databases to carry on profiling on my newly installed Information server 8.5 on a Unix AIX 6.1
i.e
1)specfying the ODBC connections in .odbc.ini file at
for Information Analyzer Analysis Database and DSN's for databases where i need to do profiling (followed the steps on IBM site)..Server/DSEngine
Code: Select all
[IADBDB2]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMdb222.so
Description=DataDirect DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Database=<DATABASE NAME>
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=<IPADDRESS DB SERVER>
IsolationLevel=CURSOR_STABILITY
LogonID=<unsmae>
Password=<pwd>
Package=iadb
PackageOwner=
TcpPort=50000
WithHold=1
Code: Select all
<IADBDB2>
DBMSTYPE = ODBC
Code: Select all
com.ascential.investigate.cas.exception.CASConnectionException: Failed to create a Connection
Can any one please help out what i am doing wrong.
I need to configure my analysis settings and connect to my profiling databases to carry on profiling on my newly installed Information server 8.5 on a Unix AIX 6.1
Althaf
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 64
- Joined: Wed Sep 26, 2007 6:52 am
- Location: Syracuse ,NY
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 64
- Joined: Wed Sep 26, 2007 6:52 am
- Location: Syracuse ,NY
-
- Participant
- Posts: 64
- Joined: Wed Sep 26, 2007 6:52 am
- Location: Syracuse ,NY
Also please let us know if there are any specific agents which should run for information analyzer to connect to the connectors and DSN's on the engine tier
We have our DSN's installed on the Enginer tier when information Analyzer project and DS resides.
Where exactly at each tier ,what needs to be installed so that my client can talk to the engine.
We have repository installed on Service Tier on different machine on (Db2 .OS Unix AIX 6.1),Engines on Engine tier (Unix AIX 6.1)and my client on a client tier(Windows XP)..
Please help
We have our DSN's installed on the Enginer tier when information Analyzer project and DS resides.
Where exactly at each tier ,what needs to be installed so that my client can talk to the engine.
We have repository installed on Service Tier on different machine on (Db2 .OS Unix AIX 6.1),Engines on Engine tier (Unix AIX 6.1)and my client on a client tier(Windows XP)..
Please help
Althaf
-
- Participant
- Posts: 64
- Joined: Wed Sep 26, 2007 6:52 am
- Location: Syracuse ,NY
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne