Hopefully an easy question to answer. Our NetSuite...
# suiteqlb
BullgillRunner
01/27/2022, 4:53 PMHopefully an easy question to answer. Our NetSuite install has 100's of custom fields. We've not got Connect yet provisioned on our account, but will I be able to access all the custom fields using SuiteQL via an odbc connection ?
Thanks
j
jen
01/27/2022, 5:24 PMSuiteQL != ODBC
jen
01/27/2022, 5:24 PMschema a bit different etc
jen
01/27/2022, 5:25 PMbut yes, you should be able to access your custom fields in both
a
Alan Fitch
01/27/2022, 7:26 PMWith the netsuite2.com datasource I thought it's the same but only with SQL-92.
Alan Fitch
01/27/2022, 7:26 PMI've prototyped probably 50 queries in suiteql and ported them into the ODBC connector.
j
jen
01/27/2022, 7:34 PMoh I’m not sure. I’m using DBeaver. Tables are called different things.
a
Alan Fitch
01/27/2022, 7:36 PMIs
transactionlinetransaction_linesj
jen
01/27/2022, 7:37 PMyes
a
Alan Fitch
01/27/2022, 7:38 PMThis reddit thread talks about it.
Alan Fitch
01/27/2022, 7:40 PMBasically netsuite2.com is the new datasource and is pretty much SuiteQL with the added restriction of not being able to use Oracle SQL.
2 Views