Minitab Connect®  Support

MsSQL

Learn more about Minitab Connect
Use this connection to communicate between a Microsoft® SQL Server and Minitab Connect.

In This Topic

Set up a new connection

Complete the following steps to set up a connection in Minitab Connect.
  1. From the Home screen, select the Add button under Tables.
  2. In Datasets, enter MsSQL and select the connector from the results.
  3. Enter a Name that identifies the connection.
  4. Under Setup [1 of 5], select the data Gateway that you previously set up in Minitab Connect. If you have not set up a data gateway, select None.
  5. Enter a Hostname and Port number for the connection. Then select Next.
  6. Enter a Username and Password for your account. From Azure Service, select Yes if you use an Azure hosted server and you don't see your database on the next step.

    Then select Next.

  7. Enter the Database from which you want to pull data. If you selected a specific data gateway on the first setup page, you'll have to manually type the database. If you selected None, you can select the database from a drop down list. Then select Next.
  8. Select a database Schema. If you selected a specific data gateway on the first setup page, you'll have to manually type the schema. If you selected None, you can select the schema from a drop down list. If you do not want to select a schema, leave the box blank. Then select Next.
  9. Minitab Connect displays a message if the connection is successful or if there is an error with the connection. If the connection is successful, select Save .

After you save the connection, Connect displays options to import data into a new table. Start at step 4 of the following section for more information on importing data to create a table.

Create a table with data from a connection

Complete the following steps to import data from MsSQL and create a new table in Connect.
  1. From the Home screen, select the Add button under Tables.
  2. In Datasets, enter MsSQL and select the connector from the results.
  3. Under Connection, select the MsSQL connection that you previously set up. If you have not previously set up a connection, select New Connection and follow the steps in the previous section.
  4. On the left panel, enter a Name that identifies the table and select a Folder to save the table.
  5. Under Update Frequency, specify how often you want Connect to update the table. You can import the data one time or have Connect continuously import the data at a set time interval. Connect automatically creates a flow for your import. If you select Once, you can use the flow at a later time to automatically run the import again.
  6. Under Skip to SQL, select Yes so skip the import options and enter the SQL statement manually. Select No to use the Minitab Connect options to create the SQL statement.
  7. Under Type of Pull, select whether you want to pull a single table, multiple tables, or all tables.
  8. Select Next.
  9. Select the table or tables that you want to import. If you pulled multiple tables or all tables, select Save . If you pulled only a single table, select Next.
  10. Select the fields for the table Fields, that you want to pull. Then select Next.
  11. Select Add Filter and select the field you want to filter. Next, define the filter. Select an expression and a value. For example, suppose you want a list of the restaurants that begin with the letter "C". Use the expression, Facility Type, Begins With, C. Select the button on the last selection box to open the SQL dialog box for more complicated filters.
  12. Select Next. Connect displays the SQL statement. Select Save . If you go to the Prep Tool and select Run , Minitab Connect displays the imported data.
    Note

    If no data appears after you select Run, select Reset Config .

When you save the import, Connect creates a flow with the settings that you selected. For more information on how to schedule a flow and add more data processes to clean data, go to Overview of the Flow Tool .

Export a file

Complete the following steps to export data from a Minitab Connect table.
  1. Open the Outputs tab of the Flow Tool .
  2. Select the plus sign beside Export to add a new export.
  3. Under Export, select New Export. If you select One Time Download, Connect downloads the file to your computer and does not create an export.
  4. Enter a Name for the export.
  5. Under View, select a saved view of the table. If you select None, Connect exports all the data from the table. For more information on saved views, go to Example of creating a data view.
  6. Under Delivery, select Connection.
  7. Under Connection, select the MsSQL connection that you previously set up.

You can specify the file type and file name along with other options. Select Save to add the export to the list of exports in the Outputs tab. Select Run to run the export.

Copyright © 2024 Minitab, LLC. All rights Reserved.