Recommendation: Connecting to Vertex

swagner · 2021-03-03T14:12:53+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Accepted answers

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

All comments

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)?

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.