In all cases where simple binding is employed, the best practice is to configure your directory service so that SSL or TLS protection is enabled and the database is configured to use either SSL or TLS when communicating with your directory service. If you're using ADAM, it is recommended to use simple binding and the contents of the user's userPrincipalName attribute as your authcid. so user for datastudio, i created custom rule in nf with md5, and updated his password to. If you're using Active Directory, it is recommended to use DIGEST-MD5 binding and your domain user name for the authcid or simple binding and the contents of the user's userPrincipalName attribute as the authcid. Would like to be able to connect to postgres v14. The databases will be added to the Database Pane. Otherwise, the Teradata user name would be taken from the first 30 characters of your authcid, which would make your Teradata user name as "dn:cn=TWM01,dc=tera,dc=data" which is not the expected one. Pick one or more of the databases from the currently connected server you wish to include in the Cross Database Query from the Add Database Dialog and click OK. This form of logdata will work with Sun and few other directories using DIGEST-MD5 binding, it would not work with Active Directory or ADAM.Īssuming that you are using a Sun or other non-Microsoft directory and you have Teradata schema installed in your directory service, the user "cn=twm01,dc=tera,dc=data" is explicitly mapped to a Teradata user, profile or role. Unlike its competition, it provides a unique combination of a full-featured database IDE and visual analytics, the broadest range of native data sources, versatile import and.
![conneting in aqua data studio conneting in aqua data studio](https://dataedo.com/asset/img/kb/db-tools/ibm_data_studio/sp_pict_path.png)
Aqua Data Studio helps database developers and administrators, and data and business analysts to manage data platforms and data, and visually analyze data.
![conneting in aqua data studio conneting in aqua data studio](https://plumskiey341.weebly.com/uploads/1/2/6/4/126427936/829862433.png)
The LDAP logdata parameters are space separated and not comma separated. Aqua Data Studio Download, Install, and Connect: Explore Aqua Data Studio’s advanced visual analytics to create dashboards and easily interact with your data. Remove username and password attributes from modelmanager-ds.xml.įor LDAP authentication, the logdata must contain at least the user's authcid (authentication id) and the user's password.
![conneting in aqua data studio conneting in aqua data studio](https://moplabig.weebly.com/uploads/1/3/3/2/133263321/458130088_orig.png)
The URL connection should be: “jdbc:teradata://localhost/DATABASE=mmMeta,TMODE=TERA,LOGMECH=LDAP,L OGDATA='authcid=dn:cn=TWM01,dc=tera,dc=data password=TWM01'”Ĭ.
#CONNETING IN AQUA DATA STUDIO UPDATE#
Update tdgssconfig.jar with the modified TdgssUserConfigFile.xml.