OracleAppsODA°¡ »ý¼ºÇÏ´Â Business Object Á¤ÀÇ¿¡´Â ´ÙÀ½ÀÌ ÀÖ½À´Ï´Ù.
ÀÌ ¼½¼ÇÀº ´ÙÀ½¿¡ ´ëÇØ ¼³¸íÇÕ´Ï´Ù.
OracleAppsODA´Â Business Object ·¹º§¿¡¼ ´ÙÀ½ Á¤º¸¸¦ »ý¼ºÇÕ´Ï´Ù.
Business-Object ·¹º§¿¡¼ ÀÀ¿ëÇÁ·Î±×·¥ ƯÁ¤ Á¤º¸´Â ´ÙÀ½À» ¼öÇàÇϵµ·Ï Çã¿ëÇÕ´Ï´Ù.
Business-Object ·¹º§¿¡¼ ÀÀ¿ëÇÁ·Î±×·¥ ƯÁ¤ Á¤º¸ Çü½ÄÀº ¼¼¹ÌÄÝ·Ð(;) ºÐ¸®¹®ÀÚ·Î ºÐ¸®µÇ´Â ¸Å°³º¯¼ö·Î ÀÌ·ç¾îÁý´Ï´Ù. ¸Å°³º¯¼öÀÇ À̸§°ú °ªÀº ÄÝ·Ð(:) ºÐ¸®¹®ÀÚ·Î ºÐ¸®µË´Ï´Ù. ±¸¹®Àº ´ÙÀ½°ú °°½À´Ï´Ù.
TN=TableName; SCN=StatusColumnName:StatusValue
¿©±â¼, TableNameÀº µ¥ÀÌÅͺ£À̽º Å×À̺íÀ» ½Äº°Çϰí StatusColumnNameÀº ³í¸® »èÁ¦¸¦ ¼öÇàÇϱâ À§ÇØ »ç¿ëµÇ´Â µ¥ÀÌÅͺ£À̽º ¿ÀÇ À̸§À̸ç, StatusValue´Â Business Object°¡ ºñȰ¼ºÈµÇ°Å³ª »èÁ¦µÊÀ» ÀǹÌÇÏ´Â °ªÀÔ´Ï´Ù.
ÀÌ ·¹º§¿¡¼ OracleAppsODA°¡ »ý¼ºÇÏ´Â AppSpecificInfo´Â µ¥ÀÌÅͺ£À̽º Å×À̺íÀ̳ª º¸±âÀÇ À̸§¿¡ ´ëÇÑ °ª¸¸À» Æ÷ÇÔÇÕ´Ï´Ù. »óÅ ¿¿¡ °ªÀ» ÁöÁ¤ÇÏ´Â °Í¿¡ ´ëÇÑ Á¤º¸´Â "Business-Object ·¹º§¿¡¼ ÀÀ¿ëÇÁ·Î±×·¥ ƯÁ¤ Á¤º¸"¸¦ ÂüÁ¶ÇϽʽÿÀ.
ÀÌ ¼½¼Ç¿¡¼´Â OracleAppsODA°¡ °¢ ¼Ó¼º¿¡ »ý¼ºÇÏ´Â µî·Ï Á¤º¸¿¡ ´ëÇØ ¼³¸íÇÕ´Ï´Ù. ¼Ó¼º¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸´Â "Business Object ¼Ó¼º µî·Ï Á¤º¸"¸¦ ÂüÁ¶ÇϽʽÿÀ.
OracleAppsODA´Â ¼Ó¼ºÀÇ À̸§ °ªÀ» µ¥ÀÌÅͺ£À̽º Å×À̺íÀ̳ª º¸±âÀÇ ¿ À̸§¿¡¼ È®º¸ÇÕ´Ï´Ù.
¼Ó¼ºÀÇ À¯ÇüÀ» ¼³Á¤ÇÒ ¶§, OracleAppsODA´Â Å×À̺íÀ̳ª º¸±â¿¡ ÀÖ´Â ¿ÀÇ µ¥ÀÌÅÍ À¯ÇüÀ» ÇØ´çÇÏ´Â IBM WebSphere Business Integration Adapters Business Object À¯ÇüÀ¸·Î º¯È¯ÇÕ´Ï´Ù. ÀÌ º¯È¯Àº µÎ ´Ü°è·Î ¿Ï·áµË´Ï´Ù. ¸ÕÀú µ¥ÀÌÅͺ£À̽º¿¡ ÀÖ´Â µ¥ÀÌÅÍ À¯ÇüÀÌ JDBC À¯ÇüÀ¸·Î º¯È¯µË´Ï´Ù. ±×·± ÈÄ, JDBC À¯ÇüÀÌ IBM WebSphere Business Integration Adapters Business Object À¯ÇüÀ¸·Î º¯È¯µË´Ï´Ù. ù ¹øÂ° º¯È¯Àº »ç¿ëÇϰí ÀÖ´Â JDBC µå¶óÀ̹ö¿¡ ÀÇÇØ ¼öÇàµË´Ï´Ù. JDBC À¯Çü¿¡ ¸ÊÇεǴ °³º° µ¥ÀÌÅͺ£À̽º À¯Çü¿¡ ´ëÇÑ ¼¼ºÎ»çÇ×Àº JDBC ½ºÆå(2.0 ÀÌ»ó)À» ÂüÁ¶ÇϽʽÿÀ. Ç¥ 14´Â JDBC À¯ÇüÀÌ ÇØ´ç IBM WebSphere Business Integration Adapters Business Object À¯ÇüÀ¸·Î º¯È¯µÇ´Â °ÍÀ» º¸¿©ÁÝ´Ï´Ù.
JDBC À¯Çü | WebSphere Business Integration Adapters Business Object À¯Çü |
---|---|
BIT |
BOOLEAN |
CHAR |
STRING |
VARCHAR |
STRING |
LONGVARCHAR |
STRING |
INTEGER |
INTEGER |
NUMERIC |
INTEGER |
SMALLINT |
INTEGER |
TINYINT |
INTEGER |
BIGINT |
INTEGER |
DATE |
DATE |
TIME |
DATE |
TIMESTAMP |
DATE |
DECIMAL |
STRING |
DOUBLE |
DOUBLE |
FLOAT |
DOUBLE |
REAL |
FLOAT |
BINARY |
STRING, ´ÙÀ½ÀÇ BYTEARRAY=TRUE ¸¦ ´ÙÀ½¿¡ Ãß°¡ AppSpecificInfo |
VARBINARY |
STRING, ´ÙÀ½ÀÇ BYTEARRAY=TRUE ¸¦ ´ÙÀ½¿¡ Ãß°¡ AppSpecificInfo |
OracleAppsODA´Â ¸ðµç ´Ü¼ø ¼Ó¼ºÀÇ Ä«µð³Î¸®Æ¼¸¦ 1·Î ¼³Á¤ÇÕ´Ï´Ù.
OracleAppsODA´Â ¹®ÀÚ¿ÀÇ ±æÀ̸¦ varchar, char ¶Ç´Â text µ¥ÀÌÅÍ À¯Çü¿¡ ÁöÁ¤µÈ ±æÀÌ¿¡¼ È®º¸ÇÕ´Ï´Ù.
¿ÀÌ Å×À̺íÀÇ 1Â÷ ŰÀÎ °æ¿ì, OracleAppsODA°¡ À̸¦ Ű ¼Ó¼ºÀ¸·Î Ç¥½ÃÇÕ´Ï´Ù. ±×·¯³ª, Å×À̺í´ë½Å ºä°¡ ¼Ò½º ³ëµå·Î¼ ¼±ÅÃµÇ¾î¼ Business Object¸¦ »ý¼ºÇϸé, OracleAppsODA°¡ ¿À» Ű ¼Ó¼ºÀ¸·Î Ç¥½ÃÇÏÁö ¾Ê½À´Ï´Ù. ÀÌ·± °æ¿ì¿¡ Ű ¼Ó¼ºÀÌ ¼öµ¿À¸·Î ¼³Á¤µÇ¾î¾ß ÇÕ´Ï´Ù.
OracleAppsODA´Â IsForeignKey µî·Ï Á¤º¸¸¦ ¼³Á¤ÇÏÁö ¾Ê½À´Ï´Ù. Business Object Designer¿¡¼ À̸¦ ¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
Çʵ尡 Å×À̺íÀ̳ª º¸±â¿¡¼ ºñ¾î ÀÖÁö ¾ÊÀ½À¸·Î ÁöÁ¤µÇ´Â °æ¿ì, OracleAppsODA°¡ À̸¦ Çʼö ¼Ó¼ºÀ¸·Î Ç¥½ÃÇÕ´Ï´Ù. ±×·¯³ª Ű Çʵå¿Í ¿¬°üµÈ ¼ø¼°¡ Àְųª Ű Çʵ尡 ID ¿ÀÏ ¼ö ÀÖÀ¸¹Ç·Î, OracleAppsODA´Â Ű Çʵ带 Çʼö·Î Ç¥½ÃÇÏÁö ¾Ê½À´Ï´Ù.
OracleAppsODA´Â ¼Ó¼º ·¹º§¿¡¼ AppSpecificInfo µî·Ï Á¤º¸¿¡ ´ëÇÑ µÎ °³ÀÇ ¸Å°³º¯¼ö¸¦ Æ÷ÇÔÇÕ´Ï´Ù. ÁöÁ¤µÈ ¸Å°³º¯¼öÀÇ ±¸¹®Àº ´ÙÀ½°ú °°½À´Ï´Ù.
CN=ColumnName
¿©±â¼, ColumnNameÀº ÁöÁ¤µÈ ¼Ó¼º°ú ¿¬°üµÈ µ¥ÀÌÅͺ£À̽º Å×À̺íÀ̳ª º¸±â¿¡ ÀÖ´Â ¿ÀÇ À̸§ÀÔ´Ï´Ù.
BYTEARRAY=true|false
OracleAppsODA´Â 2Áø µ¥ÀÌÅ͸¦ °¡Áø ¿À» ÀνÄÇϰí BYTEARRAY=true¶ó´Â
AppSpecificInfo¸¦ °¡Áø À¯Çü StringÀÇ ¼Ó¼ºÀ» ÀÛ¼ºÇÕ´Ï´Ù.
OracleAppsODA´Â BO µî·Ï Á¤º¸ â¿¡¼ ÁöÁ¤µÈ Verb¸¦ »ý¼ºÇÕ´Ï´Ù. ¶ÇÇÑ °¢ Verb¿¡ ´ëÇÑ AppSpecificInfo µî·Ï Á¤º¸¸¦ ÀÛ¼ºÇÏÁö¸¸, ä¿ìÁö´Â ¾Ê½À´Ï´Ù. ÀÚ¼¼ÇÑ Á¤º¸´Â "Verb¿¡ ´ëÇÑ ÀÀ¿ëÇÁ·Î±×·¥ ƯÁ¤ Á¤º¸ Çü½Ä"À» ÂüÁ¶ÇϽʽÿÀ.