Introduction
This article guides you through connecting to the DropBox API in SSIS, enabling seamless integration and management of DropBox data using the Zappysys DropBox connector
Prerequisites
-
SSIS PowerPack: Download and install the ZappySys SSIS PowerPack from the Customer Download Area or trial version
-
Have a DropBox account: Ensure you have a DropBox account to access DropBox data.
Use Case
With simple steps, connect to the DropBox API using SSIS to read from and write to DropBox data locally.
Steps
Create/Select an App from the DropBox Developers Page
-
Log into your DropBox account.
-
Go to DropBox Developers and click the Create app button to create a new app.
-
Select the Scoped access option when prompted.
-
Choose Full Dropbox to access all files and folders or App folder to access specific folders’ files and folders.
-
Provide a name for your App and click Create App.
-
Under the Permission type section, click Scoped App to select application scopes.
-
Choose all Individual Scopes and Team Scopes if managing team data is necessary, then click Submit.
-
Navigate to the Settings tab, and copy the App key and App secret to Notepad.
Connect with DropBox Connector in SSIS:
-
Drag and drop a Data Flow task in your SSIS package.
-
Add a API Source component inside the Data Flow.
-
Create a new connection within the API Source, choose the Dropbox connector, and press Continue for the next step.
-
Fill in the connector fields, including Client ID, Client Secret, and Scopes (separated by spaces).
-
Generate the token and click OK to save the configuration.
- If the token isn’t automatically sent to the connector, cancel the connection, click yes, and copy the code from the browser Access Code Generated.
- Select a table/endpoint and preview the data.
Considerations
Save the credentials and scopes for easy access in the future.
Conclusion
Following these steps, you can seamlessly connect to DropBox within SSIS, leveraging the ZappySys tool for efficient data retrieval and integration. For assistance or inquiries, contact our support team via chat on our website or through email at support@zappysys.com.
References
For further information, refer to our DropBox connector article.