Skip to main content
Version: v2

Excel connect Canner Enterprise

This article will tell you how to get data from Excel to Canner Enterprise.

Install and configure ODBC

Before connecting, you need to install PostgreSQL ODBC Driver on your computer and set ODBC parameters.

Step 1: Install ODBC Driver

First, go to the msi folder in the download point of the official PostgreSQL website, look for the 13_02 version, and download psqlodbc_13_02_0000-x64.zip.

Please refer to this link -> PostgreSQL MSI Download Page

pg-excel-download-site

After downloading: Unzip and execute the MSI file. Follow the steps and default options of the installation wizard. Execute the installation.

pg-excel-extract

pg-excel-odbc-wizard

Step 2: Set ODBC Data Sources

In the menu, search for odbc, find ODBC Data Sources (64-bit), and execute it with administrator privileges.

pg-excel-find-odbc

Select System DSN, click Add

pg-excel-create-ds

Find PostgreSQL Unicode(x64) in the menu, click Finish and fill in the following parameters.

pg-excel-create-ds-save

  • Data Source: The name of the data source, such as Canner
  • Database: Fill in the SQL Name of the workspace
  • Server: fill in the Host or IP address of Canner Enterprise
  • User Name: fill in canner
  • SSL Mode: If the deployed Canner Enterprise does not use SSL, select disabled
  • Port: usually 7432; if there is a particular port setting, please update this field
  • Password: fill in Personal Access Token

Finally click Save to save

Connect to Canner Enterprise from Excel

Step 1: Get Data

From the menu, select Get Data -> From Other Sources -> From ODBC

pg-excel-find-import-odbc

In the pop-up window, in the field Data Source Name (DSN), select the name of the data source set in ODBC Setup Steps.

pg-excel-canner-odbc

Fill in the User name and password.

pg-excel-canner-odbc-cred

  • User Name: fill in canner
  • Password: fill in Personal Access Token

After clicking Connect, the connection will start. Select the data in the Navigator to connect.

pg-excel-nav

Finish

You will see that Excel will import the data into one of the sheets, and you can use the advanced functions of Excel to analyze the imported data.

pg-excel-sheet

pg-excel-pivot-table