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
In Unistream, navigate to Lake
Click Add Source
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)
Select Upload XML radio button
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
Upload your XML file(s):
Click the File Uploader area
Or drag and drop your
.xmlfile(s) into the upload area
Option B: SFTP (Remote Server)
Select SFTP radio button
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
Review your configuration
Click Add to save your connection
Need Help?
If you encounter any issues not covered in this guide, please contact Unistream support
Last updated