Recommendation: Connecting to Vertex

swagner
swagner 🟒
in Connectors

Looking for some help - I am not an IT guy... not great with this kind of thing, so I'm looking for a recommended approach.

We're looking to pull a custom report generated in Vertex to Domo (called a Data Extract definition in Vertex). My assumption is that this is probably best accomplished via their Web Services/FTP but I honestly lack the expertise to take this further on my own.

Vertex OSeries v9 Client Utilities Users Guide.pdf


Best Answer

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟀
    Accepted Answer

    @swagner this would be a 'usual suspects' type question if you asked a TAM.

    Can Vertex automate emailing to you? (email connector)

    can Vertex set up an automated file drop? (FTP, Amazon S3 or similar storage)?


    I didn't look closlely at the documentation, but it sounds like Vertex provide a CLI (a cli presumably would allow you to gerneate a CSV locally on your machine which you could then ingest via Workbench.)

Answers

  • GrantSmith
    GrantSmith Indiana πŸ”΄

    Hi @swagner

    Looks like you might be able to use their GetFile end point to download a file from the URL however I haven’t use this product so that’s going solely off the documentation you provided. You can start there but you may need to bring in a consultant or someone more technical to complete this connection.

  • swagner
    swagner 🟒

    @jaeW_at_Onyx & @GrantSmith thank you both for the information.

Categories