bimlSnap is the primary application used by the ELT/ETL developers. This highly functional application allows users to easily create Biml connections, parameters, packages, and projects, using intuitive forms and user actions. All entries are placed into a back-end SQL Server database, where the BIML code is generated, and then copied into Visual Studio. This application is provided as a fully functional ‘Trial’ version. Subscriptions are available for a low monthly cost. Please contact us at firstname.lastname@example.org for more details.
Included in the bimlSnap download is the following:
Generates SSIS packages to enable the following framework features:
Streamlined project re-runability
Row count logging
SSIS Metadata Refresh Project
The Snapmart Refresh SSIS project is used for populating the metadata tables in the ‘bimlsnap’ database.
‘Snapmart Refresh’ project requirements:
SQL Server 2016 SP1 or later (Express Edition or greater)
SQL Server Data Tools (SSDT) for Visual Studio 2015 or greater
The ‘Metadata Management’ Form controls are integrated into the ‘BimlSnap Desktop’ Front-End. Using these forms the user can view and/or extend metadata on available servers, databases, tables and columns.
With the integrated Front-end a user can:
Set databases to be used for the extracting metadata
Designate Dimension table column merge types
View and Export database (DDL) changes
Terms and Conditions
Agreement between user and www.bitracks.com
Welcome to www.bitracks.com The www.bitracks.com website (the “Site”) is comprised of various web pages operated by BI Tracks Consulting, LLC (“BI Tracks”). www.bitracks.com is offered to you conditioned on your acceptance without modification of the terms, conditions, and notices contained herein (the “Terms”). Your use of www.bitracks.com constitutes your agreement to all such Terms. Please read these terms carefully, and keep a copy of them for your reference.
www.bitracks.com is E-commerce Websites, which are Portals for creating ‘Biml’ based XML documents used for ETL applications.
Visiting www.bitracks.com or sending emails to BI Tracks constitutes electronic communications. You consent to receive electronic communications and you agree that all agreements, notices, disclosures and other communications that we provide to you electronically, via email and on the Site, satisfy any legal requirement that such communications be in writing.
If you use this site, you are responsible for maintaining the confidentiality of your account and password and for restricting access to your computer, and you agree to accept responsibility for all activities that occur under your account or password. You may not assign or otherwise transfer your account to any other person or entity. You acknowledge that BI Tracks is not responsible for third party access to your account that results from theft or misappropriation of your account. BI Tracks and its associates reserve the right to refuse or cancel service, terminate accounts, or remove or edit content in our sole discretion.
BI Tracks does not knowingly collect, either online or offline, personal information from persons under the age of thirteen. If you are under 18, you may use www.bitracks.com only with permission of a parent or guardian.
You may cancel your subscription at any time. Any cancellations made after 30 days of service will not qualify for a refund. Please contact us at email@example.com with any questions.
Links to third party sites/Third party services
www.bitracks.com may contain links to other websites (“Linked Sites”). The Linked Sites are not under the control of BI Tracks and BI Tracks is not responsible for the contents of any Linked Site, including without limitation any link contained in a Linked Site, or any changes or updates to a Linked Site. BI Tracks is providing these links to you only as a convenience, and the inclusion of any link does not imply endorsement by BI Tracks of the site or any association with its operators.
Certain services made available via www.bitracks.com are delivered by third party sites and organizations. By using any product, service or functionality originating from the www.bitracks.com domain, you hereby acknowledge and consent that BI Tracks may share such information and data with any third party with whom BI Tracks has a contractual relationship to provide the requested product, service or functionality on behalf of www.bitracks.com users and customers.
No unlawful or prohibited use/Intellectual Property
All content included as part of the Service, such as text, graphics, logos, images, as well as the compilation thereof, and any software used on the Site, is the property of BI Tracks or its suppliers and protected by copyright and other laws that protect intellectual property and proprietary rights. You agree to observe and abide by all copyright and other proprietary notices, legends or other restrictions contained in any such content and will not make any changes thereto.
You will not modify, publish, transmit, reverse engineer, participate in the transfer or sale, create derivative works, or in any way exploit any of the content, in whole or in part, found on the Site. BI Tracks content is not for resale. Your use of the Site does not entitle you to make any unauthorized use of any protected content, and in particular you will not delete or alter any proprietary rights or attribution notices in any content. You will use protected content solely for your personal use, and will make no other use of the content without the express written permission of BI Tracks and the copyright owner. You agree that you do not acquire any ownership rights in any protected content. We do not grant you any licenses, express or implied, to the intellectual property of BI Tracks or our licensors except as expressly authorized by these Terms.
Use of communication services
The Site may contain bulletin board services, chat areas, news groups, forums, communities, personal web pages, calendars, and/or other message or communication facilities designed to enable you to communicate with the public at large or with a group (collectively, “Communication Services”), you agree to use the Communication Services only to post, send and receive messages and material that are proper and related to the particular Communication Service.
By way of example, and not as a limitation, you agree that when using a Communication Service, you will not: defame, abuse, harass, stalk, threaten or otherwise violate the legal rights (such as rights of privacy and publicity) of others; publish, post, upload, distribute or disseminate any inappropriate, profane, defamatory, infringing, obscene, indecent or unlawful topic, name,
material or information; upload files that contain software or other material protected by intellectual property laws (or by rights of privacy of publicity) unless you own or control the rights thereto or have received all necessary consents; upload files that contain viruses, corrupted files, or any other similar software or programs that may damage the operation of another’s computer; advertise or offer to sell or buy any goods or services for any business purpose, unless such Communication Service specifically allows such messages; conduct or forward surveys, contests, pyramid schemes or chain letters; download any file posted by another user of a Communication Service that you know, or reasonably should know, cannot be legally distributed in such manner; falsify or delete any author attributions, legal or other proper notices or proprietary designations or labels of the origin or source of software or other material contained in a file that is uploaded, restrict or inhibit any other user from using and enjoying the Communication Services; violate any code of conduct or other guidelines which may be applicable for any particular Communication Service; harvest or otherwise collect information about others, including e-mail addresses, without their consent; violate any applicable laws or regulations.
BI Tracks has no obligation to monitor the Communication Services. However, BI Tracks reserves the right to review materials posted to a Communication Service and to remove any materials in its sole discretion. BI Tracks reserves the right to terminate your access to any or all of the Communication Services at any time without notice for any reason whatsoever.
BI Tracks reserves the right at all times to disclose any information as necessary to satisfy any applicable law, regulation, legal process or governmental request, or to edit, refuse to post or to remove any information or materials, in whole or in part, in BI Tracks’ sole discretion.
Always use caution when giving out any personally identifying information about yourself or your children in any Communication Service. BI Tracks does not control or endorse the content, messages or information found in any Communication Service and, therefore, BI Tracks specifically disclaims any liability with regard to the Communication Services and any actions resulting from your participation in any Communication Service. Managers and hosts are not authorized BI Tracks spokespersons, and their views do not necessarily reflect those of BI Tracks.
Materials uploaded to a Communication Service may be subject to posted limitations on usage, reproduction and/or dissemination. You are responsible for adhering to such limitations if you upload the materials.
Materials provided to www.bitracks.com or posted on any BI Tracks web page <br/>
BI Tracks does not claim ownership of the materials you provide to www.bitracks.com (including feedback and suggestions) or post, upload, input or submit to any BI Tracks Site or our associated services (collectively “Submissions”). However, by posting, uploading, inputting, providing or submitting your Submission you are granting BI Tracks, our affiliated companies and necessary sublicenses permission to use your Submission in connection with the operation of their Internet businesses including, without limitation, the rights to: copy, distribute, transmit, publicly display, publicly perform, reproduce, edit, translate and reformat your Submission; and to publish your name in connection with your Submission.
No compensation will be paid with respect to the use of your Submission, as provided herein. BI Tracks is under no obligation to post or use any Submission you may provide and may remove any Submission at any time in BI Tracks’ sole discretion.
By posting, uploading, inputting, providing or submitting your Submission you warrant and represent that you own or otherwise control all of the rights to your Submission as described in this section including, without limitation, all the rights necessary for you to provide, post, upload, input or submit the Submissions.
The Service is controlled, operated and administered by BI Tracks from our offices within the USA. If you access the Service from a location outside the USA, you are responsible for compliance with all local laws. You agree that you will not use the BI Tracks Content accessed through www.bitracks.com in any country or in any manner prohibited by any applicable laws, restrictions or regulations.
You agree to indemnify, defend and hold harmless BI Tracks, its officers, directors, employees, agents and third parties, for any losses, costs, liabilities and expenses (including reasonable attorneys’ fees) relating to or arising out of your use of or inability to use the Site or services, any user postings made by you, your violation of any terms of this Agreement or your violation of any rights of a third party, or your violation of any applicable laws, rules or regulations. BI Tracks reserves the right, at its own cost, to assume the exclusive defense and control of any matter otherwise subject to indemnification by you, in which event you will fully cooperate with BI Tracks in asserting any available defenses.
THE INFORMATION, SOFTWARE, PRODUCTS, AND SERVICES INCLUDED IN OR AVAILABLE THROUGH THE SITE MAY INCLUDE INACCURACIES OR TYPOGRAPHICAL ERRORS. CHANGES ARE PERIODICALLY ADDED TO THE INFORMATION HEREIN. BI TRACKS CONSULTING, LLC AND/OR ITS SUPPLIERS MAY MAKE IMPROVEMENTS AND/OR CHANGES IN THE SITE AT ANY TIME.
BI TRACKS CONSULTING, LLC AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY, RELIABILITY, AVAILABILITY, TIMELINESS, AND ACCURACY OF THE INFORMATION, SOFTWARE, PRODUCTS, SERVICES AND RELATED GRAPHICS CONTAINED ON THE SITE FOR ANY PURPOSE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, ALL SUCH INFORMATION, SOFTWARE, PRODUCTS, SERVICES AND RELATED GRAPHICS ARE PROVIDED “AS IS” WITHOUT WARRANTY OR CONDITION OF ANY KIND. BI TRACKS CONSULTING, LLC AND/OR ITS SUPPLIERS HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THIS INFORMATION, SOFTWARE, PRODUCTS, SERVICES AND RELATED GRAPHICS, INCLUDING ALL IMPLIED WARRANTIES OR CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE AND NON-INFRINGEMENT.
BI Tracks reserves the right, in its sole discretion, to terminate your access to the Site and the related services or any portion thereof at any time, without notice. To the maximum extent permitted by law, this agreement is governed by the laws of the State of Ohio and you hereby consent to the exclusive jurisdiction and venue of courts in Ohio in all disputes arising out of or relating to the use of the Site. Use of the Site is unauthorized in any jurisdiction that does not give effect to all provisions of these Terms, including, without limitation, this section.
You agree that no joint venture, partnership, employment, or agency relationship exists between you and BI Tracks as a result of this agreement or use of the Site. BI Tracks’ performance of this agreement is subject to existing laws and legal process, and nothing contained in this agreement is in derogation of BI Tracks’ right to comply with governmental, court and law enforcement requests or requirements relating to your use of the Site or information provided to or gathered by BI Tracks with respect to such use. If any part of this agreement is determined to be invalid or unenforceable pursuant to applicable law including, but not limited to, the warranty disclaimers and liability limitations set forth above, then the invalid or unenforceable provision will be deemed superseded by a valid, enforceable provision that most closely matches the intent of the original provision and the remainder of the agreement shall continue in effect.
Unless otherwise specified herein, this agreement constitutes the entire agreement between the user and BI Tracks with respect to the Site and it supersedes all prior or contemporaneous communications and proposals, whether electronic, oral or written, between the user and BI Tracks with respect to the Site. A printed version of this agreement and of any notice given in electronic form shall be admissible in judicial or administrative proceedings based upon or relating to this agreement to the same extent an d subject to the same conditions as other business documents and records originally generated and maintained in printed form. It is the express wish to the parties that this agreement and all related documents be written in English.
Changes to Terms
BI Tracks reserves the right, in its sole discretion, to change the Terms under which www.bitracks.com is offered. The most current version of the Terms will supersede all previous versions. BI Tracks encourages you to periodically review the Terms to stay informed of our updates.
BI Tracks welcomes your questions or comments regarding the Terms:
BI Tracks Consulting, LLC
Cincinnati, Ohio 45246
Email Address: firstname.lastname@example.org
Effective as of March 01, 2017