Oracle Database

This example discusses how to connect Tableau to an Oracle database.
  1. Select Data > Connect to Data to open the Connect to Data page.
  2. Select Oracle.
  3. Follow the steps in the Oracle Connection dialog box to complete the connection.
    1. Step 1 – Enter the Oracle connection name.
      If you do not know the exact connection string to type, click the advanced button. In the Advanced Oracle Connection dialog box, type the server name, service name, and optionally specify the port. Then click OK. The connection name will be created based on these variables.
    2. Step 2 – Provide log in information for the server.
      Specify whether to use Windows NT Integrated security or a specific username and password. If the cube is password protected, you must type your username and password.
    3. Step 3 – 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.
    4. Step 4 – Use the drop-down list to select the schema that you want to connect to.
    5. Step 5 – Select a table or view from the database.
      Oracle 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 Oracle is shown below.


Note:
In order to use your net services definitions in Tableau, you must set either TNS_ADMIN or ORACLE_HOME as an environment variable. To set TNS_ADMIN as the environment variable use the full path of the directory that contains the tnsnames.ora file. To set ORACLE_Home as an environment variable use the path to the main Oracle directory.

14 comments:

  1. Oracle Database Training will help you develop a thorough understanding of Oracle Database, as well as its related products. With more than 50 Database offerings, enhance your knowledge of Database 11g, MySQL, Data Guard, and more.


    SQL DBA Training in Chennai
    Best Oracle Training in Chennai

    ReplyDelete
  2. Very informative post! There is a lot of information here that can help any business get started with a successful social networking campaign!
    Tableau Online Training

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. This is very nice blog,and it is helps for student's.Thanks for sharing..
    Oracle training institute in delhi

    ReplyDelete

  5. This is very important and imformative blog,thanks for good info Oracle SOA Online Training Bangalore

    ReplyDelete


  6. It is really a great work and the way in which you are sharing the knowledge is excellent.Tableau Training in Chennai

    ReplyDelete
  7. There are a number of ways that can help us to learn tableau and become tableau certified associate and the best one so far is through tableau certification dumps and practice tests

    ReplyDelete
  8. Thank you for providing this kind of useful information,
    I am searching for this kind of useful information; it is very useful to me and some other looking for it. It is very helpful to who are searching for Oracle training.Oracle Training

    ReplyDelete
  9. Thanks for your blog. very nice article keep posting.
    tableau training
    learn tableau

    ReplyDelete
  10. Thanks for sharing this great information on Oracle PPM Cloud. Actually I was looking for the same information on internet for Oracle Project Portfolio Management (PPM) Cloud Tutorial and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can learn more about PPM Cloud by attending Oracle PPM Cloud Training .

    ReplyDelete
  11. Grab Data Science Certification in Chennai for skyrocketing your career with Infycle Technologies, the best Software Training & Placement institutes in and around Chennai. In addition to the Certification, Infycle also gives the best placement training for personality tests, interview preparation, and mock interviews for leveling up the candidate's grades to a professional level.Get Data Science Certification in Chennai | Infycle Technologies

    ReplyDelete
  12. Infycle Technologies, the No.1 software training institute in Chennai offers the Selenium course in Chennai for tech professionals, freshers, and students at the best offers. In addition to the Selenium, other in-demand courses such as Python, Big Data, Oracle, Java, Python, Power BI, Digital Marketing, Cyber Security also will be trained with hands-on practical classes. After the completion of training, the trainees will be sent for placement interviews in the top companies. Call 7504633633 to get more info and a free demo.Infycle Technologies, the No.1 software training institute in Chennai offers the Selenium course in Chennai for tech professionals, freshers, and students at the best offers. In addition to the Selenium, other in-demand courses such as Python, Big Data, Oracle, Java, Python, Power BI, Digital Marketing, Cyber Security also will be trained with hands-on practical classes. After the completion of training, the trainees will be sent for placement interviews in the top companies. Call 7504633633 to get more info and a free demo.

    ReplyDelete
  13. Hi, I read your whole blog. This is very nice. Good to know about the career in. Tableau Training & Certification Tableau Training for making their career in this field .

    ReplyDelete