Reference

Authentication None (no IAM)

Description

No description available [API reference]

Instructions

Amazon Neptune JDBC (SQL-Gremlin) from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools. Neptune is VPC-only. Use this Auth when IAM DB authentication is off, or when you already opened an SSH tunnel to port 8182.

  1. Confirm the cluster endpoint in the Neptune console (not a public hostname). Default port is 8182.
  2. From outside the VPC, open an SSH tunnel through a bastion in the same VPC, or run JDBC Bridge on an EC2 host that can reach the cluster.
  3. Enable SSL on the cluster. After Finish, replace the host (e.g. MyHostName) on the DSN Main UI. Keep authScheme=None for this profile.
  4. Prefer SQL-Gremlin (jdbc:neptune:sqlgremlin://) for Power BI and other ODBC tools. Gremlin / openCypher / SPARQL URLs are for graph-native clients.
  5. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
  6. Done. You can query from C#, Python, PowerShell, and ODBC apps.

Parameters

Parameter Required Default value Options
Name: DriverFilePaths

Label: JDBC driver file(s)

Filled by the wizard after download. Separate multiple JARs with a semicolon (e.g. C:\ZappySys\Jdbc\MyConnector\driver.jar). 		YES C:\ZappySys\Jdbc\Amazon Neptune\amazon-neptune-jdbc-driver-3.0.3-all.jar
Name: HostName

Label: Host

JDBC host name or IP (e.g. MyHostName). 		YES MyHostName
Name: Port

Label: TCP port

JDBC port (e.g. 8182). 		YES 8182
Name: DriverClass

Label: Driver class

Optional. Leave blank to auto-detect from the JAR unless SPI is ambiguous (e.g. software.amazon.neptune.jdbc.NeptuneDriver). 		software.amazon.neptune.jdbc.NeptuneDriver
Name: EnableSsl

Label: Enable SSL

Enable TLS for this JDBC URL (e.g. Yes from the dropdown). 		true
Name Value
Notset
Yes true
No false
Name: UserName

Label: User name

Database user. Leave empty if the server allows anonymous JDBC.
Name: Password

Label: Password

Database password. Leave empty if no password is required.