SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications.

The data in a View in Mammoth can be exported to the SQL Server database on a remote server.

  1. Open Data Preparation > Exports > SQL Server.

  2. Enter your database credentials - Host, Username, Password, Database, and the Table name.

  3. Check the checkbox “Keep at the end of the pipeline” to keep the export task at the end of your pipeline. Any task performed will be added to the Pipeline before the export task.

  4. Enable the checkbox “include hidden columns” if you want the hidden columns to be exported.

  5. Validate the credentials. Once it is validated, click on “Apply”.

    SQL Server credentials

A table with data from the View will be created in the remote database.

Note

  1. Except table name, the other requirements are mandatory. If table name is not provided, it will be auto-generated and visible in the notification corresponding to the action.

  2. If a table is present in the database with same name as table name mentioned in the export action, then the existing table would be deleted and a new table will get created with that name.

  3. Make sure you have the write access to the database.