Create a Microsoft SQL data provider
/visma-net-erp/help/integration/preparing-data-for-import-and-export-by-using-scenarios/create-a-microsoft-sql-data-provider
section
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.
2026-02-19T17:09:06+01:00
# 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.
For more information: [Data providers (SM206015)](/visma-net-erp/help/integration/integration-windows/data-providers-sm206015/).
You use the [Data providers (SM206015)](/visma-net-erp/help/integration/integration-windows/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.
1. Go to the [Data providers (SM206015)](/visma-net-erp/help/integration/integration-windows/data-providers-sm206015/) window.
1. 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.
1. **Data Type**: **MS SQL Provider**.
1. 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.
1. Specify the database name as the value of the **Database** parameter.
1. 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** ).
1. 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.
1. 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.
1. Repeat the previous step for all objects (SQL tables and views) that you want to import data to and export data from.
1. Click .
You have created a Microsoft SQL data provider that you can use in an import or export scenario.
Related pages
Concepts
Windows