|
|
FAQ about repSL |
|
|
|
| Online Technical Support |
|
|
|
Help Desk & Assistance |
|
|
|
Contacts |
|
|
|
Italiano |
|
|
|
|
|
Data Sources Access with repSL
repSL Engine can realize reports extracting data from the most common data sources used in the Business Intelligence world.
Once a connection to a data source is established, data gathering is obtained using SQL (Structured Query Language) commands or running server-side procedures.
|
Supported Data Sources
| |
Microsoft SQL Servers |
|
| SQL Servers can be accessed providing Host and Database names.
All objects defined into a DB (Tables, Views, Stored Procedures, System and User defined Functions and Types, ...) are available.
|
| |
|
| |
Microsoft Access Databases |
|
| |
Access Databases can be queried simply providing local/network path of .ACCDB, .ACCDE, .MDB or .MDE file.
Data can be retrieved executing queries defined into DB or via standard SQL commands.
|
| |
|
| |
Any Data Source providing ODBC |
|
| |
Engine can use any ODBC connection configured in the local host using its Data Source Name (DSN).
Virtually, any remote database providing this standard interface can be queried: Oracle, MySQL, PostgreSQL, dBase, Solid SQL, Paradox, FoxPro, ....
|
| |
|
| |
Text Files |
|
| |
Text files (CSV, TXT, TAB, DAT, ...) can be accessed providing local/network path, delimter char, numbers/dates format, ....
File can be viewed as a virtual database table and can be queried via standard SQL commands.
Also, files can be bulk-imported into the Engine, regardless any formatting.
Moreover, with the flexibility of the programming language, it's possible to realize complex parsing of text files. |
| |
|
| |
Microsoft Excel Files |
|
| |
A .XLSX or .XLS file can be accessed simply providing its local/network path.
Sheets can be viewed as virtual database tables and can be queried via standard SQL commands.
Also, Engine can retrieve data from any specified sheet, range or cell .
|
| INTEGRATION OF DIFFERENT SOURCES AND DIFFERENT DATA FORMATS |
 One of the main advantages of repSL Engine over other reporting tools is the capability of collect into a single report heterogeneous data extracted by different data sources.
You can build summary tables or charts where each element became to different database! |
| MORE ABOUT CONNECTIONS |
  Zoom Picture |
repSL Engine does not require any addictional or particular grant in accessing data sources; no change to database metadata or schema is required for reporting with repSL!
Connections can be opened both automatically by Engine, using the parameters specified in a script, and by users thanks to the interactive and customizable Dialogs available (view picture).
|
|
|
