dbshiftSDK

Name	dbshiftSDK JSON
Version	1.0.1 JSON
	download
home_page	None
Summary	A tool for converting Informatica XML mappings to Snowflake SQL and dbt models.
upload_time	2024-11-27 20:02:33
maintainer	None
docs_url	None
author	Anand
requires_python	None
license	None
keywords
VCS
bugtrack_url
requirements	No requirements were recorded.
Travis-CI	No Travis.
coveralls test coverage	No coveralls.

            # dbshiftSDK

A Python SDK for converting Informatica XML mappings to Snowflake SQL and dbt models.

## Installation

You can install the package using pip:

```bash
pip install dbshiftSDK
```

## Features

- Convert Informatica XML mappings to Snowflake SQL
- Generate dbt models from Snowflake SQL
- Support for various Informatica transformations
- Automatic handling of mapplets and complex transformations

## Usage

```python
from dbshiftSDK import infa_to_dbt

# Convert XML mappings in a directory
infa_to_dbt('/path/to/your/xml/files')
```

## Input Requirements

- Informatica XML mapping files
- Valid XML format with proper transformation tags
- Source and target definitions in the mapping

## Output

The tool generates:
- Converted SQL files in the 'converted_sql' directory
- dbt models in the 'converted_dbt' directory
- A detailed conversion log file

## Dependencies

- google-generativeai
- tabulate
- argparse

## License

This project is licensed under the MIT License - see the LICENSE.txt file for details.

## Author

Anand (anandt@systechusa.com)

            

Raw data

            {
    "_id": null,
    "home_page": null,
    "name": "dbshiftSDK",
    "maintainer": null,
    "docs_url": null,
    "requires_python": null,
    "maintainer_email": null,
    "keywords": null,
    "author": "Anand",
    "author_email": "anandt@systechusa.com",
    "download_url": "https://files.pythonhosted.org/packages/7f/fd/6ba2d5f9f119a09559e719a0887948e0535c37d8c35a4c12bad737118c70/dbshiftsdk-1.0.1.tar.gz",
    "platform": null,
    "description": "# dbshiftSDK\r\n\r\nA Python SDK for converting Informatica XML mappings to Snowflake SQL and dbt models.\r\n\r\n## Installation\r\n\r\nYou can install the package using pip:\r\n\r\n```bash\r\npip install dbshiftSDK\r\n```\r\n\r\n## Features\r\n\r\n- Convert Informatica XML mappings to Snowflake SQL\r\n- Generate dbt models from Snowflake SQL\r\n- Support for various Informatica transformations\r\n- Automatic handling of mapplets and complex transformations\r\n\r\n## Usage\r\n\r\n```python\r\nfrom dbshiftSDK import infa_to_dbt\r\n\r\n# Convert XML mappings in a directory\r\ninfa_to_dbt('/path/to/your/xml/files')\r\n```\r\n\r\n## Input Requirements\r\n\r\n- Informatica XML mapping files\r\n- Valid XML format with proper transformation tags\r\n- Source and target definitions in the mapping\r\n\r\n## Output\r\n\r\nThe tool generates:\r\n- Converted SQL files in the 'converted_sql' directory\r\n- dbt models in the 'converted_dbt' directory\r\n- A detailed conversion log file\r\n\r\n## Dependencies\r\n\r\n- google-generativeai\r\n- tabulate\r\n- argparse\r\n\r\n## License\r\n\r\nThis project is licensed under the MIT License - see the LICENSE.txt file for details.\r\n\r\n## Author\r\n\r\nAnand (anandt@systechusa.com)\r\n",
    "bugtrack_url": null,
    "license": null,
    "summary": "A tool for converting Informatica XML mappings to Snowflake SQL and dbt models.",
    "version": "1.0.1",
    "project_urls": null,
    "split_keywords": [],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "0609515e9dcf9b593fcff88f467115ad51e18e5d84d5cd27940d9f661e297da6",
                "md5": "efb94fb7fd4f52e20dbad6e6e292a2c6",
                "sha256": "74f908fe938c695227b524f24ee28e536c30f4f62f2a0956c5a110c5327aa745"
            },
            "downloads": -1,
            "filename": "dbshiftSDK-1.0.1-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "efb94fb7fd4f52e20dbad6e6e292a2c6",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 2730,
            "upload_time": "2024-11-27T20:02:31",
            "upload_time_iso_8601": "2024-11-27T20:02:31.294116Z",
            "url": "https://files.pythonhosted.org/packages/06/09/515e9dcf9b593fcff88f467115ad51e18e5d84d5cd27940d9f661e297da6/dbshiftSDK-1.0.1-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "7ffd6ba2d5f9f119a09559e719a0887948e0535c37d8c35a4c12bad737118c70",
                "md5": "8fd5861e2b1988015802dd9ede199cba",
                "sha256": "e56ba29785a9a93fd0d77c73c7abd5528fc2cd233018d9210da5e7a7cd80f9d6"
            },
            "downloads": -1,
            "filename": "dbshiftsdk-1.0.1.tar.gz",
            "has_sig": false,
            "md5_digest": "8fd5861e2b1988015802dd9ede199cba",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 2767,
            "upload_time": "2024-11-27T20:02:33",
            "upload_time_iso_8601": "2024-11-27T20:02:33.077763Z",
            "url": "https://files.pythonhosted.org/packages/7f/fd/6ba2d5f9f119a09559e719a0887948e0535c37d8c35a4c12bad737118c70/dbshiftsdk-1.0.1.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2024-11-27 20:02:33",
    "github": false,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "lcname": "dbshiftsdk"
}