This "how-to-connect" documentation will explain the initial configuration of an example connection from Azure File Storage to a SharePoint Online document library in Office 365. We will be synchronizing data stored in Azure with SharePoint.
You can find more information in our Layer2 Cloud Connector User Documentation and you can download a free trial.
Step 1 - Configuring Azure File Storage
Go to your Azure account and open Storage accounts to create a new storage account. Note the name you gave to it.
Step 2 - copy URL and key
Open your created storage account and copy the URL.
Step 3 - map Azure File Storage to local computer
In your storage account, open the Connect tab. You should see the command line and PowerShell commands to map Azure File Storage to your local computer. Set the desired letter for your mapped driver and copy the commands. We used the command line version.
Open a command line and paste the command you copied. Execute it.
Step 5 - configuring Data Entity 1
We will now set up our Data Entities. Go to the data entity “Data Entity 1” to open the configuration settings.
Choose a Data Entity Title. It is recommended to give your entities meaningful names to maintain an overview when you decide to set up multiple connections.
Select the Data Provider for File System from the data provider list. You can search for File System by typing into the selection box.
For the Connection String, we need the in step 1 mentioned information. You can copy the below connection string and adjust it to match your gathered information.
Use the Verify Connection String option to evaluate if the provided connection string is valid.Select the Data Provider for File System from the data provider list. You can search for File System by typing into the selection box.
Enter the storage account key into the Password field.
- "Directory=path;" this property points to the URL we got in step 1.
- "Authentication=Windows;" this property defines which authentication method we are using.
- "User=AZURE\storageaccountname;" this property must be set to the Azure storage account name we created in step 1.
The Select Statement text box is used to define specific data queries. We do not need it here. Save your changes by using the right-hand pane option Save Changes.
Step 7 - running your connection of Azure and SharePoint
To run your connection switch back to the main connection configuration node and use the Run Now Button located on the bottom of the setup page. The Run Synchronization Toolbox will also display the synchronization process.
Here you can see a data preview of the information we have accessed in our source entity.