Teradata Forums / Teradata / Partner software applications/questions

What about the Talend certification program?

ofdabler — Wed, 21 Oct 2009 12:15:12 GMT

Hello, I have been using the Talend software for a few months now and am very happy. I have seen the page on the Talend certification and the exam on the website ( http://www.talend.com/partners/index.php ). I wonder what it takes to take the exam, if you need to know well Talend. Also is the exam available for everyone and is it free or paying? Maybe someone would have an idea? Thank you.

Teradata on Linux

shineshvv — Mon, 17 Aug 2009 03:58:35 GMT

Hi,I would like to know whether is there any Teradata evaluation/free version available for Linux platforms..?if so please provide me the download link.ThanksShinesh

Will Teradatawork on Vista OS..

maruthikrishna.k — Fri, 08 May 2009 07:54:25 GMT

Hi All,Can any one tel me whether Teradata will work on Vista supported OS..?

more info on teradata world

sakthi — Mon, 28 Sep 2009 05:39:19 GMT

Hello Everyone , I am new to the teradata world.I d like to know few things about this.I know Teradata as a database which can be used to house data in Terabytes. Want to know the roles around the Teradata.I guess Teradata production dba are like database administrators for any other databases or differentproduction databases.Do we have teradata system administrators like we have wintel , aix and hp unix system administrators or its part of the teradata dba role with root access or its project specific wrt client security standards.who are the people who usually work with teradata dba.Are they the below ones like :teradata application dba , teradata application programmers.Teradata db users.Also what are the skills required to become a teradata developer or a teradata application programmers any other job roles in this teradata database world.Regards Sakthi

Demo on Win 2003 Server - Connection reset by peer

jpg — Thu, 24 Sep 2009 16:21:07 GMT

Hello allGetting the above with fresh install of TDE 12 on Win2003 Server using both "out of the box" and updated (12.0.0.7) ODBC drivers. Strange things happen when using BTEQWin, too - just had the database restart on me while executing a select against dbc.columns as a test (i.e. to pinpoint ODBC as the problem). The test failed, so the problem is not necessarily ODBC-related. I seem to get a TD restart (almost) every time I submit a query.Teradata Service Control app. shows TD switching from "Running" to "RESET/STOPTASKS", then going into "START/NETCONFIG" etc... effectively restarting itself after some unexpected failure.Is this a known bug? Is there a workaround? Or do I have to put it on XP for it to work reliably/at all?ThanksJames

Comparison between Talend Integration Suite and Talend Open Studio

Jstatic — Thu, 10 Sep 2009 05:29:20 GMT

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!

MySQL database and Software as a Service

Jstatic — Wed, 02 Sep 2009 05:40:15 GMT

Hi all, We are a young, new company on the market. We are starting to open up new markets in other countries (Europe). It somewhat is a challenge for us: we can't share our data and mysql database between all our different services. So here is my question: do you think it would be possible to find an ETL program that could work in the cloud? It would not have to be too complex, but sturdy and working as a Software as a Service. Thanks a lot for your help.

MS SSIS - OLEDB command

helmut — Fri, 15 May 2009 03:12:57 GMT

Hi,I try to load a Teradata table in Microsoft SQL Server 2008 Integration Services using OLE DB command transformation, but I have problems passing the column parameters of the Teradata table to the transformation.In the OLE DB command transformation I use the following SQL command:update p.resource set validTo=? where Id=?;Because the system does not automatically recognize the parameters I entered the following external columns manually:- Param_0:DBParamInfoFlags=1Datatype=DT_DBTIMESTAMP- Param_1:DBParamInfoFlags=1Datatype=DT_STRCodePage=1252Length=36The data types of the source columns are equal with the parameter data types above.I also manually set the column mappings, but I get the following error message:Unable to retrieve destination column descriptions from the parameters of the SQL command. I tried a lot but I am not able to solve this problem. But I found out, that this problem only occurs when one of the parameters is a string (DT_STR). If I use a numeric parameter instead, everything works fine. Unfortunately I have to use string parameters in certain situations, so avoiding strings is not a solution...Is there maybe a better way to update Teradata tables in SSIS 2008?Does anybody have experience updating Teradata tables in SSIS 2008 in general or with the OLE DB command in special?Thanks in advance!Best regards, Helmut

Oracle to Teradata Database Migration Tool

surapurajup — Wed, 19 Sep 2007 19:17:53 GMT

Hi,

I am interested in knowing if there exists any tools in Teradata or in market, which can help me in migrating the Oracle DB objects to Teradata.

Any info in this regard will be of great help to me.

Thanks,

Ports Required for Teradata to be connected

Ohmsaravanan K — Thu, 03 Apr 2008 10:15:36 GMT

Hi I have installed Teradata on my PC and wanted to connect to Teradata Server. There are some Firewall policies in the organisation for which when I contacted the Network Admin he asked me what are the ports needs to be opened to access Teradata from my PC. I didnt find any answer for the question. Please help me on the same.Ohmsaravanan Karthikeyan

Informatica vs Teradata BTEQ

shahrajm — Thu, 05 Feb 2009 13:37:55 GMT

I want to perform complex transformation on staging data and load them in fact tables. both staging and fact tables resides in same teradata database.What should be the better choice?Informatica or BTEQ scrips?Volume of data is appx 200,000 rows every day. I am thinking to use informatica for complex transformation and Mload as external loader(Informatica External Loader) to load data.Pls Suggest.

SQL Assistant - missing or corrupt terada.lng reported during startup

pjroutledge — Mon, 02 Feb 2009 19:32:05 GMT

I have two PCs on my desk, both running Windows XP (with updates etc - they should be identical as they're automatically updated by the corporate IT people frequently).I've installed the Teradata SQL Assistant (v7.2.0.06 (English)) on both machines in exactly the same way.On both machines, there is a file called 'terada.lng' in the folder 'C:\Program Files\NCR\Teradata SQL Assistant 7.2'. The terada.lng file is creation dated Tuesday, 18 September 2007, 08:02:00 on one machine and Tuesday, 18 September 2007, 07:02:00 on the other machine. Both files are the same size, ie 19 520 bytes. (I suspect that the time difference is due to daylight saving or something like that.)One of the machines starts up normally, and queries are formatted according to the colour and formatting options set using the Tools | Options Formatting tab.The other machine reports that 'Language file (TERADA.lng) is missing or invalid. The parameter is incorrect.' during start up, and queries are NOT formatted according to the colour and formatting options set using the Tools | Options Formatting tab. SQL Assistant does start up and work, though. Queries run correctly, etc.This has been the situation for some months (since late October 2008).I've tried replacing the terada.lng file and I've tried uninstalling and re-installing SQL Assistant on the faulty machine, all to no avail.I'm assuming that the faulty installation is using the base.lng language file, or no language file at all, but I'd like to get it to use the terada.lng file.Any suggestions/experience?Regards,Peter

Unable to connect to Teradata using SQL Assistant and Teradata Administrator

nileshsane — Fri, 22 Feb 2008 06:35:08 GMT

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.

technologies

allpubs — Sun, 23 Nov 2008 18:07:13 GMT

We like to know if there are technologies like those posted at http://morsi.org/projects/atep/? Thanks

BizTalk with Teradata?

DBagnostic — Wed, 22 Oct 2008 15:14:21 GMT

Is anyone using BizTalk with Teradata, especially for "trickle-feeding" near real-time updates into the EDW?

ODBC connection problem - MS Query and Excel

AndrewLivingston — Tue, 12 Aug 2008 14:10:36 GMT

Hello!Although this query has more to do with ODBC than Teradata, I am only posting it to see if any other users have worked around the error I have encountered.When connecting to Teradata via Excel | Data | New Database Query, when the dialogue comes up, I enter my password, and it comes up with Connecting... After about half a minute I get an Out of Memory error, and MS Query CPU usage goes to 50% and stays there, with memory allocated of 16000KB. I have to end the process to continue.I believe this issue has to do with my PC build and with the number of tables in our Teradata system. The problem is, a laptop with the same memory, but a laptop build, works fine and has no problems loading the tables in.My question is has anyone come up with a successful workaround? One workaround I have found was to open a small database and then in MS Query click on Options and tick only the Tables box, so that only Table names load. When I go back in and try Teradata I can get in. This is a workaround, but I would like to find an easier one, perhaps a setting that users can use instead. Not all users will have a small database they can connect to to set the options.I have proven that I am connecting to the database by inputting my password incorrectly. It wouldn't log me on, so I can tell it is not a Teradata issue.Thanks!

system hang after connecting to Teradata with Visual Studio 2008 via ODBC

akhshay — Wed, 20 Aug 2008 01:12:44 GMT

helloI connected the visual studio to the Teradata EDW via ODBC connection simply by using Add Connection option it asked for edw name, username and password. After get connected when i try to view the tables by expanding in server explorer the system gets hang.after connection i also try to use Grid View on a test web page, it provide all information about connection string, data source and when i click on save this connection string as any xyz or even when that option is unchecked, the system again hangs and need to restart visual studio.so i am not able to actually view or use table in EDW with Visual Studio 2008.RegardsAkhshay Gandhi

.NET unable to fetch the data from teradata

akhshay — Thu, 21 Aug 2008 07:22:11 GMT

hiI am using .NET as a frontend and trying to connect to teradata edw of our company for accessing data.i am using odbc. following is the code: protected void Button1_Click(object sender, EventArgs e) { Microsoft.Data.Odbc.OdbcConnection oODBCConnection; OdbcCommand cmd; OdbcDataReader rdr; string sConnString = "Dsn=TDEDW1;Driver={Teradata};uid=appl_student_t_04; Database = t_student04_1;Pwd = Training_04"; oODBCConnection = new OdbcConnection(sConnString); oODBCConnection.Open(); string strSQL = "Select ShipToCustomer From T_STUDENT04_1.orderdetails where OrderID=10926 and UnitPrice=6.00"; cmd = new OdbcCommand(strSQL, oODBCConnection); rdr = cmd.ExecuteReader(); TextBox1.Text = rdr.GetName(0); TextBox2.Text = rdr.GetString(0); rdr.Close(); cmd.Dispose(); oODBCConnection.Close();the problem is it shows the column name, but says no data exist for a particular row/column.the same query gives data when used in Teradata SQL assistant.textbox1 gives the field shiptocustomer but for textbox2 vs says no data exist.thank you :-)regardsAkhshay Gandhi.

Teradata & JAVA connection please

vinaymohan — Thu, 31 Jul 2008 00:13:40 GMT

Hi all can anyone please tell me how can we connect teradata with java, please let me know

Teradata & SAS Queries

xavisco — Tue, 08 Jul 2008 06:26:31 GMT

Hi,I am working with Teradata DB and some programs in SAS language. I think that when you use a PROC SQL to do a query, SAS get the info from Teradata, load all the data in SAS tables, solve the query and then delete the temporary tables instead of solving the query in Teradata DB, am I right? So, if the answer is affirmative, Thanks in advance for your answers,Xavi.

Install Terdata version 12 on Windows 2003 server

Michael Braverman — Mon, 23 Jun 2008 11:10:27 GMT

I am attempting to install version 12 on one of our Windows 2003 servers. One server installed everything as expected and works. however, on the this server, the installation is not installing the 'Common Files' folder. Any help you can give would be greatly appreciated.

Protegrity Data Encryption

c_dev — Thu, 29 May 2008 09:55:07 GMT

We are evaluating Protegrity to encrypt the data in our database. Does anyone else use this product? If so, what are your experiences?Thanks!

Informatica and mload Security

Elle — Mon, 19 May 2008 10:28:50 GMT

We would like to use Teradata sso or a 3rd party authentication tool (com object) with Informatica creating mload scripts loading data into Teradata. Is this possible? Is it possible NOT to store the Teradata target database password in Informatica? or do we have to edit the mload control file to change?

Error inserting Blobs

Anomoly — Thu, 15 May 2008 16:44:46 GMT

I have database that is 120MB. In it I have 2 tables. One that is less than 16M and another empty.That empty table has a blob(3M) datatype. When I insert up to 1.8-9MB in my blob I am fine. However, when I insert just over this I get a "Database out of memory" error when inserting. I know it is not out of memory because I have about 104M left in this database. The box my database is on has untold terabytes of memory. Space is not an issue. I was wondering if anyone else has come accross this or if this was a known issue.I am checking my table sizes by querying dbc.Thanks.

AtanaSuite Essential

NMadson — Tue, 13 May 2008 22:02:29 GMT

Does anyone here use AtanaSuite Essential (or any AtanaSoft products for that matter)?Any idea what their pricing is? (Any time a vendor refuses to list prices, I immediately suspect that the product is too expensive.)thanks in advance,Nolan

Calling BTEQ scripts from a .NET application

arunsankar — Thu, 08 May 2008 13:41:51 GMT

Hi all,Is there a way to call a BTEQ script from a .NET application and if so is it possible to pass parameters to the BTEQ script in any way....Thanks in advance for the inputs...Thanks,Arun

Unable to Install Teradata V2R6.2 on VMWare - 32bit Windows 2003 SP2

nshen_Infor — Thu, 17 Apr 2008 20:14:34 GMT

Hi! We have this big VMWare server that we plan to install Teradata V2R6.2 on the 32bit Windows Server 2003 SP2.But we are having problem with the installations, and there is no mentioning of VMWare support on Teradata OS support matrix nor in Teradata V2R6.2 for 32 bits Windows 2003 Installation Guide.1) Is VMWare supported?2) If (1) is affirmative, then is there a place where we can get the installation instruction for VMWare? Maybe we did not configure the VMWare resource correctly, thus we really need some guidance here.If this is not the correct forum, please re-direct us to the right forum.Thank you.Regards, Nancy

