Minitab Connect®  Support

Oracle

Learn more about Minitab Connect

Use this connection to import and export data from Oracle Cloud applications.

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 Oracle and select the appropriate connector from the results.
  3. Under Connection Setup, enter the following:
    Name
    Identifies the connection.
    Gateway
    Select the data gateway that you previously set up in Minitab Connect. If you have not set up a data gateway, select None.
    Hostname
    Identifies the host server.
    Port
    The number for the connection.
    Service Name
    Identifies the connection.
  4. Select Next.
  5. Enter the Username and Password for the sever. Contact your IT department if you do not know the database username and password.
  6. Select Next. Connect communicates with the server to ensure that the credentials and directories are valid. 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 a file on a server and create a new table in Connect.
  1. From the Home screen, select the Add button under Tables.
  2. In Datasets, enter Oracle and select the appropriate connector from the results.
  3. Under Connection, select the 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 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.
  6. Under Type of Pull, select whether you want to pull a single table, multiple tables, or all tables.
  7. Select Next.
  8. Under Owner, select the owner of the tables to filter the available tables by owner. Then in Table/View, select the table to import. You can also enter text to further filter the results.
  9. 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 to a connection

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. From Export, select New Export to set up an export to a server. 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 Oracle 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 © 2025 Minitab, LLC. All rights Reserved.