When possible, use a built-in connector in Streamline. We've connected a bunch of ERPs and inventory management systems already. But if there's no built-in connector created specifically for your ERP system, no worries, you can connect any database via the ODBC connection.
It can be an ERP database - most ERPs allow read‐only access to their databases, or it can be a separate database created specifically to store data needed by Streamline.
Connecting an ERP database in read-only mode is straightforward. Simply insert SQL queries into the Database connector tabs in Streamline and your data will be updated every time the user of Streamline clicks the Update Data button.
The only disadvantage of this approach is that you usually can't export ordering recommendations back to the same database. Users can only export recommended orders to a spreadsheet or text file.
Therefore it's sometimes difficult to decide whether you should simply insert SQL queries into Streamline and pull data directly from the ERP's database or, perhaps, create a new intermediate database instead. The intermediate database requires your IT team to arrange a 2-way data connection to the ERP using the tools and methods provided by the ERP vendor.
Use this check list to find out if an intermediate database is a must:
You can download SQL-scripts that create an intermediate database and find here an example of the gsl project file. This implementation example project includes scripts that work with the intermediate database.