Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:datasource [2018/09/20 14:28] admin ↷ Page déplacée de en:datasource à public:en:datasource |
en:datasource [2021/08/25 10:29] (current) |
||
|---|---|---|---|
| Line 54: | Line 54: | ||
| ===== - How to install the Zebrix Connector ? ===== | ===== - How to install the Zebrix Connector ? ===== | ||
| - | Start the setup {{:zebrix_connector_setup_1.jpg?nolink|}}. | + | Start the setup {{public_media:zebrix_connector_setup_1.jpg?nolink|}}. |
| Please follow instructions: | Please follow instructions: | ||
| * Start of the installation - click next | * Start of the installation - click next | ||
| - | {{:zebrix_connector_setup_2.jpg?nolink|}} | + | {{public_media:zebrix_connector_setup_2.jpg?nolink|}} |
| * At this step you can choose to add a shortcut on your desktop | * At this step you can choose to add a shortcut on your desktop | ||
| - | {{:zebrix_connector_setup_3.jpg?nolink|}} | + | {{public_media:zebrix_connector_setup_3.jpg?nolink|}} |
| * Click on install and it's done ! | * Click on install and it's done ! | ||
| - | {{:zebrix_connector_setup_4.jpg?nolink|}} | + | {{public_media:zebrix_connector_setup_4.jpg?nolink|}} |
| Folder "ZebrixConnector" will be created in the root of C: with all relevant files to the execution of software. | Folder "ZebrixConnector" will be created in the root of C: with all relevant files to the execution of software. | ||
| You can verify that the Windows service "Zebrix Connector" is present among the other services : | You can verify that the Windows service "Zebrix Connector" is present among the other services : | ||
| - | {{:zebrix_connector_-_service_windows.jpg?nolink|}} | + | {{public_media:zebrix_connector_-_service_windows.jpg?nolink|}} |
| Start> Run> services.msc | Start> Run> services.msc | ||
| Select the service "Zebrix Connector" and click Start at the top left to start the service. | Select the service "Zebrix Connector" and click Start at the top left to start the service. | ||
| - | To start the configurator click on this icon {{:zebrix_connector_-_executable.jpg?nolink&200|}} | + | To start the configurator click on this icon {{public_media:zebrix_connector_-_executable.jpg?nolink&200|}} |
| ===== - Zebrix Connector startguide ===== | ===== - Zebrix Connector startguide ===== | ||
| Line 83: | Line 83: | ||
| ==== - homescreen ==== | ==== - homescreen ==== | ||
| - | {{:zebrix_connector_-_accueil.jpg?nolink|}} | + | {{public_media:zebrix_connector_-_accueil.jpg?nolink|}} |
| Here you can see all Datalinks created with Zebrix Connector and information about them: | Here you can see all Datalinks created with Zebrix Connector and information about them: | ||
| Line 92: | Line 92: | ||
| Icons description: | Icons description: | ||
| - | * {{:zebrix_connector_-_btn_creation.jpg?nolink|}} To create a new DataLink | + | * {{public_media:zebrix_connector_-_btn_creation.jpg?nolink|}} To create a new DataLink |
| - | * {{:zebrix_connector_-_btn_modification.jpg?nolink|}} To edit an existing DataLink | + | * {{public_media:zebrix_connector_-_btn_modification.jpg?nolink|}} To edit an existing DataLink |
| - | * {{:zebrix_connector_-_btn_suppression.jpg?nolink|}} To delete a DataLink | + | * {{public_media:zebrix_connector_-_btn_suppression.jpg?nolink|}} To delete a DataLink |
| ==== - Steps for datalink creation ==== | ==== - Steps for datalink creation ==== | ||
| Line 103: | Line 103: | ||
| * First step: Specify the ODBC connection to the database and chose which table you want to get data from | * First step: Specify the ODBC connection to the database and chose which table you want to get data from | ||
| - | {{:zebrix_connector_-_creation_-_etape_01.jpg?nolink|}} | + | {{public_media:zebrix_connector_-_creation_-_etape_01.jpg?nolink|}} |
| * The connection is made via the ODBC driver previously created. | * The connection is made via the ODBC driver previously created. | ||
| Line 112: | Line 112: | ||
| * You can then choose the database and the table you want to use (screenshot below) | * You can then choose the database and the table you want to use (screenshot below) | ||
| - | {{:zebrix_connector_-_creation_-_etape_02.jpg?nolink|}} | + | {{public_media:zebrix_connector_-_creation_-_etape_02.jpg?nolink|}} |
| === - Filters === | === - Filters === | ||
| Line 121: | Line 121: | ||
| * You can see on the screen below the various filters that can be applied on our table | * You can see on the screen below the various filters that can be applied on our table | ||
| - | {{:zebrix_connector_-_creation_-_etape_03.jpg?nolink|}} | + | {{public_media:zebrix_connector_-_creation_-_etape_03.jpg?nolink|}} |
| * Different filters Check all / Uncheck all (just check / uncheck all) or so, we do not check that the relevant columns. | * Different filters Check all / Uncheck all (just check / uncheck all) or so, we do not check that the relevant columns. | ||
| Line 128: | Line 128: | ||
| * There are 3 advances filters: | * There are 3 advances filters: | ||
| * Allows a given column select a range of values (between 1 and 3 in the following example) | * Allows a given column select a range of values (between 1 and 3 in the following example) | ||
| - | {{:zebrix_connector_-_filter_between.jpg?nolink|}} | + | {{public_media:zebrix_connector_-_filter_between.jpg?nolink|}} |
| * Allow to filter by a value comparaison (>, <, =, <=, >= ) on a given column | * Allow to filter by a value comparaison (>, <, =, <=, >= ) on a given column | ||
| - | {{:zebrix_connector_-_filter_comparator.jpg?nolink|}} | + | {{public_media:zebrix_connector_-_filter_comparator.jpg?nolink|}} |
| * Allow to replace a given value (in the column of your choice) by another. For example this feature will allow you to replace a "True / False" boolean value by another text string such as "Open / Close" or "Available / Not available" you can also replace a stock value "0" to the "Out of stock" text. Please note that this would of course not change the data in your source database. | * Allow to replace a given value (in the column of your choice) by another. For example this feature will allow you to replace a "True / False" boolean value by another text string such as "Open / Close" or "Available / Not available" you can also replace a stock value "0" to the "Out of stock" text. Please note that this would of course not change the data in your source database. | ||
| - | {{:zebrix_connector_-_filter_replace.jpg?nolink|}} | + | {{public_media:zebrix_connector_-_filter_replace.jpg?nolink|}} |
| * In the following example, the filters "between" and "select" has been set up. | * In the following example, the filters "between" and "select" has been set up. | ||
| We want the volumes that are between 1 and 3, and the name of the series is Tintin by displaying the first 5 columns. | We want the volumes that are between 1 and 3, and the name of the series is Tintin by displaying the first 5 columns. | ||
| - | {{:zebrix_connector_-_creation_-_etape_04.jpg?nolink|}} | + | {{public_media:zebrix_connector_-_creation_-_etape_04.jpg?nolink|}} |
| * Next, we want to use the french word "Faux" instead of False, so we set up a "replace" filter | * Next, we want to use the french word "Faux" instead of False, so we set up a "replace" filter | ||
| - | {{:zebrix_connector_-_creation_-_etape_05.jpg?nolink|}} | + | {{public_media:zebrix_connector_-_creation_-_etape_05.jpg?nolink|}} |
| === - Interval of the data update and save of the DataLink === | === - Interval of the data update and save of the DataLink === | ||
| Line 154: | Line 154: | ||
| Warning, the datalink name must be unique. | Warning, the datalink name must be unique. | ||
| - | {{:zebrix_connector_-_creation_-_etape_06.jpg?nolink|}} | + | {{public_media:zebrix_connector_-_creation_-_etape_06.jpg?nolink|}} |
| * Then you just have to confirm. If you see the confirmation message it means that the first synchronisation is done (if you have an error it might mean that your client name, username, password could be wrong) | * Then you just have to confirm. If you see the confirmation message it means that the first synchronisation is done (if you have an error it might mean that your client name, username, password could be wrong) | ||
| - | {{:zebrix_connector_-_creation_-_etape_07.jpg?nolink|}} | + | {{public_media:zebrix_connector_-_creation_-_etape_07.jpg?nolink|}} |
| * The datalink has been added. You can created as many datalink you want. | * The datalink has been added. You can created as many datalink you want. | ||
| - | {{:zebrix_connector_-_creation_-_etape_08.jpg?nolink|}} | + | {{public_media:zebrix_connector_-_creation_-_etape_08.jpg?nolink|}} |
| ==== - Edition of an existing DataLink ==== | ==== - Edition of an existing DataLink ==== | ||
| Line 169: | Line 169: | ||
| * for example you can modify filters, column selection, interval, etc. | * for example you can modify filters, column selection, interval, etc. | ||
| - | {{:zebrix_connector_-_creation_-_etape_05.jpg?nolink|}} | + | {{public_media:zebrix_connector_-_creation_-_etape_05.jpg?nolink|}} |
| Line 175: | Line 175: | ||
| - Create a new page | - Create a new page | ||
| - | - Add the datasources you want to use in the page {{ :fr_datasource_selection.jpg?nolink |}} {{ :fr_datasource_selectionlist.jpg?nolink |}} | + | - Add the datasources you want to use in the page {{ public_media:fr_datasource_selection.jpg?nolink |}} {{ public_media:fr_datasource_selectionlist.jpg?nolink |}} |
| - Add a new zone | - Add a new zone | ||
| - | - Specify that the zone is a "dynamic datasource" {{ ::fr_datasource_zonetype.jpg?nolink |}} | + | - Specify that the zone is a "dynamic datasource" {{ public_media:fr_datasource_zonetype.jpg?nolink |}} |
| - | - Specify which field you need to display {{ :fr_datasource_fieldselection.jpg?nolink |}} {{ :fr_datasource_fieldselection2.jpg?nolink |}} | + | - Specify which field you need to display {{ public_media:fr_datasource_fieldselection.jpg?nolink |}} {{ public_media:fr_datasource_fieldselection2.jpg?nolink |}} |
| - Data will automatically be updated in that zone after each synchronization. | - Data will automatically be updated in that zone after each synchronization. | ||
