Configure the ABRA Interface
Before you can use the ABRA import or export utility, you must configure your Vision server to work with the Abra database.
This involves creating an ODBC System DSN on your Vision web/application server.
Pre-requisites: You must have Microsoft SQL Server connection credentials (SQL Server username and password) that are members of the db_owner role for the Abra SQL Server database in SQL Server Management Studio.
To create an ODBC System DSN on the Vision web/application server, complete the following steps:
- On your Vision web/application server, click to launch the ODBC Data Source Administrator (64-bit) tool.
- Click the System DSN tab.
- Click Add, and in the Create New Data Source dialog box, select SQL Server from the list.
- Click Finish.
- In the Create a New Data Source to SQL Server wizard dialog box, enter VisionABRA in the Name field.
- In the "Which SQL Server do you want to connect to?" Server field, enter in the name\instance of your SQL Server that is hosting your Abra database.
- Click Next.
- In the wizard dialog box that asks "How should SQL Server verify the authenticity of the login ID?" enter the correct credentials to connect to the Abra database server. These are the Microsoft SQL Server connection credentials (SQL Server username and password) that are members of the db_owner role for the Abra SQL Server database in SQL Server Management Studio. The credentials that you enter are used to confirm that you can make a connection between Vision and Abra. You will need to enter these credentials in Vision every time you perform an import or you schedule an import.
- Click Next.
- In the wizard dialog box with the Change the default database to check box at the top, accept the default entries, and click Next.
- In the wizard dialog box with the Change the language of SQL Server system messages to check box at the top, accept the default entries, and click Finish.
- On the ODBC Microsoft SQL Server Setup dialog box, click OK.