Skip to main content

Connecting to Arch

Arch-managed data warehouses speak the PostgreSQL wire protocol, meaning that any clients and tools that are compatible with PostgreSQL can interact with Arch, enabling seamless integration and interoperability. This allows you to use a wide variety of database clients and BI/analytics tools to connect to and interact with Arch without needing specialized connectors or configurations. For detailed instructions specific to your tools, please consult the documentation provided by the tool's vendor. Below, we provide a general guide on how to connect to Arch via ODBC on Windows.

Connecting to Arch via ODBC on Windows

Prerequisites​

  1. ODBC Driver for PostgreSQL: Ensure that you have the ODBC driver for PostgreSQL installed on your Windows machine. You can download it from the official PostgreSQL ODBC driver page.

Steps​

  1. Open ODBC Data Source Administrator:
  • Press Win + R, type odbcad32, and press Enter.
  1. Add a New Data Source:
  • In the ODBC Data Source Administrator, go to the System DSN tab and click Add.
  • Select PostgreSQL Unicode and click Finish.
  1. Configure the Data Source:
  • Data Source Name (DSN): Enter a name for your data source (e.g., Arch Data Warehouse).
  • Server: Enter the hostname or IP address of your Arch data warehouse.
  • Port: Enter the port number (default is 5432).
  • Database: Enter the name of the database you want to connect to.
  • User Name: Enter your Arch username.
  • Password: Enter your Arch password.
  1. Test the Connection:
  • Click the Test button to ensure that the connection settings are correct and that you can successfully connect to Arch.
  • If the test is successful, click Save to save the data source configuration.
  1. Using the ODBC Data Source:
  • You can now use this ODBC data source in any application that supports ODBC connections. Simply select the data source name you configured when setting up the connection.

Troubleshooting​

  • Connection Issues: Ensure that your network settings allow communication with the Arch data warehouse server.
  • Authentication Errors: Double-check your username and password.
  • Driver Issues: Ensure that the PostgreSQL ODBC driver is correctly installed and up-to-date.