Connections
The sub-item Connections, inside the item Support, enables the maintenance of Connections with databases, Protheus-SX, and Protheus-Direto.
Creation of connections has two objectives:
| • | Import of table structure to the definition of Dimension attributes. |
| • | Import of data from different data sources. |
As connections can be used to import the structure of dimensions and/or cubes, sometimes creating connections before data warehouse implementation is useful. |
Each connection shows a different data source. Through these connections, data sources may be from different databases. Then, you can have a Customer dimension that comes from a Oracle base and a Sales dimension that comes from a DB2 base, for example.
There are three types of connections supported by SIGADW: TOTVS | DbAcess, Protheus-SX and Protheus-Direta. To create a new connection, access the menu Support and choose the type to be created from the submenu Connections.
By loading the connection page, click New.
TOTVS | DbAcess
Page: User Interface
It enables the access to databases that are accessed through TOTVS | DbAcess. The following data must be entered:
Name: enter a name for the connection.
Description: enter a description for the connection.
Server/Port: Enter the IP address or the name of the server where Top Connect is located.
If TOTVS | DbAcess default port is used (7890), you do not need to enter the port. Example: SRVERP. Otherwise, you must enter the port separated by the colon sign (:). Example: SRVERP:7899 |
Type of Connection: enter the type of connection to be used.
Type of Database: enter the database.
Alias: inform the alias created in TOTVS | DbAcess.
Protheus-SX
It enables the access to information about tables presented in the System data dictionary. It facilitates the process because either table names or field names are related to the dictionary. Therefore, it is the user-friendlier interface.
This connection is only used to import a structure, and not to import data. The following data must be entered:
Name: enter a name for the connection.
Description: enter a description for the connection.
Server/Port: enter the name of the system server (or IP address) and tcp port if necessary (separated by \":\").
If System standard port is used, you do not need to enter the port. Example: SRVERP. Otherwise, you must enter the port separated by the colon sign :. Example: SRVERP:1504. |
Environment: enter the name of a valid environment of the System
Company: enter the company code.
Branch: enter the branch code.
Protheus-Direto
It enables the access to tables that are neither accessed through TOTVS | DbAcess, nor presented in the System data dictionary. For example, a standard temporary file (xbase) generated in any directory under the System RootPath. Enter:
Name: Name for the connection.
Description: Description for the connection.
Server/Port: Name or IP of Protheus server and TCP port separated by :. If the port is default ( “7777”), you do not need to enter it.
Environment: Name of Protheus environment used by DW.
Company: Company code.
Branch: Branch Code.
Path: Enter the name of the folder under system RootPath, in which the files to be accessed are. In this row, you can enter the full path or only the folder under RootPath.
Example:
Name: Connection01
Description: Protheus-direto connection
Server: Port: 172.16.33.32:1234
Environment: PROTHEUS11
Company: T1
Branch: D SP 01
Path: System_11
Testing Connection
The Test feature allows you to check if the data entered in the connection are correct and displays the message Connection Successful when running it successfully. If the message is not displayed, go back and review the parameters entered.
Through these three types of connections, you can connect to any database homologated by the System. However, the performance is always much better in the access to relational databases. |