Microsoft 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.

Microsoft maintains at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

Connecting to the Database

Mammoth allows you to connect to your SQL Server Database and get the data into Mammoth.

  1. Select API & Databases from the ‘Add Data’ menu and click on SQL Server .

  2. Create a new connection and add your database credentials - Host URL, Port, Username, Password.

    MSSQL connection

    Fig. 68 Logging into SQL server

  3. Once the connection is established, you will be presented with a list of tables and views in that database.

    • Select the desired table to get a preview.

    • Write a SQL query or run a test query and preview the result.

    • Click on Next

After you have selected the table you want to work on, you get options to schedule data imports as discussed in the next section.

Scheduling your Data Pulls

You can start retrieving the data now or at a specific time. Further schedule the data imports to get the latest data from your Database at a certain time interval - every few minutes, daily, weekly or monthly.

On every data pull from your Database, you also have an option to either replace the older data or combine with older data.

On choosing Combine with older data option, you will get an option to choose a unique sequence column. Using this column, on refresh, Mammoth will pick up all the rows that have greater value in this column than the previous data pull.

Note

  1. If you have used Stored Procedure in your query, you would not be able to use the Combine mode for data batches on the schedule screen. The combine mode is supported only for select queries.

  2. Make sure that Mammoth’s public IP address is added to your whitelist.

  3. Mammoth’s public IP is displayed on the create connection window.