Community Conundrum 25:Feature Visualization is now live! Read More

Trouble connecting using Teradata Aster JDBC driver

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
4 Replies
Dataiker
Dataiker
Try setting "UID" and "PWD" as connection properties instead of "username" and "password"
0 Kudos
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
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".
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)