3
responses

Good day Family

I have a problem with nxlog on Linux, I am having difficulties pulling records from an oracle DB using the agent.
Has anyone done it before?

Please help

AskedAugust 5, 2020 - 5:40pm

Comments (2)

  • manuel.munoz's picture
    (NXLog)

    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.

    This is for your reference...

    https://www.connectionstrings.com

Answer (1)