Existing external data sources such as ERP or MPR systems can be linked to SOLIDWORKS via CustomTools. You need to provide some information about those external data sources in order to link them to CustomTools.
|
NOTE: External sources are server specific connections and changing the database connection to another database takes the same external database connections. |
The following information are needed about the new external data source:
| Name | The name of the external data source to be linked. |
| Provider | Specifies the provider of an external data source. |
| Data source | The name of the external data source as defined by the OLE DB provider.
NOTE: When you are usign Microsoft Excel workbook or Microsoft Access database as an external data source, type the Data source path exactly as it is from the database server point of view. The database server means in this case the workstation or the server machine where the SQL Server used by the CustomTools database is installed at. |
| Connect with CustomTools server connection credentials | Enable/Disable the External database connection to use the same login information as your connection between CustomTools and CustomTools database server. |
| Remote user | Specifies your remote user name. The original remote user name should be received from the provider of an external data source. |
| Remote user password | Specifies your password needed to access the external data source. The original password should be received from the provider of an external data source. |
| Provider string | Specifies the programmatic identifier (PROGID) of the OLE DB provider that corresponds to the external data source. |
|
TIP: Find more information about the OLE DB data sources from Microsoft Developer Network (MSDN). |
| Location | Specifies location of the database as interpreted by the OLE DB provider. |
| Catalog | The name of the catalog to use when making a connection to the OLE DB provider. |