File Integration with Link to SQL Database
I have a set of fields in a trigger file as part of a file integration. The value of these fields is printed on a label. I now want to add another field to this label which is not part of the trigger file. Instead it needs to be pulled from a table in a SQL Server database. Is this possible? I tried to join the integration file with the database in the database connection area but it does not work. Maybe I'm doing something else wrong. Any help would be appreciated.
I believe the procedure would need t o be something like this, Join the two files together in the label and then create the filter to carry out the SQL look up. The filter value would need to the new field you are adding to the end of your trigger file.
You would need to refrsh the connection to the label in the integration to pick up the changes in the label template0