since ‎17-04-2019
‎10-12-2019
appuputti
Level 2
Re: How does Adobe read ODBC provider type? appuputti - Adobe Campaign Classic
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
388
Views
0
Likes
0
Answers
Incoming task tablename appuputti - Adobe Campaign Classic
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
1779
Views
1
Like
1
Replies
Re: How does Adobe read ODBC provider type? appuputti - Adobe Campaign Classic
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 library somewhere but cannot find it.Thanks,Ari
379
Views
0
Likes
0
Answers
How does Adobe read ODBC provider type? appuputti - Adobe Campaign Classic
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 reads the db type, anybody has any better insights here?Here are some sample outputs from the function getDBMSType:When using ClouderaODBC hive driver --> output = 'hive'When using Teradata driver --> out...
681
Views
1
Like
4
Answers and Comments
Re: Custom SQL template for odbc external connection appuputti - Adobe Campaign Classic
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 (column_list) SELECT stufff FROM so I need custom template to construct the query here.Thanks,Ari
462
Views
0
Likes
0
Answers
Re: Custom SQL template for odbc external connection appuputti - Adobe Campaign Classic
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
467
Views
0
Likes
0
Answers
Custom SQL template for odbc external connection appuputti - Adobe Campaign Classic
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 and any activity in Adobe that uses internal templates to create the query will fail as the syntax is slightly different.First time i got this error "Unable to load document of identifier 'xtk:crdb_.xs...
990
Views
1
Like
5
Answers and Comments
Re: Handling requests in scale appuputti - Adobe Campaign Classic
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 official documentation, one should use HTTPClientRequest for this. However it is only libcurl and therefore is sending the requests as sequential which in our case is not possible as there will be millions ...
396
Views
0
Likes
0
Answers
Handling requests in scale appuputti - Adobe Campaign Classic
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 to use execCommand and have my dispatch script written in python or similar in server. Have anybody done anything similar? What is the best way to get the data to the script? Is there a way somehow to ...
905
Views
2
Likes
3
Answers and Comments
Likes from