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
mina's avatar
mina
Employee
5 years ago

Awesome. For the Timestamp issue, I found the answer in SQLServer Insert snap doc. It called out:
TIMESTAMP datatype in SQL Server is not supported. According to the Microsoft official document, "The timestamp syntax is deprecated.

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.