Unfortunately I don't have any example for Oracle, but see the following one (for MSSQL):
<Input mssql_datetimeoffset>
Module im_odbc
ConnectionString Driver={ODBC Driver 17 for SQL Server}; Server=MSSQL-HOST; \
Trusted_Connection=yes; Database=TESTDB
IdType integer
SQL SELECT RecordID AS id, \
CAST(LogTime AS datetime2) AS EventTime, \
DATEPART(tz, LogTime) AS TZOffset, \
Message \
FROM dbo.test1 WHERE RecordID > ?
Exec rename_field($id, $RecordID);
</Input>
You just need to find out what's the ConnectionString that suits you.
You will find info about that in the documentation provided by the ODBC driver's manufacturer.
Comments (2)
Can you please provide an example for an Oracle database specifically
Unfortunately I don't have any example for Oracle, but see the following one (for MSSQL):
You just need to find out what's the ConnectionString that suits you. You will find info about that in the documentation provided by the ODBC driver's manufacturer.
This is for your reference...
https://www.connectionstrings.com