Skip to main content
Gainsight Inc.

Export to S3 from Bionic Rules

Bionic Rules allow you to export each task output data to Amazon S3 from the Gainsight Rules Engine. When using S3 Buckets, the job exports the data from the datasets. The destination of the data does not change, only the method of how the data is ingested. S3 is a place to store files - it is not a database.

For each task, Bionic Rules allow you to configure export. In Bionic Rules, select the Enable Export checkbox under the Export to S3 section at the Rule Setup screen.

Setup Rule_Export_to_S3.png

As an Admin, you can now export each task’s output to S3 buckets which can either be Gainsight Bucket or Custom Bucket with encryption and decryption capabilities. Perform the following steps to export the output to S3.

  1. Select Rule Setup > Export to S3 > Enable Export checkbox. The following screen appears.

Export to S3.gif

  1. Provide the required information in the fields available in this section:
    1. Export with the file name: Enter a name for the output file and select a value from the drop-down list. The output file of each task is stored with the provided name along with the pattern type that appends the selected value to the file name. The following is the output file naming convention:
  • None - fileName.csv
  • Rule Date - fileName-2017-10-10.csv
  • Execution Datetime - fileName-2017-10-10-21:15:57.csv

If you add slash in the File name, it creates the folder name as shown in the following image.

Export_to_S3_FileName.png

 Note: Avoid creating file names with leading spaces.

  1. To which S3 Connector you want to Export?
    1. Gainsight Bucket: Select the option Gainsight Bucket and select GainsightManaged from the dropdown list.

Export_to_S3_GainsightManaged.png

  1. Customer Bucket: You can export your task output data to any custom bucket. You should have the following credentials to export to your S3 bucket:
    • Bucket Access Path
    • Access key
    • Security Token

Select the option, Custom Bucket and enter your S3 bucket credentials. Following are the credentials of an S3 bucket, shown for your reference:

  • Bucket Access Path: export-gainsight-data
  • Access Key: DXYABAT5L76LDQCRS8GH
  • Security Token: kNUSlVSbcAcKPgpDCiSqNuORLss3KDWApWCpTQdH

Note: Credentials shown above are just for reference only. They are not the original credentials of any S3 bucket.

Export_to_S3_Custom Bucket.png

  1. Click VALIDATE S3 CREDENTIALS to verify the S3 credentials. You get the response message whether the credentials are valid or not.
  1. Do you want to do File Encryption?
    1. Select the checkbox.
    2. Select the Do you want to export if encryption fails? Checkbox.
    3. Select the Available Keys checkbox if you have the key details with you or you can contact Gainsight tech support to request for the key.
      Note: You can also select Custom key which is Pretty Good Privacy (PGP) Public key. PGP is an Encryption-Decryption program. Using Public key, the data is encrypted, then customers can decrypt only with private key.

Export to S3_PGP Encryption.gif

3. Select a compression type for the available key from the drop-down list.

Compression Type.png

4. How do you want to generate file? Select the required options from the drop-down lists for Field Separator, Text Qualifier, and Escape Character fields.

File properties.png

5. Click SAVE.

  • Was this article helpful?