Hi Can anyone please help me with pre requisite for ODBC connections
p
PNJ
12/29/2020, 9:58 AM
Is it available on your account? What are you trying to connect from? More info needed
h
Hozysam
12/29/2020, 1:01 PM
Hi @PNJ
Do we need an ODBC license from Netsuite to connect?
s
Suite Sensei
12/29/2020, 4:26 PM
If you're an admin you can check by going to: Setup > Company > View Billing Information.
The page will load, click on the Add-On Modules subtab and check to see if "SuiteAnalytics Connect" is enabled. If not, then the module would need to be purchased/licensed from NetSuite.
Suite Sensei
12/29/2020, 4:27 PM
Alternatively, if it is enabled you should also simply see a "Set Up SuiteAnalytics Connect" menu option in the Settings portlet on the Home dashboard. If that's not there (and you are using an administrator role) then it is not enabled.
h
Hozysam
12/29/2020, 4:42 PM
Thanks @Suite Sensei
Can I have any document link to read about SuiteAnalytics Connect
Does it also works on Sandbox or it will work only in production?
s
Suite Sensei
12/29/2020, 5:27 PM
You can use it in any environment. You will just use a different connection string for each environment. I typically use JDBC + SQuirreL (open source SQL Client).
You can start with SuiteAnswer 38970. It has links to everything you will need. If you have more specific questions you can ask here or DM me directly.
h
Hozysam
12/29/2020, 6:45 PM
@Suite Sensei Thanks a lot.
I will go through the document and will revert if stuck in between some where
Once again thanks for your help