Creating Synonyms for SQL Server Databases
This topic provides guidance for the creation of SQL Server synonyms that need to be generated during the installation of JD Edwards Agent.
The use of synonyms is only available with MS SQL Server 2005 and greater.
The scripts provided below will need to be modified to reference the Database and Schema names that are used by the JD Edwards system that the JD Edwards Agent will be integrating with. The correct DB and schema names should be obtained from the JD Edwards System Administrator.
Examples of replacement values:
| Current Value | Example Replacement Value |
|---|---|
|
<SYSTEM_DB> |
JDE900 |
|
<Object_Librarian_Schema> |
OL900 |
|
<CO_DB_Name> |
JDE_PY900 |
|
<CO_Schema> |
PY900 |
|
<System_Schema> |
SY900 |
|
<Server_Map_Schema> |
SVM900 |
Synonyms to Be Created
Object Librarian (F9860) - used to retrieve list of available UBEs:
USE [master]
GO
/****** Object: Synonym [dbo].[F9860] Script Date: 06/07/2015 07:33:33 ******/
CREATE SYNONYM [dbo].[F9860] FOR [<SYSTEM_DB>].[<Object_Librarian_Schema>].[F9860]
GO
Versions List (F983051) - used to retrieve available versions for selected UBE:
USE [master]
GO
/****** Object: Synonym [dbo].[F983051] Script Date: 07/07/2010 07:36:07 ******/
CREATE SYNONYM [dbo].[F983051] FOR [<CO_DB_Name>].[<CO_Schema>].[F983051]
GO
Printer List (F986130) - used to select printer overrides:
USE [master]
GO
/****** Object: Synonym [dbo].[F986130] Script Date: 07/07/2010 07:37:39 ******/
CREATE SYNONYM [dbo].[F986130] FOR [<SYSTEM_DB>].[<SYSTEM_SCHEMA>].[F986130]
GO
Environment List (F0094) - used to select environment for Job submission:
USE [master]
GO
/****** Object: Synonym [dbo].[F0094] Script Date: 06/07/2015 07:38:42 ******/
CREATE SYNONYM [dbo].[F0094] FOR [<SYSTEM_DB>].[<SYSTEM_SCHEMA>].[F0094]
GO
Job Master Table (F986110) - used to retrieve Job status:
USE [master]
GO
/****** Object: Synonym [dbo].[F986110] Script Date: 06/07/2015 07:42:13 ******/
CREATE SYNONYM [dbo].[F986110] FOR [<SYSTEM_DB>].[<Server_Map_Schema>].[F986110]
GO
JD Edwards Job Queue Table (F986167) - used to select Job Queue overrides:
/****** Object: Synonym [dbo].[F986167] Script Date: 06/07/2015 14:24:57 ******/
CREATE SYNONYM [dbo].[F986167] FOR [<SYSTEM_DB].[<SYSTEM_SCHEMA>].[F986167]
GO
Object Librarian (F986111) - used to get the JD Edwards run number:
USE [master]
GO
/****** Object: Synonym [dbo].[F986111] Script Date: 06/07/2015 07:34:63 ******/
CREATE SYNONYM [dbo].[F986111] FOR [<SYSTEM_DB>].[<Object_Librarian_Schema>].[F986111]
GO
SQL Server DB Login Scripts
Automic SQL Server Login (AEJDE):
/* For security reasons the login is created disabled and with a random password. */
/****** Object: Login [AEJDE] Script Date: 06/07/2015 07:46:17 ******/
CREATE LOGIN [AEJDE] WITH PASSWORD=N'4ùkM˘ùOÔS2nrV1dß*ÈäŪÄÕôFy©6„', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
GO
Grant Automic SQL Server ID access to JD Edwards Databases:
USE [<SYSTEM_DB>]
GO
/****** Object: User [AEJDE] Script Date: 07/07/2010 07:48:10 ******/
GO
CREATE USER [AEJDE] FOR LOGIN [AEJDE] WITH DEFAULT_SCHEMA=[dbo]
GO
USE [JDE_PY900]
GO
/****** Object: User [AEJDE] Script Date: 06/07/2015 07:50:18 ******/
GO
CREATE USER [AEJDE] FOR LOGIN [AEJDE] WITH DEFAULT_SCHEMA=[dbo]
GO