data extraction to an external account (big query) | Community
Skip to main content
R
rbiri
Level 3
November 14, 2024
Solved

data extraction to an external account (big query)

  • November 14, 2024
  • 1 reply
  • 889 views

Hello

We need to extract the data from a list to a big query external account already set up, we are able to receive data from Big Query, but  when I set up my file  upload acitvity, in theremote server part, my external account  is not availble to select.

The big query external account we set up, is an external database type

 

Any ideas?

 

PS: we dont want to transfer to SFTP

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by somasundaram_h

Hi, data loading RDBMS activity - this is self explanatory. We can only load data using that activity and not possible to push data using that. However, we may try different approach if you're familiar with Javascript and SQL. But this requires deep understanding of External accounts setup, Javascript, SQL and looping all your data inside JS.

Example: 

sqlExecOnDataSource("UPDATE XtkOption SET sStringValue = $(sz) WHERE sName = $(sz)", oracleExternalDB, 'WdbcOptions_TableSpaceWork_nms:extAccount:' + ExtAccount)

Reference: https://experienceleague.adobe.com/developer/campaign-api/api/f-sqlExecOnDataSource.html

 

The user friendly approach will be via File transfer activity. Hope this helps.

1 reply

somasundaram_h
Community Advisor
somasundaram_hCommunity Advisor
Community Advisor
November 15, 2024

Hi, I guess you're loading data using Data loading(RDBMS) activity. And you wish to use the same activity to send data to external database. If that is the case, it is not possible. Let me know what activities you used to import data and what activities you tried for exporting?

razengaan
razengaan
Level 2
November 18, 2024

Hi

 

Yes, we set up an external account (external database type) to pick up file from Big Query, and we use a data loading RDBMS to check that data source in a specific table name, and we select a column to extract.

But we want now, transfer files to Big Query through the same external account.

..If there is no other way, we will try the regular approach (file to sftp)..

 

somasundaram_h
Community Advisor
somasundaram_hCommunity AdvisorAccepted solution
Community Advisor
November 19, 2024

Hi, data loading RDBMS activity - this is self explanatory. We can only load data using that activity and not possible to push data using that. However, we may try different approach if you're familiar with Javascript and SQL. But this requires deep understanding of External accounts setup, Javascript, SQL and looping all your data inside JS.

Example: 

sqlExecOnDataSource("UPDATE XtkOption SET sStringValue = $(sz) WHERE sName = $(sz)", oracleExternalDB, 'WdbcOptions_TableSpaceWork_nms:extAccount:' + ExtAccount)

Reference: https://experienceleague.adobe.com/developer/campaign-api/api/f-sqlExecOnDataSource.html

 

The user friendly approach will be via File transfer activity. Hope this helps.

    Terms & ConditionsAccessibility statement

    Loading footer...