Use this connection to communicate between a Couchbase® Server and Minitab Connect.
Set up a new connection
Complete the following steps to set up a connection in Minitab Connect.
- From the Home screen, select the Add button under Tables.
- In Datasets, enter Couchbase and select the connector from the results.
- Enter a Name that identifies the connection.
- Enter a Hostname for the connection. Then select Next.
- Enter the Username and
Password for the sever. Then 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 Couchbase and create a new table in Connect.
- From the Home screen, select the Add button under Tables.
- In Datasets, enter Couchbase and select the connector from the results.
- 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.
- On the left panel, enter a Name that identifies the table and select a Folder to save the table.
- From Bucket, select the bucket that contains the data.
- Enter a Scope and Collection. Connect assumes the default if you leave either of these fields empty.
- In Document, enter the exact key for a document. Connect uses this document to create the fields in the table. If you leave this blank, Connect uses the first document.
- 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.
- Open the Outputs tab of the Flow Tool
.
- Select the plus sign
beside
Export to add a new export. - Under Export, select New Export. If you select One Time Download, Connect downloads the file to your computer and does not create an export.
- Enter a Name for the export.
- 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.
- Under Delivery, select Connection.
- Under Connection, select the connection that you previously set up.
- Select the Bucket, Scope, Collection, and Key Field you want for the export. the The File Type must be CSV and the File Name must match a Couchbase document name.
Select Save to add the export to the list of exports in the Outputs tab. Select
Run
to run the export.