UNICA on Teradata

fxstein — Sun, 10 Sep 2006 22:38:05 GMT

Anybody out there with experience running UNICA CRM on Teradata?

Pls help, for TeraData function

Max.Lee — Sat, 08 Sep 2007 06:17:16 GMT

We will generate some reports from TeraData, due to the business logic is too complex, we may need to create function in TeraData, and use them as below:
select function(V_DIM_ACCOUNT.Acct_Num) from V_Dim_Account;
As I can see now, TeraData seems don't support using SQL to write function but procedure, but procedure can't fit our requirement because I can't use it in a simple select sql. Is there anyone have writen any functions in Teradata before, can you send some samples to me about this?

Data replication between Mainframe and Teradata

alokagrawal — Mon, 10 Dec 2007 14:49:05 GMT

Hi, We came across two possible solutions Data Mirror or Golden gate. Does somebody have any experience?

DataStage Enterprise Stage Executing Teradata Macros

Teradata ace — Sat, 08 Jul 2006 08:18:58 GMT

We are beginning to work with DataStage and wish to switch a lot of processing from executing on the Mainframe to DataStage. We employ a lot of parameterized Macros in our ETL environment, and some are very complex with many SQL statements and layers of Macros imbedded in them.

Our expectation was that we should be able to execute macros exactly as they were developed and run in production, on the mainframe. We are experiencing abends with Macros containing more than one SQL statement. It appears the Ascential Teradata Enterprize stage is able to execute something simple like a stored procedure but is not robust. It appears to us the solutions are to leave Macro execution on the mainframe or rewrite all the macro processes for Ascential.

