Kloudio's Dropbox integration allows users to easily create reports from Dropbox file data.
The following article will help you get started:
Step 1 : Go to Kloudio Dataflows and Click on Add a Flow button to create a New Data Flow.
Step 2: Select the appropriate Data Warehouse and Click on Next button.
Note: On selecting Use Kloudio's Data warehouse check box, Kloudio’s Default Data Warehouse gets selected.
Step 3: Select Dropbox from the Data Sources List.
Step 4: On Selecting the Data Source, Corresponding Popup window is displayed, Enter the following details:
Connection Name : Enter the appropriate name of the Connection
Schema Name : Enter the Desired Schema Name (Schema Name can only contain lowercase letters, numbers and underscores, and cannot begin with a number)
Table Name: Enter the appropriate Table Name
Frequency : Select the desired frequency for the sync to be initiated and Click on Continue button.
Click on the I Understand button to navigate to the authorization page.
Step 6: On Redirecting to Dropbox Dashboard Screen, Select the AUTHORIZE button and Authenticate with appropriate Credentials
Step 7: After Successful Dropbox Authorization Enter the required details and Click on SAVE and TEST Button. Now application is redirected to the Dashboard Screen and Finally Once all the connection tests are passed, again will be redirected to the Data Flow List Screen, where Sync Job status “Success” gets displayed on successful sync.
Step 8 : Once the Dropbox connection is created successfully, you will be able to create Reports using that Data Flows. To Create a New report, Go to Reports tab and click on New Report.
Once the Report Type window is displayed, click on the “Report Builder” option.
Step 9: Finally Select the above created connection, table, columns and Click on Preview Button to get the Data Preview of the Reports. Then Enter the Report name and click on Save button to save the reports.