The target database is MemSQL, can we accomplish this with BIX? ---> you can create a different schema and you can mention it as target schema in BIX.
We planned to run the BIX periodically, how can we make sure that works only be exported once? ---> You can make use of filter criteria for this.
Use Last Updated Time as Start
For classes that include the property pxCommitDateTime, select this check box to extract all data that was created or updated since the last time the Extract rule was run. This field is not relevant until the Extract rule has run at least once.