|IBM DB2 OLAP Starer Kit 7.2¿¡¼´Â OLAP ÅëÇÕ ¼¹ö¿¡¼ °ü°èÇü µ¥ÀÌÅÍ |¼Ò½º¿Í OLAP ¸ÞŸµ¥ÀÌÅÍ Ä«Å»·Î±×·ÎÀÇ ODBC(Open Database Connectivity) ¿¬°á ÀÛ¾÷À» |ÇÏ·Á¸é ODBC.ini ÆÄÀÏÀÌ ÀÖ¾î¾ß ÇÕ´Ï´Ù. |
|ODBC.ini ÆÄÀÏÀº ODBC ¼ÒÇÁÆ®¿þ¾î ÆÐÅ°Áö¿¡ »ç¿ë °¡´ÉÇϸç, |Microsoft Office ¼ÒÇÁÆ®¿þ¾î¿¡µµ Æ÷ÇԵǾî ÀÖ½À´Ï´Ù. |ODBC µå¶óÀ̹ö³ª ODBC °ü¸®ÀÚ¸¦ ¼³Ä¡ÇÏ´Â ÀÀ¿ëÇÁ·Î±×·¥¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸´Â |À¥ »çÀÌÆ® http://support.microsoft.com/À» ÂüÁ¶ÇϽʽÿÀ.
|AIX ¸Ó½Å¿¡¼ OracleÀ» »ç¿ëÇÏ´Â »ç¿ëÀÚ°¡ ODBC¸¦ Oracle¿ëÀ¸·Î ±¸¼ºÇÏ·Á¸é |MERANT 3.6 µå¶óÀ̹ö¸¦ °¡¸®Å°µµ·Ï ODBC.ini ÆÄÀÏÀ» °»½ÅÇØ¾ß ÇÕ´Ï´Ù.
|¹öÀü 7.2¿¡¼´Â OLAP Starter Kit°¡ °ü°èÇü µ¥ÀÌÅÍ ¼Ò½º ¹× OLAP ¸ÞŸµ¥ÀÌÅÍ |Ä«Å»·Î±×·ÎÀÇ ODBC ¿¬°áÀ» °ü¸®ÇÕ´Ï´Ù. |ÀÌ·¯ÇÑ ODBC ¿¬°áÀ» À§ÇØ OLAP Starter Kit´Â Windows NT 4.0, Windows 2000, AIX, Solaris¿¡¼ |ODBC µå¶óÀ̹ö¸¦ »ç¿ëÇÕ´Ï´Ù. |
|AIX¿Í Solaris¿¡¼´Â ODBC¿ë ȯ°æ º¯¼ö¸¦ ¼öµ¿À¸·Î ¼³Á¤ÇÏ°í |odbc.ini ÆÄÀÏÀ» ÆíÁýÇÏ¿© °ü°èÇü |µ¥ÀÌÅÍ ¼Ò½º ¹× OLAP ¸ÞŸµ¥ÀÌÅÍ Ä«Å»·Î±×¸¦ ±¸¼ºÇØ¾ß ÇÕ´Ï´Ù. |»õ µå¶óÀ̹ö ¶Ç´Â µ¥ÀÌÅÍ ¼Ò½º¸¦ Ãß°¡Çϰųª, µå¶óÀ̹ö³ª µ¥ÀÌÅÍ ¼Ò½º¸¦ º¯°æÇÑ °æ¿ì¿¡´Â |¹Ýµå½Ã odbc.ini ÆÄÀÏÀ» ÆíÁýÇØ¾ß ÇÕ´Ï´Ù.
|AIX ¶Ç´Â Solaris¿¡¼ DB2 OLAP Starter Kit¸¦ »ç¿ëÇؼ Merant ODBC ¼Ò½º ¹× DB2 µ¥ÀÌÅͺ£À̽º¿¡ |¾×¼¼½ºÇÏ·Á¸é, .odbc.ini ÆÄÀÏÀÇ DB2 ¼Ò½º ¼½¼Ç¿¡¼ "Driver=" ¼Ó¼º °ªÀ» ´ÙÀ½°ú |°°ÀÌ º¯°æÇϽʽÿÀ.
|AIX¿¡¼ µå¶óÀ̹ö À̸§Àº /usr/lpp/db2_07_01/lib/db2_36.oÀÔ´Ï´Ù.
|AIX¿ë »ùÇà ODBC ¼Ò½º Ç׸ñÀº ´ÙÀ½°ú °°½À´Ï´Ù.
|[SAMPLE] Driver=/usr/lpp/db2_07_01/lib/db2_36.o |Description=DB2 ODBC Database |Database=SAMPLE
|Solaris ¿î¿µ ȯ°æ: µå¶óÀ̹ö À̸§Àº /opt/IBMdb2/V7.1/lib/libdb2_36.soÀÔ´Ï´Ù.
|Solaris¿ë ODBC ¼Ò½º Ç׸ñ »ùÇÃ
|[SAMPLE] Driver=/opt/IBMdb2/V7.1/lib/libdb2_36.so |Description=DB2 ODBC Database |Database=SAMPLE
|UNIX ½Ã½ºÅÛ¿¡¼´Â ODBC ÇÙ½É ±¸¼º¿ä¼Ò¸¦ ¾×¼¼½ºÇÒ ¼ö ÀÖµµ·Ï ȯ°æ º¯¼ö¸¦ ¼³Á¤ÇØ¾ß ÇÕ´Ï´Ù. |ÇÊ¿äÇÑ º¯¼ö¸¦ ¼³Á¤ÇÏ´Â is.sh ¹× is.csh |½© ½ºÅ©¸³Æ®´Â Starter KitÀÇ È¨ µð·ºÅ丮¿¡ ÀÖ½À´Ï´Ù. |ODBC¸¦ ÅëÇØ µ¥ÀÌÅÍ ¼Ò½º¿¡ ¿¬°áÇϱâ Àü¿¡ ÀÌ ½ºÅ©¸³Æ® Áß Çϳª¸¦ ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù. |¶ÇÇÑ »ç¿ëÇÒ »ç¿ëÀÚ À̸§À¸·Î OLAP Starter Kit¸¦ ¼öÇàÇÏ·Á¸é ·Î±×ÀÎ ½ºÅ©¸³Æ®¿¡ |ÀÌ ½ºÅ©¸³Æ®µéÀ» Æ÷ÇÔÇØ¾ß ÇÕ´Ï´Ù.
|odbc.ini ÆÄÀÏ¿¡¼ µ¥ÀÌÅÍ ¼Ò½º¸¦ ±¸¼ºÇÏ·Á¸é ODBC µ¥ÀÌÅÍ ¼Ò½º¿¡ ´ëÇÑ ¼³¸í°ú À̸§À» Ãß°¡ÇÏ°í, |µ¥ÀÌÅÍ ¼Ò½º À̸§¿¡ »ç¿ëÇϱâ À§ÇØ ÀÛ¼ºÇÑ º°µµÀÇ ¼½¼Ç¿¡ ODBC µå¶óÀ̹ö °æ·Î, ÆÄÀÏ À̸§, ±âŸ µå¶óÀ̹ö ¼³Á¤À» |ÀÔ·ÂÇØ¾ß ÇÕ´Ï´Ù. |¼³Ä¡ ÇÁ·Î±×·¥Àº »ùÇà odbc.ini ÆÄÀÏÀ» ISHOME µð·ºÅ丮¿¡ ¼³Ä¡ÇÕ´Ï´Ù. |ÀÌ ÆÄÀÏ¿¡´Â Áö¿øµÇ´Â ODBC µå¶óÀ̹ö¿¡ ´ëÇÑ ÀÏ¹Ý ODBC ¿¬°á°ú ±¸¼º Á¤º¸°¡ ÀÖ½À´Ï´Ù. |ÀÌ ÆÄÀÏÀ» ½ÃÀÛÁ¡À¸·Î ÇÏ¿© »ç¿ëÇÒ ODBC µå¶óÀ̹ö¸¦ °ü°èÇü µ¥ÀÌÅÍ ¼Ò½º |¹× OLAP ¸ÞŸµ¥ÀÌÅÍ Ä«Å»·Î±×¿¡ ¸ÊÇÎÇϽʽÿÀ.
|odbc.ini°¡ ¾Æ´Ñ ´Ù¸¥ ÆÄÀÏÀ» »ç¿ëÇÒ °æ¿ì¿¡´Â |ODBCINI ȯ°æ º¯¼ö¸¦ »ç¿ëÇÒ ÆÄÀÏ À̸§À¸·Î ¼³Á¤ÇϽʽÿÀ.
|´ÙÀ½ ¿¹´Â AIX¿¡ ¼³Ä¡µÈ DB2 Universal Database ¹öÀü 6.1¿¡¼ IBM DB2 ¿ø½Ã ODBC µå¶óÀ̹ö¸¦ »ç¿ëÇÏ¿© |db2data °ü°èÇü µ¥ÀÌÅÍ ¼Ò½º¿¡ ¿¬°áÇϱâ À§ÇØ odbc.ini |ÆíÁý ¹æ¹ýÀ» º¸¿©ÁÝ´Ï´Ù. |vi ÆíÁý±â¿¡¼ |$ODBCINI ¸í·ÉÀ» »ç¿ëÇÏ¿© odbc.ini ÆíÁý ÈÄ |´ÙÀ½ ¸í·É¹®À» »ðÀÔÇϽʽÿÀ.
| [ODBC Data Sources] | db2data=DB2 Source Data on AIX | ... | [db2data] | Driver=/home/db2inst1/sqllib/lib/db2.o | Description=DB2 Data Source - AIX, native
|´ÙÀ½ ¿¹´Â Oracle ¹öÀü 8(Solaris)¿¡¼ MERANT ¹öÀü 3.6 ODBC µå¶óÀ̹ö¸¦ »ç¿ëÇÏ¿© |oradata °ü°èÇü µ¥ÀÌÅÍ ¼Ò½º¿¡ ¿¬°áÇϱâ À§ÇØ |odbc.ini ÆíÁý ¹æ¹ýÀ» º¸¿©ÁÝ´Ï´Ù. |ÀÌ ¿¹¿¡¼ LogonID¿Í Password¿¡´Â |OLAP Starter KitÀÇ »ç¿ëÀÚ À̸§°ú ¾ÏÈ£¿¡ »ç¿ëµÈ ½ÇÁ¦ °ªÀ» »ç¿ëÇß½À´Ï´Ù.
| [ODBC Data Sources] | oradata=Oracle8 Source Data on Solaris | ... | [myoracle] Driver= | /export/home/users/dkendric/is200/odbclib/ARor815.so | Description=my oracle source
|AIX¿Í Solaris¿¡¼ OLAP ¸ÞŸµ¥ÀÌÅÍ Ä«Å»·Î±×¸¦ ±¸¼ºÇÏ´Â |°ÍÀº µ¥ÀÌÅÍ ¼Ò½º¸¦ ±¸¼ºÇÏ´Â °Í°ú ºñ½ÁÇÕ´Ï´Ù. |OLAP ¸ÞŸµ¥ÀÌÅÍ Ä«Å»·Î±× µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ 29.6.1.2, odbc.ini ÆÄÀÏ ÆíÁý¿¡ ¼³¸íµÈ ´ë·Î |odbc.ini ÆÄÀÏ¿¡ µ¥ÀÌÅÍ ¼Ò½º À̸§°ú ¼½¼ÇÀ» Ãß°¡ÇϽʽÿÀ. |ÀÌ ¿Ü ´Ù¸¥ ºÎºÐÀº º¯°æÇÒ ÇÊ¿ä°¡ ¾ø½À´Ï´Ù.
|ODBC µ¥ÀÌÅÍ ¼Ò½º·Î ±¸¼ºÇϱâ Àü¿¡ ¸ÕÀú Áö¿øµÇ´Â RDBMS¿¡ |OLAP ¸ÞŸµ¥ÀÌÅÍ Ä«Å»·Î±× µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇØ¾ß ÇÕ´Ï´Ù.
|´ÙÀ½ ¿¹´Â DB2 ¹öÀü 6.1(Solaris)¿¡¼ ¿ø½Ã ODBC µå¶óÀ̹ö¸¦ »ç¿ëÇÏ¿© |OLAP ¸ÞŸµ¥ÀÌÅÍ Ä«Å»·Î±×, TBC_MD¿¡ ¿¬°áÇϱâ À§ÇØ |odbc.ini¸¦ ÆíÁýÇÏ´Â ¹æ¹ýÀ» º¸¿©ÁÝ´Ï´Ù.
| [ODBC Data Sources] | ocd6a5a=db2 v6 | ... | [ocd6a5a] | Driver=/home/db2instl/sqllib/lib/db2.0 | Description=db2
|Windows NT³ª Windows 2000 ½Ã½ºÅÛ¿¡¼ °ü°èÇü µ¥ÀÌÅÍ ¼Ò½º¸¦ ±¸¼ºÇÏ·Á¸é |ODBC °ü¸®ÀÚ¸¦ ½ÃÀÛÇÑ ´ÙÀ½ OLAP ¸ðµ¨ ¹× metaoutline ÀÛ¼º¿¡ »ç¿ëÇÒ |µ¥ÀÌÅÍ ¼Ò½º¿¡ ´ëÇÑ ¿¬°áÀ» ÀÛ¼ºÇØ¾ß ÇÕ´Ï´Ù. |Windows Á¦¾îÆÇ¿¡¼ ODBC °ü¸®ÀÚ À¯Æ¿¸®Æ¼¸¦ ½ÇÇàÇϽʽÿÀ. |´ÙÀ½ ¿¹´Â DB2 µ¥ÀÌÅÍ ¼Ò½º¸¦ ÀÛ¼ºÇÕ´Ï´Ù. ´Ù¸¥ RDBMS¿¡¼´Â ´ëÈ »óÀÚ°¡ ´Ù¸¨´Ï´Ù.
|ODBC °ü¸®ÀÚ¸¦ »ç¿ëÇÏ¿© °ü°èÇü µ¥ÀÌÅÍ ¼Ò½º¸¦ ±¸¼ºÇÏ·Á¸é ´ÙÀ½ ´Ü°è¸¦ ¿Ï·áÇϽʽÿÀ. |
|Customers, products, markets
|´ÙÀ½ ´Ü¾î¸¦ ÀÔ·ÂÇÏ¿© »ùÇà ÀÀ¿ëÇÁ·Î±×·¥ÀÇ µ¥ÀÌÅͺ£À̽º¸¦ ¼³¸íÇÒ ¼ö ÀÖ½À´Ï´Ù.
|Sample relational data source
|OLAP Starter Kit µ¥½ºÅ©Å¾¿¡¼ ¿¬°áÇÒ ¶§ ÀÌ·¯ÇÑ ¼³¸íÀ» º¸°í ¼±ÅÃÇÑ Ç׸ñ¿¡ »ç¿ë °¡´ÉÇÑ µ¥ÀÌÅÍ ¼Ò½º¸¦ ½Äº°ÇÒ ¼ö ÀÖ½À´Ï´Ù.
|µ¥ÀÌÅÍ ¼Ò½ºÀÇ ±¸¼º Á¤º¸¸¦ ÆíÁýÇÏ·Á¸é |
|Windows NT³ª Windows 2000¿¡¼ OLAP ¸ÞŸµ¥ÀÌÅÍ Ä«Å»·Î±×¸¦ ±¸¼ºÇÏ·Á¸é |ODBC °ü¸®ÀÚ¸¦ ½ÃÀÛÇÑ ´ÙÀ½ OLAP ¸ÞŸµ¥ÀÌÅÍ Ä«Å»·Î±× µ¥ÀÌÅͺ£À̽º°¡ Æ÷ÇÔµÈ µ¥ÀÌÅÍ ¼Ò½º¿¡ ´ëÇÑ |¿¬°áÀ» ÀÛ¼ºÇϽʽÿÀ.
|´ÙÀ½ ¿¹´Â DB2 µ¥ÀÌÅÍ ¼Ò½º¸¦ ÀÛ¼ºÇÕ´Ï´Ù. ´Ù¸¥ RDBMS¿¡¼´Â ´ëÈ »óÀÚ°¡ ´Ù¸¨´Ï´Ù. |OLAP ¸ÞŸµ¥ÀÌÅÍ Ä«Å»·Î±×¿ë µ¥ÀÌÅÍ ¼Ò½º¸¦ ÀÛ¼ºÇÏ·Á¸é ´ÙÀ½ ´Ü°è¸¦ ¿Ï·áÇϽʽÿÀ. |
|OLAP Catalog first
|´ÙÀ½ À̸§À» ÀÔ·ÂÇÏ¿© »ùÇà ÀÀ¿ëÇÁ·Î±×·¥ÀÇ OLAP ¸ÞŸµ¥ÀÌÅÍ Ä«Å»·Î±× µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áÇÑ´Ù´Â |°ÍÀ» ³ªÅ¸³¾ ¼ö ÀÖ½À´Ï´Ù.
| TBC_MD
|My first models and metaoutlines
|´ÙÀ½ ´Ü¾î¸¦ ÀÔ·ÂÇÏ¿© »ùÇà ÀÀ¿ëÇÁ·Î±×·¥ÀÇ OLAP ¸ÞŸµ¥ÀÌÅÍ Ä«Å»·Î±× |µ¥ÀÌÅͺ£À̽º¸¦ ¼³¸íÇÒ ¼ö ÀÖ½À´Ï´Ù.
|Sample models and metaoutlines
|ÀÌ ¼³¸íÀ» º¸°í OLAP Starter Kit µ¥½ºÅ©Å¾¿¡¼ OLAP ¸ÞŸµ¥ÀÌÅÍ Ä«Å»·Î±×¿¡ |¿¬°áÇÒ ¶§ ¼±ÅÃÇÒ Ä«Å»·Î±×¸¦ ½±°Ô ½Äº°ÇÒ ¼ö ÀÖ½À´Ï´Ù.
|µ¥ÀÌÅÍ ¼Ò½ºÀÇ ±¸¼º Á¤º¸¸¦ ÆíÁýÇÏ·Á¸é |
|°ü°èÇü µ¥ÀÌÅÍ ¼Ò½º¿Í OLAP ¸ÞŸµ¥ÀÌÅÍ Ä«Å»·Î±×¸¦ ±¸¼ºÇßÀ¸¸é OLAP Starter Kit¿¡¼ |°ü°èÇü µ¥ÀÌÅÍ ¼Ò½º¿Í OLAP ¸ÞŸµ¥ÀÌÅÍ Ä«Å»·Î±×¿¡ ¿¬°áÇÒ ¼ö ÀÖ½À´Ï´Ù. |¿¬°áÇÑ ´ÙÀ½ OLAP ¸ðµ¨°ú metaoutlineÀ» ÀÛ¼º, ¼öÁ¤, ÀúÀåÇÒ ¼ö ÀÖ½À´Ï´Ù.
|SQL Server µ¥ÀÌÅͺ£À̽º¸¦ È£ÃâÇÏ´Â µ¿¾È SQL Server ODBC µå¶óÀ̹ö°¡ ½Ã°£Á¾·áµÉ ¼ö ÀÖ½À´Ï´Ù. |µ¥ÀÌÅͺ£À̽º°¡ »ç¿ë ÁßÀÌÁö ¾ÊÀ¸¸é ´Ù½Ã ½ÃµµÇϽʽÿÀ. |µå¶óÀ̹ö ½Ã°£Á¾·á ½Ã°£À» ´Ã·Á ÀÌ ¹®Á¦¸¦ ¹æÁöÇÒ ¼ö ÀÖ½À´Ï´Ù. |ÀÚ¼¼ÇÑ Á¤º¸´Â »ç¿ë ÁßÀÎ µå¶óÀ̹öÀÇ ODBC ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ.
|ODBC ¿¬°á ¹®Á¦Á¡ ¹× ¼Ö·ç¼Ç¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸´Â OLAP Integration Server ½Ã½ºÅÛ °ü¸®ÀÚ ¾È³»¼¸¦ ÂüÁ¶ÇϽʽÿÀ.