Data export options

Ask the Community
1

I need to set up a system to load data to a target environment, and have 2 options, would like to know if either/both are viable, and if someone has done this or has a guide on how to get it started:

  • Loading a ODBC driver into an agent for the load (Is it possible to get it signed / how to get it signed ? *Note: it is not a jar file)

  • Doing a SQL Write through a external transform. Is it possible to do that by interacting with a JDBC driver?

Background:

  • Tried doing the load through a JDBC driver, but it fails because of a mismatch of the JDBC SQL query. Client suggested maybe ODBC is ideal for the load, or a custom SQL statement
2

It’s not clear if you went to sync data into foundry or export data from foundry to a target system. Which one is it?

3

export! I am able to ingest from this source but not export to it

4

The most flexible option available to day is the legacy export task. Unfortunately, the docs vanished and it’s in status “Sunset”.

You can try to access the docs here, if still available on your stack:
https:///workspace/documentation/product/data-connector/export-tasks

The new Exports lack configuration flexibility to tune the performance (e.g. call procedures before or after exports, set the batch size, run arbitrary sql).

Using jdbc in external transforms is not possible, to my knowledge.