Manual
Page 1 of 6
FROM 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
FROM SQL DB
Manual
Page 2 of 6
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 ......................................................................................................... 6
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
FROM SQL DB
1
Manual
Page 3 of 6
APP DOCUMENTATION
1.1 HOW IT WORKS
From SQL DB APP is an acquisition task that enables to import data from a relational database
to MANTRA, by specifying a SQL query to run on a specified source database.
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
FROM SQL DB
Page 4 of 6
1.2 INPUT DATA
This APP allows You to import data from a relational database to MANTRA, by specifying a SQL
query.
You can see an example of input data in the following figure:
Figure 1 – an example of input data.
These input data enable to import all data contained in a MySQL Database and generated by the
following SQL query: “select * from tagFactorTweets;”.
To configure data to import, You must specify DB Host, DB Port, DB Type, DB Username, DB
Password, DB Name, DB Access (access type, “Native” for example), SQL Query.
1.3 OUTPUT DATA
This app gives data from a relational database based on a specified SQL query; therefore the
output fields depend on the SQL query You specify as input.
You can see output data by using a next APP or by the watcher.
If You use some APP as the Sentiment-Analysis next to the From SQL DB, You can see the
database fields imported as shown in the following figure:
Figure 2 – output fields becoming from a MySQL Database.
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
FROM SQL DB
1.4
Manual
Page 5 of 6
BASIC WORKFLOW EXAMPLE
From SQL DB APP need not a next app in the workflow, but if you want to use data extracted
you can create a simple flow as shown Figure 3 (doing sentiment analysis for example); You can
set input parameter and watch the results by the watcher button as shown in Figure 4:
Figure 3 - simple From SQL DB example
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
FROM SQL DB
2
Manual
Page 6 of 6
API DOCUMENTATION
For information about how to use From 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
