OLAP ¼³Ä¡ ¹× »ç¿ëÀÚ ¾È³»¼­

SQL Interface¿¡ ´ëÇÑ ODBC ·Îµå ¹× ±¸¼º

SQL Interface Ãß°¡ ±â´ÉÀ» ¼±ÅÃÇÑ °æ¿ì RDBMS ȯ°æÀÌ Á¦´ë·Î ¼³Á¤µÇ¾î ÀÖ´ÂÁö È®ÀÎÇØ¾ß ÇÕ´Ï´Ù. SQL Interface¿¡ ´ëÇØ ȯ°æ ¹× ODBC µå¶óÀ̹öµµ ¼³Á¤ÇØ¾ß ÇÕ´Ï´Ù.

¼³Ä¡ ÇÁ·Î±×·¥Àº ODBC µå¶óÀ̹ö¸¦ ·Îµå ¹× ±¸¼ºÇÏÁö ¾Ê½À´Ï´Ù. SQL Interface Ãß°¡ ±â´ÉÀ» »ç¿ëÇÏ·Á¸é, Á÷Á¢ IBM DB2¿ë ODBC¸¦ ¼³Á¤ÇÒ Çʿ䰡 ÀÖ½À´Ï´Ù.

SQL Interface¸¦ »ç¿ëÇÒ ¶§, SQL ¾×¼¼½º¿ëÀ¸·Î »ç¿ëÇÏ´Â °èÁ¤ÀÇ ¾ÏÈ£°¡ ´ë¹®ÀÚÀÎÁö È®ÀÎÇϽʽÿÀ.

´ÙÀ½ ½Ã³ª¸®¿À´Â IBM DB2¿ë ODBC¸¦ ·ÎµåÇÏ°í ±¸¼ºÇÏ´Â ¹æ¹ýÀ» º¸¿©ÁÝ´Ï´Ù. ÀÌ ½Ã³ª¸®¿À´Â SQL Interface¸¦ ¼³Ä¡Çß´Ù°í °¡Á¤ÇÕ´Ï´Ù.

  1. $ARBORPATH/bin µð·ºÅ丮¿¡¼­, ´ÙÀ½À» Æ÷ÇÔÇÏ´Â esssql.cfg¶ó´Â ÅØ½ºÆ® ÆÄÀÏÀ» ÀÛ¼ºÇϽʽÿÀ.
    [
    Description "IBM DB2 ODBC Driver"
    DriverName db2.o
    Database 0
    Userid 1
    Password 1
    SingleConnection 0
    UpperCaseConnection 0
    IsQEDriver 0
    ]
    
  2. /home/essbase ($ARBORPATH) µð·ºÅ丮¿¡¼­ inst-sql.sh ÆÄÀÏÀ» ½ÇÇàÇϽʽÿÀ. ÀÌ ÆÄÀÏÀº SQL Interface¸¦ µå¶óÀ̹ö ¶óÀ̺귯¸®¿¡ ¸µÅ©ÇÕ´Ï´Ù.
  3. $ARBORPATH µð·ºÅ丮¿¡ .odbcinst.ini¿Í .odbc.ini¶ó´Â µÎ °³ÀÇ ÆÄÀÏÀ» ÀÛ¼ºÇϽʽÿÀ. ¶ÇÇÑ, /home/db2inst1/ÀÌ $INSTHOME ȯ°æ º¯¼öÀÇ ³»¿ë°ú °°´Ù´Â Á¡µµ ±â¾ïÇϽʽÿÀ.
  4. .odbcinst.ini ÆÄÀÏÀ» ÆíÁýÇÏ¿© ÇØ´ç µå¶óÀ̺êÀÇ ¿Ã¹Ù¸¥ °æ·Î¸¦ ¼³Á¤ÇϽʽÿÀ. ¿¹:
    [ODBC Drivers]
    IBM DB2 ODBC DRIVER=Installed
     
    [IBM DB2 ODBC DRIVER]
    Driver=/home/db2inst1/sqllib/lib/db2.o
    
  5. .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 µ¥ÀÌÅÍ ¼Ò½º ¸ñ·Ï¿¡ À̵éÀ» Ãß°¡ÇϽʽÿÀ.

  6. DB2 UDB ÀνºÅϽº ¼ÒÀ¯Àڷμ­ »ç¿ëÀÚ ½Ã½ºÅÛÀ¸·Î ·Î±×ÀÎÇÏ°í ´ÙÀ½ ´Ü°è¸¦ ¼öÇàÇϽʽÿÀ.
    1. SQL ¾×¼¼½º¿ëÀ¸·Î »ç¿ëÇÏ·Á´Â °èÁ¤¿¡ °ü·ÃµÈ ¸ðµç Å×ÀÌºí¿¡ ´ëÇÑ ¼±Åà ±ÇÇÑÀ» ºÎ¿©ÇϽʽÿÀ. ¿¹¸¦ µé¾î, DB2 ¸í·ÉÇà 󸮱⿡¼­, ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇÏ¿© arbsql °èÁ¤¿¡ ±ÇÇÑÀ» ºÎ¿©ÇϽʽÿÀ.
      GRANT SELECT ON STAFF TO arbsql
      
    2. DB2 TERMINATE¸¦ ½ÇÇàÇÏ¿© īŻ·Î±× ¹öÆÛ¸¦ ºñ¿ì½Ê½Ã¿À.

