Note
Galvanize will end support for Analytics Exchange on January 1, 2023. Learn more or upgrade to Robots.
You can connect to AX Server from Analytics. The component of AX Server you are connecting to is a Windows service called AX Connector.
To connect, you need to use a server profile, which includes connection information for the server, such as the hostname or IP address for the computer where AX Server is located, and the username and password required to access the server. If Analytics and AX Client are both installed on your computer, the required server profile is automatically created.
You can create as many server profiles as you require, but you can only connect to one server at a time. When a connection is made to a server, that server becomes the active server, and any server tables or local tables that are already open in Analytics are closed.
Analytics automatically connects to AX Server when you:
-
Open a table linked to a file on the server.
-
Link a table to a file on the server.
-
Define a new table from a server profile using the Data Definition Wizard.
Analytics automatically disconnects from AX Server when:
-
You close and exit Analytics.
-
Communications between Analytics and AX Server fail for any reason.
-
The connection to AX Server is inactive for a period of time. The server timeout value is configured on the server.
If you want to access database tables using Analytics server tables, you also need to create a database profile, which includes the information required to connect to the database, such as the database type and the user account to use to access the database. Connections to Oracle, SQL Server, and IBM DB2 are supported on Windows using database profiles.
