Alteryx - 데이터베이스 연결하기

Version:2022.1 / Last modified: May 04, 2022

1.  알터릭스에 분석이 필요한 데이터베이스를 연결할 수 있습니다.

Connect In-DB 도구를 이용하여 기존 또는 새로운 데이터베이스와 연결할 수 있습니다.

In-Database를 사용하면 데이터를 데이터베이스 밖으로 이동시키지 않고도, 대량의 데이터 세트를 혼합 및 분석할 수 있으며, 

전통적인 분석방법에 비해 성능도 크게 향상됩니다.

 

2. In-database 연결하는 방법

https://www.youtube.com/watch?v=Amf10YUwG7M

[연결방법]

1. In Designer, drag and drop the Connect In-DB tool (located in the In-Database tool palette) onto the canvas

 

2. Select the “Manage Connections…” option to establish a new In-DB connection

3. The Manage In-DB Connections window should appear. To configure this window:

 

4. Select the Data Source/Database type from the Data Source drop-down.

• Select the Data Source/Database type from the Data Source drop-down.
• Under Connection Type, select User, System or File connection.
• For file connections, see this article: How To: Create an Alteryx In-DB Connection File
• On the server, make sure to select a System Connection. If you do not see the System option available, see this article: Unable to create System Connection/System Connection type missing. For more information about In-DB workflows on server, see this article: How to run In-DB workflows on server without using a connection file
• Under Connections, select New.
• Under Connection Name, enter a name for this connection.
• Under Driver, select the method of connection to use.
• Click the Connection String drop-down. You can choose to use an existing connection or create a new connection by clicking the New database Connection…option. You can also paste in the full connection string if you have it available.
• Repeat steps 5 and 6 for the Write tab.
• Click OK. If the connection was successful, the Choose Table or Specify Querywindow should appear.

5. The connection will now be stored in the Connection Name drop-down.

[출처]

https://www.youtube.com/watch?v=Amf10YUwG7M 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Create-an-In-Database-Connection/ta-p/17608

How To: Create an In-Database Connection

 

https://help.alteryx.com/20221/designer/connect-db-tool

Connect In-DB Tool | Alteryx Help

https://help.alteryx.com/20221/designer/database-overview

In-Database Overview | Alteryx Help