How to use the Data Exchange feature in Mail & Deploy?
| FIRST CREATED ON 31 May 2023 I AUTHOR Emma Camacho |
The
Data Exchange feature in Mail & Deploy allow the export of the
Execution Logs into a database that can then be loaded into a Qlik App:
If enabled, Mail & Deploy will write maintenance data (e.g. log files of executions etc.) into an SQLite database:
C:\Mail & Deploy folder\Data\Exchange\Database.s3db
It is necessary to install the 32Bit SQLite ODBC Driver or the 64Bit SQLite ODBC Driver in order to load it to a Qlik App.
The drivers are shipped here:
C:\Mail & Deploy
folder\Data\Exchange\sqliteodbc.exe
C:\Mail & Deploy folder\Data\Exchange\sqliteodbc_w64.exe
Or into a SQL Server database.
Enable the setting here:
Settings -> Data Exchange
Find attached, a small example App in this article.
Looking for Additional Guidance?
If you require more detailed information or further assistance, please visit our comprehensive Online Documentation. Our resources are designed to help you navigate all features and functionalities effectively.
Related Articles
What is Mail & Deploy's Heartbeat, and how does it function?
FIRST CREATED ON 10 Oct 2023 I AUTHOR Emma Camacho With Mail & Deploy's Heartbeat, you can regularly check the system's status and key components, such as data connections, tasks, and processes, to confirm they are functioning as expected. Use a ...After configuring Mail & Deploy to use Azure AD as a user directory, will new developers log in using their Azure AD password, or will they need a local Mail & Deploy login password?
When Mail & Deploy is configured to use Azure Active Directory (Azure AD) as a user directory, users, including developers and designers, will log in using their Azure AD credentials. There is no need to create or use a separate local Mail & Deploy ...How do I configure E-Mail Notifications in Mail & Deploy, when a Task in a Workspace fails?
FIRST CREATED ON 17 May 2023 I AUTHOR Emma Camacho Configuring E-Mail Notifications in Mail & Deploy for task failures ensures that you’re promptly informed of any issues in your workspace. Here’s a quick guide on setting up these notifications to ...How to insert a row in a Microsoft SQL Server table within a Mail & Deploy Task?
FIRST CREATED ON 19 Dec 2024 I AUTHOR Emma Camacho If a new row should be added to a table in a Microsoft SQL Server Database when running a Mail & Deploy Task, this can be achieve following the steps described below. Create a Microsoft SQL Server ...How to connect to a Snowflake Datasource in Mail & Deploy?
FIRST CREATED ON 21 Dec 2023 I AUTHOR Emma Camacho This image highlights the key fields needed to connect your Snowflake Datasource to Mail & Deploy. Looking for Additional Guidance? If you require more detailed information or further assistance, ...