Data Sources Q&A

Hi,I am trying to import data from a Oracle db and need a datefilter to limit the amount of data extracted, for instance last 7 days.Version: Discovery Hub 19.2.9.64Everything works fine when I test the SQL in Oracle, but when I put it into TX this error occurs every time:ORA-01830: date format picture ends before converting entire input stringDetails:ORA-01830: date format picture ends before converting entire input string ...Module: OraOLEDBSystem.Data.OleDb.OleDbExceptionat System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult)at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehav

'ORA-01861 Literal does not match format strings' I keep getting this error when I want te deploy and execute my table. I tried the troubleshoot option: delete the table by using the SQL Server Cleanup Tool, but this doesn't seems to work in my case. The field that gets the error is my Regestration Date with data type 'DATE'. This field also contains dates before 1753-1-1 (I guess typos). I've added a data selection rule and then I get the ORA error. You guys got a solution for this problem?

 Need to connect to someone with the experience of using Theobald connector in TX.  Seems like the only connection options I get are Z_XTRACT_IS_TABLE and Z_XTRACT_IS_TABLE_COMPRESSION, which implies that TX is only using the Xtract_IS_Table connector.What if I want to use other Theobald connectors, such as Xtract_IS_OHS, Xtract_IS_BW_Loader or Xtract_IS_Report?