maybe someone can help me out. I like to connect to our company CRM in Dynamics365. I found a commercial JDBC driver, but the problem here is, in the configuration user and password is clear code and therefor visible for everyone accessing the workflow.
is there any workaround or a better methode to connect to dynamics?
Hello sven,
did you try to use the Credentials Configuration node? When using credential variables the password isn’t visible in clear text anymore. Once created you can select the credential in the DB Connector node. For an example see here.
Bye
Tobias
thanks for your answer. can i use a normal jdbc connection for dynamics? because the paid version of driver i currently use doesn’t support credentials in your described way.
Hi,
maybe you can ask the JDBC driver vendor what options you have. I did a quick search but couldn’t find any free JDBC driver for Dynamics365. Maybe there is also another way to access the data e.g. via REST.
Bye
Tobias
Before using Knime, I used a JDBC connector from CData which let me connect to Dynamics 365 (this was a paid driver), the password was not stored in clear text. Just wanted to throw it out there an option if you didn’t want to implement your own REST workflows.
thanks for your reply. I know this driver, but additional software subscription was not a option for our customer.
i have a working workflow now build only with knime board nodes.
I am curious to know how you managed to realize this connection. I am having the similar situation. Unfortunately, Google has not provided me with an answer yet. Can you help me out?
Thank you for getting back to me.
I was on vacation last week…
It is somewhat urgent, yes. It all starts with getting the data. That process is now “on hold”. After I get to the data, I can play around and work my “magic” in KNIME.
Screenshots and anything that can help me unlock the data in Dynamics 365 is greatly appreciated.
maybe you don’t need all nodes, because i wanted to get all available tables in dyanmics365 and then retrieve the data.
it is a webapi request, so you probably can choose some other nodes like python.
@sven-abx Hi Sven, could not even make it past the first screenshot: “your tenant here”… as in my name? Company name? Does not end there, I am new to using Post request. I probably have the necessary information, just not sure how to put what where…