Schedule Export Reports with DataNow

Description: Use this guide to create and manage daily export schedules in DataNow. You can send exports to destinations like email, Amazon S3, or SFTP at a time you define.

Schedule Exports

You can schedule exports directly from each export tab in DataNow. To set up a schedule:

1. Select the tab where you want to schedule an export.
2. Confirm the appropriate time zone in the top-right corner.
3. Select the three-dot icon in the top-right corner, then select Schedule Delivery.
4. Choose the delivery method:
   • Amazon S3 Bucket: Do not include leading or trailing slashes ("/") in the Bucket or Optional Path fields—this will cause an error.
   • SFTP: See SFTP schedules below for required IP addresses.
   • Email: Enter email addresses and press Tab after each one.
5. Set the export format to CSV.
6. Select the desired time of day for delivery.
7. Set filters to include data updated in the last 24 hours.
8. Repeat the above steps for each export tab as needed.
   

Important: Do not schedule exports to run hourly or by the minute. For near real-time data, a Kinesis data stream is available—contact your account manager for setup.

Manage existing exports

To modify an existing export:

1. Return to the export tab.
2. Select the three-dot icon > Schedule Delivery.
3. Edit your settings as needed.

SFTP schedules

Add the following IP addresses to your SFTP server allow list:

34.200.121.56
3.83.72.41
54.197.142.238

The host key algorithms supported by SFTP deliveries are as follows:

• ssh-ed25519-cert-v01@openssh.com
• ssh-ed25519
• ecdsa-sha2-nistp521-cert-v01@openssh.com
• ecdsa-sha2-nistp384-cert-v01@openssh.com
• ecdsa-sha2-nistp256-cert-v01@openssh.com
• ecdsa-sha2-nistp521
• ecdsa-sha2-nistp384
• ecdsa-sha2-nistp256
• ssh-rsa-cert-v01@openssh.com
• ssh-rsa-cert-v00@openssh.com
• ssh-rsa
• rsa-sha2-256
• rsa-sha2-512

The encryption algorithms (ciphers) supported by SFTP deliveries are as follows:

• aes256-ctr
• aes192-ctr
• aes128-ctr
• aes256-gcm@openssh.com
• aes128-gcm@openssh.com

The message authentication code algorithms supported by SFTP deliveries are as follows::

• hmac-sha2-512-etm@openssh.com
• hmac-sha2-256-etm@openssh.com
• hmac-sha2-512
• hmac-sha2-256
• hmac-sha1

Amazon S3 Bucket Permissions

With KMS encryption:

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Action": [
        "s3:PutObject",
        "s3:PutObjectAcl",
        "s3:List*"
      ],
      "Resource": [
        "arn:aws:s3:::<BUCKET NAME>",
        "arn:aws:s3:::<BUCKET NAME>/*"
      ],
      "Effect": "Allow"
    },
    {
      "Action": [
        "kms:Encrypt",
        "kms:Decrypt",
        "kms:ReEncrypt*",
        "kms:GenerateDataKey*",
        "kms:DescribeKey"
      ],
      "Resource": [
        "arn:aws:kms:<REGION>:<ACCOUNT-ID>:key/<KEY-UUID>"
      ],
      "Effect": "Allow"
    }
  ]
}

Without KMS encryption:

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Action": [
        "s3:PutObject",
        "s3:PutObjectAcl",
        "s3:List*"
      ],
      "Resource": [
        "arn:aws:s3:::<BUCKET NAME>",
        "arn:aws:s3:::<BUCKET NAME>/*"
      ],
      "Effect": "Allow"
    }
  ]
}

Tips

• Exports include all data modified in the last 24 hours.
  • If an order is created today, it appears in the next export.
  • If that order is refunded two days later, it appears again in the export for that day.
• When scheduling exports, always confirm the correct time zone in Advanced Options.
• When entering email recipients, press Tab after each address to confirm.

Data resources

• Field definitions for exports
• Sample export data