Publish to Data Lakes & access your storage.
Data Lakes provide a cost-effective means to store structured and unstructured data. Popdock allows you to connect to your CSV’s stored in Microsoft Azure with an intuitive interface to access and work with the data.
With Popdock, you can:
With a couple clicks, you can connect to any Popdock datasource connectors and copy data as a CSV to your Azure Data Lake storage account. You’re able to move specific data sets, copy entire databases to Azure, and access attachments.
Learn more about Data Lake management.
Migrating to a new system requires a different strategy when it comes to giving your users insight to legacy data. While traditional integration moves your data from the old system to your new system is an option, it usually doesn’t make the most sense from a cost perspective.
Storing a copy of your legacy data in Azure and usingPopdock’s intuitive interface to work with the data without moving it to your new application solves a lot of data migration problems. From a cost perspective, you’re able to take advantage of Azure Data Lakes storage pricing, provide the insight your team needs, and deliver legacy data access affordably. Popdock allows you to save reports for your legacy data, combine your legacy data and new system data with custom reports, and even access attachments. Your users will love that they can access all their legacy data right in their new system.
With the Microsoft Azure Data Lake connector, you can access any data that is stored as a CSV in your storage account. Here are the steps to set up the Azure Data Lake connector to connect to your storage and container.
There actually isn’t connector-based pricing. The majority of available Popdock connectors are available with the purchase of every Popdock Plan. You can set up as many reports, connectors, and Popdock widgets as you’d like in all of the pricing plans. Premium Connectors, for example, Dynamics 365 Finance & Operations Connector is only available in the Premium Plan. Learn more about pricing here.
No. All the data lake management features (publish to and access data from data lakes) is included in the Popdock Business and Premium Plans.
Yes. Popdock takes files that are stored as BLOBs in a database, recreates them as files, and saves them to the Data Lake. That way, when your users need access to them, it’s a simple click to download.
For the step of publishing your data to the Data Lake,Popdock also gives you an option to split your files, which allows Popdock tocopy multiple “sets” simultaneously to the Data Lake. This makes it a faster process when you’re initially getting your data into Microsoft Azure storage.
The access of your CSV data from the Azure Data Lake connector is really efficient, so your users have a great experience working with the Azure Data Lake data from the interface of the Popdock app or via a Popdock widget using Virtual Integration.
It depends on how you set up the Popdock widget. If you’re looking for the Popdock widget data to inherit security from the source system, then, yes. If you’re using a service user for the source data, then your Salesforce users do not each need a dedicated Popdock user.
Using Popdock widgets, data from data lakes (Microsoft Azure, Amazon Web Services S3,and Wasabi) can be embedded as a web resource (or iFrame) or as a link in really any application that allows that. Popdock also has a code generator to provide portlets for Oracle NetSuiteand Salesforce Visulalforce pages.
Yes, the Export to Excel option can be turned on for any Popdock list and can also be made available within Popdock widgets. One Popdock app we highly recommend is the Popdock add-in for Microsoft Excel, which allows the end user to select any Popdock list favorite available to them to bring the data into Microsoft Excel.