Microsoft SQL Server - Placeholder values

Please consult the article Replace the placeholders in the Artifacts to learn how to replace the placeholders with the values explained below.

Placeholder values

Depending on the Generator Configuration you are using for a Microsoft SQL Server Target Technology, you can replace the placeholder values with the following:

server_name

The placeholder values for server_name must be empty, except your data solution architecture is deployed on several servers, and you are using Linked Server to allow communication between them. In this case, the Linked Server name must be filled in the server_name placeholder.

If you are using the Microsoft SQL Server Stage Open Query Target Environment, it should contain the Linked Server name.

In our example, it is ORACLE_19_DOCKER.

database_name

Contains the target Microsoft SQL Server database name.

If you are using the Microsoft SQL Server Stage Open Query Target Environment, it should contain the Linked Server name.

In our example, it is ORACLE_19_DOCKER.

schema_name

Contains the target Microsoft SQL Server schema name.

source_directory

If you are using the Microsoft SQL Server Stage File Target Environment, the source_directory must contain the local path to the folder Source

In our example, the value is: C:\\TEMP\\biGENIUS-X\\Ressources\\Source\\

format_directory

If you are using the Microsoft SQL Server Stage File Target Environment, the format_directory must contain the local path to the folder Format

In our example, the value is: C:\\TEMP\\biGENIUS-X\\Ressources\\Format\\

archive_directory

If you are using the Microsoft SQL Server Stage File Target Environment, the archive_directory must contain the local path to the folder Archive

In our example, the value is: C:\\TEMP\\biGENIUS-X\\Ressources\\Archive\\

error_directory

If you are using the Microsoft SQL Server Stage File Target Environment, the error_directory must contain the local path to the folder Error

In our example, the value is: C:\\TEMP\\biGENIUS-X\\Ressources\\Error\\

As the path contains \, you should escape them with another \.

For example, your path is: "C:\TEMP\biGENIUS-X\Ressources\Source\"

In the placeholder's value, you should put "C:\\TEMP\\biGENIUS-X\\Ressources\\Source\\"

DON'T USE PATHS ON CLOUD SPACES AS ONE DRIVE, DROPBOX...

Integrated security inside them stops Microsoft SQL Server from loading a file.

You can download a replacement_config.json example here for:

Microsoft SQL Server - Placeholder values - 1.7