SQL Server Reader - Haufe-Lexware/haufe.no-frills-transformation GitHub Wiki
In order to read data from an SQL Server database, use the following source definition:
<Source config="[configuration]">sqlserver://[SQL query]</Source>Any SQL query which is supported by SQL Server can be passed into the SQL Query parameter. All resulting fields will be interpreted as strings.
For the configuration, there are two possibilities:
- Using a connection string directly
- Using a connection string which is located in a text file
Pass the connection string directly into the configuration of the source tag:
<Source config="Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;">sqlserver://select * from MyTable where wage > 1000</Source>Parameters can be used inside the connection string, if needed.
Please note the use the substitution of the greater (>, >) operator in the SQL query (needed for XML compliance).
In order to read the connection string from a file, use the following syntax (using the @ character):
<Source config="@sqlserver_connection.txt">oracle://select * from MyTable where wage > 1000</Source>Sample content of the sqlserver_connection.txt file, also using a parameter (§env§):
Server=§env§;Database=myDataBase-§env§;User Id=myUsername;Password=myPassword;