teradata

Hi, Just wondering if anyone has any experience using Teradata database connections and might be able to give me some advice on how to get around the Spool space issues. I am trying to find a way to potentially join a table before query imports the table to cut down the amount of lines that...

What is the Teradata connection string when connecting in VBA code? I understand that the provider now includes the version number.

This is the current Power Query code: With the data coming from another Power Query table (tblDateCurrent) with only one entry. let Source = Teradata.Database("cdwp", [HierarchicalNavigation=true, Query="SELECT #(lf) DIV_DESC,#(lf) DEPT_DESC,#(lf) SUB_DEPT_DESC,#(lf)...

Hello, Please help. I have queries in Teradata and SQL Server, which I have brought both into separate connections in Excel. I need to join an Access table to both queries. I have the access table linked in the Excel workbook, but cannot figure out how to join the access table in the...

I am new to Teradata, so I am trying to learn all its quirks. What I am trying to accomplish is write a temp table and then query off of it all in one statement. When I run the query below in Powerpivot I get the following error: [Teradata Database] [3932] Only an ET or null statement is...

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 a...

Hello friends, I need help in connecting to a Teradata database on a remote server. I could comeup with a VBA for connecting to 'Teradata' database locally with in that server and want to move my solution a step further where the user would be able to connect to the database in a server and get...

I'm using an Excel macro to run several SQL queries. Some are Teradata queries, and one query is a DB2 query. To synch up all the queries to return comparable data, I’m using a column in a worksheet to define parameters for the SQL where statements. This lets me control the inputs in one...