Once you have modeled your artifacts in the biGENIUS-X application, follow the development cycle outlined below to use them:
Generate the artifacts
After modeling your Project, you generate the artifacts.
Download the artifacts
When the artifacts are generated, you can download them.
It is also possible to push them to your git repository.
Details about artifacts for each generator are available in the section Artifacts.
Replace the placeholders
When the artifacts are generated, placeholders are used for all information related to your target environment (such as server name, user, password, key, database name, data lakehouse URL, etc.).
Example for a Microsoft SQL Server Generator:
USE [{sqlserverdimensionalandmart#stage#database_name}];
GO
CREATE TABLE [{sqlserverdimensionalandmart#stage#schema_name}].[STG_ST_CreditCard] (
[BG_LoadTimestamp] DATETIMEOFFSET NOT NULL
,[BG_SourceSystem] NVARCHAR(255) NULL
,[CreditCardID] INT NOT NULL
,[CardType] NVARCHAR(50) NOT NULL
,[CardNumber] NVARCHAR(25) NOT NULL
,[ExpMonth] TINYINT NOT NULL
,[ExpYear] SMALLINT NOT NULL
,[ModifiedDate] DATETIME NOT NULL
)
;
GO
The replacement_config.json generated file contains all the placeholders used in the generated artifacts:
{
"environments": [
{
"name": "DEV",
"projects": [
{
"name": "SQL Server Dimensional and Mart",
"variables": [
{
"name": "sqlserverdimensionalandmart#cleanse#server_name",
"value": "",
"secretname": ""
},
...........
{
"name": "sqlserverdimensionalandmart#stage#server_name",
"value": "",
"secretname": ""
},
{
"name": "sqlserverdimensionalandmart#stage#database_name",
"value": "",
"secretname": ""
},
{
"name": "sqlserverdimensionalandmart#stage#schema_name",
"value": "",
"secretname": ""
},
...........
]
},
...........
]
},
{
"name": "PROD",
...........
}
],
"secretprovider": {}
}
In this configuration file, you can specify the values to be used to replace the placeholders.
You can define multiple environments to set different values for development (DEV) and production (PROD) target environments.
Details about replacing placeholders for each generator are available in the section Replace Placeholders.
Deployment
Once your artifacts are ready after replacing the placeholders, you can deploy the target data solution to your target environment.
The documentation provides example configurations for each target technology in the Target solution environment section.
Details about deployment for each generator are available in the Deployment section.
Load data
After deploying your target data solution, it's time to load your data.
Details about load control are available in the section Load Control environment.
You can choose from several load control types to load your data, depending on your target technology: