This functionality is only available for certain module packages.

You are here: EEC > BASE > Data sources > Using data sources as resources

Using data sources as resources

External databases (Oracle, SQL server, etc.) with large data volumes continue to be maintained externally. Frequently, though, there are transparent models, for example, simple tables, where wire cross-sections are specified, certain part data are managed, etc. For such data formats (CSV files, MDL files, etc.), it often makes sense to transfer management to EEC.

All data sources, except DatabaseDataSource (with a Connection URL), therefore, are integrated into EEC in a manner similar to a new discipline. This has the following advantages:

The user preferences for the connection pool are listed in detail in the following table.

Parameter name Default value Description
Initial connection pool size 1 Number of connections to be captured at the start. This number should be greater than the minimum number, and less than the maximum size of the connection pool.
Minimum size of the connection pool 0 Minimum number of connections that are served simultaneously.
Maximum size of the connection pool 3 Maximum number of connections that are served simultaneously.
Increment for pool increase 2 Number of connections that are added if the connection pool is exhausted.
Maximum idle time of a connection in the pool 300 Time in seconds during which an unused connection remains in the pool until it is deleted.
Maximum age of a connection in the pool 28800 Absolute time in seconds during which a connection exists in the pool before it is disconnected and deleted. Connections with few unused times are also removed. The maximum age is set to 0 by default.
Number of connection attempts 5 Number of connection attempts before it is abandoned. If the attempt to connect is never to be abandoned, 0 must be entered.
Pause between connection attempts 1000 Time in milliseconds between two connection attempts.