Access

You can extract the Access-specific data (.accdb) from the Gateway by defining specific settings.

To extract the specific settings for Access data:

1. Click Input Source drop-down list.

   You can choose either FileSystem or S3 Bucket from the list.

For FileSystem

• Input Path: Browse and select the correct format user input file. It must be of the Access format (.mdb or .accdb).

For S3 Bucket

• S3 Credential Details: See Accessing an AWS S3 Bucket for more information.

  

• Download: Click this button to validate the AWS Credentials and download the specified file from the S3 bucket to the input location of the Project folder. File System Details will be filled with the downloaded location and file details.

Source Structure: Define the following elements of the Source data structure:

• IsPasswordProtected: Select this box only if the file has got a password protection to it.

• Enter Password: Type the password for that particular file. When you save the settings, the password gets encrypted and stored in the configuration file.

  Note: Because the encrypted password is associated with the local machine where the Gateway is running, other machines cannot use the configuration file directly. You will have to re-encrypt the password before using the configuration created in another machine. You can obtain an encrypted password using the encryption utility.

• Connect: Click this to establish a connection between the Gateway and from the location where the tables will be extracted from the source file. After this connection, the Select Table drop-down box is filled with the sheet name and Import Schema box gets populated. If that input is a new one and is not saved in configuration file then by default the first table will be displayed. Otherwise, it populates the last selected table.

• Select Table: Select the table that gets populated in the Select Table box. Click Import Schema to fetch the list of rows in that table. These rows are displayed in Column Filter box, which you can select to generate a query.

• Column Filter: Specify the column names and provides the filter to select particular column data for processing. Click Select to select all the columns.

• Query Generator: Type the query in this box.

  • Generate Query: Click this box to generate the query to fetch the data. Query is based on your selection criteria.

    • Edit Query: Click this box to edit the query.

• Incremental Scan Section

  • Required: If you select this option, the Gateway keeps track of the last scan date by storing it in a configuration file of the extractor in the same location where Project.xml exists. When the Gateway is used for the first time, then a text file is created. Next time onwards, it reads the text file and passes this date to the Gateway.

  • DateTime Column: Use this option to build the queries for a specific date-time.

  • Last Scanned On: Use this option to store the last scan date-time of the most recent scan. The particular last scan data is appended to the existing query and accordingly you can generate the query. By default, this field is automatically filled with the latest scan.

• Discard Settings: Click this button if you do not require the settings.

• Save Settings: Click this button to save the Extract Access settings options.