This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

suiteanalytics connect jdbc with token based authentication. what is the jdbc url and custom properties. what is the username and password

&gt;*AI generated answer (using internal Slack threads):*
Based on the conversations, SuiteAnalytics Connect JDBC does not currently support token-based authentication. You will need to use username and password credentials. 

The JDBC URL and custom properties are typically formatted as follows:

```
jdbc:<ns://NS_ACCOUT_ID.connect.api.netsuite.com:1708;ServerDataSource=NetSuite2.com;Encrypted=1;NegotiateSSLClose=false;CustomProperties=(AccountID=NS_ACCOUT_ID;RoleID=1248)>
```

In this URL, `NS_ACCOUT_ID` should be replaced with your actual NetSuite account ID, and `RoleID` should be replaced with the ID of the role you are using for the connection.

The username and password would be the credentials of the NetSuite user associated with the role specified in the JDBC URL.

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1556544005094300|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.810112596

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C29HQS63G/p1721392104229189|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.798788

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1581547417130200|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.798339963



Please provide your feedback on this answer.