JDBC Connection String

MySQL

"url" -> "jdbc:mysql://Host/DBName?user=UserName&password=UserPassword" "driver" -> "com.mysql.jdbc.Driver" "dbtable" -> "TableName"

MongoDB

sqlContext.read.format("com.mongodb.spark.sql") .options(Map("uri" -> "mongodb://Host/DBName", "collection" -> "TableName"))

Oracle

"url" -> "jdbc:oracle:thin:UserName/UserPassword@Host:Port:SIDName", "driver" -> "oracle.jdbc.driver.OracleDriver", "dbtable" -> "TableName")

Last updated

Was this helpful?