Create the ERP Connector Database

Create the database

1. Create a new database named Ec_Vault on the SQL server of your choice. In this example, we'll use the current instance of the Autodesk Vault SQL server.

2. Create a user account ecuser mapped to the Ec_Vault database. We will use it later in the ERP Connector settings window to connect to the database.

3. Add the following user database role memberships for the Ec_Vault database: db_datareader, db_datawriter, db_owner.

Steps review

Using the Microsoft SQL Server Management Studio, we created a new database named Ec_Vault and assigned a user account to it. This database does not yet contain any tables (Data Interface) but is ready for the connection from the ERP Connector Vault add-in.