Skip to main content

    Power BI

    Planned

    HP Vertica Support

    Vote (206) Share
    Daniel Scarvalone's profile image

    Daniel Scarvalone on 14 Jan 2015 05:06:12

    Adding support to connect to an HP Vertica database

    Administrator on 16 Aug 2020 02:15:30

    Thanks everyone for the feedback - We plan to release an HP Vertica connector before end of CY17. Stay tuned for more updates.

    Comments (24)
    Daniel Scarvalone's profile image Profile Picture

    Melody on 16 Aug 2020 03:51:03

    RE: HP Vertica Support

    Hello, we have a Vertica database that I want to connect to from PowerPivot. I was able to use the connection wizard and connect using the ODBC DSN data source. When it asks you to select the tables and views in the table Import Wizard, I selected three tables. But I get an error when it tries to import the data. Does anyone know what this error is and how to resolve this? Your help is greatly appreciated!!
    OLE DB or ODBC error: ERROR 4856: Syntax error at or near "[" at character 8
    ; 42601.

    An error occurred while processing table 'GamePlayLog'.

    The current operation was cancelled because another operation in the transaction failed.

    Daniel Scarvalone's profile image Profile Picture

    Sebastian YEPES FERNANDEZ on 16 Aug 2020 03:48:36

    RE: HP Vertica Support

    '+5 For this one

    Daniel Scarvalone's profile image Profile Picture

    Melody on 16 Aug 2020 03:48:09

    RE: HP Vertica Support

    Hello, we have a Vertica database that I want to connect to from PowerPivot. I was able to use the connection wizard and connect using the ODBC DSN data source. When it asks you to select the tables and views in the table Import Wizard, I selected three tables. But I get an error when it tries to import the data. Does anyone know what this error is and how to resolve this? Your help is greatly appreciated!!
    OLE DB or ODBC error: ERROR 4856: Syntax error at or near "[" at character 8
    ; 42601.

    An error occurred while processing table 'GamePlayLog'.

    The current operation was cancelled because another operation in the transaction failed.

    Daniel Scarvalone's profile image Profile Picture

    Melody on 16 Aug 2020 03:41:58

    RE: HP Vertica Support

    Hello, we have a Vertica database that I want to connect to from PowerPivot. I was able to use the connection wizard and connect using the ODBC DSN data source. When it asks you to select the tables and views in the table Import Wizard, I selected three tables. But I get an error when it tries to import the data. Does anyone know what this error is and how to resolve this? Your help is greatly appreciated!!
    OLE DB or ODBC error: ERROR 4856: Syntax error at or near "[" at character 8
    ; 42601.

    An error occurred while processing table 'GamePlayLog'.

    The current operation was cancelled because another operation in the transaction failed.