Can we pass Mysql database name and table name to dynamically through web url using macros?

@kamal_pradhan

Firstly, please check if the credentials you are passing is correct. Because error indicates wrong credentials...

Could you please give more details here?
What's the database? Also how exactly your process is setup, like how you are passing the macro value, and in what part of the workflow you are using it. Since you are saying, you are tryng to give database connection details via macros?

Please share Server error logs, available in following location:
<server-home-directory>\log\server.log

Cheers,
Pavithra

@Pavithra_Rao

Hi,

What I'm trying to active passing the database details (url, username and password) through a created web-service using macro bindings. If I use a predefined connection in the server then the process works but If I try to specify the details through macros and parameters the following error occurs:




Thanks

Try something like this

<?xml version="1.0" encoding="UTF-8"?><process version="8.2.000">
  <context>
    <input/>
    <output/>
    <macros>
      <macro>
        <key>url</key>
        <value/>
      </macro>
      <macro>
        <key>user</key>
        <value/>
      </macro>
      <macro>
        <key>pass</key>
        <value/>
      </macro>
    </macros>
  </context>
  <operator activated="true" class="process" compatibility="8.2.000" expanded="true" name="Process">
    <process expanded="true">
      <operator activated="true" class="jdbc_connectors:read_database" compatibility="8.2.000" expanded="true" height="68" name="Read Database" width="90" x="380" y="34">
        <parameter key="define_connection" value="url"/>
        <parameter key="database_url" value="%{url}"/>
        <parameter key="username" value="%{user}"/>
        <parameter key="password" value="ZGmujF5bm8M="/>
        <enumeration key="parameters"/>
      </operator>
      <connect from_op="Read Database" from_port="output" to_port="result 1"/>
      <portSpacing port="source_input 1" spacing="0"/>
      <portSpacing port="sink_result 1" spacing="0"/>
      <portSpacing port="sink_result 2" spacing="0"/>
    </process>
  </operator>
</process>

@MarcoBarradas

I think you correct. I tried with the same step and it works fine in the studio but fails in the server.