Hi CMCN1982,
The dataware house db link and Jaspersoft error is different. Can you please confirm that you have given the below rights
MSSQL:
GRANT ALTER ANY LOGIN TO PPM_DWH
GRANT ALTER ANY LINKED SERVER TO PPM_DWH
Common procedures can be used to create DBLINK for both Microsoft SQL and Oracle from CA Clarity PPM. The procedures can be called directly from the Data Warehouse schema if necessary.
MSSQL:
CMN_DBLINK_SP @P_DB_LINK_NAME VARCHAR(30),
@P_CLARITY_DB_HOST_NAME VARCHAR(30),
@P_CLARITY_SCHEMA_NAME VARCHAR(30),
@P_CLARITY_USER VARCHAR(30),
@P_CLARITY_PASSWD VARCHAR(30)
Example: Microsoft SQL DBLINK Creation
CMN_DBLINK_SP 'PPMDBLINK','<hostname>','NIKU','NIKU','NIKU'
Troubleshooting steps
MSSQL
Follow these steps:
1. Verify that the following privileges are granted to the PPM_DWH schema:
GRANT ALTER ANY LOGIN TO PPM_DWH
GRANT ALTER ANY LINKED SERVER TO PPM_DWH
2. To verify that PPMDBLINK is working, run the following query from the PPM_DWH schema:
SELECT count(1) FROM PPMDBLINK.niku.niku.srm_resources
If the link works, data is returned.
Regards
Suman Pramanik