Manual
Page 1 of 7
TO SQL DB
Manual
ALTILIA S.r.l.
Sede opertiva: Piazza Vermicelli – 87036 Rende (CS), Italy
Sede legale: Via A. Volta, 41 – 87036 Rende (CS), Italy
Tel & Fax: +39 0984 494277
E-mail:
[email protected]
Web:
www.altilagroup.com
Used by permission. All rights reserved.
P. IVA e C. Fiscale: 10780921002 Reg. Imprese Cosenza
R.E.A. Cosenza n°209625 - Cap. Soc. versato € 17.395,56
14/05/2014
TO SQL DB
Manual
Page 2 of 7
TABLE OF CONTENTS
1
APP DOCUMENTATION ........................................................................................................ 3
1.1 HOW IT WORKS
3
1.2 Input data
4
1.3 Output data
4
1.4 Basic workflow example
5
2
API DOCUMENTATION ......................................................................................................... 7
ALTILIA S.r.l.
Sede operativa: Piazza Vermicelli – 87036 Rende (CS), Italy
Sede legale: Via A. Volta, 41 – 87036 Rende (CS), Italy
Tel & Fax: +39 0984 494277
E-mail:
[email protected]
Web:
www.altilagroup.com
Used by permission. All rights reserved.
P. IVA e C. Fiscale: 10780921002 Reg. Imprese Cosenza
R.E.A. Cosenza n°209625 - Cap. Soc. versato € 17.395,56
14/05/2014
TO SQL DB
1
Manual
Page 3 of 7
APP DOCUMENTATION
1.1 HOW IT WORKS
To SQL DB APP is an actuation task that enables to export data from MANTRA to a database
MySQL or MS Sql Server.
ALTILIA S.r.l.
Sede operativa: Piazza Vermicelli – 87036 Rende (CS), Italy
Sede legale: Via A. Volta, 41 – 87036 Rende (CS), Italy
Tel & Fax: +39 0984 494277
E-mail:
[email protected]
Web:
www.altilagroup.com
Used by permission. All rights reserved.
P. IVA e C. Fiscale: 10780921002 Reg. Imprese Cosenza
R.E.A. Cosenza n°209625 - Cap. Soc. versato € 17.395,56
14/05/2014
TO SQL DB
Manual
Page 4 of 7
1.2 INPUT DATA
This APP allows You to export MANTRA data becoming from the previous APP in a relational
database like MySQL or MS SQL Server.
You can see an example of input data in the following figure:
Figure 1 – an example of input data.
These input data enable to export all data contained in the previous APP in a MySQL Database,
for post elaborations to do outside the MANTRA platform (as input of a MANTRA Mashboard, for
example).
To configure data to export, You must specify DB Name, DB Type, DB Username, DB Password,
host, port, access type (“Native”), truncate Table (if you want to empty the output table before
export new data), output Table Name; finally You have to click the “Source Fields” text box, it
will appear the popup “Select parameters” through which you can select the fields you want to
export into the new table.
1.3 OUTPUT DATA
This app gives a table in a selected database containing MANTRA data based on the fields
selected as input.
You can see an example of output data in the following figure:
ALTILIA S.r.l.
Sede operativa: Piazza Vermicelli – 87036 Rende (CS), Italy
Sede legale: Via A. Volta, 41 – 87036 Rende (CS), Italy
Tel & Fax: +39 0984 494277
E-mail:
[email protected]
Web:
www.altilagroup.com
Used by permission. All rights reserved.
P. IVA e C. Fiscale: 10780921002 Reg. Imprese Cosenza
R.E.A. Cosenza n°209625 - Cap. Soc. versato € 17.395,56
14/05/2014
Manual
TO SQL DB
Page 5 of 7
Figure 2 – exporting output data in a MySQL Database.
In the example above the output data are exported from the previous APP in a MySQL Database,
for post elaborations (red strips hide some data for privacy reasons).
1.4
BASIC WORKFLOW EXAMPLE
To SQL DB APP needs an app before in the workflow, so you can create a simple flow as shown
in Figure 3; You can set input parameter and watch the results by the watcher button as shown
in Figure 4:
Figure 3 - simple To SQL DB example
ALTILIA S.r.l.
Sede operativa: Piazza Vermicelli – 87036 Rende (CS), Italy
Sede legale: Via A. Volta, 41 – 87036 Rende (CS), Italy
Tel & Fax: +39 0984 494277
E-mail:
[email protected]
Web:
www.altilagroup.com
Used by permission. All rights reserved.
P. IVA e C. Fiscale: 10780921002 Reg. Imprese Cosenza
R.E.A. Cosenza n°209625 - Cap. Soc. versato € 17.395,56
14/05/2014
TO SQL DB
Manual
Page 6 of 7
Figure 4 – the watcher
ALTILIA S.r.l.
Sede operativa: Piazza Vermicelli – 87036 Rende (CS), Italy
Sede legale: Via A. Volta, 41 – 87036 Rende (CS), Italy
Tel & Fax: +39 0984 494277
E-mail:
[email protected]
Web:
www.altilagroup.com
Used by permission. All rights reserved.
P. IVA e C. Fiscale: 10780921002 Reg. Imprese Cosenza
R.E.A. Cosenza n°209625 - Cap. Soc. versato € 17.395,56
14/05/2014
TO SQL DB
2
Manual
Page 7 of 7
API DOCUMENTATION
For information about how to use To SQL DB API in your application, send us a message to
[email protected].
ALTILIA S.r.l.
Sede operativa: Piazza Vermicelli – 87036 Rende (CS), Italy
Sede legale: Via A. Volta, 41 – 87036 Rende (CS), Italy
Tel & Fax: +39 0984 494277
E-mail:
[email protected]
Web:
www.altilagroup.com
Used by permission. All rights reserved.
P. IVA e C. Fiscale: 10780921002 Reg. Imprese Cosenza
R.E.A. Cosenza n°209625 - Cap. Soc. versato € 17.395,56
14/05/2014
