Connect to the Ferdia Data Warehouse

← Back to overview

Connection details

Replace placeholders above with your actual environment values.

Power BI Desktop

  1. Open Power BI Desktop and go to Home → Get data → More, then choose ODBC.
    Power BI: Home ribbon with Get Data and ODBC option
  2. Select your configured Ferdia Data Warehouse ODBC data source (DSN) and click OK.
    Power BI: From ODBC dialog showing available DSNs
  3. In the Navigator, browse to ferdia_dw_production/public and select the tables you need.
    Power BI: Navigator with schemas and tables listed
  4. Choose Load (or Transform Data) to bring the data into your report model.
    Power BI: Load data buttons and preview
  5. Choose Load (or Transform Data) to bring the data into your report model.
    Power BI: Load data buttons and preview

Optional advanced: enable query folding and set privacy levels to optimize performance.

Microsoft Excel

  1. Install the Amazon Redshift ODBC driver appropriate for your system. After installation, restart Excel.
  2. Open ODBC Data Sources from the start-button.
    ODBC Data Sources: System DSN tab with Add button
  3. Click Add to create a new data source.
    ODBC: Select Amazon Redshift ODBC driver dialog
  4. Select the Amazon Redshift ODBC Driver from the list and proceed.
    ODBC: Configure DSN with server, port, database, username, password
  5. Enter the Ferdia Data Warehouse details, and your username/password).
    ODBC: Connection test succeeded message
  6. Open Excel and navigate to Data → Get Data → From Other Sources → From ODBC to start a new connection.
    Excel: Data tab with Get Data menu highlighted
  7. Select your configured Ferdia Daatawarehouse ODBC connection.
    Excel: Choose data source dialog showing database options
  8. You can now browse all the available data-tables, found under "ferdia_dw_production/public", select the tables you need.
    Excel: Connection dialog with Server and Database fields
  9. You can now load the data to a Sheet or PivotTable.
    Excel: Navigator window with tables selected for load

SQL clients (Azure Data Studio / SSMS / DBeaver)

  1. Create a new connection.
  2. Set Host, Port, and Database from the details above.
  3. Select the correct Driver (e.g., SQL Server, PostgreSQL, etc.).
  4. Choose Authentication and connect.

Example query:

SELECT TOP 100 *
FROM dbo.SampleTable
ORDER BY 1;

Troubleshooting