CCL Global’s Post

What is the biggest challenge when you want to migrate from your old PowerCenter ETL to Talend Cloud Data Fabric ? 1 - The cost of the conversion : One mapping to one Talend Job is at least 4 or 5 days, you don't have the documentation, the PowerCenter developer is gone and you want someone who speaks both languages : it's expensive 2 - The duration of the conversion : 4 or 5 days per mapping, plus non-regression testing. 1 or 2 years for 400 jobs ? it's 4 years with 1 FTE ! 3 - The risk for the conversion : PowerCenter has very specifics features, it manages null like nobody else, it's convert without any notice from 1 type to another type, it's agregates data like nobody. The Dynamics lookups, the all-matches lookup, the File as Command, etc. it's a nightmare. But there is one preferred way : konvertilo. We've built the tool to convert, automatically, the mappings that are 'compatible' with our engine (and we improve it daily). Don't by shy. Contact me and I'll tell you more. Hervé/CEO

Over the past few years, companies have been looking to simplify their IT landscapes. That often means cutting costs—sometimes on personnel, sometimes on equipment, but very rarely on software. That’s where we’ve focused our efforts. We’ve developed a converter to migrate PowerCenter mappings to Talend. This conversion is partially automatic (over 80% of data flows on average) and partially semi-manual: we retain most of the mapping logic and replace certain components with generic ones. The automatic part? It’s fully automated. Contexts, connections, metadata, UDFs, variables, parameters—everything is handled automatically. We’ve ensured compliance with TMC naming conventions and optimized performance. We’ve worked hard on this. So what’s next? Bringing to Talend Studio the components that are critically missing for any integration project: disconnected lookups, dynamic lookups, uncached lookups, ranks, full outer joins—in short, all the functions we’ve developed in our Java library but that could rightfully be standard components. Stay tuned, we’re moving quickly in this direction! #DataIntegration #Talend #PowerCenter #Innovation #konvertilo #conversion #ETL

Prerequisites for logging into Informatica PowerCenter include ensuring that you have the necessary credentials, such as a valid username and password, provided by your system #administrator. Additionally, it's crucial to have access to the appropriate #network or server where the PowerCenter instance is hosted. Depending on the #configuration, you may also need specific permissions or roles assigned to your account to access certain functionalities within PowerCenter. Read more: https://zurl.co/lvy1 #ssquaresystems #ssquare

🚀 Today I'm excited to share my latest post on "Optimizing MySQL CRUD Operations with MuleSoft!"In this post, I'll cover how to integrate and improve MySQL CRUD operations using MuleSoft, #MuleSoft #Integration #DataOptimization #CRUDOperations #APIIntegration. #Mysql ▶In my next post, I will walk you through the practical implementation of each operation with a step-by-step guide. Don’t miss out on a detailed, hands-on approach complete with examples.

Creating a mapping in #Informatica PowerCenter involves several essential steps. First, launch Informatica PowerCenter #Designer and connect to the repository by providing your repository #credentials. Create a new folder in the Navigator pane to organize your work. Next, define your sources and targets by using the Source Analyzer to import or manually create source definitions, and the Target Designer for target definitions. Read more: https://zurl.co/A9lP #ssquaresystems #ssquare

