User Interface > The Browser > The Query Page > Mix Information from DBWorks and Other Data Sources

Querying an external data source

The query files .SQL can contain a .CONNECTION command that forces MechworksPDM to execute the query on a data source different from the standard DBWORKS; the format is as follows:

.CONNECTION ODBC;DSN=<data source name>;UID=<user identifier>;PWD=<password>

Parameters

ODBC	It is mandatory
DSN	The name of the data source as declared in the ODBC Administrator (accessible from the system Control Panel)
UID	The user identifier as declared in the ODBC Administrator (accessible from the system Control Panel)
PWD	The password as declared in the ODBC Administrator (accessible from the system Control Panel)

The data source name DSN is displayed in the query title while running the query.

Examples

.CONNECTION ODBC;DSN=DBWCUST;UID=DBA;PWD=SQL

SELECT * FROM SUPPLIER

.CONNECTION ODBC;DSN=SQL_SERVER_DATABASE;UID=DBA;PWD=SQL

SELECT * FROM CUSTOM_TABLE

These type of queries must be written using a text editor like NOTEPAD.