Topic: Teradata Doesnt Display Table
Teradata Doesnt Display Table
I can connect to a Teradata database but the tables in the database do not display in the Analysis Job Panel. The table was created in my own database so it should display accordingly.
Any suggestions?
Any suggestions?
If you start up DC from the command line, are there any interesting (error) messages being printed?
Technically speaking this will happen if the database driver does not return the tables when Connection.getMetaData().getTables(...) is being invoked.
Technically speaking this will happen if the database driver does not return the tables when Connection.getMetaData().getTables(...) is being invoked.
We got it to work finally. Took a bit of trial and error and our datawarehouse is huge 12+TB so it takes a while to load the tables. I am not sure if the connection string had anything to do with but this worked.
jdbc:teradata://host/database=duisg,table=xxxxemails,type=default,tmode=ANSI,CHARSET=UTF8,LOB_TEMP_TABLE=databaseName.tableName,partition=dbc/sql
At least this works. I was able to analyze 5 text fields with over 1+mm rows in under 10 minutes. What a great product.
jdbc:teradata://host/database=duisg,table=xxxxemails,type=default,tmode=ANSI,CHARSET=UTF8,LOB_TEMP_TABLE=databaseName.tableName,partition=dbc/sql
At least this works. I was able to analyze 5 text fields with over 1+mm rows in under 10 minutes. What a great product.
Log in by clicking the login link at the top of the screen
Go back to forum.
