High-Level Steps
- Export your Informatica workflow in the form of an XML file. This step is explained in greater detail in the next section.
- Visit https://w2sql.agility1st.com and log in using your LinkedIn credentials so that you can leverage full full-featured W2SQL solution.
- Copy-paste your workflow XML
- Click on Spark SQL or Snowflake SQL to get your SQLs for the workflow.
How to Export Your Workflow + Transformation Logic (Full Details)
When you export your workflow from Informatica, choose the option to include all mappings and transformations. This gives us the complete blueprint—the overall workflow steps and the internal logic each step uses.
In more technical terms, to export a workflow with full transformation logic (excluding only session-level configuration), use Repository Manager’s ‘Export Object’ on the workflow and check “Export all dependencies”. Alternatively, in Workflow Manager, use Tasks → Export Objects, select the workflow, and include all associated mappings, mapplets, and transformations. For a demo or worked-out examples, email us at contact@agility1st.com.
GUI Steps — Repository Manager (most complete)
- Open Repository Manager and connect to your repository and the folder containing your workflow.
- Locate your workflow under the Navigator pane (under Workflows) (Informatica Docs, knowledge.informatica.com, knowledge.informatica.com, Informatica Docs).
- Right‑click the workflow → Export Object….
- In the Export dialog, ensure Export All Dependencies is selected (for mappings, transformations, sources, targets) (Informatica Docs).
- Save to an .xml file. This output includes your workflow, mapping logic, and transformation definitions.
GUI Steps — Workflow Manager Alternative
- Open Workflow Manager and connect.
- Navigate to Tasks → Export Objects.
- Select the workflow and enable all mappings, mapplets, transformations in the selection list.
- Export to .xml. Confirm the file contains <MAPPING> and <TRANSFORMATION> tags along with <WORKFLOW>.
Reference Documentation
- Informatica official page: You can export repository objects to XML through Repository Manager, Workflow Manager, or Designer (Informatica Docs).
- Dependent objects listing: Parent workflows include associated tasks, sessions, transformations, mapplets, and user-defined functions by default (Informatica Docs).
If you have questions or need clarifications, please contact us.