Amazon S3

Orbit Connect provides a flexible method for importing data directly from Amazon S3 into your Apteco Orbit system.

Amazon S3 (Simple Storage Service) is a widely-used cloud storage service. Many businesses utilise it to store and transport data files. By facilitating data ingestion from S3, we offer a more adaptable solution for integrating data into your system, paving the way for more automated update processes.

Using S3 provides you with:

  • Flexibility to import data from cloud storage in addition to local files.

  • Ability to set up automated processes to regularly fetch updated data from S3.

  • Leverage existing AWS infrastructure and credentials.

Setting up your S3 data source

To set up Amazon S3 as a data source:

  1. In Orbit connect, click + New Data Source.

  2. Under Amazon S3, click Set Up.

  3. Enter a name for your new data source, then click Create.

  4. Set your AWS credentials:

    1. Click the Credential drop-down menu, then click + New Credential.

    2. Enter a name for the credential.

    3. Enter your AWS Access Key ID and Secret Access Key.

    4. Click Add.

  5. Enter the S3 file path URL for the data file you want to import in the File Path (URL) box.

  6. A preview of your data appears and is ready for you to import. Click Import to begin.

    Once imported successfully, a confirmation message appears.

  7. You can now choose to add another data source by clicking + New Data Source, or begin setting up a table definition with your data import by clicking + New Table Definition.

Setting a schedule for your S3 data source

Once you’ve created a data source, you can then set a schedule against any data sources that uses an S3 source (as opposed to a manual upload). Once established, the data source is updated according to the schedule that has been defined.

To schedule your S3 data source:

  1. In Orbit connect, go to the Data Sources screen.

  2. On your preferred schedule, click the option menu, then click Edit.

  3. Click Schedule.

  4. Use the Schedule Settings menu options to adjust your schedule:

    • Publish: Schedule your data source to update immediately or at a specific time.

    • Date & Time: Select the date and time to update.

    • Timezone: Select which time zone.

    • Every: Select the frequency you want to update your data source.

    • End: Choose whether you want to end the schedule at some point.

  5. Once you’ve applied your settings, you can Delete, Cancel, or Apply your schedule.