Trouble connecting using Teradata Aster JDBC driver

Solved!
ankitmahato
Level 2
Trouble connecting using Teradata Aster JDBC driver

I downloaded the Aster jar from 



https://aster-community.teradata.com/docs/DOC-2254



and added it to the dss/lib/jdbc folder.



I referred to the Aster Client Guide (Pg 112) - http://www.info.teradata.com/download.cfm?ItemID=1000318



and defined the username and password JDBC properties as mentioned in the images below





I am getting the following error:



Connection failed: Failed to connect: [AsterData][JDSI](20280) Required setting UID is not present in connection settings., caused by: BadAuthException: [AsterData][JDSI](20280) Required setting UID is not present in connection settings.





Any help will be definitely appreciated. Thanks.



 



 



 



 

0 Kudos
1 Solution
ankitmahato
Level 2
Author
The issue is now resolved. The issue was in the naming of the JDBC property. Please use "user" instead of "username" or "UID".

View solution in original post

4 Replies
Clément_Stenac
Dataiker
Dataiker
Try setting "UID" and "PWD" as connection properties instead of "username" and "password"
0 Kudos
ankitmahato
Level 2
Author
Thanks for the reply.
I had already made that attempt.
I still got the same error message.

Connection failed: Failed to connect: [AsterData][JDSI](20280) Required setting UID is not present in connection settings., caused by: BadAuthException: [AsterData][JDSI](20280) Required setting UID is not present in connection settings.
0 Kudos
ankitmahato
Level 2
Author
The issue is now resolved. The issue was in the naming of the JDBC property. Please use "user" instead of "username" or "UID".

View solution in original post

Clément_Stenac
Dataiker
Dataiker
Great, thanks for the update! I guess this must depend on versions or settings, since we have some customers running OK with "UID" - glad it is resolved!
0 Kudos
Labels (2)
A banner prompting to get Dataiku DSS
Public