Configure SSRS to connect to a Virtual PostgreSQL Data Interface

Perform the following steps to configure SSRS to connect to a virtual PostgreSQL data interface:
  1. Click here to navigate to the
    Microsoft
     Report Builder download page.
    Alternatively, you can paste the following URL in your browser's address bar and press
    Enter
    .
    https://www.microsoft.com/en-us/download/details.aspx?id=53613
  2. Click
    Download
    .
    Click Download
    The
    ReportBuilder.msi
     file will be downloaded in the Downloads folder of your local machine.
  3. Double-click the
    ReportBuilder.msi
     file.
    The
    Microsoft Report Builder
     dialog box is displayed.
  4. Click
    Next
    .
    Microsoft Report Builder Dialog
  5. Select the
    I accept the terms in the license agreement
     option.
  6. Click
    Next
    .
    License Agreement
  7. In the
    Feature Selection
    , click
    Next
    .
    Feature Selection
  8. In the
    Default Target Server
    , click
    Next
    .
    NOTE:
    If the target server URL differs from the default, provide the new URL in the
    Default target server URL (Optional)
     box.
    Default Target Server
  9. Click
    Install
    .
    Click Install
  10. Once the installation is completed, click
    Finish
    .
    Click Finish
  11. Click here to navigate to the ODBC driver download page.
    Alternatively, you can paste the following URL in your browser's address bar and press
    Enter
    .
    https://www.postgresql.org/ftp/odbc/releases/REL-17_00_0004-mimalloc/
  12. Click
    psqlodbc-setup.exe
    .
    Click Setup File
    The
    psqlodbc-setup.exe
     file will be downloaded in the Downloads folder of your local machine.
  13. Double-click the
    psqlodbc-setup.exe
     file.
    The
    psqlodbc Setup
     dialog box is displayed.
  14. Select the
    I agree to the license terms and conditions
     checkbox.
  15. Click
    Install
    .
    Psqlodbc Setup Dialog
  16. Once the installation is completed, click
    Close
    .
    Click Close
  17. Open the
    ODBC Data Source Administrator
     from your local machine.
  18. In the
    ODBC Data Source Administrator
     dialog box, under
    User DSN
     tab, click
    Add
    .
    NOTE:
    Users can also select the
    System DSN
     tab to create a new data source.
    ODBC Data Source Administrator Dialog
  19. In the
    Create New Data Source
     dialog box, click
    PostgreSQL ANSI
    .
  20. Click
    Finish
    .
    Create New Data Source Dialog
  21. In the
    PostgreSQL ANSI ODBC Driver (psqlODBC) Setup
     dialog, perform the following actions:
    • Data Source: By default, the data source name is displayed. The user can also provide the unique name for the data source.
    • Description (Optional): Provide a description for the data source.
    • Database: The name of the project in
      FactoryTalk DataMosaix SaaS
      . For example, Check-46
    • SSL Mode: Select the
      require
       mode from the drop-down list.
    • Server:
      dm-virtualpostgres.cloud.rockwellautomation.com
       (Production URL).
    • Port: Provide the port number as
      5432
      .
    • Username: Refer to the Client ID generated while registering the application.
    • Password: Refer to the Client Secret generated while registering the application.
  22. Click
    Test
    .
    PostgreSQL ANSI ODBC Driver (psqlODBC) Setup Dialog
  23. Once the test connection is successful, the
    Connection Test
     dialog box is displayed and click
    OK
    .
    Connection Test Dialog
  24. In the
    PostgreSQL ANSI ODBC Driver (psqlODBC) Setup
     dialog box, click
    Save
    .
    Click Save
    In the
    ODBC Data Source Administrator
     dialog box, the user can view the PostgreSQL data source name.
  25. Click
    OK
    .
    ODBC Data Source Administrator Dialog
  26. Open the
    Microsoft Report Builder
     from your local machine.
  27. Right-click the
    Datasets
     from the left pane and click
    Add Dataset…
    .
    Click Add Dataset
  28. In the
    Dataset Properties
     dialog box, select the
    Use a dataset embedded in my report
     option.
  29. Click
    New
    .
    Dataset Properties
    The
    Data Source Properties
     dialog box is displayed.
  30. Select the
    Use a connection embedded in my report
     option.
  31. Select
    ODBC
     from the
    Select connection type
     drop-down list.
  32. Click
    Build
    .
    Data Source Properties Dialog
  33. In the
    Connection Properties
     dialog box, select the
    Use user or system data source name
     option and select the
    PostgreSQL30
     from the drop-down list.
  34. Click
    Test Connection
    .
    Connection Properties Dialog
  35. Once the test connection is successful, the
    Test results
     dialog box is displayed and click
    OK
    .
    Test Results
  36. In the
    Connection Properties
     dialog box, click
    OK
    .
    Connection Properties
  37. In the
    Data Source Properties
     dialog box, click
    OK
    .
    Data Source Properties
  38. Right-click the newly created datasets and click
    Query
    .
    Click Query
  39. In the
    Query Designer
     dialog box, provide the sample query and click the [] icon to run the query.
    Run Query
    Based on the query, the final data will be populated.
    Final Output
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal