<\/p>\n
Setting up a connection for Excel to the Teradata database was a little bit of a challenge.\u00a0In this example, the Operating System was Windows 7 and version Excel 2013 was used.\u00a0This is broken in to two parts, first is setting up the ODBC connection, then section is attaching the connection in Excel.<\/p>\n
Note:<\/strong>\u00a0If the ODBC connection is already setup, then skip down to Part 2<\/p>\n <\/p>\n PART 1: SETTING UP THE ODBC CONNECTION TO TERADATA<\/strong><\/p>\n 1.\u00a0\u00a0\u00a0Click the\u00a0Start<\/strong>\u00a0button, type in the run text box:\u00a0odbcad32<\/strong>, then hit the enter button or click on the link above the box.<\/p>\n 2. The ODBC Data Source Administrator box will open, click the\u00a0Add<\/strong>\u00a0button.<\/p>\n 3. A new box will pop open, click on the\u00a0Teradata<\/strong>\u00a0driver, then click the\u00a0Finish<\/strong>\u00a0button.<\/p>\n Note: If the Teradata driver is not there, then contact the IT department to have it install on the computer.<\/strong><\/p>\n 4. If using a Teradata database account:<\/p>\n 1. Enter a\u00a0name<\/strong>\u00a0that will be easy to recognize<\/p>\n 2. Optional to enter a\u00a0description<\/strong><\/p>\n 3.\u00a0Then the\u00a0database server name<\/strong>\u00a0or\u00a0IP address<\/strong>\u00a0of the Teradata database (may need to get this from the IT department)<\/p>\n 4. Enter the\u00a0database account<\/strong><\/p>\n 5. Enter the\u00a0password<\/strong>\u00a0for the database account<\/p>\n 6. Click the\u00a0OK<\/strong>\u00a0button<\/p>\n 4a. If using an LDAP or Microsoft Active Directory account (eg. password is the same as the one logging on to the network), the in the Mechanism drop down menu and chose\u00a0LDAP<\/strong>, before clicking the\u00a0OK<\/strong>\u00a0button.<\/p>\n 5. A popup warning will display about choosing to store the password.\u00a0If the company\u2019s security policy permits this, then click the YES button.\u00a0This will prevent being asked each time for a password when the connection is made.<\/p>\n 6. The newly created ODBC connection for Teradata should now be listed, click the\u00a0OK<\/strong>\u00a0button to close the ODBC Data Source Adminstrator.<\/p>\n <\/p>\n PART 2: CONNECTING TO THE ODBC CONNECTION IN EXCEL<\/strong><\/p>\n 1.\u00a0\u00a0\u00a0In the Excel Workbook that you want the Teradata information, click on the\u00a0Data<\/strong>\u00a0tab.\u00a0Then click on the\u00a0From Other Source<\/strong>\u00a0drop down menu.\u00a0Then click on the\u00a0From Data Connection Wizard<\/strong>.<\/p>\n 2. Click on the\u00a0ODBC DNS<\/strong>, then click on the Next button.<\/p>\n 3. The newly created ODBC connection for Teradata from part 1 above should be there, click on it to highlight it, then click on the\u00a0Next<\/strong>\u00a0button.<\/p>\n 4. This is where the table or view with the information that you want brought in to Excel.\u00a0Highlight the database and table name, then click on the\u00a0Next<\/strong>\u00a0button.<\/p>\n Caution: In Teradata, some of your tables can be holding billions of records, if you attempt to bring in that large a table, it will crash Excel.<\/strong><\/p>\n 5. Enter a descriptive name, especially if this connection with be used again.\u00a0The description is optional.\u00a0Click on the\u00a0Finish<\/strong>\u00a0button, and the box will close.<\/p>\n 6. A popup box will ask to import the data now.\u00a0If there is a large amount of data, this may take seconds, maybe even minutes depending on the database.\u00a0In the example below, the defaults were taken by clicking on the\u00a0OK<\/strong>\u00a0button.<\/p>\n 7. Below is an example of what the results may look like.<\/p>\n Thanks & Regards,<\/p>\n Pankaj Chahar<\/p>\n +91-8802350184<\/p>\n Pankajchahar052@gmail.com<\/p>\n\n