Connector Improvement: itunes_connect Sales/Finance schemas and 2FA
Hey Fivetran team,
Currently, the itunes_connect connector uses multiple data sources to back the tables/data it provides. One of the reports you can obtain is the sales and finance reports, which uses Apple's Reporter tool. Unfortunately, this tool requires an AppleID username + password + App Specific Password, and this combination is prone to a failure mode of locking the "host" AppleID's account due to too many 2FA attempts in a small amount of time.
Now, obviously, the Actual Solution is for Fivetran to intelligently "back off" when a sync cannot access certain records/underlying data sources, instead of hammering the AppleID until Apple locks the account.
However, I suspect that's rather complicated, so I'm asking for something simpler:
I don't care about the sales/finance reports – I don't want the connector to download those reports, and I don't want it to use the Apple Reporter to access those reports.
Today, I can configure the connector to not sync the reports, but according to Marsha @ Fivetran, configuring the schema to not sync these reports does not change whether the connector attempts to obtain the reports via the Reporter tool.
My request – either:
- stop hammering the AppleID upon 2FA failures, OR,
- if the sales/finance tables are not synced, do not invoke the Reporter tool at all
I can reference my support tickets where I've dug into this, if that's helpful! Thanks in advance!
Parth
Please sign in to leave a comment.
Comments
0 comments