Dynamics Business Central Schema Extraction Consultation

$30-70 USD/ giờ

Đang mở

Đã đăng vào

1 ngày trước

•

Kết thúc sau 5 ngày

$30-70 USD/ giờ

Need some consulting on the best method to get the raw schema from dynamics business central cloud in either json, SQL DDL or some other format so that it can be visualized in a database modelling software. Looking to get: table name, field id, field name, field type, primary keys, foreign keys and relate table names. Through VS code you can download all the symbol .al files where each file contain the complete raw schema of each table but I have only been able to use parsing in python to get this information and its very error prone. There is also the 3rd part site [login to view URL] but I'm looking for full control of the output to put into stand alone data modeler. There's also some vs code plugins like AZ AL Dev Tools but there is no export options. Just looking for advice on best solution and a bit of help with the proccess. I have uploaded one of the .al files that I'm looking to extract the raw schema from and have been able to get the correct output using python but the code won't reliably work with the 100's of other .al file need to get the schema for as well. The solution doesn't have to be using the AL files, I've tried using custom APIs but have only had limited success. The related table information seems to be stored in the .al files and not the API but I might be wrong. The challenge with APIs is that I haven't been able to access the "TableRelation" property. Please put the keyword "DYNAMICS123" at the start of your response so that we can filter out the automated responses. Thanks!

Database Administration

Mã dự án: 38932507

Về dự án

29 đề xuất

Mở nhận chào giá

Dự án từ xa

Hoạt động 6 giờ trước

Đặt chào giá của bạn

Số tiền chào giá

USD

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

29 freelancer chào giá trung bình $47 USD/giờ cho công việc này

@mobimubasir

Hello. I read your requirement i will do that. Please come on chat we will discuss more about this. I will waiting your reply

$50 USD trong 40 ngày

5,0

(18 nhận xét)

5,0

@sagarwal3005

"DYNAMICS123" Hi there! I have experience in extracting schema data from Dynamics Business Central Cloud and can provide consulting on the best method to get the raw schema in JSON, SQL DDL, or any other format for visualization in database modeling software. I can help you retrieve table names, field id, field name, field type, primary keys, foreign keys, and related table names. With my expertise, I can guide you on the most efficient solution and offer assistance throughout the process. Let's work together to create a seamless data modeling experience. Let me know how I can support you!

$56,95 USD trong 7 ngày

5,0

(6 nhận xét)

4,7

@tangramua

Dear C-Media D., We carefully studied the description of your project and we can confirm that we understand your needs and are also interested in your project. Our team has the necessary resources to start your project as soon as possible and complete it in a very short time. We are 25 years in this business and our technical specialists have strong experience in Database Administration, Relational Databases, Business Central, Database Management, Data Modeling and other technologies relevant to your project. Please, review our profile https://www.freelancer.com/u/tangramua where you can find detailed information about our company, our portfolio, and the client's recent reviews. Please contact us via Freelancer Chat to discuss your project in details. Best regards, Sales department Tangram Canada Inc.

$35 USD trong 5 ngày

5,0

(5 nhận xét)

4,4

@irsolutions

"DYNAMICS123" The client is seeking consultation on extracting the raw schema from Dynamics Business Central Cloud in a format that can be visualized in a database modeling software. They are facing challenges with parsing in Python and are looking for a more reliable solution. From my extensive experience in web and mobile development, including expertise in Python, data extraction, and database modeling, I understand the importance of accuracy and efficiency in this process. I have successfully worked on similar data extraction and visualization projects, ensuring seamless integration and reliable results. My proficiency in Python, data manipulation, and database management will enable me to provide valuable insights and guidance on the best method for extracting and visualizing the required schema. So, if you're looking for expert advice and assistance in optimizing the process of extracting and visualizing the raw schema from Dynamics Business Central Cloud, feel free to reach out. Let’s schedule a meeting to discuss your specific requirements and how we can achieve your project goals efficiently.

$56 USD trong 15 ngày

5,0

(1 nhận xét)

3,6

@softsolution2000

Hi there DYNAMICS123 After reviewing your project requirements, I propose to leverage Visual Studio Code to extract the raw schema from Dynamics Business Central Cloud in the form of JSON files containing table names, field IDs, field names, field types, primary keys, foreign keys, and related table names. By utilizing custom Python parsing scripts, we can ensure accuracy and minimize errors in the data extraction process. Additionally, I can provide guidance on importing this information into a database modeling software for visualization and analysis. Let's discuss further to identify the best approach for your specific needs. Please go through my profile its 15 years old see the work I did over the years. ---> No Win No Fee means that your satisfaction is my utmost priority. <---- Lets discuss the job details. Moreover, I am willing to start the job and perform tasks without even being hired; it is just to show my commitment to this project. Looking forward to hear from you. Regards Shah

