Hello, we are going live next month and I was playing around with the Netsuite ODBC Connection. I have the ODBC access and connected to MSSQL SERVER MANAGEMENT STUDIO(SSMS) through Linked Server. I know this a READ_ONLY permission but is there a way or extra module that I can use or buy to write data directly into Netsuite.
j
James Morris
01/09/2019, 5:08 PM
@KRISHNA No. On a shared instance (which all of them are, even if you have a "dedicated server") NetSuite will never give you access to the SQL backend. This could potentially allow you to get into other client's instances or completely break your own instance, so a big no-no in terms of security and support.
James Morris
01/09/2019, 5:11 PM
However if you're looking to do all sorts of fancy changes across multiple records, you still have lots of options: mass updates, workflows, and scripting. With a skilled developer, I'd be hard-pressed to find something that you absolutely couldn't do.
k
KRISHNA
01/09/2019, 5:12 PM
Thank you, Just curious I want to use the ODBC access and write my SQL Queries and connect to SSRS (Report Builder) for some complex reports. Do you think it is the best practice for doing complex reports or should I depend on Reports and Saved Searches from Netsuite.
j
James Morris
01/09/2019, 5:16 PM
For reporting ODBC should be able to dump out and or connect to other services as needed. Whether or not Reports and Saved Searches are sufficient is really dependent on what you're trying to do, and I couldn't tell you without a lot more background info. Also, they have a new reporting tool in beta that sort of combines those two and allows multi-level joins (the big limitation in saved searches/reports), so that's worth looking at as well.
k
KRISHNA
01/09/2019, 6:17 PM
Yeah I already played around with the Beta version of the workbooks. Kind of liked it but there are some requirements in my company which needs more grouping,calculations,expressions and other complex stuff. May be once they developed the full version might be helpful for all. Thank you for your time and immediate response.