SmartConnect can connect to FTP servers as both a data source and destination. Microsoft Azure allows BLOB storage to be consumed via an SFTP connection. This enables Popdock to read and write files stored in Azure Blobs and potentially Azure Data Lake Storage (ADLS), if stored in CSV format.
Azure Configuration
- Generate an SSH key pair.
- Create a Storage Account and Container.
- The steps are the same as this Article.
- In the Storage Account, navigate to Settings > SFTP.
- Click Enable SFTP.
- Click Add local user.
- Username – Enter a username that will be used for connection.
- SSH Key pair – Check this box to enable SSH authentication.
- Add key – Click this button to add the SSH key.
- Public key source – Select Use existing public key
- Key name or Public key – Paste the SSH key generated in step 1
- Key description – Friendly key description
- Click Next.
- Containers – select the container to store FTP files.
- Assign the permission All permissions to the container
- Home (landing) directory – set this to /<container> where <container> is your container from step 10.
- Click Add.
SmartConnect Configuration
- Open SmartConnect and create a new FTP Connector.
- Host Name – <storage account>.blob.core.windows.net where <storage account> is the one generated in step 2.
- Server Type – SFTP
- User Name – <storage account>.<username> where <storage account> is the one generated in step 2 and <username> is created on step 6.
- Password – Leave blank.
- Key File -Upload the private_key file generated in step 1.
- Click Validate.
Did this answer your question?