Recommendation: Connecting to Vertex

swagner

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

jaeW_at_Onyx

@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.)

jaeW_at_Onyx

@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.)

GrantSmith

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

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