Re: Datatype Transformation

2024-09-26 Thread Michael Moser
Hello Deepanshu, With an out-of-the-box installation of Apache NiFi 2.0.0-M4, NiFi creates self-signed certificates that will only work with "localhost" and https://localhost:8443/nifi If you want to use IP addresses or other domain names, you should create your own certificates. See this [1] fo

Recall: Datatype Transformation

2024-09-25 Thread Deepanshu Lodhi
deepansh...@inventia.in would like to recall the message, "Datatype Transformation".

Datatype Transformation

2024-09-25 Thread Deepanshu Lodhi
Dear all, Greetings of the Day!! I'm trying to host "Apache NiFi 2.0.0-M4" on my windows local machine with the local IP and custom port configuration, for that I'm configuring the 'nifi.properties' to define custom port and IP, in that case the server is started but browser is raising an error

RE: Datatype Transformation

2024-09-25 Thread Deepanshu Lodhi
2024 7:32 PM To: users@nifi.apache.org<mailto:users@nifi.apache.org> mailto:users@nifi.apache.org>> Subject: Re: Datatype Transformation Hello Deepanshu, I suggest you do the transformation in the query in the "QueryDatabaseTable". Using a combination of string functions sub

Re: Datatype Transformation

2024-09-25 Thread Vijay Chhipa
I'll practice your suggested approach, however I've already done it by using > "UpdateRecord" processor. > > Deepanshu > From: Dennis N Brown > Sent: Thursday, September 5, 2024 7:32 PM > To: users@nifi.apache.org > Subject: Re: Datatype Transformation >

Re: Datatype Transformation

2024-09-05 Thread Dennis N Brown
Hello Deepanshu, I suggest you do the transformation in the query in the "QueryDatabaseTable". Using a combination of string functions substring() and or date functions until you build the string you need on the MSSQL side. On Thu, Sep 5, 2024 at 4:01 AM Deepanshu Lodhi wrote: > Hi all, > > I'

Datatype Transformation

2024-09-05 Thread Deepanshu Lodhi
Hi all, I've created a simple data flow using "QueryDatabaseTable" and "PutDatabaserRecord" which transfers the data from PostgreSQL DB to MSSQLServer DB in which the datatype of datetime columns in source_db i.e., PostgreSQL table is "timestamp without time zone", which is not compatible with