Introduction

This form is to add, change and delete data warehouse definitions within Ajilius. A data warehouse definition is the set of metadata for the warehouse.

This is the most detailed form in the Ajilius application, and scrolls over several pages.

doc_warehouse_edit_01

Form Fields

Data Warehouse Details
Warehouse

Unique data warehouse identifier. Can only be entered while adding a new data warehouse definition.

Must begin with an alphabetic character, comprise letters and numbers only, and must be non-blank.

Description

Free text description of data warehouse, used in script headings, documentation, and other points of reference.

Must be non-blank.

Target

DBMS against which this data warehouse will be deployed.

Must be non-blank.

Data Warehouse Connection
Server

Domain name or IP address at which data warehouse access point is located.

An optional port number may be appended after a colon, eg:

192.168.0.1:1532
Database Name of database in which data warehouse is to be created. Must conform to target DBMS naming rules.
DW User

User as which Ajilius will connect to the data warehouse.

Note: The user must have the ability to create and delete database objects, and to execute bulk load features where available.

DW Password

Password for DW User.

May be left blank when integrated authentication is supported by the target DBMS.

Note that Ajilius encrypts all database credentials, including the data warehouse credentials, when stored in your metadata.

Extract Defaults
Extract User

Default user name under which source system extracts will be performed.

Many customers prefer to use one standard user name for data warehouse extracts, and give that user name read-only access to source databases.

If it is not possible to use the same name for each data source, individual user credentials may be entered for each source.

May be blank if data source credentials will be supplied.

Extract Password Password which enables the Extract User to access source systems.
Extract Streams

MPP data warehouse systems may support the parallel loading of multiple input files. This value represents the number of parallel extracts that will be created for this warehouse.

Refer to your DBMS data warehouse vendor for a recommended number of extract streams for your configuration.

Extract Directory

Where a target DBMS requires a separate extract and load for optimal performance, this value is the location where extract files will be written.

In extracts are required, and this value has been left blank, extracts will be created in one of the following directories:

c:\ajilius2\extracts\ (Windows)
/opt/ajilius2/extracts/ (Linux & OSX)
Log File

Location to which Ajilius log files will be written during ELT processes.

In multi-server environments, this should be a fully qualified UNC path so that all servers write to the same file.

If this field is left blank, logs will be written to the folder from which the script was initiated, or to the following file if run from the Ajilius application:

c:\ajilius2\bin\ajilius.log (Windows)
/opt/ajilius2/bin/ajilius.log (Linux & OSX)
Cloud Storage Container
Storage Account

Cloud storage might be used as the load source for your data warehouse. Redshift and Snowflake, for example, might load from AWS S3, while Azure SQL Data Warehouse may load from Azure Page Blob Storage.

This field represents the account name, equivalent to a user-id, for your storage account.

Storage Key If using cloud storage, this field is the account key, equivalent to a password, for your storage account.
Storage Region If your cloud storage supports multiple regions, and your data warehouse or storage container are in non-default locations, this field represents the region or location where the storage is located.
Storage Container The Storage Container is the bucket or store in which your data is held.

 Form Actions

The presence of the Add, Change, Delete and Connect buttons depends on the mode in which the form has been opened.

Add Add the details you have entered as a new data warehouse.
Change Save the details you have entered for this data warehouse.
Delete

Delete this data warehouse definition from Ajilius.

WARNING: This action permanently deletes the metadata for the data warehouse.

Connect Test the credentials you have entered for the data warehouse, displaying a message at the bottom left of the screen with the connection results.
Cancel Close this form and go back to the list from which it was opened.