Problems with ETL and DataManager
I am trying to get data from a ClearQuest system. I have create an ETL resource and can make a connection to the CQ server and then I added a resource and a mapping table and can see the values in the table.
I then go to data manager and create a Fact build. I then insert a data source for the data stream. I select fetch one row and get no data. If I look at the ri_jdbc.log I see that I get a 401 authorization error for the URL. If I paste the URL into a browser I can see the data. I have checked all the test connection and it says the connection is successful. What am I doing wrong?
I then go to data manager and create a Fact build. I then insert a data source for the data stream. I select fetch one row and get no data. If I look at the ri_jdbc.log I see that I get a 401 authorization error for the URL. If I paste the URL into a browser I can see the data. I have checked all the test connection and it says the connection is successful. What am I doing wrong?
One answer
I am trying to get data from a ClearQuest system. I have create an ETL resource and can make a connection to the CQ server and then I added a resource and a mapping table and can see the values in the table.
I then go to data manager and create a Fact build. I then insert a data source for the data stream. I select fetch one row and get no data. If I look at the ri_jdbc.log I see that I get a 401 authorization error for the URL. If I paste the URL into a browser I can see the data. I have checked all the test connection and it says the connection is successful. What am I doing wrong?
You need to check your ClearQuest Connection in ---> Library ---> Connections --->ClearQuestion right click on it , go to Properties
Connection Details
Data Source Name
Point to you IBM Rational XML ODBC Driver (this one point to xdc file)
Leave username and password as blank
if you put user name and password in there. They will be carried over to REST server and all the web servers. It may cause your authorization error