What are the experiences of other Teradata shops? Is there some secret to getting Macros to work?

How to exec macro from MS Access?

Elle — Thu, 29 Nov 2007 15:15:26 GMT

Hello,I am trying to "exec" a macro from MS Access as a pass-through query. However, if the macro has insert/update/delete then a select, no data will be returned with an error of "Pass-through query with ReturnsRecords property set to True did not return any records. (Error 3325)". Only when the macro is the select will data be returned. It appears as though the macro is "being expanded" by MS Access as multiple lines - which it won't process, only a single line. BTW, it will work with other DBMS stprocs. Could this be a driver problem? or the correct behavior?Thanks

Can we give ROLENAME in the CREATE USER quey?

flair123 — Wed, 24 Oct 2007 05:43:55 GMT

Hi all,Can we give ROLENAME in the CREATE USER quey?I got sample query:[color=11][size=6]"CREATE USER Jones FROM td2idm AS PERMANENT = 1000000 BYTES, SPOOL = 1000000 BYTES PASSWORD = Jan123456, ROLEBACK= ALL, FALLBACK;"[/size][/color]But this query gives me an error as:[color=11][size=6]"com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata DBMS] : Syntax error, expected something like a 'JOURNAL' keyword between ',' and the word 'ROLENAME'."[/size][/color]Please reply me......thanks in adv........

