本記事では CData サポート担当からこんなことを聞かれたらどこを確認すべきか?という観点で、よく頂くお問合せ内容をご紹介します。
記事はこちら →SQL Server databases are commonly used to store enterprise records. It is often necessary to move this data to other locations. The CData SSIS Task for Microsoft OneDrive allows you to easily transfer Microsoft OneDrive data. In this article you will export data from SQL Server to Microsoft OneDrive.
To get started, add a new ADO.NET Source control and a new Microsoft OneDrive Destination control to the data flow task.
Follow the steps below to specify properties required to connect to the SQL Server instance.
Follow the steps below to set required connection properties in the Connection Manager.
OneDrive uses the OAuth authentication standard. To authenticate using OAuth, you will need to create an app to obtain the OAuthClientId, OAuthClientSecret, and CallbackURL connection properties. See the OAuth section of the Help documentation for an authentication guide.
In the destination component Connection Manager, define mappings from the SQL Server source table into the Microsoft OneDrive destination table.
You can now run the project. After the SSIS Task has finished executing, data from your SQL table will be exported to the chosen table.