Add Schedule Job – Google Drive Upload

You can automatically upload Reports and files to your Google Drive account.

• Open the Schedule and click the Add Job button.

• Add a Job description.

• Select a DBxtra Report Object.

DBxtra Queries and Reports can be sent as different file formats, select what you want to send in order to see the available formats.

Note! If a Report has an user-input Parameters , then when choosing it to be scheduled you’ll need to assign the Parameter.
The Report will be scheduled with the assigned Parameter.

• Optionally add a date to the file name.

• Optionally choose if to zip the file.

• Click Ok.

• Click Save.

Authorize your Google Drive account.

In order to be able to upload files to your Google Drive account, you must authorize your account first, for that, if you’re adding a new Google Drive job or editing an existing one, click on Settings and in the resulting window you will see the authorization status, the Google Drive folder you’re going to upload your files to and a Authorize button, click on Authorize and this will take you to Google Drive’s site to complete the authorization process.

First you need to sign in into your Google account.

Then you will see a prompt asking you to approve the access to your Google account the Schedule Server requires for it to work; the Schedule Server requires the following:

• See, edit, create and delete all of your Google Drive files: This is required for us to be able to upload files and verify whether the file already exists or not, also it allows us to see the folders you have in your account and create the needed folders for the file you’re going to upload.

If you’re ok with the permissions DBxtra asks, just click on Continue.

Once you do so, you will see the message: “Received verification code. You may now close this window.” and in the Schedule Server you will see the Status as Authorized and the Account of said authorization.