Has anybody out there in the Teradata community tried creating a custom build system in Sublime Text (i.e. this guy did it for psql - https://www.youtube.com/watch?v=tPd4m3PLVqU)? If so, would you mind sharing your build-system code as an example? Thanks in advance!

Hi All,
 
We are in the process of moving from Greenplum to Teradata, When i try to insert into one of the teradata tables, I'm getting the following error,
 
Error:
RDBMS code 3707: Syntax error, expected something like a name or a Unicode delimited identifier between ',' and the 'enabled' keyword.  
 

Currently we are using Teradata TTU 14 and Informatica 9.1 and 9.5.1. As per my understanding Teradata has declared end of support for Teradata 14 in 2016, so we need to know
 
1. if Teradata TTU 15 will be compatible with 9.1 and 9.5.1 versions of Informatica.
 
2. If not then do I need to upgrade Informatica to 9.6 .

Hi All,
Working with a client that likes using Hyperion.  We use TD Sql assistant to write, develop and test.   Is there an easy way to transpose TD SQL into Hyperion so my clients users can continue to use the tools that they are comfortable with?
Cheers,
Shawn

Hello,

I have 400 Oracle Procedures which need to be converted into Teradata.

Can I use Automated Application Migration tool (AAMT) for the above requirement?

If Yes, how can I download Automated Application Migration tool (AAMT)?

Please help.

Thanks,

Arka

Can anybody provide feedback on what third party software they are using to archive teradata tables? Currently we are using OPTIM and it is unable to handle it. Any inputs appreciated.
 
Thanks

Hi all, I have been working with Talend Open Studio for a few weeks now and would like to have your opinion. Is using Talend Integration Suite really better compared to using Talend Open Studio? On what kind of project can you not use Talend Open Studio and would be best to use Talend Integration Suite? Thanks a lot for your answers. Have a good day!

I am trying to understand how Datastage interacts with Teradata in Immedaite mode. During my testing, I created a Datastage job with TD connector as  source and destination to just select from one table and load into another table. 

Good day.

In the log of all my backups I have the following message.

" Failed to updade catalog table - Failed to log on, check account and password (Teradata Error Code: 224)"

I would like to fix this problem.

What is the correct way to solve this problem?

Hey Guys,
I am a backup admin. Normally for backups we use to install netbackup client on all the DB nodes. Is this the case with teradata also or is the installation of Teradata extension for Netbackup limited to the BAR servers alone. If it is limited to BAR servers only How data is sent from Teradata to TARA server/Netbackup server.Awaiting your reply.
 
Regards,

I can run stored procedures from within SAS, but I cannot seem to be able to create them? Is this a limitation of the SAS Access for Teradata software?
Thanks

Can some please throw some light on sql server to teradata datatype conversion.
We have a requirement to convert Sql server tables to Teradata but for certain 
datatypes like geography ,hierarchyid, image in sql server , we are not able to map them in teradata.
 

What are multistream jobs in Netvault backup jobs for taking Teradata backup ?How do they split the table's data across multiple streams?What is the concept on which they work?
How do we decide the number of sessions and streams for a mutilstream netvault job that is optimum for a particular Teradata system configuration?

Hi,
Is there any free source tool available which we can translate Oracle built-in SQL functions to Teradata functions? I have read about Automated Application Migration tool (AAMT) but it's teradata owned. is it available as free source ? 
Thanks in advance.

Would like to know if it is possible to show tablenames in mixed case (i.e., MixedCase instead of MIXEDCASE) in the Database Explorer window. If so, where and how is this option set?
Thank you!

I am working on a project with Teradata 13.10 and SAS 9.3.  We are using SAS/Access to interact with the Teradata system.  

Hi,
 
Is there a way to create temporary tables in Teradata using an Excel connection?  I would like to run a select query afterwards, which I can run.  However, creating the temporary tables is difficulat.
Thoughts?

I built an Access DB and front-end application. My application and everything in Access worked perfectly fine. The problem is no one else could use it unless I emailed it or put it on our shared drive. So, the mgmnt team decided to migrate the back-end to Teradata Labs. I finished migrating all my tables and data, however still using the Access front-end.

HiI have installed Teradata demo on Windows 2000 machine and I have been working comfortable with the same using SQL Assistant and Administrator (7.1).Recently I installed the same demo version on Windows 2003 and I have been trying to connect to it using SQL Assistant and it gives me the error (160: Specified driver could not be loaded due to system error 124 (Teradata). When I try and connect using Administrator I get the error "10054: 10054 WSA E ConnReset: Connection reset by peer" and the service stops.I do not have any firewalls and my hosts file is untouched (the same as with 2000). I have tried installing the latest ODBC drivers but the result is unchanged.Any help is resolving this issue would be highly appreciated.

Hi,
We have some BI queries which run on Teradata. Now these queries create a temp table in the base tables database and then read from another transaction table again in the base tables daabase. If any other job is updating this transaction table then we face a deadlock because of the read lock already on the table. 

Hi all,
Situation
I have a spreadsheet that pulls back multiple tables from Teradata using the Data connection tool within Excel 2010.
Issue
My issue is Excel is requesting me to type my Teradata password in for every table/query bought back/that runs (username is saved).
Question

Is there already any free tool or I need to develop one?

I see a gap of technology, business and people, while working on projects.

I know it's not cerified, but has anyone found themselves here, or know of a reason it shouldn' t be tried?
 
 
 
RGlass

Which tools or RDBMS are best for extracting and Tranforming unstructured data?
Or is it better to write unix, perl or python scripts?
Load of stream data can be for long time.
Thanks and regards,
Raja

Hi All,

Has there ever been an implementation of the Teradata Control Framework on IBM DataStage?

And if the said Teradata Control Framework had utilized the InfoSphere DataStage Balanced Optimization for implementation?

Any advise is highly appreciated.

Many thanks!