Anyone using DBeaver here for SuiteAnalytics Conne...
# suiteql
s
Anyone using DBeaver here for SuiteAnalytics Connect? I’m trying to use it with TBA but it seems sending authentication request twice so 2nd one is failing with nonceUsed and I can’t use it basically.
@jen I remember you mentioned that you use DBeaver earlier. do you use TBA or user/password for authentication?
a
I recall having issue with DBeaver recently, when trying to connect via UN/PW. I think I just switched to a different app
s
I use SQuirreL SQL, but with user/pwd credentials. Is there a reason you need to use TBA with DBeaver? TBA seems great for an integrated Java application using the JDBC driver, where you can generate a new signature for every request. With a desktop application, unless it was built to handle that scenario, it will be a challenge.
s
I also reverted back to my old Squirrel SQL 🙂
no reason, I was testing some connectivity and faced with the issue. it looks like a bug that it sends authentication twice
s
While I like the DBeaver interface, it feels more polished, it definitely performs worse when connecting to databases with a large schema, compared to Squirrel. I try it out every so often, but mostly out of curiosity.
j
@Selcuk Dogru I’m using username/password.
I don’t use it much, just for taking a look at the underlying DB.
d
Came up against this a few months back and its how NS have designed it. I tried a few SQL tools and all with the same result as it tests the connection when you first enter the details ... then you can't use the same token again. We use it in a bespoke app and have to generate a new token on every call.
s
Any and all OAuth signatures are one time use by design, to prevent someone from packet sniffing and re-using your generated signatures. They can try, but will rightfully be denied access. AQny successful technique requires being able to generate a new, dynamic signature on demand each time
d
Yeah, this and coupled with removing admin access to v2. Your only option for full access is via the DWI account which uses TBA.
Such a PITA