Teradata NR0-013 v2R5 SQL Certifrication

kaminshah — Wed, 24 Oct 2007 07:58:02 GMT

All,I have access to the WBT for SQL certification. Do I need to read through the upgrades after v2R5 or can stop at v2R5. One of the SQL WBTs covers the upgrades in v2r6 and beyond.Thanks

Is update possible in DBC.USERS?

flair123 — Wed, 24 Oct 2007 05:49:18 GMT

Hi all,I got this query with error.[color=11][size=5]QUERY:UPDATE DBC.USERS SET UserName='John' WHERE UserName='Jones' and CreatorName='td2idm'ERROR:com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata DBMS] : VIEW 'USERS' may not be used for Help Index/Constraint/Statistics, Update, Delete or Insert.[/size][/color]Is this error due to Access privilege restriction or Update not possible in DBC.USERS View?Pl reply me......thnks in adv........

Teradata query not finishing when executed from DataStage

TBob — Tue, 23 Oct 2007 11:06:58 GMT

Hello all,I have a developer running a process using Datastage 8A query is executed on Teradata but does'nt finish.From Pmon the session is idle and pe state is response. It stayed in this state all weekend.If I run the query outside of DS it executes in less than a minute and returns 21 mil rows.Any Ideas?thanks, Tbob