Hello Folks We have a new opening for Senior Informatica Developer for Remote in TX Note: Open for W2 & 1099 Only- TX local only (State client) Feel free to reach at [email protected] or 703-659-1122 JD: •       Development of ETL mappings and Task flows in IDMC for data movement with different type of sources and targets. Sources include IMS database, VSAM, Oracle, SQL servers. •       Refactoring of database ETL scripts from mainframe IMS databases to Oracle RDBMS. •       Able to create data maps (application extraction and registration groups) in Power Exchange (PWX) Navigator or similar Real Time CDC products. •       Develop Data Quality / Data Governance modules using Informatica DQ / Data Governance or similar products. •       Develop data pipelines in Snowflake using PL/SQL procedures with different type of source / targets like Oracle, Salesforce, SQL Server. •       Determines database requirements by analyzing business operations, applications, and programming; reviewing business objectives; and evaluating current systems. •       Obtains data model requirements, develops, and implements data models for new projects, and maintains existing data models and data architectures. •       Performs root cause analyses (RDA) related to information issues and non-conformance to published data standards based on review of technical metadata of various source systems. •       Creates graphics and other flow diagrams (including ERD) to show complex database design and database modeling more simply. •       Performs related work as assigned. •       Creation of technical documentation for process and interface documentation is a key element of this role, as the Team is working on release two of a multiple release effort. •       Ability to review the work of others, troubleshoot, and provide feedback and guidance to meet tight deliverable deadlines is required. •       Ability to promote the code from development environments to test and production environments using DevOps CI/CD pipelines.. #ORACLEDEVELOPER #DEVOPS #CICD #datagovernance #Snowflake #PLSQL #Oracle #Salesforce #SQLServer.

Who knows what "MAX(IIF(MAX(PORT > 2), 0, 1))" does in PowerCenter? We do! And we’ve developed it within our Java library that accompanies our conversion projects from PowerCenter to Talend Data Fabric. This complex aggregate function enables advanced calculations and conditional aggregations in a single expression. In this formula: • The inner MAX() operates on each individual row to evaluate the condition PORT > 2. • The outer MAX() applies to the group defined by the GROUP BY clause. Since this functionality isn’t available with standard Talend components, we’ve implemented it in our Java library, kLib, enhancing the capabilities of our converted projects. Interested in how this can optimize your data workflows? Feel free to reach out!

🚀 Day 22 of the 100-Day MuleSoft Learning Challenge: Today, let's master CRUD in MySQL using MuleSoft! 🌐 💡 Key Components: 👉 MySQL Server: Configure connection details. 👉 HTTP Listener: Handle incoming requests. 👉 Set Variable: Store data for operations. 👉 Logger: Track flow execution. 👉 Transform Message: Format data. Database Connectors: 👉 Database Select Connector: Retrieve records based on specified criteria. 👉 Database Insert Connector: Insert new records into the database table. 👉 Database Update Connector: Update existing records in the database table. 👉 Database Delete Connector: Delete records based on specified conditions. 🔍 Example Usage: Listen for HTTP requests. Set variables for data. Use database connectors for CRUD operations. Log execution details. Dive into the world of CRUD operations with MuleSoft and MySQL! 🛠️ #MuleSoftChallenge #Day22 #MySQLCRUD #mulesoftdeveloper #mulesoftcommunity #mulesoftdevelopers #mulesoftcertified #salesforce #hustlehard #mysql #integrations #apis #apiintegration #crud #crudoperations #salesforce 👊

🚀 Here are 3 compelling reasons why the time to upgrade your Talend software is NOW: 1️⃣ Streamlined Updates: Keeping your Talend software current is essential, but traditional updates can eat up valuable time. Our automated update solution revolutionizes this process, slashing both time and costs by up to 70%. Bid farewell to manual rebuilding and embrace seamless updates! 2️⃣ Transition from TOS: With Talend Open Studio reaching its end of life (since January 2024), transitioning to an upgraded version is paramount. Ensure your systems stay secure and up-to-date with our smooth migration process, complete with a 10% discount on your new Entry Level License. Don't compromise on security—make the switch today. 3️⃣ Effortless Artifact Management: Simplify the publishing of Talend Artifacts to your preferred repository, whether it's TAC or an on-premise setup. Our automated Maven solution streamlines interface rebuilding and publishing, freeing you from unnecessary hassle and saving precious time. 💡 Take advantage of our comprehensive migration offer: - Automated and accelerated full migration solution - Expert advice for TOS users transitioning to an Entry Level Talend license - Smooth migration from on-premise to the cloud. Don't miss out—upgrade now and experience the power of efficiency and automation. Ready to unlock these benefits and more? Contact us at [email protected] or call +31 6 218 719 05 to kickstart your migration journey and receive more information "how we do it". #TalendUpgrade #Automation #Efficiency #MigrationOffer #cimt #TOS