ERP Today’s Post

The latest update for #Integrateio includes "How to Convert XML to JSON: A Step-by-Step Guide" and "Unlock Potential with ERP #Integration". #ETL #DataAnalytics #DataPipelines https://lnkd.in/ePvwyvTQ

In his recent article, Jonathan Bragg shares his insights on getting started with #Datasphere. To read the full article: https://lnkd.in/gAdHc_t6 #Sapcommunity #SAPBTP #SAPFiori #SAPDevOps #SAPs4HANA #SAPapphausnetwork #SAPApphaus #ApphausNetwork #SAPui5 #MindsetConsultingLLC 

Learn how to work on Azure blob storage in SAP CI/CPI! Do you know you can setup your own free trial Azure blob storage account to learn all necessary concepts on Azure Blob in SAP CPI? Below share some key concept. You can use it as exercise for CPI interview questions(see how many you know the answer) or just for self-check / self-learning: Q: Do CI/CPI have Azure Blob adapter? A: Yes. Since around begin of 2023. Q: What authentication can you use to call to Azure Blob adapter? A: Shared account key and SAS token. Q: What else authentication can use in SAP CI to call Azure Blob API? A: OAuth2 client credential and HTTP adapter. Q: What tool available for view/add/remove containers & blobs? A: Azure portal and Azure Storage Explorer software. Q: How to do connectivity test? A: Just create simple iFlow to try call. E.g. List Containers. Q: What is the default payload format? A: XML Q: How to list blobs by naming convention? A: Use prefix Q: How to limit list blobs returned number of rows? A: Use 'Page Size' Q: How to do auto pagination in Azure Blob? A: Use 'Page Size' + Looping Process Call + 'Process in Pages' Q: How to do manual pagination? A: Use 'Page Size' + Looping Process Call + marker/NextMarker Q: Which operation to use if just want to upload a file? A: Upload Block Blob Q: What about append file? A: Upload Append Blob Q: What about copy file? A: Upload Blob From URL Q: Do CI/CPI Azure Blob receiver adapter able to get Blob content? A: No. (As of Apr 2024). Q: What alternative to make call to get Blob Content? A: Use direct HTTP call. Q: What header must present in Azure Blob API call? A: x-ms-version. Q: Is it need complex coding to do Azure Blob API call? A: Not necessary, can make use of Azure app registration and OAuth2 Client Credential. Q: What the different between Get Blob Metadata and Get Blob Properties? A: Get metadata return metadata only, while Get properties return both properties and metadata. Q:What happen to existing metadata in blob if set single new metadata to blob? A: Existing metadata is gone. Q: How to update or add new metadata? A: Get existing metadata 1st, then add or update before set metadata again. Q: Can show some real-time/real-life example on various Blob operations in single iflow? A: In course lesson, do show how to all-in-one to list blobs with auto looping, process one-by-one, get blob from container, do something on blob, put blob to different container, set blob metadata and delete blob as well. Above just some info related to Azure Blob, for more detail content are included in new section "Azure Blob Storage" added in SAP CI course, can consider check out the course at this link https://lnkd.in/gxkY_3YX. If above Q&A is useful, can just repost this to share to benefit others. (I thanks you for repost 🙏 ) #sapcloudintegration #cloudintegration #sapci #sapcpi #sapintegration #sapintegrationsuite

The latest update for #SnowflakeDB includes "Accelerate Your #MachineLearning Workflows in Snowflake with Snowpark ML" and "5 Reasons Manufacturers Should Move ERP Data to Snowflake to Supercharge #Analytics". #BusinessIntelligence #BI #DataDriven https://lnkd.in/dH8h5ftY

[Article] Snowflake Resource Monitors to Track Resource Usage Learn about Snowflake resource monitors to track resource usage. This article covers how to set up, configure, and enable notifications. Author: Sergey Gigoyan >>> https://lnkd.in/enmVwPPY #sql #sqlserver #microsoftsqlserver #mssql #mssqlserver #snowflake #resourcemonitor #resourceusage #configuration #notifications #businessintelligence

Explore the replication flow capabilities of SAP Datasphere such as outbound integration options to integrate with data stores from SAP, Google, Azure and AWS and integration with Kafka. Follow the blog post series from Tobias Koebler and colleagues: https://lnkd.in/eSpDRrUP #sapintegration #dataintegration #sapbtp #sapdatasphere

💪The power of data with the seamless integration of Oracle APEX and OCI Ops Insights. Discover how custom dashboards can revolutionize your approach to database and IT management, making data-driven decisions easier than ever. ➡️Read the full article to learn more! https://lnkd.in/gxPyPG49

[Article] Snowflake Resource Monitors to Track Resource Usage Learn about Snowflake resource monitors to track resource usage. This article covers how to set up, configure, and enable notifications. Author: Sergey Gigoyan >>> https://lnkd.in/ePmp7Bm2 #sql #sqlserver #microsoftsqlserver #mssql #mssqlserver #snowflake #resourcemonitor #resourceusage #configuration #notifications #businessintelligence

Get an introduction to Oracle Data Safe, Oracle's platform for securing #data in #databases, plus a hands-on lab and Q&A. Register here: https://lnkd.in/eSYKWDfd

Get an introduction to Oracle Data Safe, Oracle's platform for securing #data in #databases, plus a hands-on lab and Q&A. Register here: https://lnkd.in/gKWmM46B