#DateForumTypeThreadPost
2001 Mar 2016 @ 08:48 PSTHadoopReplyCan we recommend TDCH for Extract-Load processIs the 1.4.2 release also known for having these issues?  We are looking at using this for weekly unloads from Hadoop and loading to Teradata.
1919 Nov 2015 @ 06:18 PSTGeneralTopicPassword constructionDoes Teradata support the use of spaces in password?  If it does what database version and what connectors/versions are needed to use this abilty?  Does using LDAP for authentication effe...
1817 Sep 2015 @ 01:31 PDTToolsTopicclispb.dat implicationsReading through the CLI documentation I was excited to discover the clispb.dat file and how to leverage it to change settings.  Before I actually implement changes on my systems I was curious ...
1701 Jul 2015 @ 10:35 PDTToolsReplyTPT: system variables with result countWhen can we expect to see this functionality? When will it be usable via IBM Information Server, formerly Data Stage?  The legacy Enterprise stage offers this but can't get the same f...
1626 May 2015 @ 08:02 PDTToolsTopicdata provider for Ole DBI know that functional updates are not being added to the data provider for OLEDB but I was curious if it was being updated for 15.10 and if it will be in the same path as the other executable...
1514 May 2015 @ 05:12 PDTExtensibilityReplyIssue with Stored ProcedureThat worked great, thank you so much.
1412 May 2015 @ 11:43 PDTExtensibilityReplyIssue with Stored Procedure REPLACE PROCEDURE dba_tables.AbortSession_sp(IN dbcidname VARCHAR(128))   SQL SECURITY CREATOR   BEGIN       DECLARE AbortStmt VARCHAR(1000);   ...
1311 May 2015 @ 02:27 PDTToolsTopicTTU 15.10 Windows installation pathsWhy was the default installation path for SQL Assistant change to not Teradata SQL Assistant in the path?  Why did the sample ODBC program also get moved to be located in the folder with SQL A...
1230 Apr 2015 @ 06:13 PDTExtensibilityReplyIssue with Stored ProcedureDoes anyone have suggestions on how to get this stored procedure to work?
1127 Apr 2015 @ 07:42 PDTExtensibilityTopicIssue with Stored ProcedureI am working on a stored procedure for dropping all sessions for a specific user and I have written a SP to do this.  the SP creates but it fails when I run it with an id.  I can get the ...
1018 Mar 2015 @ 07:23 PDTConnectivityReplySetting up ODBC Driver setup parameters and ODBC Driver options globally.The only thing I have found for this is restricting the registry permissions once the DSN has been defined.  Unfortunately, this will only work for the System DSN, users would still be able to...
910 Mar 2015 @ 05:56 PDTDatabaseReplyEncryption in the indexDepending on the version of TD you are using, you may be able to collect stats on the expression for the decryption of the column which could help with performance. --Searching on decrypted inde...
812 Feb 2015 @ 05:26 PSTDatabaseTopicDropping usersI am having issues with user clean on my Teradata systems due to drop user failing for any of the following reasons. Users have objects under them Proxy user access associated with th...
723 Jan 2015 @ 05:37 PSTConnectivityReplyODBC odbcconf.exe vs ODBC Driver for Teradata Vers. 15.00.00.01I use powershell to create the registry entries for all my DSNs on windows servers, we have a couple hundred servers with windows based TTU.  The last installationation we rolled out, which is...
627 Oct 2014 @ 12:16 PDTConnectivityReplyConnections Created (w/ ODBC/.NET) Are Surviving After conn.Close()ODBC by default doesn't do connection pooling, however the .Net Data Provider for Teradata does.  Connection pooling does have its pros and cons.  Personally I prefer the use of the ....
513 May 2014 @ 08:52 PDTConnectivityReplyWindows .Net (non-ODBC) connection to Teradata using LDAP authenticationIf you are coding the app yourself you can use the Teradata.Client.Provider.TdConnectionStringBuilder.  This has all the properties that let you build what you are wanting and formats the resu...
414 Mar 2014 @ 12:21 PDTConnectivityReplySSIS 2012 OLE DB Teradata provider 'TDOLEDB.1'Have you tried the .Net data provider for Teradata?  It seems to work better then OLEDB, just don't forget to modify the response buffer size.
328 Feb 2014 @ 04:45 PSTToolsReplyIssue with SQL assistant Try adjusting the connection timeout parameter on your connection and try setting a value for the Data Source DNS Entries property.  For ODBC these are found in options then advanced...
212 Nov 2013 @ 12:12 PSTGeneralReplyJDBC Driver 12.0 CompatibilityAre there plans to support newer versions of Tomcat?
108 Nov 2013 @ 12:00 PSTGeneralReplyJDBC Driver 12.0 CompatibilityI noticed this chart doesn't show anything for TTU/JDBC 12 or JDBC 3.03