QueryPie Community Edition is live ๐ŸŽ‰ Get it now for free Download today!

๋ฌด๋ฃŒ๋กœ ์‹œ์ž‘ํ•˜๊ธฐ
ACP ๊ธฐ๋Šฅ

์—์ด์ „ํŠธ๋ฅผ ํ†ตํ•ด ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ ‘์†ํ•˜๊ธฐ

์—์ด์ „ํŠธ๋ฅผ ํ†ตํ•ด ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ ‘์†ํ•˜๊ธฐ

2024๋…„ 11์›” 29์ผ

์—์ด์ „ํŠธ๋ฅผ ํ†ตํ•ด ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ ‘์†ํ•˜๊ธฐ

Overview

QueryPie Agent๋ฅผ ์„ค์น˜ํ•˜๋ฉด, DataGrip, DBeaver์™€ ๊ฐ™์€ 3rd Party ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜์„ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ์›น SQL ์—๋””ํ„ฐ์™€ ํ•จ๊ป˜ ํ”„๋ก์‹œ ์—ฐ๊ฒฐ์„ ์ง€์›ํ•˜์—ฌ ๋‹ค์–‘ํ•œ ์‚ฌ์šฉ์ž ํ™˜๊ฒฝ์—์„œ๋„ ๋ฌธ์ œ์—†์ด ์ปค๋„ฅ์…˜ ์ ‘๊ทผ์„ ์ œ์–ดํ•˜๊ณ , ์ •์ฑ…์„ ์ ์šฉํ•  ์ˆ˜ ์žˆ์œผ๋ฉฐ, ๋กœ๊ทธ๋ฅผ ๋‚จ๊ธธ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

์—์ด์ „ํŠธ ์•ฑ ๋‹ค์šด๋กœ๋“œ

QueryPie Agent๋Š” Mac, Windows, Linux OS๋ฅผ ์ง€์›ํ•ฉ๋‹ˆ๋‹ค.

STEP 1 QueryPie ๋กœ๊ทธ์ธ ํ›„ ์šฐ์ธก ์ƒ๋‹จ ํ”„๋กœํ•„์„ ํด๋ฆญํ•˜์—ฌ Agent Download ๋ฒ„ํŠผ์„ ํด๋ฆญํ•ฉ๋‹ˆ๋‹ค.

STEP 2 PC ์šด์˜์ฒด์ œ์— ๋งž๋Š” ์„ค์น˜ ํŒŒ์ผ์„ ๋‹ค์šด๋กœ๋“œํ•ฉ๋‹ˆ๋‹ค.

์—์ด์ „ํŠธ๋กœ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ ‘์†ํ•˜๊ธฐ

์‚ฌ์ „ ์กฐ๊ฑด: DB ์ปค๋„ฅ์…˜ ๋ฉ”๋‰ด์—์„œ ํ•ด๋‹น ์ปค๋„ฅ์…˜์˜ Proxy Usage ์˜ต์…˜์ด ํ™œ์„ฑํ™”๋˜์–ด์•ผํ•ฉ๋‹ˆ๋‹ค.

  • Use QueryPie Registered Account: ๊ด€๋ฆฌ์ž๊ฐ€ ์ปค๋„ฅ์…˜ ์ •๋ณด ํŽ˜์ด์ง€ ๋‚ด์— ์ €์žฅํ•œ DB username / password ๊ธฐ์ค€์œผ๋กœ Proxy ์ ‘์† ์ •๋ณด๋ฅผ ์ƒ์„ฑํ•˜๋Š” ๋ฐฉ์‹์ž…๋‹ˆ๋‹ค. ์‚ฌ์šฉ์ž๋Š” Agent ๋˜๋Š” ๋ณ„๋„๋กœ ์ƒ์„ฑ๋œ Proxy Credential ์ •๋ณด๋ฅผ ์ด์šฉํ•ด Proxy ๋กœ ์ ‘์†ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

  • Use Existing Database Account with Agent: ์‚ฌ์šฉ์ž๊ฐ€ ๊ธฐ์กด์— ์‚ฌ์šฉํ•˜๋˜ DB username / password ๋ฅผ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๋Š” ๋ฐฉ์‹์œผ๋กœ Proxy ์ ‘์† ์ •๋ณด๊ฐ€ ์ƒ์„ฑ๋ฉ๋‹ˆ๋‹ค. ์‚ฌ์šฉ์ž๋Š” Agent ์—์„œ ์‹คํ–‰ ํ›„ localhost ์™€ port ์ •๋ณด๋ฅผ ์ด์šฉํ•ด Proxy ๋กœ ์ ‘์†ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

STEP 1 QueryPie Host ์ž…๋ ฅ๋ž€์— QueryPie URL์„ ์ž…๋ ฅํ•˜๊ณ  Next ๋ฒ„ํŠผ์„ ํด๋ฆญํ•ฉ๋‹ˆ๋‹ค.

STEP 2 ์›น ๋ธŒ๋ผ์šฐ์ €๊ฐ€ ์—ด๋ฆฌ๋ฉด, ๋กœ๊ทธ์ธ ํŽ˜์ด์ง€์—์„œ ์ธ์ฆ์ •๋ณด๋ฅผ ์ž…๋ ฅํ•˜๊ณ , Continue ๋ฒ„ํŠผ์„ ํด๋ฆญํ•ฉ๋‹ˆ๋‹ค.

STEP 3 ๋กœ๊ทธ์ธ์„ ์„ฑ๊ณตํ•˜๋ฉด ์•„๋ž˜์™€ ๊ฐ™์ด ๋กœ๊ทธ์ธ ์„ฑ๊ณต ํ™”๋ฉด์ด ํ‘œ์‹œ๋˜๋ฉฐ ์ดํ›„ Agent๋กœ ๋Œ์•„๊ฐ‘๋‹ˆ๋‹ค.

STEP 4 Agent ์•ฑ ๋‚ด Databases ํƒญ์—์„œ ๊ถŒํ•œ ์žˆ๋Š” ์ปค๋„ฅ์…˜๋“ค์˜ ์ ‘์† ์ •๋ณด๋ฅผ ํ™•์ธํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

  • ์ ‘์†ํ•  ์ปค๋„ฅ์…˜์— ํ• ๋‹น๋œ Port ๋ฅผ ํด๋ฆญํ•˜๋ฉด, ํ•ด๋‹น ์ปค๋„ฅ์…˜์˜ Proxy Credentials ์ •๋ณด๋ฅผ ํ™•์ธํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

STEP 5 ์ ‘์† ์ •๋ณด๋ฅผ 3rd Party ํด๋ผ์ด์–ธํŠธ์— ์ž…๋ ฅํ•˜๋ฉด DB ์ปค๋„ฅ์…˜ ์ ‘์†์ด ๊ฐ€๋Šฅํ•ฉ๋‹ˆ๋‹ค.

์—์ด์ „ํŠธ๋ฅผ ํ†ตํ•ด ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ ‘์†ํ•˜๊ธฐ | QueryPie