Support for External loader

[bhardwajankita07]

Hi Team,

Does Ateryx support External loader?

Regards,

Ankita

[ChristineB]

Hi @bhardwajankita07, 

Could you provide a bit more information as to the specific loader you're interested in, or the the database to which you're trying to write?  

Thanks, 

----------------------------------------

Christine

Customer Support Engineer

[bhardwajankita07]

 Hi Christine,

Example  implementation of bulk load in other ETl  is done either

-> By directly calling a vendor ’s bulk load API or

-> Generating the control and matching data file for batch input processing or

-> By calling external procedure

How do we implement this in alteryx using some external entity.

Regards,

Ankita

[bhardwajankita07]

Hi Christine,

Example  implementation of bulk load in other ETl  is done either

-> By directly calling a vendor ’s bulk load API or

-> Generating the control and matching data file for batch input processing or

-> By calling external procedure

How do we implement this in alteryx using some external entity.

Regards,

Ankita

[ChristineB · Accepted solution]

@bhardwajankita07: It may be helpful to know that Alteryx does support a few bulk loaders (Oracle, SQL Server, Teradata and Redshift) as part of the standard Output tool and In-DB Data Stream In tool.  If you’re looking into one of these particular platforms, take a look at the documentation for configuration specifications. 

Alteryx also supports Stored Procedures.  Unfortunately, this capability is only supported for Microsoft SQL Server, but I’ve seen other posts requesting that this capability be extended to other platforms, like Oracle.  If applicable, I’d encourage you to add your support for this enhancement to this discussion as well!

[bhardwajankita07]

Thanks Christine :)

[ChristineB]

Not a problem!  Glad that information was helpful!