XML

This guide provides step-by-step instructions for connecting XML files to Unistream.

Prerequisites

You will need:

• XML files (.xml format)

• For SFTP connection: SFTP server credentials

• Unistream platform credentials

---

Step 1: Prepare Your XML Files

Ensure your XML files are properly formatted with a clear structure.

1.1 XML File Structure

Your XML files should have a consistent structure with repeating elements that represent data records.

Step 2: Connect to Unistream

2.1 Add XML Source

1. In Unistream, navigate to Lake

2. Click Add Source

3. Select XML

2.2 Configure General Fields

Fill in the General Fields:

• Name: Enter a descriptive name for your connection (e.g., "Customer Data XML")

• Code: Enter a unique code identifier (e.g., "customers_xml")

2.3 Choose Connection Type

Select your preferred connection method:

Option A: Upload XML (Direct Upload)

1. Select Upload XML radio button

2. Choose Processing Type:

   • Each XML file as separate table: Creates one table per XML file

   • Union all XML files: Combines all XML files into a single table

3. Upload your XML file(s):

   • Click the File Uploader area

   • Or drag and drop your .xml file(s) into the upload area

Option B: SFTP (Remote Server)

1. Select SFTP radio button

2. Configure SFTP connection details:

   • Host: SFTP server address

   • Port: SFTP port (typically 22)

   • Username: SFTP username

   • Password: SFTP password

   • Remote Directory: Path to XML files on SFTP server

2.4 Processing Type Options

Each XML file as separate table

• Each uploaded XML file becomes its own table

• Best for: Different data types in different files

• Example: If you upload 3 files, you get 3 tables

Union all XML files

• All uploaded XML files are combined into a single table

• Best for: Same data structure across all files

• Example: If you upload 3 files with the same structure, you get 1 combined table

2.5 Test and Save

1. Review your configuration

2. Click Add to save your connection

Need Help?

If you encounter any issues not covered in this guide, please contact Unistream support