Do you have an external database that you would like to connect to Lynx? Then you should read this article. This article will explain how to make this connection and how the data from the database can be used within Lynx.
Connecting the database
To connect an external database with Lynx, select the three bars in the top left, move to File and then press Setup. A pop-up will be shown, in which you can select the last tab on top: External Database (DB) Connection, see figure:
The next step is to add a new connection to a database. Add a new connection by pressing the '+'-sign which will give the following box:
Within this pop-up, you can change the Name of the connection and you have to add the Connection String in the second box.
Connection String
The input of the Connection String has a specific order to make it possible to connect to the database:
- Driver=
- Server=
- Database=
- UID=
- PWD=
We strongly recommend to use an account that is read-only, because the SQL-statements that are used could influence the data in the database when an account with writing rights is used.
An example for a string would be (in one line):
Driver={ODBC Driver 17 for SQL Server};Server=xxx:xxxxxxx.database.windows.net;Database=Lynx_Database;UID=a-dato.xxxxxx.database.windows.net;PWD=Welc0met0Lynx!
Use data from database
Unit of Measure - External Field
To use the data from the database, you have to add an extra field to the Unit of Measure-table. Give the field a name and select the Datatype External Field. Connect to the created Database and use a SQL-statement to extract the correct data from the database.
-- A little advise, we use the statement: Select top 10 * at the start to show only the best ten results from the filter. Otherwise, it will take some time for Lynx to show the database as a whole. --
Besides, as explained behind Query, we advise to use the: Like ? - statement to filter results that similar to the term that is searched for.
Custom Field
When the database bas been connected to a Unit of Measure, you can choose where you would like to use this data. For instance to a card, as is explained within this paragraph: Card Custom Field.
In short, as an example we will add this field to a project. Therefor, open Configure and select Custom Fields. As a standard, it opens Project Custom Fields. Add a new custom field, choose the name and connect that name to the correct Unit of Measure:
Comments
0 comments
Please sign in to leave a comment.