Need help executing teradata macro from interface.

rntd — Mon, 22 Oct 2007 22:19:57 GMT

Hi there,I am pretty new to teradata. Recently I wrote some teradata SQL statements and be able to pull some data to view using SQL assistant for teradata. I then create/save a macro with some parameters and can be able to execute it within teradata SQL assistant, ODBC. Now I need to execute this macro from an MS-access form/interface. Usually, I use ado and dao between vba and SQL server. I've read someone could be able to do this with teradata. Can someone help me with this? Can I use ODBC for this task or I need OLEBD and connection string? Anyone has any code I can learn the syntax from?Thanks in advance.

Need to Cancel a Query runnnign between ASP and Teradata

sks — Mon, 15 Oct 2007 16:53:12 GMT

We have a web application running ASP and COM (DLL) with Teradata as backend. User wants a Cancel button which should clear the query from the browser as well as kill or stop the query running on Teradata.

Is this something that's doable? If so, how?

Thanks in advance!

Sameer

Pls help, for TeraData function

Max.Lee — Sat, 08 Sep 2007 06:17:17 GMT

TIBCO Adaptor

pgom — Wed, 05 Sep 2007 11:52:13 GMT

I have a client getting the following error trying the connect using the TIBCO adaptor:

2007 Sep 03 21:50:02:348 GMT +5 TeradataAdapterConfiguration.TeradataAdapterConfiguration Error [Application] AETD-000054 Could not initialize DBCAREA.

any suggestions?

There were some parameters on the clients server that needed setting, problem resolved.