AEM 6.5 snowflake connector

[X015206]

Hi All,

I need to connect AEM6.5 to snowflake.

Does AEM support this?

Found that Adobe campaign has snowflake connect.

Without Adobe campaign is there any possibility to connect AEM instance to snowflake.

Please provide insights how to do this, this looks like some new concept.

Thanks,

Pradeep

[shelly-goel · Accepted solution]

@X015206  I think you must have seen this link: https://tray.io/connectors/adobe-experience-manager-snowflake-integrations

Did you give it a try to see the demo and if meets your need? It might involve certain cost but you could explore.

The other option is to connect to Snowflake APIs and meet your specific needs:https://docs.snowflake.com/en/developer-guide/sql-api/guide.html

[X015206]

I have tested snowflake jdbc driver working fine in standalone java class. When I integrated same code in AEM class it is not working, getting below errors in bundle. net.snowflake.client.jdbc.internal.apache.commons.lang3 -- Cannot be resolved net.snowflake.client.jdbc.internal.apache.commons.lang3.tuple -- Cannot be resolved net.snowflake.client.jdbc.internal.apache.log -- Cannot be resolved net.snowflake.client.jdbc.internal.apache.log4j -- Cannot be resolved net.snowflake.client.jdbc.internal.google.common.collect -- Cannot be resolved net.snowflake.client.jdbc.internal.google.common.math -- Cannot be resolved net.snowflake.client.jdbc.internal.google.common.primitives -- Cannot be resolved net.snowflake.client.jdbc.internal.joda.convert -- Cannot be resolved

[shellygoel06]

@X015206 - I assume this is happening at runtime so you would have to make neccassary changes in embed section of maven-bundle-plugin: <Export-Package>*</Export-Package> <Embed-Dependency>*;scope=compile|runtime;inline=true</Embed-Dependency> as mentioned here: https://stackoverflow.com/questions/56697999/how-to-embed-external-jars-dependency-in-osgi-bundles

[X015206]

These error are still there even after adding doing all left and right. It seems AEM officially doesn't support snowflake integration.