OLAP ¼³Ä¡ ¹× »ç¿ëÀÚ ¾È³»¼
SQL Interface Ãß°¡ ±â´ÉÀ» ¼±ÅÃÇÑ °æ¿ì RDBMS ȯ°æÀÌ Á¦´ë·Î ¼³Á¤µÇ¾î
ÀÖ´ÂÁö È®ÀÎÇØ¾ß ÇÕ´Ï´Ù. SQL Interface¿¡ ´ëÇØ ȯ°æ ¹× ODBC µå¶óÀ̹öµµ
¼³Á¤ÇØ¾ß ÇÕ´Ï´Ù.
¼³Ä¡ ÇÁ·Î±×·¥Àº ODBC µå¶óÀ̹ö¸¦ ·Îµå ¹× ±¸¼ºÇÏÁö ¾Ê½À´Ï´Ù. SQL
Interface Ãß°¡ ±â´ÉÀ» »ç¿ëÇÏ·Á¸é, Á÷Á¢ IBM DB2¿ë ODBC¸¦ ¼³Á¤ÇÒ
Çʿ䰡 ÀÖ½À´Ï´Ù.
SQL Interface¸¦ »ç¿ëÇÒ ¶§, SQL ¾×¼¼½º¿ëÀ¸·Î »ç¿ëÇÏ´Â °èÁ¤ÀÇ
¾ÏÈ£°¡ ´ë¹®ÀÚÀÎÁö È®ÀÎÇϽʽÿÀ.
´ÙÀ½ ½Ã³ª¸®¿À´Â IBM DB2¿ë ODBC¸¦ ·ÎµåÇÏ°í ±¸¼ºÇÏ´Â ¹æ¹ýÀ»
º¸¿©ÁÝ´Ï´Ù. ÀÌ ½Ã³ª¸®¿À´Â SQL Interface¸¦ ¼³Ä¡Çß´Ù°í °¡Á¤ÇÕ´Ï´Ù.
- $ARBORPATH/bin µð·ºÅ丮¿¡¼, ´ÙÀ½À» Æ÷ÇÔÇÏ´Â esssql.cfg¶ó´Â
ÅØ½ºÆ® ÆÄÀÏÀ» ÀÛ¼ºÇϽʽÿÀ.
[
Description "IBM DB2 ODBC Driver"
DriverName db2.o
Database 0
Userid 1
Password 1
SingleConnection 0
UpperCaseConnection 0
IsQEDriver 0
]
- /home/essbase ($ARBORPATH)
µð·ºÅ丮¿¡¼ inst-sql.sh ÆÄÀÏÀ»
½ÇÇàÇϽʽÿÀ. ÀÌ ÆÄÀÏÀº SQL Interface¸¦ µå¶óÀ̹ö ¶óÀ̺귯¸®¿¡
¸µÅ©ÇÕ´Ï´Ù.
- $ARBORPATH µð·ºÅ丮¿¡ .odbcinst.ini¿Í
.odbc.ini¶ó´Â µÎ °³ÀÇ ÆÄÀÏÀ» ÀÛ¼ºÇϽʽÿÀ. ¶ÇÇÑ,
/home/db2inst1/ÀÌ $INSTHOME ȯ°æ º¯¼öÀÇ ³»¿ë°ú °°´Ù´Â
Á¡µµ ±â¾ïÇϽʽÿÀ.
- .odbcinst.ini ÆÄÀÏÀ» ÆíÁýÇÏ¿©
ÇØ´ç µå¶óÀ̺êÀÇ ¿Ã¹Ù¸¥ °æ·Î¸¦ ¼³Á¤ÇϽʽÿÀ. ¿¹:
[ODBC Drivers]
IBM DB2 ODBC DRIVER=Installed
[IBM DB2 ODBC DRIVER]
Driver=/home/db2inst1/sqllib/lib/db2.o
- .odbc.ini ÆÄÀÏÀ» ÆíÁýÇÏ¿© µå¶óÀ̹ö
¹× ¼³Ä¡ µð·ºÅ丮ÀÇ ¿Ã¹Ù¸¥ °æ·Î¸¦ ¼³Á¤ÇϽʽÿÀ. DB2 µ¥ÀÌÅͺ£À̽º
µð·ºÅ丮 ³ª¿ ±â´ÉÀ¸·Î ³ª¿µÇ´Â °¢ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ ÀÌ ÆÄÀÏ¿¡
Ç׸ñÀ» ³Ö¾î¾ß ÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, SAMPLE ¹× OLAPSRCÀÇ µÎ °³ÀÇ
µ¥ÀÌÅͺ£À̽º¸¦ °¡Áø °æ¿ì, »ç¿ëÀÚ ÆÄÀÏÀº ´ÙÀ½°ú °°À» ¼ö ÀÖ½À´Ï´Ù.
[ODBC Data Sources]
SAMPLE=IBM DB2 ODBC DRIVER
OLAPSRC=IBM DB2 ODBC DRIVER
[SAMPLE]
Driver=/home/db2inst1/sqllib/lib/db2.o
Description=Sample DB2 ODBC Database
[OLAPSRC]
Driver=/home/db2inst1/sqllib/lib/db2.o
Description=DB2 OLAP Server Source Database
[ODBC]
Trace=0
TraceFile=odbctrace.out
InstallDir=/home/db2inst1/sqllib/odbclib
¿ø°Ý µ¥ÀÌÅÍ ¼Ò½º¿¡ ¾×¼¼½ºÇÏ·Á´Â °æ¿ì, ODBC µ¥ÀÌÅÍ ¼Ò½º ¸ñ·Ï¿¡ À̵éÀ»
Ãß°¡ÇϽʽÿÀ.
- DB2 UDB ÀνºÅϽº ¼ÒÀ¯Àڷμ »ç¿ëÀÚ ½Ã½ºÅÛÀ¸·Î ·Î±×ÀÎÇϰí
´ÙÀ½ ´Ü°è¸¦ ¼öÇàÇϽʽÿÀ.
- SQL ¾×¼¼½º¿ëÀ¸·Î »ç¿ëÇÏ·Á´Â °èÁ¤¿¡ °ü·ÃµÈ ¸ðµç Å×ÀÌºí¿¡ ´ëÇÑ
¼±Åà ±ÇÇÑÀ» ºÎ¿©ÇϽʽÿÀ. ¿¹¸¦ µé¾î, DB2 ¸í·ÉÇà 󸮱⿡¼, ´ÙÀ½
¸í·ÉÀ» ½ÇÇàÇÏ¿© arbsql °èÁ¤¿¡ ±ÇÇÑÀ» ºÎ¿©ÇϽʽÿÀ.
GRANT SELECT ON STAFF TO arbsql
- DB2 TERMINATE¸¦ ½ÇÇàÇÏ¿© īŻ·Î±× ¹öÆÛ¸¦ ºñ¿ì½Ê½Ã¿À.
SQL Interface¸¦ ½ÃÇèÇÏ·Á¸é ´ÙÀ½ ´Ü°è¸¦ ¼öÇàÇϽʽÿÀ.
- SQL ¾×¼¼½º¿ëÀ¸·Î »ç¿ëÇÏ·Á´Â °èÁ¤À» »ç¿ëÇÏ¿© ½Ã½ºÅÛÀ¸·Î ·Î±×ÀÎÇϽʽÿÀ.
DB2 ¸í·ÉÇà 󸮱â·Î »ç¿ëÀÚ Å×À̺íÀ» ¾×¼¼½ºÇÒ ¼ö ÀÖ´ÂÁö È®ÀÎÇϽʽÿÀ.
- Ŭ¶óÀÌ¾ðÆ® ±â°è¿¡¼, Application Manager¸¦ »ç¿ëÇÏ¿© ÀÀ¿ëÇÁ·Î±×·¥ ¹×
µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇϽʽÿÀ.
- À±°ûÀ» ¿°í ÀϺΠ´õ¹Ì Â÷¿ø ¹× ±¸¼º¿øÀ» Ãß°¡Çϰí, À±°ûÀ» ÀúÀåÇϽʽÿÀ.
- »õ ±ÔÄ¢ ÆÄÀÏÀ» ¿©½Ê½Ã¿À.
- File ¸Þ´º¿¡¼
Open SQLÀ» ¼±ÅÃÇϽʽÿÀ. ¼¹ö,
ÀÀ¿ëÇÁ·Î±×·¥ ¹× µ¥ÀÌÅͺ£À̽º À̸§À» È®ÀÎÇÑ
´ÙÀ½ OK¸¦ ´©¸£½Ê½Ã¿À.
- Define SQL ÆÐ³ÎÀÇ
SQL Data Sources »óÀÚ¿¡¼´Â
µî·ÏÇÑ °¢ µ¥ÀÌÅÍ ¼Ò½º¸¦ ³ª¿ÇÕ´Ï´Ù. Å×À̺í À̸§ÀÌ ±ÔÁ¤ÈµÇ¾ú´ÂÁö
È®ÀÎÇϽʽÿÀ. SELECT, FROM ¹× WHERE Çʵ带 ä¿î ´ÙÀ½
OK/Retrieve¸¦ ´©¸£½Ê½Ã¿À.
- SQL Connect ÆÐ³Î¿¡¼ DB2 »ç¿ëÀÚ ID¿Í
¾ÏÈ£¸¦ ÀÔ·ÂÇÏ°í ¼¹ö, ÀÀ¿ëÇÁ·Î±×·¥ ¹× µ¥ÀÌÅͺ£À̽º À̸§À» È®ÀÎÇÑ
´ÙÀ½ OK¸¦ ´©¸£½Ê½Ã¿À. µ¥ÀÌÅͺ£À̽º°¡
¿ø°Ý ¸Ó½Å¿¡ ÀÖ´Â °æ¿ì, ÇØ´ç ¸Ó½Å¿¡ ´ëÇÑ »ç¿ëÀÚ ID ¹× ¾ÏÈ£¸¦ ÀÔ·ÂÇϽʽÿÀ.
[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]