Create a Microsoft SQL data provider

You use the Data providers (SM206015) window to create a data provider that defines the structure of external data for Visma Net during data import or data export.
This procedure describes how to create a Microsoft SQL data provider that is used to transfer data between Visma Net and a table of a Microsoft SQL Server database.

1. Review the columns of the database table for which you need to create the data provider to identify the external data schema.
2. Go to the Data providers (SM206015) window.
3. Create a provider, and specify the following settings for it:
   1. Name: The name of the provider, which usually describes the data you will transfer by using this provider.
   2. Data Type: MS SQL Provider.
4. On the Parameters tab, do the following:
   1. As the value of the Server parameter, specify one of the following:
      • The name of the computer where the Microsoft SQL Server instance is installed if you use the default instance of Microsoft SQL Server.
      • The name of the computer and the name of the Microsoft SQL Server instance if you use a named instance.
   2. Specify the database name as the value of the Database parameter.
   3. Specify the login and password for accessing the SQL Server instance and the type of authentication that is used by the SQL Server instance (either SQL or Windows).
5. On the toolbar in the Source objects area of the Schema tab, click Fill schema objects.
   The system connects to the database, pulls the list of tables and views from it, and populates the Source objects tab with the schema objects that correspond to tables and views.
   If you don't see Fill schema objects in the toolbar, click , to display any buttons that do not fit on the toolbar.
6. Select the Active check box for the needed object. In the toolbar of the Source fields area, click Fill schema fields.
   The system displays the column headers available in the source database table. Make sure the Active check box is selected for all needed fields.
7. Repeat the previous step for all objects (SQL tables and views) that you want to import data to and export data from.
8. Click .

You have created a Microsoft SQL data provider that you can use in an import or export scenario.