Forum Discussion

Christophe's avatar
Christophe
New Contributor II
5 years ago

How to make a generic pipeline Oracle => SQL Server

Hello, I would like to build a generic pipeline to load data from an Oracle DB to a SQL Server DB. I have more than 100 queries to load, so I would like to be able to call the pipeline with the S...
mapper
pipeline
Christophe's avatar
Christophe
New Contributor II
5 years ago

Yes. So in SnapLogic we should have “if source field type = Timestamp then SQL Server field type = DateTime”
(but I can manage it)
Thanks.

mina's avatar
mina
Employee
5 years ago

Good idea! Replace the Timestamp in the ddl returned to DateTime on a mapper.