Page Comparison

Once you establish a connection to the Amazon S3 storage service, you can proceed to configure the data source in Sigma Studio for transferring the files to the listed Amazon S3 cloud-based storage service. 

...

1. Right-click the created Amazon S3 connection and select the Create Data Source option.
   
   Refer Connectors - Amazon S3 for more information on creating an Amazon S3 connection.
   
   
   
   The Create New Data Source page appears.
   
   
   
   
2. Enter a unique data source name in the Data Source Name field, e.g. AMAZON S3 DS.
   
   
   
   

3. If you want to fetch a particular file from the S3 cloud-based storage service, specify the relevant file path and the accurate file name in the In the Bucket Name field, provide the bucket name present in the connected S3 storage service, e.g. barathbucket23456.
   

   Note
   The File Path and File Name are optional fields

   respectively

   .

   
   

   Note
   For transferring the files to the S3 cloud-based storage service, there is no need to specify the file path and the file name. Only to receive or fetch files from the S3 Currently, Sigma Studio supports only the transfer of files to the S3 bucket cloud-based storage service, you must specify the relevant file path and the accurate file name.

   Image Removed
   

   In the Bucket Name field, provide the bucket name present in the connected S3 storage service, e.g. barathbucket23456.
   

   Note

   The Local File Path and File Name are optional fields. Both the Local File Path and File Name fields are not required to create a FTP DS, with the Put File Request Type. It is sufficient only if you provide the appropriate server path in the Relative Path on Server field. You can receive files of following formats from the FTP server. For the transferring of files to the S3 cloud based storage service, the supported formats are listed as follows: CSV XLS PDF DOCX TXT HTML XML

   Image RemovedImage Added
   
   

4. Click Save to save the FTP S3 data source.
   

   Warning
   When you try to exit the Data Source screen, before saving the configured FTP S3 data source, a warning pop-up message appears, as shown in the following screen shot: Click Cancel, if you do not want to exit the Data Source screen. Click Ok, if you want to exit the Data Source screen.

   
   Image RemovedImage Added
   
   A success message for creating the data source appears as shown in the following screenshot:
   
   
   
   

   
   

5. Click Ok.

   Note

   In order to trigger the FTP service connection, the CT platform's server-side API, CT.ftp must be used while passing the ExecutionContext action in a Java Handler class. Refer the following sample code snippet for better understanding on the triggering process:

   Here, on the following sample code snippet a new ExecutionContext action is created within which a map (HashMap) is built. The FTP datasource ID is passed as the input to activate the connection request within which the CT.ftp API is passed to trigger the process.

   Code Block

   language	js

   ExecutionContext ec = new ExecutionContext(); Map inputParams1 = new HashMap(); inputParams1

   .

   put("DATA_SRC_ID","FTP_DS"); // FTP_DS refers to the Datasource ID. ec.setInitialRequestData(inputParams1); try { CT.ftp(ec); } catch(Exception e){ }

Client Customization

To customize a FTP an Amazon S3 data source for a specific corporate client or customer, perform the following steps in Sigma Studio:

1. Right-click the newly created FTP Amazon S3 data source (e.g. FTP_Amazon S3 DS) and select the Customize DS for Client option.
   Image Removed
   Image Added
   
   The Edit Datasource page appears.
   Image Removed
   Image Added
   
   

2.  Click the Client lookup field and select the Corporate Client or Customer of your choice, e.g. HIGHSCORE.

   Note
   The Parent Data Source Id and Connection Name are non-editable fields.  icon is used to export the FTP S3 data source in the SQL format, while  is used to delete the FTP S3 data source.

   
   Image RemovedImage Added
   
   

3.  Provide a unique data source name in the Data Source Name field, e.g. HIGHSCORE FTP S3 DS.
   
4. Select the Put File option in Request Type to send the requested file to the FTP server.
Provide the appropriate file path on the FTP server to which the files need to be transferred to the server in the Relative Path on Server field.
Image Added



5. In the Bucket Name field, provide the accurate bucket name, which exists in the S3 storage service, e.g. barathbucket23456. 

   Note
   The

   Local

   File Path and File Name are optional fields. Both the

   Local

   File Path and File Name fields are not required if you want to transfer files to

   create a FTP DS, with the Put File Request Type

   a specific bucket in the S3 storage service. It is sufficient only if you provide the

   appropriate server path

   relevant bucket name, specific to the selected corporate client or customer, in the

   Relative Path on Server field

   Bucket Name field.

   Image Removed

   Image Added
   
   

6. Click Save to save the customized FTP S3 data source for the selected HIGHSCORE client.
   Image Removed
   Image Added
   
   A confirmation message, indicating a successful save of the customized FTP S3 bucket data source, appears.
   
   
   
   
7. Click Ok.

8. Access the Information Report screen and configure the report with the relevant and appropriate configurations, as shown in the following screen shot:

   Note
   For detailed information on creating reports, refer Configuring Reports.

   
   Image RemovedImage Added
   
   

9. Click the Additional Info tab.
   Image Removed
   Image Added
   
   

10. Click the Publishers drop-down list and select the FTP option S3BUCKET option.

    Image RemovedImage Added
    
    

11. Click the S3BUCKET option to select the S3 data source.
    
    Image Added
    
    

12.  In the Select Publisher Data Source Id pop-up, click the Publisher Datasource lookup field and select the relevant FTP Parent S3 data source, e.g. FTPAMAZON_S3_DS. 

    Note

    For making use of the the customized S3 data source for a specific client, it is essential that the Parent FTP S3 data source for the customized client data source should be aptly selected. The customized client FTP S3 data source is HIGHSCORE FTP S3 DS, whereas the Parent Data Source Id is FTPAMAZON_S3_DS. So, it is essential that the FTPAMAZON_S3_DS Parent Data Source is selected in the Publisher Data Source lookup field, while configuring a report in Sigma Studio.

    
    Image RemovedImage Added
    
    

13. Once the report is configured with essential attributes, click Save to save the report.
    Image Removed
    Image Added 
    
    

14. Access the relevant report, e.g. HIGHSCORE REPORT ACCOUNTS in the Sigma Application and click Run to generate the report.

    Note
    For detailed information on generating the reports in Sigma Application, refer Generating a Report in Sigma. Once the report gets generated, the generated report can be found in the relevant server path, which was specified as the relative server path, while configuring the FTP data source in Sigma Studioon the specified bucket, present in the S3 cloud-based storage service.

     
    Image RemovedImage Added

    
    
    The HIGHSCORE REPORT XLS file ACCOUNTS report PDF file can be found in the provided FTP server path or the Relative Server Path bucket (e.g. /workfolder/files/)barathbucket23456) on the S3 cloud-based storage service, as shown in the following screen shot:
    
    Image Added
    
    On accessing the ACCOUNTS PDF file from the listed bucket (barathbucket23456) in the S3 storage service, you can view the additional details and properties of the transferred report PDF file, as shown in the following screen shot:
    Image Removed
    Image Added
    
    The fetched data of the HIGHSCORE REPORT displayed ACCOUNTS report is displayed in the XLS PDF file, as shown in the following screen shot:
    Image Removed
    Image Added