1 Reply Latest reply on Sep 20, 2018 1:44 PM by Patrick A Van Der Hyde

    Connecting to SparkSQL using JDBC format for reading tables

    Jasim Ansari

      I would like to connect to Tableau using SparkSQL via JDBC driver. So far, I looked into forums for answers but I am still quite confused how to access it.

       

      Programmatically using Spark, I am able to work with my dataset as follows:

       

      spark.read.format("jdbc").option("url", "jdbc:oracle:tihn:@<HOST>:<PORT>:<DATABASE_NAME>").option("dbtable", "<some db name>").option("user", "<username>").option("password", "<password>").option("driver", "oracle.jdbc.driver.OracleDriver").load()

       

       

      What could be its equivalent to connect using Tableau?

       

      TIA
      Jasim