First, I love Studio, just to get that out of the way.
We use SQL Asst and are transitioning to Studio now. We have a few things we want to do..
Kael, I will try to respond to your questions above. I am not sure if you were referring to Studio or Studio Express, but the response applies to both. The workspace and template names are different.
Thanks for responding Francine. We are converting to Studio for everyone right now. Express may be more approiate for users that don't need or should have access to all the functionality of Studio... but anyway, I will keep working on how we install Studio/Express.
The SQL Server jar is sqljdbc42.jar. The driver template I used in Studio was SQL Server 2008 JDBC. I guess I don't know what the template is doing or how to install a more updated template into Studio.
I am able to connect to SQL Server with and ETL username/password. The SQL Server DBA wants USERS to use integrated authentication.
The integrated authentication method does work using ODBC.
Any ideas would be great.
Kael, I found this mentioned on an Eclipse Bugzilla page regarding SQL Server integrated authentication:
They can set the "java.library.path" property to the location of the "sqljdbc_auth.dll" file.
Refer to "Connecting with Integrated Authentication" section at http://msdn.microsoft.com/en-us/library/ms378428.aspx for more details.
Let me know if this works.
Thank you for your help. I did try to set the java.library.path. I also set the PATH of my windows pc to point at the file, and actually move the dll file to the Teradata Studio directory. Nothing seemed to work.
I will keep trying things and update this thread if I nave any success.
Thank you for your help again.
Kael, You can also set a runtime java variable inside the TeradataStudio.ini file. Add it to the end of the file, below the -Djava.util.arrays.uselegacyMergeSort=true.