ãã® ã·ãªãŒãºã®ããŒã1 ã§ã¯ãAmazon Q BusinessãšAmazon Bedrockã®åãçµã¿åãããŠãSAP Early Watch Reportsããå®çšçãªã€ã³ãµã€ããåŸãæ¹æ³ãããã³Business Data Automationã䜿çšããIntelligent Document ProcessingãSAPã·ã¹ãã ã®è«æ±æžããŒã¿åŠçã«äœ¿çšããæ¹æ³ãæ€èšããŸããããã®æçš¿ã§ã¯ãAmazon Bedrock Knowledge Bases for Structured Dataã䜿çšããŠãSAPããŒã¿ã«é¢ãã質åã«èªç¶èšèªåœ¢åŒã§åçããæ¹æ³ã宿ŒããŸãã èªç¶èšèªã䜿çšãã財åããŒã¿åæ ãã£ããããŒã¹ã®ã€ã³ã¿ãŒãã§ãŒã¹ã¯ãå¶æ¥ããŒã ãšãªãŒããŒã·ããã«è¿
éã§å®çšçãªã€ã³ãµã€ããæäŸã§ããŸãã売äžãšäºæž¬ããŒã¿ãžã®ã¢ã¯ã»ã¹ãšåæã容æã«ããããšã§ãçµç¹ã¯ããæ
å ±ã«åºã¥ããæææ±ºå®ãè¡ããåžå Žã®å€åã«ããè¿
éã«å¯Ÿå¿ããè€éãªããŒã¿åŠçãã©ãããã©ãŒã ãåŠã¶å¿
èŠãªããæçµçã«ããè¯ãå¶æ¥ããã©ãŒãã³ã¹ãæšé²ã§ããŸãã å¶æ¥ããã©ãŒãã³ã¹ã補åã€ã³ãµã€ããå¶æ¥äºæž¬ãå°åæ¯èŒãªã©ã®æ
å ±ã¯ãæ§é åããŒã¿çšAmazon Bedrock Knowledge Basesã䜿çšããŠè¿
éã«å©çšå¯èœã«ã§ããããŒã¿ã®äŸã§ãããã®ãŠãŒã¹ã±ãŒã¹ã§ã¯ãAmazon Bedrock Knowledge Bases for Structure Dataã䜿çšããŠãäŒè©±ã€ã³ã¿ãŒãã§ãŒã¹ã䜿çšããŠããŒã¿ãžã®ã€ã³ãµã€ããè¿
éã«æäŸããæ¹æ³ã瀺ããŸãã SQLããŒã¿çšã®æ§é åãã¬ããžããŒã¹ã¯ãç®çãšå®è£
ã®äž¡æ¹ã«ãããŠåŸæ¥ã®RAGïŒRetrieval Augmented GenerationïŒãšã¯ç°ãªããŸããRAGã¯äž»ã«LLMã¬ã¹ãã³ã¹ãæ¡åŒµããããã«éæ§é åããã¹ãã®é¢é£ãã£ã³ã¯ãååŸããããšã«çŠç¹ãåœãŠãŠããã®ã«å¯ŸããSQLããŒã¿çšã®æ§é åãã¬ããžããŒã¹ã¯ãããŒã¿ããŒã¹ã¹ããŒããããŒãã«ãããã³ãããã®çžäºæ¥ç¶ã«é¢ããæç€ºçãªé¢ä¿ãããžãã¹ã«ãŒã«ãã¡ã¿ããŒã¿ãç¶æããŸãããã®æ§é ã«ãããéçšããŒã¿ã®ããæ£ç¢ºã§ä¿¡é Œæ§ã®é«ãã¯ãšãªãå¯èœã«ãªããRAGã®ç¢ºççæ§è³ªãé©åã§ãªã財åèšç®ãåšåº«æ°ãå¶æ¥ææšãªã©ã®åéã§ä¿èšŒããã粟床ãæäŸããŸãã SQLããŒã¿çšã®æ§é åãã¬ããžããŒã¹ã䜿çšããäž»ãªå©ç¹ã¯ãèªç¶èšèªã¢ã¯ã»ã¹ãæäŸããªããããŒã¿ã®æŽåæ§ãšããžãã¹ããžãã¯ãç¶æã§ããããšã§ããRAGã¯ããã¥ã¡ã³ããéæ§é åã³ã³ãã³ãããã®ã³ã³ããã¹ãæäŸã«åªããŠããŸãããæ§é åãã¬ããžããŒã¹ã¯ãéçšããŒã¿ã«ãšã£ãŠéèŠãªããŒãã«é¢ä¿ãããŒã¿åãããžãã¹ã«ãŒã«ãå°éããŠãã¯ãšãªãæ£ããSQLã«å€æãããããšãä¿èšŒããŸããããã«ãERPããŒã¿ã«ã¯å€§ããªããŒã¿ã»ãããå«ãŸããŠãããåŸæ¥ã®RAGæè¡ã䜿çšãããšæ§èœãã³ã¹ãå¹çãè¯ããªãå ŽåããããŸãããã¿ãã€ãèŠæš¡ã®åæããµããŒãããAmazon Redshiftã«ããŒã¿ãä¿åããããšã§ã倧éã®ããŒã¿ããªã¥ãŒã ã«ã¢ã¯ã»ã¹ããBedrockã§å©çšå¯èœãªéžæããLLMã«ãã£ãŠåæã§ããŸãã SAP DatasphereãSAP SLTãAWS GlueãããŒãããŒãœãªã¥ãŒã·ã§ã³ãªã©ãSAPãæäŸããæè¡ã䜿çšããŠãSAPãŸãã¯ä»ã®ERPã·ã¹ãã ããAmazon Redshiftã«ããŒã¿ãç§»åããŠããŒã¿åæãè¡ãããã®ããã€ãã®ãªãã·ã§ã³ããããŸãã詳现ã«ã€ããŠã¯ã AWSäžã®SAPããŒã¿çµ±åãšç®¡çã®ã¬ã€ãã³ã¹ ãåç
§ããŠãã ããã æ³šïŒ ãã®ããã°ã§ã¯ãApache 2.0ã©ã€ã»ã³ã¹ã®äžã§GitHubã§ SAPãå
¬éããèªè»¢è»è²©å£²ãµã³ãã«ããŒã¿ ã䜿çšããŸããããã«ã¯ãåæã®ããã«S3ã«ããŒããããèªè»¢è»è²©å£²ããŒã¿ã®äŸãå«ãŸããŠããŸãããªã¢ã«ã¿ã€ã ããŒã¿æŽæ°ãæå¹ã«ããããã«ãS3ã®æ
å ±ã¯ããã® AWSããã° ã§èª¬æãããŠããããã«ãèªåã³ããŒã䜿çšããŠåã蟌ãããšãã§ããŸãã ãšã³ã¿ãŒãã©ã€ãºãããã€ã¡ã³ãã®å Žåãããžãã¹ã³ã³ããã¹ããããè¯ãä¿æããããã«ãAmazon Redshiftã«ããŒãããåã« Amazon S3ãžã®çµ±åã«SAP Datasphere ã®äœ¿çšãæ€èšããŠãã ãããSAP Datasphereã¯SAP Business Technology PlatformãšSAP Business Data Cloudã®äžéšãšããŠå©çšã§ããã©ã¡ããAWSäžã§å®è¡ãããŸãã ã¢ãŒããã¯ã㣠å³1ã¯ãœãªã¥ãŒã·ã§ã³ã®ã¢ãŒããã¯ãã£å³ã瀺ããŠããããã®ã»ã¯ã·ã§ã³ã§ã¯ãããæ§ç¯ããæé ã瀺ããŸãïŒ ããŒã¿ã¯ãã奜ã¿ã®çµ±åãœãªã¥ãŒã·ã§ã³ã䜿çšããŠSAPããS3ã«ã³ããŒãããŸãããã®å ŽåãSAPãå
¬éããBike SalesããŒã¿ã䜿çšããŸãã ããŒã¿ã¯Amazon RedshiftããŒã¿ãŠã§ã¢ããŠã¹ã«ã³ããŒãããŸãã æ§é åããŒã¿çšAmazon Bedrock Knowledge Baseãèšå®ããŸãã ãŠãŒã¶ãŒã¯ãæ£ç¢ºãªæ
å ±æ€çŽ¢ã®ããã«SQLãçæããããã«ãã奜ã¿ã®BedrockãæŽ»çšããŸãã çæãããSQLã¯ãBedrockãã¬ããžããŒã¹ã«ãã£ãŠèª¿æŽããããªã¢ã«ã¿ã€ã æ
å ±ãšã¹ã±ãŒã©ããªãã£ã®ããã«Amazon Redshiftã§å®è¡ãããŸãã ã¢ãã«ã¯ãã¯ãšãªã®çµæã䜿çšããŠããªã¯ãšã¹ãã«åºã¥ããŠãŠãŒã¶ãŒã«ã€ã³ãµã€ããèŠçŽãæäŸããŸããã³ã³ããã¹ããç¶æãããããããŠãŒã¶ãŒã¯äŒè©±åœ¢åŒã§æ
å ±ã詳ãã調ã¹ãããšãã§ããŸãã å³1: çæAIã䜿çšããæ§é åããŒã¿åæã®ã¢ãŒããã¯ã㣠ããã»ã¹ ããã§æŠèª¬ãããŠããæé ã«åŸãããšã§ãAmazon RedshiftããŒã¿ããŒã¹ãäœæããBedrockãã£ããã€ã³ã¿ãŒãã§ãŒã¹ã䜿çšããŠçµæãã¯ãšãªã§ããŸãã S3ãžã®ããŒã¿ããŒã Amazon S3ãã±ãããäœæãïŒãã®å Žåããã±ãããkb-structured-data-bike-salesãšåŒã³ãŸãããååã¯äžæã§ããå¿
èŠããããŸãïŒãå³2ã«ç€ºãããã«ãUploadãã¿ã³ãéžæãâAdd FilesâãéžæããŠã ãµã³ãã«ããŒã¿ãã¡ã€ã« ïŒåèš9ãã¡ã€ã«ã§ããå¿
èŠããããŸãïŒãS3ãã±ããã«ã¢ããããŒãããŸãã å³2: S3ãã±ããã§ã®SAPãµã³ãã«ããŒã¿ã®ä¿å æ³šïŒ ãµã³ãã«ãã¡ã€ã«Employees.csvã«ã¯ã以äžã«ç€ºãããã«ããã€ãã®ç©ºçœã®ååããããŸããããããããããŒãšããŒã¿è¡ã§åé€ããŠãããç°¡åã«ã€ã³ããŒãã§ããããã«ããããã«ããæ°ã«å
¥ãã®ãšãã£ã¿ãŒã䜿çšããŠãã ããããŸããããæè¿ã®æ
å ±ãæç€ºããããã«ãµã³ãã«ããŒã¿ãæŽæ°ããããšãã§ããŸãã EMPLOYEEID,NAME_FIRST,NAME_MIDDLE,NAME_LAST,NAME_INITIALS,SEX,LANGUAGE,PHONENUMBER,EMAILADDRESS,LOGINNAME,ADDRESSID,VALIDITY_STARTDATE,VALIDITY_ENDDATE,,,,,, 0000000001,Derrick,L,Magill,,M,E,630-374-0306,derrick.magill@itelo.info,derrickm,1000000001,20000101,99991231,,,,,, 0000000002,Philipp,T,Egger,,M,E,09603 61 24 64,philipp.egger@itelo.info,philippm,1000000002,20000101,99991231,,,,,, 0000000003,"Ellis",K,Robertson,,M,E,070 8691 2288,ellis.robertson@itelo.info,ellism,1000000003,20000101,99991231,,,,,, 0000000004,William,M,Mussen,,M,E,026734 4556,william.mussen@itelo.info,williamm,1000000004,20000101,99991231,,,,,, SAPããŒã¿ãšéSAPããŒã¿ã®çµå ãã®æ®µéã§ãSAPããŒã¿ãä»ã®ããžãã¹ãœãŒã¹ããã®éSAPé¢é£ããŒã¿ãšçµã¿åãããããšãã§ãããããçæAIæè¡ã䜿çšããçµ±åãšã³ã¿ãŒãã©ã€ãºã®äŸ¡å€ã§ãã ã¯ãšãªã®å®¹æãã®ããã«Amazon RedshiftããŒã¿ãŠã§ã¢ããŠã¹ã«ããŒã¿ãããŒã S3ããRedshiftã«ããŒã¿ã远å ããã«ã¯ãæ¬¡ã®æé ã«åŸããŸãïŒ Amazon Redshiftã«ç§»åãããµãŒããŒã¬ã¹åå空éãäœæããŸãããã®äŸã§ã¯ãdefault-workgroupãšåå空éã䜿çšããŸãã Redshift Query Editorã«ã¢ã¯ã»ã¹ããã«ã¯ãAmazon Redshiftã®ã³ã³ãœãŒã«ããQuery DataãéžæããŸããããã«ããRedshiftã¯ãšãªãšãã£ã¿ãŒã«ç§»åããŸã ã¯ãšãªãšãã£ã¿ãŒãããå³3ã«ç€ºãããã«Create > DatabaseãéžæããŸã å³3: ã¯ãšãªãšãã£ã¿ãŒç»é¢ããRedshiftããŒã¿ããŒã¹ãäœæ âcreate databaseâãã©ãŒã ã䜿çšããŠããŒã¿ããŒã¹ãäœæããŸãïŒãã®ããã°ã§ã¯ãbike_salesãšããååã䜿çšããRedshift serverlessã䜿çšããŠããŸãïŒ å.csvãã¡ã€ã«ã«ã€ããŠãbike_salesããŒã¿ããŒã¹ã«å¯Ÿå¿ããããŒãã«ãäœæããŸããããŒãã«ãäœæãã1ã€ã®ã¹ãããã§ããŒã¿ãããŒãããã«ã¯ãâLoad Dataâãã¿ã³ãéžæããããšããå§ããŸã âLoad from S3 BucketâãšâBrowse S3â³ãéžæããŠãé©åãªãã¡ã€ã«ãéžæããŸã ããŒã¿ãã¡ã€ã«ã«ã¯YYYYMMDD圢åŒã䜿çšããDATE圢åŒãå«ãŸããŠãããããã¯æŽæ°å€ãšããŠèª€ã£ãŠèªåæ€åºãããå¯èœæ§ããããŸãããããä¿®æ£ããã«ã¯ãå³4ã«ç€ºãããã«âData Conversion Parametersâãã¿ã³ãéžæããå³5ã«ç€ºãããã«ããŒã¿åœ¢åŒã倿ŽããŸãïŒç©ºçœå€ã«å¯Ÿå¿ããããã«âAccept any dateâãéžæããå¿
èŠãããå ŽåããããŸãïŒ å³4: æ¥ä»åœ¢åŒã®ããŒã¿å€æãã©ã¡ãŒã¿ã®äœ¿çš å³5: æ¥ä»åœ¢åŒå€æŽãªãã·ã§ã³ NextãéžæããŠLoad dataã¹ã¯ãªãŒã³ã«é²ã¿ãŸã âLoad new tableâãéžæããŠã.csvããããŒæ
å ±ã«åºã¥ããŠæ°ããããŒãã«ãäœæããŸããå³6ã«ç€ºãããã«ãããããããŠã³ããé©åãªã¯ãŒã¯ã°ã«ãŒããããŒã¿ããŒã¹ãã¹ããŒããéžæãã.csvãã¡ã€ã«åã«åŸã£ãŠããŒãã«ã«ååãä»ããŸã å³6: Redshiftãžã®ããŒãã«ããŒã ããŒã¿ãã£ãŒã«ãã®ããŒã¿åãâDATEâããŒã¿åã«å€æŽããŸãïŒããŒã¿åããªãåãããå Žåã¯ãVARCHARãéžæã§ããŸãïŒ âCreate TableâãšâLoad DataâãéžæããŠãããŒãã«ãäœæãããŒã¿ãããŒãããŸã ããŒãã«åãå³ã¯ãªãã¯ããâSelect tableâãªãã·ã§ã³ãéžæããããšã§ãããŒãã«ãæ£ããäœæãããããšãæ€èšŒããŸããããã«ãããselect * from âbike_salesâ. âpublicâ. âaddressesâãªã©ã®ã¯ãšãªãèªåçã«äœæãããŸã ä»ã®ããŒãã«ã«ã€ããŠããã®ããã»ã¹ãç¹°ãè¿ããŸããå®äºãããšã9ã€ã®ãã¡ã€ã«ãã¹ãŠãRedshiftã«ãããAmazon Bedrockã§äœ¿çšã§ããããã«ãªããŸã Amazon Bedrockã«ç§»åããå·Šããã«ããKnowledge BasesãéžæããŸã å³7ã«ç€ºãããã«ãCreateãéžæããæ¬¡ã«Knowledge Base with structured data storeãéžæããŸã å³7: æ§é åããŒã¿ã¹ãã¢ãªãã·ã§ã³ä»ãAmazon Bedrock Knowledge Bases Knowledge Baseã«ååãä»ããããŒã¿ãœãŒã¹ãšããŠAmazon RedshiftãéžæããŸã IAMæš©éã«ã€ããŠã¯ãâCreate and use a new service roleâãéžæããŸã Nextãã¯ãªãã¯ãããããã€ã¡ã³ãã«äžèŽããQuery Engineã®è©³çްãéžæããŸãïŒãã®äŸã§ã¯redshift serverlessïŒ ã¹ãã¬ãŒãžã¡ã¿ããŒã¿ã«ã€ããŠã¯ãäœæããããŒã¿ããŒã¹ïŒãã®äŸã§ã¯bike_salesïŒãéžæããNextãéžæããŸã ãµãŒãã¹ããŒã«ãã¡ã¢ããâCreate Knowledge BaseâãéžæããŸã ãµãŒãã¹ããŒã«ã«å¯Ÿå¿ããRedshiftãŠãŒã¶ãŒã远å Redshiftã³ã³ãœãŒã«ã«ç§»åããåã®ã¹ãããã®ãµãŒãã¹ããŒã«ã§ãŠãŒã¶ãŒãäœæããããã«æ¬¡ã®ã³ãã³ãã䜿çšããŸã: create user "IAMR:AmazonBedrockExecutionRoleForKnowledgeBase<XXXXX>" with password disable; ã³ãã³ããgrant select on all tables in schema âpublicâ to IAMR:AmazonBedrockExecutionRoleForKnowledgeBase<XXXXX>ãã䜿çšããŠIAMãµãŒãã¹ããŒã«ã«æš©éãä»äžããŸã ãã³ã: IAMããŒã«ã®èšå®ã«é¢ãã远å ã®è©³çްãšãã¹ããã©ã¯ãã£ã¹ã¯ ãã¡ãã«ææžåãããŠããŸã ã Query Engineã®åæ Amazon Bedrock Knowledge Baseã«æ»ããå³8ã«ç€ºãããã«åæãã¿ã³ã䜿çšããŸããåæã«ã¯æ°åããããã¹ããŒã¿ã¹ããCOMPLETEããšè¡šç€ºãããŸã å³8: ãã¬ããžããŒã¹ã®åæ åºç€ã¢ãã«ã䜿çšããèªç¶èšèªã«ããããŒã¿åæ ããã§ãéžæããåºç€ã¢ãã«ã§ãã®ãã¬ããžããŒã¹ã䜿çšããæºåãæŽããŸãããå³9ã«ç€ºãããã«ãäœæããKnowledge Baseãéžæããã¢ãã«ãéžæããããšããå§ããŸãã å³9: éžæããåºç€ã¢ãã«ã§Redshiftãã¬ããžããŒã¹ãäœ¿çš ãã³ã: ç§ãã¡ã®ãã¹ãã§ã¯ããAmazon NovaããšãAnthropic ClaudeãSonnetã¢ãã«ããã®åæã«é©ããŠããŸãã å³10ã®ã¹ã¯ãªãŒã³ãã£ããã£ã¯ãåºç€ã¢ãã«ããã®è³ªåãšçµæã®äŸã瀺ããŠããŸããã¬ã¹ãã³ã¹ãçæããããã«ããŒã¿ã»ããã§äœ¿çšãããç¹å®ã®ã¯ãšãªã衚瀺ããAmazon Bedrockã®éææ§ã®åŽé¢ã«æ³šç®ããŠãã ããã å³10 â ããŒã¿ãšã®ãã£ããã®äŸ æé©ãªãŠãŒã¶ãŒãšã¯ã¹ããªãšã³ã¹ã®ããã«è€æ°ã®ã¢ãã«ããã¹ãããRedshiftãã¬ããžããŒã¹ãããžãã¹ã¢ããªã±ãŒã·ã§ã³ã«çµ±åã§ããŸãã ãµã³ãã«ã³ã¹ãå
èš³ 次ã®è¡šã¯ãUS-EAST-1ïŒããŒãžãã¢åéšïŒãªãŒãžã§ã³ã§ããã©ã«ããã©ã¡ãŒã¿ã䜿çšããŠãç¬èªã®AWSã¢ã«ãŠã³ãã§ãã®ãœãªã¥ãŒã·ã§ã³ããããã€ããããã®ãµã³ãã«ã³ã¹ãå
èš³ãæäŸããŸãã AWSãµãŒãã¹ ãã£ã¡ã³ã·ã§ã³ ã³ã¹ãïŒUSDïŒ Amazon S3 CSVãã¡ã€ã«çšã®æé10GBã¹ãã¬ãŒãž $0.26 Amazon Redshift Serverless æé8æé/æ¥å®è¡æéã§4RPU $366.24 æ§é åããŒã¿çšAmazon Bedrock Knowledge Base å¹³åå
¥åºåããŒã¯ã³ãµã€ãº1000ã§1æ¥8æéã1åããã1ãªã¯ãšã¹ãã $259.20 ã³ã¹ãã管çããããã«ã AWS Cost Explorer ãéã㊠äºç® ãäœæããããšããå§ãããŸãã詳现ã«ã€ããŠã¯ããã®ããã°ã§äœ¿çšãããåAWSãµãŒãã¹ã®äŸ¡æ ŒããŒãžãåç
§ããŠãã ããã ãªãœãŒã¹ã®ã¯ãªãŒã³ã¢ãã ãã®ããã°ã§èšåãããŠãããµãŒãã¹ã¯ãã¢ã«ãŠã³ãå
ã®AWSãªãœãŒã¹ãæ¶è²»ãããããäžèŠã«ãªã£ãããããªãã³ã¹ããé²ãããã«ã¯ãªãŒã³ã¢ããããå¿
èŠããããŸãã以äžãåé€ããŠãã ããïŒ ããŒã¿ã¹ããŒãžã³ã°çšã«äœ¿çšãããS3ãã±ããå
ã®ãã¡ã€ã«ãšS3ãã±ããèªäœ æ§é åããŒã¿ããã¹ãããããã«äœ¿çšãããRedshiftããŒã¿ããŒã¹ æ§é åããŒã¿ã¹ãã¢çšAmazon Bedrock Knowledge Base IAMãµãŒãã¹ããŒã«ïŒãããã¯èª²é察象ã§ã¯ãããŸããããäžèŠã«ãªã£ãå Žåã¯ã¯ãªãŒã³ã¢ããããå¿
èŠããããŸãïŒ çµè«ã𿬡ã®ã¹ããã ãã®ããã°ã§ã¯ãç¹å®ã®ãŠãŒã¹ã±ãŒã¹ã䜿çšããŠSAPããŒã¿ïŒæ§é åããã³éæ§é åã®äž¡æ¹ïŒã«çæAIã䜿çšããæ¹æ³ã«ã€ããŠèª¬æããŸããããæŠå¿µã¯çµç¹ãæã€å¯èœæ§ã®ããä»ã®ãŠãŒã¹ã±ãŒã¹ã«ã転çšã§ããŸãã Amazon BedrockãšAmazon Qãããã«éå§ããã«ã¯ã AWSçæAIããŒãž ããå§ããŠãã ããã Kiro CLI ãš Amazon Bedrock Knowledge Retrieval MCPãµãŒã㌠ã䜿çšããŠã³ãã³ãã©ã€ã³ã§Knowledge BaseãçŽæ¥ã¯ãšãªããããšãã§ããŸãã仿¥è©ŠããŠã¿ãŠãã ããïŒãŸãã SAP DevOpsçšAmazon Q ã®äœ¿çšã«é¢ããæè¿å
¬éããããããªãã芧ãã ããã æ¬ããã°ã¯Amazon Bedrockã«ãã翻蚳ãè¡ããããŒãããŒSAæŸæ¬ãã¬ãã¥ãŒããŸãããåæã¯ ãã¡ã ã§ãã