{"id":1138,"date":"2016-04-02T14:35:34","date_gmt":"2016-04-02T14:35:34","guid":{"rendered":"http:\/\/www.theSQLReport.com\/?p=1138"},"modified":"2016-04-02T14:35:34","modified_gmt":"2016-04-02T14:35:34","slug":"creating-an-odbc-connection-to-teradata-for-excel","status":"publish","type":"post","link":"https:\/\/www.theSQLReport.com\/?p=1138","title":{"rendered":"Creating an ODBC Connection to Teradata for Excel"},"content":{"rendered":"

Setting up a connection for Excel to the Teradata database was a little bit of a challenge.\u00a0 In this example, the Operating System was Windows 7 and version Excel 2013 was used.\u00a0 This 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> If the ODBC connection is already setup, then skip down to Part 2<\/p>\n

Part 1: Setting up the ODBC Connection to Teradata<\/h3>\n
    \n
  1. Click the Start<\/strong> button, type in the run text box: odbcad32<\/strong>, then hit the enter button or click on the link above the box.<\/li>\n<\/ol>\n

    \"odbcad32.exe\"<\/a><\/p>\n

    2. The ODBC Data Source Administrator box will open, click the Add<\/strong> button.<\/p>\n

    \"ODBC<\/a><\/p>\n

    3. A new box will pop open, click on the Teradata<\/strong> driver, then click the Finish<\/strong> button.<\/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

    \"Create<\/a><\/p>\n

    4. If using a Teradata database account:<\/p>\n

    1. Enter a name<\/strong> that will be easy to recognize<\/p>\n

    2. Optional to enter a description<\/strong><\/p>\n

    3.\u00a0 Then the database server name<\/strong> or IP address<\/strong> of the Teradata database (may need to get this from the IT department)<\/p>\n

    4. Enter the database account<\/strong><\/p>\n

    5. Enter the password<\/strong> for the database account<\/p>\n

    6. Click the OK<\/strong> button<\/p>\n

    \"Driver<\/a><\/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 LDAP<\/strong>, before clicking the OK<\/strong> button.<\/p>\n

    \"Driver<\/a><\/p>\n

    5. A popup warning will display about choosing to store the password.\u00a0 If the company’s security policy permits this, then click the YES button.\u00a0 This will prevent being asked each time for a password when the connection is made.<\/p>\n

    \"ODBC<\/a><\/p>\n

    6. The newly created ODBC connection for Teradata should now be listed, click the OK<\/strong> button to close the ODBC Data Source Adminstrator.<\/p>\n

    \"Finish<\/a><\/p>\n

    <\/h3>\n

    Part 2: Connecting to the ODBC Connection in Excel<\/h3>\n
      \n
    1. In the Excel Workbook that you want the Teradata information, click on the Data<\/strong> tab.\u00a0 Then click on the From Other Source<\/strong> drop down menu.\u00a0 Then click on the From Data Connection Wizard<\/strong>.<\/li>\n<\/ol>\n

      \"Excel<\/a><\/p>\n

      2. Click on the ODBC DNS<\/strong>, then click on the Next button.<\/p>\n

      \"ODBC<\/a><\/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 Next<\/strong> button.<\/p>\n

      \"Connect<\/a><\/p>\n

      4. This is where the table or view with the information that you want brought in to Excel.\u00a0 Highlight the database and table name, then click on the Next<\/strong> button.<\/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

      \"Select<\/a><\/p>\n

      5. Enter a descriptive name, especially if this connection with be used again.\u00a0 The description is optional.\u00a0 Click on the Finish<\/strong> button, and the box will close.<\/p>\n

      \"Finish\"<\/a><\/p>\n

      6. A popup box will ask to import the data now.\u00a0 If there is a large amount of data, this may take seconds, maybe even minutes depending on the database.\u00a0 In the example below, the defaults were taken by clicking on the OK<\/strong> button.<\/p>\n

      \"Import<\/a><\/p>\n

      7. Below is an example of what the results may look like.<\/p>\n

      \"Teradata<\/a><\/p>\n

      \n","protected":false},"excerpt":{"rendered":"

      Setting up a connection for Excel to the Teradata database was a little bit of a challenge.\u00a0 In this example, the Operating System was Windows 7 and version Excel 2013 … Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":1146,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54,10],"tags":[73,74,66],"class_list":["post-1138","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-teradata","category-windows","tag-excel","tag-odbc","tag-teradata"],"_links":{"self":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1138"}],"collection":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1138"}],"version-history":[{"count":12,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1138\/revisions"}],"predecessor-version":[{"id":1168,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1138\/revisions\/1168"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/1146"}],"wp:attachment":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}