$46 USD trong 7 ngày

5,0

(1 nhận xét)

3,0

@shahajalalbabu00

Hi there! I Understand the value of accurate and efficient data entry. My expertise in Data Processing, ⛔Data-Entry⛔Excel⛔VBA-Macro⛔Power-BI & Accountant⛔PDF⛔ MS⛔Visual Basic⛔Data Processing⛔Excel⛔Excel VBA⛔Excel Macros will surely prove useful for this project. I have an excellent command over Power BI and can help you extract your data exactly the way you see it on the platform. In line with your goal to download the Excel file with utmost precision, I can assure you that my meticulous attention to detail will ensure a flawless transfer of all your data. Choose me for this project and let's achieve your goal together! Cheers!

$30 USD trong 5 ngày

0,0

(0 nhận xét)

0,0

@dusanr1

Hello C-Media, I am Dusan R, a Database Administration expert with over 10 years of experience. I have carefully reviewed your requirement for extracting schema from Dynamics Business Central cloud. My proposed solution involves utilizing VS Code to download symbol .al files and then structuring the schema data into a format suitable for visualization in database modeling software. I am proficient in Frontend Development technologies such as HTML, JavaScript, CSS, Bootstrap, and JavaScript libraries like React.js, Vue.js, Angular.js. Additionally, I have expertise in PHP Frameworks like Laravel, CodeIgniter, and WordPress, along with databases such as MySQL, MongoDB, Firebase, and PostgreSQL. Let's discuss further details in chat. Best regards, Dusan R

$30 USD trong 7 ngày

0,0

(0 nhận xét)

0,0

@AITSoft

DYNAMICS123 Hello, I understand you need some guidance on effectively extracting the raw schema from Dynamics Business Central Cloud, focusing on obtaining details like table names, field IDs, field names, and relationships. It sounds like you're looking for a way to streamline this process, as using Python for parsing has become error-prone and you want more control over the final output for your database modeler. I can provide insights on using VS Code more efficiently or suggest other tools or methods that can help you achieve a clean schema extraction with minimal fuss. Let’s explore the best options together, ensuring you get the accurate data you need for an effective database visualization. I’m ready to assist you in navigating this! To clarify the process better, I have a couple of questions: What specific output format do you prefer for your schema extraction? Are there any particular challenges you've faced with the current parsing method that I should be aware of? Thanks, Shamshad

$30 USD trong 24 ngày

0,0

(0 nhận xét)

0,0

@rashidamjad

DYNAMICS123 Hello C-Media, I understand your need for effective consultation on extracting the raw schema from Dynamics Business Central. Given your current use of Python for parsing the .al files and the challenges you're facing, I recommend exploring a more streamlined method to achieve your goals. One approach could be utilizing PowerShell scripts specifically designed for Dynamics Business Central. They can automate the extraction process and provide a cleaner extraction with less error. Additionally, integrating with REST APIs can offer flexibility in formatting the output as required for your database modeling software. If you need assistance in scripting or setting up a more reliable extraction process, I'm here to help guide you through it. My experience in database management and modeling will ensure you have a robust solution to visualize and manage your data effectively. Have you considered using PowerShell or REST APIs for a more automated extraction process? Thanks, Rashid

$30 USD trong 26 ngày

0,0

(0 nhận xét)

0,0

@rajeshrolen

Hello C-Media D., We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on Database Administration, Relational Databases, Business Central, Database Management, Data Modeling Please come over chat and discuss your requirement in a detailed way. Thank You

$50 USD trong 7 ngày

0,0

(0 nhận xét)

0,0

@nycer847

