Data Sources Q&A

I'm trying to get data from a REST api. The challenge is that the response is nested (JSON format). I did split up the seperate fields by editing the RSD file, adding something after the xPath... The result looks better than before but still all my answers are comma seperated in 1 field/row combination instead of 1 field 4 rows for example. It looks like this now: How can I make sure I only get 1 anwser per value per row? (So line 1, field q_position should be seperated to 4 rows with value 1,2,3 and 4)

For a REST endpoint we need to load incremental, how can I set up incremental columns in ODX and pass this values in the RSD file?

Is it possible to configure the default SQL connector Database Type "SQL Data Source" to use the Connection String property "ApplicationIntent=ReadOnly". It does not appear to honor this setting as Timextender connects to the primary, not the read only replica. We are confident in our Server side configuration as timextender is the only app we are having an issue with where an app does not connect to the read only replica when the connection property exists. Is there another method for us to do this? Thanks, Luke

Hello, one of our customers is considering the use of TimeXtender but their IT department is not supporting ODBC. Is it possible to discover (metadata analysis) and transfer data from new datasources (SQL, Oracle, etc.) without the use of ODBC? Or can all be done using the ODX server?

How can I access the HTTP Response Headers when retrieving data from the CData Rest Connector? I need to read values from it to set up pagination in the .rsd file. In my case it contains the current page, records per page and total number of records.

I am working on a environment with TimExtender and Dynamics 365 for Operation. First I must clear out ClientSecret and ClientAuthentication key before I can Authorize to d365. After that i put in those keys and the session is started. After a while the sessions is closed and I have to Authenticate myself all over again to be able to extract data form d365. exept from logfiles> 2020-08-13T09.00.37.158+02:00 0 [Connection: 158] Executed connect: Error: AADSTS7000215: Invalid client secret is provided.Trace ID: e4747361-a17c-448d-a5b9-b2d2fadbf800Correlation ID: 3ab329da-2059-4716-8a08-7f20e7835759Timestamp: 2020-08-13 07:00:37Z. 2020-08-13T09.00.37.160+02:00 0 AADSTS7000215: Invalid client secret is provided.Trace ID: e4747361-a17c-448d-a5b9-b2d2fadbf800Correlation ID: 3ab329da-2059-4716-8a08-7f20e7835759Timestamp: 2020-08-13 07:00:37Z. ffo190j.xaat ffo190j.nna.C(ra , String )at ffo190j.nna.q(String , String , String , Boolean , Boolean , Boolean , BmB , BmB , BmB )at ffo190j.nnI.Y(nnG ,

Hi, I need to extract data from an API which take dates as input values, [from date] and [to date]. And I need to extract data from this API each day. Is it possible to pass dynamic dates to the API connection based on todays date? I can't figure out how to do this. cheers, Sturla

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.64 Everything 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 string Details: 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(CommandBehavior behavior)at TimeXtender.DataManager.StepTransferSSISExecute.BulkCopySource(Boolean ex

'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?