Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
How Many ODBC connections can my Netsuite server handle? How can I investigate this? Can I modify th
I run ETL jobs against Netsuite which serves as a CRM and ERP at my company. These ETL jobs connect via the read only JDBC/ODBC connection and pull data into a larger data ecosystem.
There are multiple ETL jobs that sometimes run concurrently. We also have about a hundred users that may log in and run ad hoc querys or updates at any point through out the day.
Our custom ETL jobs pulling from Netsuite currently come to a total of 3. We also leverage the data visualization tool, Domo. Domo may be running as many as a dozen different ETLs at various cadences in order to create Domo housed logic and visualizations. I don't right now have exact visibility on Domo... looking in to that. For the purpose of this discussion I'd like to assume that it may be competing for resources regarding the JDBC/ODBC connection and also running multiple jobs on an hourly cadence.