*** Please note, this article refers to the All-new Reporting and Analytics. View the FAQ for more details. ***
In this article, we'll show you how to export Power BI datasets to a connected SFTP site.
An SFTP data connection is an export of prebuilt Kallidus datasets to an SFTP location of your own. Once exported, you can extract and transform the data as needed before loading it into your external reporting tools.
A few things to know about SFTP connections:
- Only Users with permission to connect data will be able to create SFTP connections
- Each SFTP connection can export one or more datasets simultaneously
- Create as many SFTP connections as required
- You must have your own non-Kallidus SFTP location to successfully create a connection
- Dataset mapping schemas will help you establish the relationships between various dimension and fact tables
In this article, we'll cover steps to:
- Grant the Data Connector permission to a User
- Create an SFTP connection
- Review the delivery history of an SFTP connection
- Rerun a one-time SFTP connection
Steps to grant the Data Connector permission to a User
- Navigate to Manage users
- Search for the desired User
- Select Actions
- Select Edit:
- Scroll down to the Roles section
- Enable the Data connector permission. Note that this permission can be enabled independently of other reporting permissions. You don't have to enable the Reporting or Edit reports permissions for the User to successfully create data connections; however, you can enable them additionally if the User needs to view/edit reports:
Steps to create an SFTP connection
- Navigate to Reports
- Select Connect data
- Select New connection:
- Give the connection a name
- Add a description (optional):
- Select Next
- Select one or more datasets:
- Select Next
- Select an SFTP destination:
- Select Next
- Select a frequency:
- Select Save to complete the connection
Steps to review the delivery history for an SFTP connection
If you need to audit the delivery of your SFTP connections, or if you see an issue with any of your SFTP connections, you can easily review the delivery history. Here's how:
- Select Actions on any SFTP connection
- Select Delivery log:
- Find the relevant Timestamp and review the Status column:
Possible statuses are:
- Successful: All datasets were successfully generated and delivered to your SFTP location
- Failed: One or more datasets were not successfully generated, or all datasets were successfully generated but not successfully delivered to your SFTP location
- For "Failed" SFTP deliveries, click into the Status column to review the Data Connection Job ID. Provide this ID to our Support team and we'll help you troubleshoot.
Steps to rerun a one-time SFTP connection
For any one-time SFTP connections (those where the Schedule column shows "Now" or "Once"), you can rerun them at any time after their initial runs by selecting Actions and Run now:
Get deeper learning in The Academy
If you’re completely new to reporting and analytics, then Get started: Reporting and analytics with Power BI is the place to start. We'll start by introducing Power BI’s top five features, then, we’ll take a deep dive into each feature, with links to related learning and tips from the Kallidus team along the way.
If you're starting to explore user-created reports, take a look at Power BI Reporting: Deep dive previews. In this short course, you'll get a quick preview of each 'deep dive' scenario. If a scenario sparks your interest, follow the links in the Lesson description to view the full course.
Do you have a question about reporting? Come to our 'Ask me Anything' events in the Academy to ask questions and share feedback directly with the team.
Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.
Comments
0 comments
Please sign in to leave a comment.