When implementing a new client that is migrating from CMC, the CMC Extract and Classic Migrate application need ODBC access to the CMC system. The steps below document the setup process.
Pre-Requisites
- Access to the FTP Site
Step-by-Step Guide
- Access the Server where you wish to install the CMC Extract & Classic Migrate applications.
- Download the setupodb.exe file from the FTP Site under the CMC Migration folder.
Note: There is a 32-bit and 64-bit version depending on the server type you are installing onto. - Run the setupodb.exe application, using all the default options.
- When complete, access the Control Panel \ Administrative Tools folder on the server.
- Depending on the driver that was installed (32-bit or 64-bit), open the appropriate ODBC Data Sources option.
- Access the System DSN tab and click Add.
- Select the DB/C FS4 ODBC Driver and click Finish.
- Specify the appropriate values then click OK.
- For CMC's GL System the settings need to be:
- Data Source Name: CMC-GL
- Database Name: erpglv3
- Server Name: (IP Address of Clients Server)
- Encryption: Disabled
- For CMC's AP System the settings need to be:
- Data Source Name: CMC-AP
- Database Name: erpapv3
- Server Name: (IP Address of Clients Server)
- Encryption: Disabled
- For CMC's GL System the settings need to be:
- The System DSN list should now be updated:
- Repeat Step #6-9 as necessary for any additional connections needed.
- Click OK to close the ODBC Data Source Administrator screen.
- Close the Control Panel window.
- You are now ready to configure the CMC Extract and/or Classic Migration applications.