Role of ETL Server in a 3-tier install?
For a "3-tier" install, with the Report Server, ETL Server, and the DW Server on separate machines:
1) What steps does one follow to validate that the ETL Server is functional? (i.e. is there some test that one runs to know that the ETL server is up and running correctly?)
2) Does the ETL Server need to know about the Report Server? If so, how do you do that?
3) Does the ETL Server need to know about the DW Server? If so, how do you do that?
Thanks in advance!
1) What steps does one follow to validate that the ETL Server is functional? (i.e. is there some test that one runs to know that the ETL server is up and running correctly?)
2) Does the ETL Server need to know about the Report Server? If so, how do you do that?
3) Does the ETL Server need to know about the DW Server? If so, how do you do that?
Thanks in advance!
One answer
1. ETL server need install Data manager, ODBC and XDC tool.
2. ETL will know report server by configuration in IBM Cognos configuration tool, this will be used when you need publish ETL job into report server. ETL logic also could be run in report server.
3. ETL will know DW with configuration in Data manager's connection sections, you could set it with valid DW information for Rational Data Warehouse.
2. ETL will know report server by configuration in IBM Cognos configuration tool, this will be used when you need publish ETL job into report server. ETL logic also could be run in report server.
3. ETL will know DW with configuration in Data manager's connection sections, you could set it with valid DW information for Rational Data Warehouse.