To use DataHub (Scheduled Import and Export service), you must first define one or more repositories, called Sites. A Site is a repository outside of your Caspio account used by DataHub for importing or exporting data. It can be any of the following types:

  • A website accessed through HTTP or HTTPS.
  • An FTP server accessed through FTP, FTPS, SFTP protocols.
  • A remote server that offers secure copy through the SCP protocol.
  • A cloud drive service such as Amazon S3, Dropbox, Google Drive, Microsoft OneDrive, or Box.
  • One or more emails (for data export by email).

Note: DataHub is available as an advanced feature. Not all the repository types and protocols mentioned above are available in all Caspio plans. Go to the Caspio’s Pricing page to see if your plan includes this feature and which repository types are included.

Complete the following steps to create a Site:

  1. Click Tools on the Caspio menu bar and click Scheduled Tasks from the dropdown menu.

define_an_external_repository_11

  1. Click Sites on the Scheduled Tasks screen.
  2. Click New Site on the Sites screen.

datahub-repositories1

  1. On the New screen, select the repository you want to use from the Type dropdown and configure settings accordingly. Each repository type has different configuration settings.

For Dropbox, Google Drive, and OneDrive repositories, you must grant DataHub access to the cloud drive service. To do this, click Authorize to go to the login screen of the chosen service and enter your credentials.

Notes: 

  • Each Google Drive account can only be used in one Site in your account. The same Site can be used in many tasks.
  • Google Drive allows multiple folders to have the same name. We recommend that you use a unique folder for your Caspio data. Otherwise, it will be difficult to distinguish which folder is used for your import and export tasks.
  1. Click Test Connection to ensure that the repository is properly set up.
  2. Click Create. You can now use this Site to create Scheduled Import or Scheduled Export tasks.