SQL Interface¸¦ ½ÃÇèÇÏ·Á¸é ´ÙÀ½ ´Ü°è¸¦ ¼öÇàÇϽʽÿÀ.

  1. SQL ¾×¼¼½º¿ëÀ¸·Î »ç¿ëÇÏ·Á´Â °èÁ¤À» »ç¿ëÇÏ¿© ½Ã½ºÅÛÀ¸·Î ·Î±×ÀÎÇϽʽÿÀ. DB2 ¸í·ÉÇà 󸮱â·Î »ç¿ëÀÚ Å×À̺íÀ» ¾×¼¼½ºÇÒ ¼ö ÀÖ´ÂÁö È®ÀÎÇϽʽÿÀ.
  2. Ŭ¶óÀÌ¾ðÆ® ±â°è¿¡¼­, Application Manager¸¦ »ç¿ëÇÏ¿© ÀÀ¿ëÇÁ·Î±×·¥ ¹× µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇϽʽÿÀ.
  3. À±°ûÀ» ¿­°í ÀϺΠ´õ¹Ì Â÷¿ø ¹× ±¸¼º¿øÀ» Ãß°¡Çϰí, À±°ûÀ» ÀúÀåÇϽʽÿÀ.
  4. »õ ±ÔÄ¢ ÆÄÀÏÀ» ¿©½Ê½Ã¿À.
  5. File ¸Þ´º¿¡¼­ Open SQLÀ» ¼±ÅÃÇϽʽÿÀ. ¼­¹ö, ÀÀ¿ëÇÁ·Î±×·¥ ¹× µ¥ÀÌÅͺ£À̽º À̸§À» È®ÀÎÇÑ ´ÙÀ½ OK¸¦ ´©¸£½Ê½Ã¿À.
  6. Define SQL ÆÐ³ÎÀÇ SQL Data Sources »óÀÚ¿¡¼­´Â µî·ÏÇÑ °¢ µ¥ÀÌÅÍ ¼Ò½º¸¦ ³ª¿­ÇÕ´Ï´Ù. Å×À̺í À̸§ÀÌ ±ÔÁ¤È­µÇ¾ú´ÂÁö È®ÀÎÇϽʽÿÀ. SELECT, FROM ¹× WHERE Çʵ带 ä¿î ´ÙÀ½ OK/Retrieve¸¦ ´©¸£½Ê½Ã¿À.
  7. SQL Connect ÆÐ³Î¿¡¼­ DB2 »ç¿ëÀÚ ID¿Í ¾ÏÈ£¸¦ ÀÔ·ÂÇÏ°í ¼­¹ö, ÀÀ¿ëÇÁ·Î±×·¥ ¹× µ¥ÀÌÅͺ£À̽º À̸§À» È®ÀÎÇÑ ´ÙÀ½ OK¸¦ ´©¸£½Ê½Ã¿À. µ¥ÀÌÅͺ£À̽º°¡ ¿ø°Ý ¸Ó½Å¿¡ ÀÖ´Â °æ¿ì, ÇØ´ç ¸Ó½Å¿¡ ´ëÇÑ »ç¿ëÀÚ ID ¹× ¾ÏÈ£¸¦ ÀÔ·ÂÇϽʽÿÀ.


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]