Trouble connecting using Teradata Aster JDBC driver

Options
ankitmahato
ankitmahato Registered Posts: 11 ✭✭✭✭

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.

Tagged:

Best Answer

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer, Registered Posts: 753 Dataiker
    Options
    Try setting "UID" and "PWD" as connection properties instead of "username" and "password"
  • ankitmahato
    ankitmahato Registered Posts: 11 ✭✭✭✭
    Options
    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
    Clément_Stenac Dataiker, Dataiku DSS Core Designer, Registered Posts: 753 Dataiker
    Options
    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!
Setup Info
    Tags
      Help me…