Hi Jon,Appreciate your effort on this.We have solved this. The parameter comes from the driver library and it is DSI_CONN_DBMS_NAME. This parameter defines the vendor for ODBC connection in Adobe.Thanks,Ari

Hi guys,Does anybody know why this task.incomingTransitionByName('input1').tableName gives always empty? According to Adobe docs, this should give you the working table from the incoming transition, how ever it has empty value always...SQL Data Management Regards,Ari

Hi Jon,Thanks for the reply. In this case when it is ODBC setup the @provider='ODBC' so that doesn't seem to be the case. It does strongly look like it reads something from the driver in use but cannot find what.Was hoping that somebody knows what getDBMSType does as this seems to be actually Java l...

Hi,We are currently creating custom ODBC driver and having a hard time figuring out how exactly Adobe recognizes the provider/dbtype?We need our custom driver to be recognized as hive.I found this .js application.getDBMSType('nms:extAccount:'+'hadoop') but couldn't find how getDBMSType actually read...

Hi Jon,Yeah, i could. However the difference here is that Spark SQL doesn't support column list insert syntax that most 'standard' SQL languages use, E.G: INSERT INTO <tablename> (column_list) SELECT stufff FROM <tablename> so I need custom template to construct the query here.Thanks,Ari

Hi Jon,Yes exactly. The connection is Spark SQL through ODBC connection. I copied and renamed the hive xsl templates but there is a slight syntax difference that i would need to modify.Thanks,Ari

Hi guys,Have anybody tried something like this before? I have custom external datasource that i was able to connect to adobe and it works fine if i just pull some data and immediately change the dimension to use Adobe internal database.However i have use cases where i cannot do it in the beginning a...

Hi Jon,Thanks for your response. I have some follow up questions regarding this. Let me first give some more context.We need to send push notifications from Adobe and we have our own centralized notification hub that directs the requests to correct provider (iOS & Android). According to Adobe offici...

Hi all,I have a situation where I am required to send millions of requests to internal Rest API. Now after some investigation it seems that HTTPClientRequest is not the way to go. I am looking alternative options without involving some middle-server to drop files etc.One approach i was thinking is t...