Fetching Data from External Account(MySql)
Hi All,
Using an external account I have connected ACC with MySql workbench. whenever I have to fetch a small amount of data it works fine but it does not work if data is huge takes a longer amount of time which is not a feasible solution I believe.
so to overcome above problem what I did is I created the schema using the external account which is an exact real-time copy of my SQL table. Now, whenever I try to fetch data from created schema ACM shows the following two errors:
1. WDB-200001 SQL statement 'DROP TABLE IF EXISTS wkf22092800_128_1' could not be executed.
2. MYS-230000 MySQL error 1290: The MySQL server is running with the --read-only option so it cannot execute this statement.
Note: I have connected SQL using read-only access credentials. but since my requirement only to fetch data I don't feel I need a write access credentials.
I found one alternative for the above problem but it is incomplete.
So what I did is, I used a script to fetch data from created external account schema.
and the script is:
<select>
<node expr="@Column1"/>
</select>
<where>
<condition boolOperator="AND" expr="ToDate(@Column2) = '2019-05-06'"/>
</where>
</queryDef>
)
var set = query.ExecuteQuery()
for each(var row in set)
{
logInfo("USER ID : " + row.@Column1);
vars.Customer_Id = +row.@Column1;
}
So, I want to store all rows into a single column using an enrichment activity.