Dear Client, I am thrilled to submit my proposal for the Python developer position you have posted on Upwork. With over 4 years of experience in Python development, I am confident in my ability to contribute effectively to your project and exceed your expectations. I have vast experience in Database Administration, Relational Databases, Data Modeling, Database Management and Business Central. In my recent projects, I have successfully implemented complex Python solutions, including [mention specific projects or functionalities you've worked on]. One notable project involved developing a data analysis tool using Python, where I utilized Pandas and NumPy to process large datasets efficiently, resulting in a 30% increase in data processing speed. Additionally, I have experience in web development frameworks like Django and Flask, having built several web applications from scratch. My expertise also extends to writing clean, maintainable code and collaborating with teams to achieve project goals within deadlines. I am eager to bring my skills to your project and ensure its success. Thank you for considering my proposal. I am looking forward to the opportunity to discuss how I can contribute to your project further. Best regards, Muhammad Asad Iqbal

$30 USD trong 18 ngày

0,0

(0 nhận xét)

0,0

@zeeshanbiit

DYNAMICS123. As a seasoned database management specialist, I have honed my skills in extracting complex schema from various platforms and I'm confident incorporating the same for your requirement in Dynamics Business Central. My experience extends across an array of industries, giving me a unique edge in comprehending diverse data models and implementing suitable solutions. Your project title aligns brilliantly with my content management expertise, which is thoroughly complemented by my proficiency in JSON and SQL DDL. Moreover, I embrace the real-world challenge that emerges with parsing python scripts and derive immense satisfaction when I can transpose convoluted code into streamlined yet detailed information for seamless visualization. Should you entrust your project to my skills, I assure you that my solutions will be both accurate and efficient, yielding a comprehensive schema view for optimal database modeling. Future-focused yet detail-oriented – that's the backbone of my freelance development approach, and one that warrants success in this venture.

$50 USD trong 40 ngày

0,0

(0 nhận xét)

0,0

@abdelrahmana79

"With a strong background in SQL database management and administration, I have successfully designed, optimized, and maintained high-performance databases. My expertise in SQL query development, database security, and performance tuning ensures seamless data flow, reliability, and scalability. I am proficient in database backup strategies, recovery planning, and troubleshooting complex issues, all of which contribute to the successful execution and maintenance of this project."

$50 USD trong 40 ngày

0,0

(0 nhận xét)

0,0

@nlivenvw

Hi, I understand that you require a reliable method to extract raw schema from Dynamics Business Central Cloud .al files. You've noted the limitations of your current Python method and the challenges with APIs and TableRelation property. To better assist you, may I ask: 1. What version of Business Central are you using? 2. Can you provide an example of the precise output you're seeking? "DYNAMICS123" - I can assure you my response is not BOT-generated. My team and I are ready to begin immediately, if required. We bring 22 years of IT experience to the table, ensuring a comprehensive solution to your problem. Best Regards, Rohit.

$63 USD trong 15 ngày

0,0

(0 nhận xét)

2,0

@Synapseco

DYNAMICS123 Hi there Synapse India offers expert consulting to extract Dynamics Business Central Cloud raw schemas reliably. We'll help refine your parsing or suggest robust methods for schema visualization, ensuring accuracy and scalability for large datasets. We are SynapseIndia, and you can trust us for our 23+ years of success in the industry, with over 18,000 projects and 5 million+ hours delivered. Our top clients include IBM, Johnson & Johnson, PayPal, Audi, and Nestlé. We adhere to ISO-certified CMMI Level 3 standards throughout the SDLC. Why choose SynapseIndia --> + Successful journey of 23+ years In Industry + 100% Job success and Top Rated Plus agency on Upwork + Our top clients include IBM, Johnson & Johnson, Paypal, Audi, Nestle, and others. + Microsoft Gold Certified Partner + ISO certified CMMI Level 3 Standard followed throughout the entire SDLC Sincerely, SynapseIndia I.T. Outsourcing @ Peace of mind An ISO 9001|27001|27701 Company "Outsourcing @ Peace of mind"

$30 USD trong 40 ngày

0,0

(0 nhận xét)

0,0

@djsmoothy

DYNAMICS123 G'day! I'm Tayo, your trusted software consultant who specializes in database-centric tasks like yours. Over the years, I have tackled numerous projects requiring data extraction, parsing, and modeling with meticulous precision. I excel at leveraging different frameworks and languages to derive meaningful insights from complex datasets while maintaining data integrity and consistency. Combining my strong problem-solving skills with my deep comprehension of Python, C#, and SQL, I can offer you an astute solution to retrieve your desired schema. Not only will I assist you in getting all relevant data elements - table name, field id, field type, primary keys, foreign keys alongside relating table names, but I'll also make sure that the process doesn't break or fail inconsistently for any given file. On the development side of things, I am a proponent of using robust version control systems such as GitLab and Azure DevOps to ensure consistently dependable outputs. If need be, we could even explore other avenues like custom APIs or alternative themes with my vast knowledge of Python (Flask, Django & more) to capture that elusive "TableRelation" property you mentioned. Beyond technical expertise, my commitment to exceptional customer service and delivering tangible results distinguishes me from others. Let's get your raw schema extracted efficiently an

$50 USD trong 40 ngày