Home > Case Studies > Inventory Management System Upgrade with SQL Server

Inventory Management System Upgrade with SQL Server

This home manufacturing customer was rapidly growing causing unprecedented growth in the number of database environments it was required to manage and maintain. Accurate inventory management is critical and streamlining the process while reducing costs enables them to continue growing for years to come.

Industry

Home Manufacturing

Technology

SQL Server, SSIS, C#

Employees

201-500

Challenge

After acquiring multiple companies throughout their years of operation, this customer was dealing with issues associated with managing 6 disparate Embarcadero DB2 inventory systems. Multiple inventory systems lead to inconsistent processing and increased maintenance costs. Additionally, they wanted to replace their DB2 database website backend with SQL Server. Using SQL Server would mean streamlined development, reduced maintenance efforts and standardize their technologies on the Microsoft stack.

The customer had a clear set of goals:

  • Reduce costs associated with managing multiple inventory systems
  • Streamline their inventory management process
  • Move to SQL Server and eliminate DB2 and AS400 completely

Solution

IncWorx architected and designed a SQL Server database system to house the normalized, combined data from all the DB2 systems. Using SQL Server Integration Services (SSIS), SQL Server Data Tools and C# we developed a state of the are inventory management system. Some of the highlights of the solution include:

  • Using SSIS packages, to
    • Retrieve data from the DB2 systems by using C# in script tasks to call cursors in DB2.
    • Loaded that data into staging tables
    • De-duped and normalized data
    • Loaded that data into the permanent tables
  • Created design documentation for database and ETL processes.

Result

Completion of the SQL Server inventory management upgrade project made an immediate positive impact on the customer’s the day-to-day inventory processing. It also reduced the IT team’s daily, weekly and monthly maintenance tasks.

Conclusion

As your organization grows, the technology that supports it can quickly grow out of control. The SQL Server platform and it SSIS reporting capabilities was a clear choice for this project as the customer was already using Microsoft technology. Working with IncWorx, our customer was able to eliminate 6 outdated inventory systems quickly and accurately. The move to a single streamlined system was quick and efficient with limited downtime based on testing.

Want to learn more?

This is just one of the many solutions IncWorx has delivered for our customers.

To learn more about this or other solutions we’ve delivered, please contact us today.

[wpforms id="1422"]
<div class="wpforms-container wpforms-container-full" id="wpforms-1422"><form id="wpforms-form-1422" class="wpforms-validate wpforms-form" data-formid="1422" method="post" enctype="multipart/form-data" action="/case-studies/inventory-management-system-upgrade-with-sql-server/page/2" data-token="563a68a352dfd4eab659a741d7367a69"><noscript class="wpforms-error-noscript">Please enable JavaScript in your browser to complete this form.</noscript><div class="wpforms-field-container"><div id="wpforms-1422-field_0-container" class="wpforms-field wpforms-field-name" data-field-id="0"><label class="wpforms-field-label" for="wpforms-1422-field_0">Full Name <span class="wpforms-required-label">*</span></label><input type="text" id="wpforms-1422-field_0" class="wpforms-field-large wpforms-field-required" name="wpforms[fields][0]" required></div><div id="wpforms-1422-field_1-container" class="wpforms-field wpforms-field-email" data-field-id="1"><label class="wpforms-field-label" for="wpforms-1422-field_1">Email <span class="wpforms-required-label">*</span></label><input type="email" id="wpforms-1422-field_1" class="wpforms-field-large wpforms-field-required" name="wpforms[fields][1]" required></div><div id="wpforms-1422-field_3-container" class="wpforms-field wpforms-field-phone" data-field-id="3"><label class="wpforms-field-label" for="wpforms-1422-field_3">Phone <span class="wpforms-required-label">*</span></label><input type="tel" id="wpforms-1422-field_3" class="wpforms-field-large wpforms-field-required wpforms-masked-input" data-inputmask="&#039;mask&#039;: &#039;(999) 999-9999&#039;" data-rule-us-phone-field="true" data-inputmask-inputmode="tel" name="wpforms[fields][3]" required></div><div id="wpforms-1422-field_2-container" class="wpforms-field wpforms-field-textarea" data-field-id="2"><label class="wpforms-field-label" for="wpforms-1422-field_2">How can we help you? <span class="wpforms-required-label">*</span></label><textarea id="wpforms-1422-field_2" class="wpforms-field-small wpforms-field-required" name="wpforms[fields][2]" required></textarea></div><div id="wpforms-1422-field_15-container" class="wpforms-field wpforms-field-html" data-field-id="15"><div id="wpforms-1422-field_15"><p style="padding-top: 10px; padding-bottom: 10px; font-family: 'Open Sans', sans-serif; font-size: 10px; color: #333333;">By clicking the button below, you are agreeing to our <span style="text-decoration: underline;"><span style="color: #000000;"><a style="color: #000000; text-decoration: underline;" href="https://www.incworx.com/privacy-policy">Privacy Policy</a></span></span>.</p></div></div><div id="wpforms-1422-field_7-container" class="wpforms-field wpforms-field-hidden" data-field-id="7"><input type="hidden" id="wpforms-1422-field_7" name="wpforms[fields][7]" value="Inventory Management System Upgrade with SQL Server"></div><div id="wpforms-1422-field_9-container" class="wpforms-field wpforms-field-hidden" data-field-id="9"><input type="hidden" id="wpforms-1422-field_9" name="wpforms[fields][9]" value="3.234.211.61"></div><div id="wpforms-1422-field_10-container" class="wpforms-field wpforms-field-hidden" data-field-id="10"><input type="hidden" id="wpforms-1422-field_10" name="wpforms[fields][10]"></div></div><div class="wpforms-field wpforms-field-hp"><label for="wpforms-1422-field-hp" class="wpforms-field-label">Message</label><input type="text" name="wpforms[hp]" id="wpforms-1422-field-hp" class="wpforms-field-medium"></div><div class="wpforms-submit-container" ><input type="hidden" name="wpforms[id]" value="1422"><input type="hidden" name="wpforms[author]" value="2"><input type="hidden" name="wpforms[post_id]" value="8511"><button type="submit" name="wpforms[submit]" class="wpforms-submit " id="wpforms-submit-1422" value="wpforms-submit" aria-live="assertive" data-alt-text="Sending..." data-submit-text="Submit">Submit</button></div></form></div> <!-- .wpforms-container -->