Initial JDBC Bridge catalog version. Hands-free JAR download. Auth Notes and SQL examples for ODBC apps. 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.
]]> IAM SigV4 for Neptune JDBC. SSL is required. Create IAM access keys in the console (same idea as a Stripe secret key), or rely on the default credential chain on an EC2 instance / role.

  1. Sign in to the IAM console.
  2. Create (or reuse) an IAM user or role with Neptune connect/query permissions. Do not use a personal employee login for unattended Linked Server or Power BI refresh.
  3. Open Security credentials and create an access key. Copy Access key ID into User name and Secret access key into Password. Alternatively leave them empty and use an instance profile / AWS_PROFILE.
  4. Set Service region to the cluster region (for example us-east-1). Keep enableSsl=true.
  5. Neptune has no public endpoint. After Finish, replace the host (e.g. MyHostName) (and SSH-tunnel port if you forwarded 8182 locally).
  6. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
  7. Done. You can query from C#, Python, PowerShell, and ODBC apps.
]]> Lists tables available to this connection. Use this in Power BI or a SQL Server Linked Server to confirm the catalog before building reports.

]]> Returns rows from country. Replace the identifier with your catalog object. Works in Excel, SSRS, and Crystal Reports.

]]> Returns matching rows from country. Swap the column and literal for your schema.

]]> Joins two tables on a key. Use in Azure Data Factory or SSIS when you need a combined extract.

]]> Counts rows per group. Typical Power BI import pattern before a visual.

]]> Keeps groups whose count is at least 10.

]]> = 10]]> Returns the first 100 rows ordered by a column. Useful for preview in Excel or Crystal Reports.

]]> Returns the number of rows in country.

]]> Maps a column to labels with CASE.

]]> Returns a column list instead of star. Prefer this in Linked Server views.

]]> Returns countries whose DESC label matches a literal. Swap the vertex label and property for your graph.

]]>