All Forums

Have questions related to the interaction of non-Teradata software with Teradata? This is the place to ask questions about any of our partners' software. You must login to create a new forum topic.

Informatica vs Teradata BTEQ Topic by shahrajm 05 Feb 2009 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...
6858 views
4 replies, 1 week ago
At our company we use Informatica as the standard data integration platform. Currently, we're in the process of implementing an Enterprise Data War...
reichel0110
Ab Initio ETL Training Online Topic by polonet 2 weeks ago Anyone know of a place that does ab initio training online. and if the training is with Teradata, better yet. Thanks!
165 views
0 replies
Unable to connect to Teradata using SQL Assistant and Teradata Administrator Topic by nileshsane 22 Feb 2008 Hi

I 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...
19441 views
3 replies, 9 weeks ago
Teradata CANNOT run unless Physical Address Extension (PAE) is completely disabled, that is /noexecute must be alwaysoff (/noexecute=alwaysoff) and...
Edgar Weber-2271
Connect INFORMATICA PowerCenter to TERADATA Topic by LUCAS 07 Oct 2009
Tags:
Hi, this is a second post, looks like the former one is lost ... an attempt to connect INFORMATICA to TERADATA via ODBC returns an error : [DataDirect][ODBC Teradata Client driver][Teradata]The user does not have SELECT access to DBC.TVM. Does anybody know why INFORMATICA should access DB...
772 views
2 replies, 18 weeks ago
Hi, All dbc.tables, dbc.databases & dbc.columns are views based on dbc.tvm table. When we create any User in Teradata, by default it grant SELE...
Thiruppathi
SAS BIGINT issue? Topic by Random_Thought 12 Nov 2009 There is an issue with SAS 9 accessing Teradata databases that use BIGINT. Error ERROR: At least one of the columns in this DBMS table has a datatype that is not supported by this engine. Has anyone fixed this issue here? There was supposed to be a fix http://support.sas.com/kb/34/72...
277 views
1 reply, 18 weeks ago
One workaround was to create views to cast the offending bigint to Decimal(31), but this has serious performance overheads. Especially when the ...
Random_Thought
Oracle to Teradata Database Migration Tool Topic by surapurajup 19 Sep 2007 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,
29602 views
6 replies, 18 weeks ago
It seems fastreader is popular tool for large migrations from oracle these days. adding the link to steps how to migrate data from oracle-to-terada...
ChelleV
What about the Talend certification program? Topic by ofdabler 21 Oct 2009 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 ...
856 views
1 reply, 20 weeks ago
Hi, The Talend certification is available to all users including any individuals. You just need to have thorough knowledge on Talend. Pricewis...
sukhi
Teradata on Linux Topic by shineshvv 17 Aug 2009 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.

Thanks
Shinesh
1861 views
3 replies, 21 weeks ago
Yes; see http://developer.teradata. com/database/articles/tera data-express-13-0-family-a vailable
mkandaaa
Will Teradatawork on Vista OS.. Topic by MKK 08 May 2009 Hi All,
Can any one tel me whether Teradata will work on Vista supported OS..?
3017 views
3 replies, 24 weeks ago
yes it will.
deq18
more info on teradata world Topic by sakthi 28 Sep 2009
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 Teradat...
900 views
1 reply, 24 weeks ago
hello, listed below are the some of the roles on Teradata 1) Teradata Infrastructure group ( these ppl handle the hardware/softare part of teradata...
deq18
Demo on Win 2003 Server - Connection reset by peer Topic by jpg 24 Sep 2009 Hello all

Getting 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...
667 views
0 replies
Comparison between Talend Integration Suite and Talend Open Studio Topic by Jstatic 10 Sep 2009
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 woul...
1044 views
1 reply, 26 weeks ago
Hi. Here is what I have to say about the comparison between both programs. Is using Talend Integration Suite really better compared to using Tal...
table
MySQL database and Software as a Service Topic by Jstatic 02 Sep 2009
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 yo...
1026 views
1 reply, 28 weeks ago
So as I understand, what you need is an online database program able to perform ETL tasks, that works in the cloud. There are a few companies ou...
table
MS SSIS - OLEDB command Topic by helmut 15 May 2009 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 followi...
4050 views
2 replies, 28 weeks ago
The SSIS connector seems to work great, but I'm getting an error when I try to run the package : "[Teradata Source [1]] Error: The Teradata TPT reg...
Terry
Welcome to the Teradata Developer Exchange discussion forums! Topic by neilotoole 14 Jul 2009
Tags:

Please see this topic in the General forum for an introduction to the new discussion forums, and a chance to give feedback.
273 views
0 replies
Ports Required for Teradata to be connected Topic by Ohmsaravanan K 03 Apr 2008 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 th...
12691 views
2 replies, 49 weeks ago
visit this link to know the port number http://www.teradata.com/te radataforum/Topic3266-9-1. aspx?Highlight=firewall
mparker
SQL Assistant - missing or corrupt terada.lng reported during startup Topic by pj.routledge 02 Feb 2009 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.
3855 views
1 reply, 1 year ago
This problem is fixed. Unfortunately I don't know what caused it nor what exactly fixed it. I purged all Teradata software from the PC (except th...
BGN
technologies Topic by allpubs 23 Nov 2008 We like to know if there are technologies like those posted at http://morsi.org/projects/atep/? Thanks
6336 views
0 replies
BizTalk with Teradata? Topic by colin.davies@amgen.com 22 Oct 2008 Is anyone using BizTalk with Teradata, especially for "trickle-feeding" near real-time updates into the EDW?
7712 views
0 replies
ODBC connection problem - MS Query and Excel Topic by AndrewLivingston 12 Aug 2008 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 pa...
19006 views
3 replies, 1 year ago
Thanks for the tips. I was also having similar problems using Excel to import data from a Teradata DB using Microsoft Query. The first link on Goo...
Sasha Froyland
system hang after connecting to Teradata with Visual Studio 2008 via ODBC Topic by akhshay 20 Aug 2008 hello

I 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 c...
11020 views
1 reply, 1 year ago
hii everyone, The issue is solved, i was using vs2008 i uninstalled it and installed vs2005 as .net teradata data provider for VS2008 is not avail...
pvgbabu-1698
.NET unable to fetch the data from teradata Topic by akhshay 21 Aug 2008 hi

I 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.D...
10602 views
1 reply, 1 year ago
hi everyone i found the error... its because i was not using rdr.read() after rdr = cmd.executereader(); thank you :-)
pvgbabu-1698
Teradata & JAVA connection please Topic by vinay 30 Jul 2008 Hi all can anyone please tell me how can we connect teradata with java, please let me know
11709 views
1 reply, 1 year ago
I am having a problem with the connection string. I am using the connection string: jdbc:teradata://HostName/D ATABASE=databaseName i am facing a...
cheng
Teradata & SAS Queries Topic by xavisco 08 Jul 2008 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, ...
11442 views
1 reply, 1 year ago
Hi, I have strong views on this subject and it often brings out the worst in me... So apologies in advanced :) In short, no something is wrong....
dantoskoti
Install Terdata version 12 on Windows 2003 server Topic by Michael Braverman 23 Jun 2008 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.
8015 views
0 replies
You must login to create a new forum topic.