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!
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.