Ctrlk
For the complete documentation index, see llms.txt. This page is also available as Markdown.

SMB

File sharing ..

Workshop - SMB/CIFS

The Server Message Block (SMB) protocol is a network file sharing protocol that allows applications on a computer to read and write to files and to request services from server programs in a computer network. The SMB protocol can be used on top of its TCP/IP protocol or other network protocols

Objective of this workshop is to:

  • install & configure a basic Samba server.

  • share user home directories as well as provide read-write anonymous access to selected directory.

SMB Server

Create a new Transformation

Any one of these actions opens a new Transformation tab for you to begin designing your transformation.

  • By clicking File > New > Transformation

  • By using the CTRL-N hot key

x

x

  1. Select the OS:

x

Test SMB Server

Before we fire up Pentaho Data Integration, let's test:

  • SMB server is up and running

  • Can log into User - Bob & Alice - & Shared spaces.

Please ensure you have completed the following setup: SMB

  1. Log into your Docker Desktop to check that the SMB Docker container is up and running.

Check SMB container.

  1. Let's test SMB server ..

SMB Shared Folders

Let's check we have some sample data in our container/shared folder.

There's a couple of ways you could do this ..!

If you have an IDE Editor installed, you can install the Docker Container Extension, see Windows 11 Pentaho Lab.

  1. In the Docker Desktop UI click on the workshop-server-smb.

  1. Click on Files > scroll down to shared folder - expand to see mounted volumes.

Shared folders.

  1. Lets connect to a data source using SMB VFS in Pentaho Data Integration.

x

x

Pentaho Data Integration

Pentaho Data Integration utilizes Virtual File System (VFS) as the abstraction layer within the kernel to expose different filesystems.

In PDI, you can add a VFS connection and then reference that connection whenever you want to access files or folders on your Virtual File System.

  1. Select the following OS.

  1. Start Pentaho Data Integration.

Windows - PowerShell

x

x

  1. Start Pentaho Data Integration.

Linux

  1. Create a New Transformation.

  2. Drag & drop the Text file input step onto the canvas.

  3. Click on the 'View' tab.

  4. Highlight 'VFS Connections' and select 'New'.

  1. Configure with the following details:

  1. Click 'Test'.

Test connection

Transformation - SMB File Retrieval

Let's create a simple Transformation to onboard data via an SMB VFS connection.

  1. Create the following transformation:

tr_SMB_File_Retrieval

  1. Double-click on Text file input > File tab

  2. Click on Browse and ensure you select:

VFS Connections > SMB > Pentaho/design-tools/data-integration/samples/transformations/files/sales_data.csv

  1. Add the path.

  1. Click on Content tab & configure with the following settings:

Content

  1. Click on Fields tab & click on 'Get Fields'

Get Fields

  1. Preview the rows.

Preview rows

  1. Click OK.

Add the other steps to format / rename some fields, before output as a .txt in the same directory as your Transformation.

x

x

x

x

x

PreviousSMB
NextBig Data

Last updated

Was this helpful?