krsuper.blogg.se - Allmänt

Odbc driver for mac excel 2016 install#

Then click on the From Data Connection Wizard.Ģ. Then click on the From Other Source drop down menu.

In the Excel Workbook that you want the Teradata information, click on the Data tab.

Part 2: Connecting to the ODBC Connection in Excel The newly created ODBC connection for Teradata should now be listed, click the OK button to close the ODBC Data Source Adminstrator. This will prevent being asked each time for a password when the connection is made.Ħ. If the company’s security policy permits this, then click the YES button. A popup warning will display about choosing to store the password. password is the same as the one logging on to the network), the in the Mechanism drop down menu and chose LDAP, before clicking the OK button.ĥ. If using an LDAP or Microsoft Active Directory account (eg. Enter the password for the database accountĤa. Then the database server name or IP address of the Teradata database (may need to get this from the IT department)ĥ. Enter a name that will be easy to recognizeģ.

Odbc driver for mac excel 2016 install#

Note: If the Teradata driver is not there, then contact the IT department to have it install on the computer.ġ. A new box will pop open, click on the Teradata driver, then click the Finish button. The ODBC Data Source Administrator box will open, click the Add button.ģ. Click the Start button, type in the run text box: odbcad32, then hit the enter button or click on the link above the box.Ģ.Note: If the ODBC connection is already setup, then skip down to Part 2 Part 1: Setting up the ODBC Connection to Teradata This is broken in to two parts, first is setting up the ODBC connection, then section is attaching the connection in Excel. In this example, the Operating System was Windows 7 and version Excel 2013 was used. Setting up a connection for Excel to the Teradata database was a little bit of a challenge.