Kbase 16967: How to Connect to a AS/400 Data Library from Actuate?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
GOAL:
How to connect to a AS/400 Data Library from Actuate?
FACT(s) (Environment):
Actuate
SYMPTOM(s):
IBM's Client/Access ODBC
FIX:
In order to connect to a AS/400 Data Library from Actuate, user must onfigure IBM's Client/Access ODBC. This will have to reside on each PC that needs to make the connection.
Configuration for C/A ODBC driver on the PC.
1. Click on C/A Directory and select ODBC Administration .
2. Data Sources screen comes up click on the ADD button to add the
C/A ODBC DRIVER(32bit)
3. General is the first tab to configure:
Data source name (this can be any name)
System (AS/400 Host Name)
User ID (your ID for the AS/400)
4. Server is the second tab to configure:
Default Libraries (put in your AS/400 Data Library name)
Commit mode - (leave the default)
5. Format,Performance,Language,Other, and Other2 - are tabs that you
should configure for your needs, or except the defaults.
When your done Click APPLY - the ODBC part is now configured.
Configuration for Actuate on the PC.
1. Click on NEW report
2. Select Tab 2 Connection
ConnectionString (leave this blank)
DataSource (the name from the ODBC entry)
DllPath (should already be defaulted to ODBC32)
Password AS/400 password
UserName AS/400 user name
3. Click Next
4. A Database Login - DBConnectional screen will appear
Fill in UserName and Password again (for the AS/400)
Click OK
You should be connect at this point.