Trouble connecting using Teradata Aster JDBC driver

ankitmahato

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.

ankitmahato

The issue is now resolved. The issue was in the naming of the JDBC property. Please use "user" instead of "username" or "UID".

Clément_Stenac

Try setting "UID" and "PWD" as connection properties instead of "username" and "password"

ankitmahato

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.

Clément_Stenac

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!