Netezza Database

This example discusses how to connect Tableau to a Netezza database.
  1. Select Data > Connect to Data to open the Connect to Data page.
  2. Select Netezza.
  3. Follow the steps in the Netezza Connection dialog box to complete the connection.
    1. Step 1 – Type the name of the server that hosts the database.
    2. Step 2 – Enter the database name that you want to connect to.
    3. Step 3 – Enter your username and password to log on to the server.
    4. Step 4 – Test the connection.
      If the connection is successful, Tableau will alert you. If the connection is unsuccessful, verify that your user name and password are correct. If the connection continues to fail, your computer is having trouble locating the server. Contact your network administrator or database administrator.
    5. Step 5 – Select a table or view from the database.
      Netezza databases can contain multiple tables and views. Specify which table or view within the database you want to connect to. You can also connect to multiple tables or a specific query by selecting the Multiple Tables and Custom SQL options.
    6. Step 6 – Give the connection a name for use in Tableau.
      Specify a unique name for the connection. The default name is automatically generated based.
A completed Connection dialog box for Netezza is shown below.

1 comment:

  1. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Big Data Hadoop and Spark Developer, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on Netezza Training. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Sangita Mohanty
    MaxMunus
    E-mail: sangita@maxmunus.com
    Skype id: training_maxmunus
    Ph:(0) 9738075708 / 080 - 41103383
    http://www.maxmunus.com/


    ReplyDelete