Versions Compared

Old Version 3

changes.mady.by.user eric revollo

Saved on

compared with

New Version Current

changes.mady.by.user eric revollo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

After selecting the Create new Repository option, the Configure Metadata Database screen displays. 

Image RemovedImage Added

You can click Click Create Database & DSN to create the required database and connection or you can enter the required information if you already created them.

UI Expand
titleCreating a database and DSN with the wizard
  1. Click Create Database & DSN and enter the following required information:

    Data Source Name: The name for the ODBC data source (DSN) the wizard will create.

    Database Host Name: The hostname or IP of the PostgreSQL server.

    Database Server Port: The port number the PostgreSQL server listens to.

    User Name: Enter the PostgreSQL user that can connect to the server and can create and write databases.

    Password: Enter the password for the PostgreSQL user.

  2. Click Validate to verify all the information you entered works.
    Image Added
  3. After a successful validation, click Next Create Database & DSN to continue. 
  4. On the Configure Metadata Database screen, the Data Source Name field should be pre-populated with the new DSN that was created.newly created DSN.
  5. Enter the User Name and Password used when creatingthe metadata repository connection.
  6. Click Validate to verify all information you entered works.
    Image Added
  7. Click Next Click next to continue with the installation.

...

  1. The WhereScape Enablement Pack window displays. As the dialog explains, you can download the Enablement Pack from the Support portal and unzip the file to a local directory, click to select the directory that contains the unzipped Enablement Pack, once your configuration is complete, click Next to continue.
    Image RemovedImage Added
  2. The Configure Enablement Packs window displays a list of components that you can include or exclude in RED.
    Image Removed Image Added 
    All components are selected by default. Click the drop-down arrow to view a sub-menu of the items available under each component.

    Note
    titleNote
    The enablement pack components vary, depending on the type of database enabled.
    OptionDescription
    Database Function SetEnables you to select the RED database function set that will be installed with the enablement pack.
    Database function sets contain a list of functions and operators that are used for building transformations.
    Data Type Mappings SetEnables you to select the RED data type mapping set that will be installed with the enablement pack.
    Data type mapping sets contain a list of mappings that are used when loading tables into the data warehouse.
    Extended PropertiesEnables you to select the RED extended property definition set that will be installed with the enablement pack.
    Extended properties are used to facilitate connection to a specific database technology (e.g. Snowflake, Amazon Redshift, Microsoft Azure, etc.) and are also used in the script-based processing of all table objects in the database target.
    PowerShell ModulesEnables you to select the RED PowerShell modules that will be installed with the enablement pack.
    Data type mapping sets contain a list of mappings that are used when loading tables into the data warehouse.
    Python Modules
    TemplatesEnables you to select the RED templates that will be installed with the enablement pack.
    Templates are used in processing the data warehouse table objects. 
    ScriptsEnables you to select the RED scripts that will be installed with the enablement pack.
    Scripts are used in processing the data warehouse table objects. 
    ProceduresEnables you to select the RED procedures that will be installed with the enablement pack.
    Procedures are used in processing the data warehouse table objects. 
    UI Configurations
    Files Automatically ExecutedEnables you to select the RED files that will be installed with the enablement pack.
  3. In the Add Targets screen, configure the connection where your data warehouse will reside.
    Image Removed Image Added
    1. Add a Connection Name, which needs to be a unique name to identify your connection.
    2. Select the Data Source Name created with the ODBC admin tool.
    3. Add User Name and Password associated with your connection
    4. Add the location of the existing schemas for object storage, follow these steps to complete this section:
      1. When you click Add Location, the Target Storage Location populates automatically. Enables you to add and validate a schema in the specified target database. If the schema defined does not exist in the target database, it is created during the installation process. 
    5. For the Connection String, click Validate to populate or type in the token values for your connection
    6. After Validation, click Next.
  4. A new Add Targets screen displays, which allows you to add another target.
    Image Removed Image Added 
    After successfully adding your database target(s) and schema, click Next to continue.
  5. The Add ODBC Sources window displays, you can skip this step and add a source later on RED.
    Image Removed Image Added
    Type To add a source type in the required data source connection details:
    1. Add a name to your connection. Typically similar or derived from the ODBC Source Name (DSN) for quick identification.
    2. The ODBC data source name (DSN) for the data source connection. The OBDC Data Source Name must be defined in the Windows ODBC Data Source Administrator to appear in this drop-down field.
    3. Enter the login User Name and Password to connect to the data source.
    4. For the Connection String, click Validate to populate or type in the token values for your connection.
    5. After Validation, click Next.
    6. After the validation is completed, click Add to add several datasources, they are displayed in the right pane of the window. Click Next to continue.
  6. In the Summary window, you can review all the details about the Metadata Location, Repository Settings, and Enabled Database settings.
    Image Removed Image Added 
    Click Install to proceed with the installation.
    Note
    titleNote
    • Clicking Previous enables you to step back through the Setup Wizard screens and edit the setting you have currently defined.
    Once the installation is complete, a message is displayed to confirm that the installation was successful.
    Image RemovedImage Added
  7. Click Finish to launch RED and start working with your data warehouse.

    Note
    titleNote

    If the installation process is not successful, a message is displayed showing the error details. You can try to fix the problem using the error information and then click Retry to continue the installation.

...